MS Excel MCQs

Question 1

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

Accepted Answer

Margin

Answer

Paper

Answer

Layout

Answer

Orientation

Question 2

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

Accepted Answer

Pie Chart

Answer

XY Chart

Answer

Line Chart

Answer

Column Chart

Question 3

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

Accepted Answer

Tools

Answer

Insert

Answer

File

Answer

View

Question 4

Which key do you press to check spelling?

Accepted Answer

F7

Answer

F3

Answer

F5

Answer

F9

Question 5

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

Accepted Answer

Macro Recorder

Answer

Media player

Answer

Sound Recorder

Answer

Calculator

Question 6

We can save and protect the workbook by

Accepted Answer

Any of the above

Answer

Write Reservation Password

Answer

Protection Password

Answer

Read-only Recommended

Question 7

The first cell in EXCEL worksheet is labeled as

Accepted Answer

A1

Answer

AA

Answer

Aa

Answer

A0

Question 8

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

Accepted Answer

An absolute cell address is created

Answer

Cell address will change when it is copied to another cell

Answer

The sheet tab is changed

Answer

The status bar does not display the cell address

Question 9

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

Accepted Answer

Sheet tabs

Answer

Reference tabs

Answer

Position tabs

Answer

Location tabs