MS EXCEL QUIZ

When you copy a formula

Excel erases the original copy of the formula

Excel edits cell references in the newly copied formula

Excel adjusts absolute cell references

Excel doesn’t adjust relative cell references

TRUE ANSWER : ?
YOUR ANSWER : ?

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

Border

Fill handle

Copy handle

Insert handle

TRUE ANSWER : ?
YOUR ANSWER : ?

Which of the cell pointer indicate that you can move the content to other cell?

Small thin plus icon

None of above

Doctor’s symbol (Big Plus)

Mouse Pointer with anchor at the tip

TRUE ANSWER : ?
YOUR ANSWER : ?

If you begin typing an entry into a cell and then realize that you don't want your entry placed into a cell, you:

Press the Edit Formula button

Press the Erase key

Press the Enter button

Press Esc

TRUE ANSWER : ?
YOUR ANSWER : ?

Ctrl+ D shortcut key in Excel will

Fill down in the selection

Apply double underline for the active cell

None of the listed here

Open the font dialog box

TRUE ANSWER : ?
YOUR ANSWER : ?

A typical worksheet has ___ number of columns.

256

128

16384

1024

TRUE ANSWER : ?
YOUR ANSWER : ?

Which area in an Excel window allows entering values and formulas?

Menu Bar

Standard Tool Bar

Formula Bar

Title Bar

TRUE ANSWER : ?
YOUR ANSWER : ?

Tab scrolling button

Allow you to view a different worksheet

Allow you to view additional worksheet rows down

Allow you to view additional worksheet columns to the right

Allow you to view additional sheets tabs

TRUE ANSWER : ?
YOUR ANSWER : ?

Which menu option can be used to split windows into two ?

Window > split

View > window > split

View > split

Review > window

TRUE ANSWER : ?
YOUR ANSWER : ?

Excel uniquely identifies cells within a worksheet with a cell name

Cell locator coordinates

Column numbers and row letters

Cell names

Column letters and row numbers

TRUE ANSWER : ?
YOUR ANSWER : ?

↑