MS Excel MCQ (Multiple Choice Questions)

To create a formula you can use

a) Values or cell references although not both at the same time
b) Values but not cell references
c) Cell references but not values
d) Values and cell references
e) None of above

Check Answer

The correct answer is d “Values and cell references”.
To create a formula you can use both values and cell references.
When creating a vertical page break

a) The active cell must be A1
b) The active cell can be anywhere in the worksheet
c) The active cell must be in row 1
d) The active cell must be in column A
e) None of above

Check Answer

The correct answer is C “The active cell must be in row 1”.
When creating a vertical page break, the active cell must be in row 1.
To delete an embedded object first

a) Double click the object
b) Select the object by clicking it
c) Press the Shift + Delete keys
d) Select it and then press the delete key
e) None of above

Check Answer

The correct answer is D “Select it and then press the delete key”.
To delete an embedded object first, select it and then press the delete key.
Right clicking something in Excel

a) Nothing the right mouse button is there for left-handed people
b) Opens a shortcut menu listing everything you can do to the
object
c) Selects the objects
d) Deletes the object
e) None of above

Check Answer

The correct answer is “Opens a shortcut menu listing everything you can do to the
object”
.
Right-clicking something in Excel opens a shortcut menu listing everything you can do to the object.
Which symbol is used before a number to make it a label?

a) =(equal)
b) “(quote)
c) _(underscore)
d) ‘(apostrophe)
e) None of above

Check Answer

The correct answer is “‘(apostrophe)”.

An apostrophe is used before a number to make it a label and is most useful for values that look like a number or label.
You can use the horizontal and vertical scroll bars to

a) Split a worksheet into two panes
b) View different rows and columns to edit the contents of
a cell
c) Edit the content of a cell
d) View different worksheets
e) None of above

Check Answer

The correct answer is ” View different rows and columns to edit the contents of
a cell”
.

You can use the horizontal and vertical scroll bars to view different rows and columns to edit the contents of a cell.
Which of the following is not a way to complete a cell entry?

a) Pressing enter
b) Pressing any arrow key on the keyboard
c) Clicking the Enter button on the Formula bar
d) Pressing spacebar
e) None of above

Check Answer

The listed options (pressing Enter, pressing an arrow key on the keyboard, and clicking the Enter button on the Formula bar) are ways to complete a cell entry in Excel.
Option a) Pressing Enter will complete the cell entry and move the cell cursor to the next cell below the current cell.
Option b) Pressing an arrow key on the keyboard (such as the left arrow, right arrow, up arrow, or down arrow) will complete the cell entry and move the cell cursor in the corresponding direction.
Option c) Clicking the Enter button on the Formula bar will complete the cell entry and leave the cell cursor in the current cell.
Therefore, the correct answer is d) pressing the spacebar.
Exact Study
Logo