MS Excel

Filter MCQs

Search

Categories

Subcategories

Difficulty

Clear

Available Questions

Showing 71 - 80 of 336 Questions

What is represented by the small, black square in the lower-right corner of an active cell or range?

A Copy handle
B Fill handle
C Insert handle
D Border
Correct Answer

Option B: Fill handle


Discussion

What are the tabs that appear at the bottom of each workbook called?

A Reference tabs
B Position tabs
C Location tabs
D Sheet tabs
Correct Answer

Option D: Sheet tabs


Discussion

What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10)

A An absolute cell address is created.
B Cell address will change when it is copied to another cell.
C The sheet tab is changed.
D The status bar does not display the cell address.
Correct Answer

Option A: An absolute cell address is created.


Discussion

The first cell in EXCEL worksheet is labeled as

A AA
B A1
C Aa
D A0
Correct Answer

Option B: A1


Discussion

We can save and protect the workbook by

A Write Reservation Password
B Protection Password
C Read-only Recommended
D Any of the above
Correct Answer

Option D: Any of the above


Discussion

To record a sequence of keystrokes and mouse actions to play back later we use:

A Media player
B Sound Recorder
C Calculator
D Macro Recorder
Correct Answer

Option D: Macro Recorder


Discussion

Which key do you press to check spelling?

A F3
B F5
C F7
D F9
Correct Answer

Option C: F7


Discussion

The spelling dialog box can be involved by choosing spelling from ________ menu.

A insert
B file
C tools
D view
Correct Answer

Option C: tools


Discussion

What do you call the chart that shows the proportions of how one or more data elements relate to another data element?

A XY Chart
B Line Chart
C Pie Chart
D Column Chart
Correct Answer

Option C: Pie Chart


Discussion

Which setting you must modify to print a worksheet using letterhead?

A Paper
B Margin
C Layout
D Orientation
Correct Answer

Option B: Margin


Discussion



WhatsApp Support