Excel Module 3, Quiz 1

Cell references in a formula are called ____.

• assumptions

• comments

• numbers

• content

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

• logical

• constant

• consistent

• calculated

The ____ Auto Fill Option that fills the destination area using the format of the source area; no content is filled.

• Copy cells

• Fill formatting only

• Fill without formatting

• none of the above

Which of the following Auto Fill Options menu options is the same as the Fill Series option?

• Fill Months

• Fill without formatting

• Fill formatting only

• Copy Cells

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?

• Quarter 1

• Qtr1

• Qtr2

• Quarter4

Which of the following is an extension of the fill pattern Sunday, Tuesday?

• Wednesday, Thursday, Saturday

• Thursday, Saturday, Monday

• Saturday, Sunday, Monday

• Monday, Wednesday, Friday

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.

• two

• three

• four

• five

The Copy button copies the contents and format of the source area to the Office ____, a temporary storage area in the computer’s memory.

• Ribbon

• Clipboard

• Folder

• File

In the context of copying a range of cells to a nonadjacent location, an alternative to clicking the Paste button is to press the ____ key.

• ENTER

• ALT

• CRTL

• SHIFT

Using the mouse to move or copy cells is called ____.

• drop and drag

• drag and drop

• drag and copy

• drag and paste