Excel Formulas and Functions Quiz

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

• CTRL

• SHIFT

Which of the following is not a valid format symbol?

• semi-colon (;)

• percent sign (%)

• dollar sign ($)

• comma (,)

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

• SYSDATE

• NOW

• DATETIME

• CURRENT

Which of the following formulas contains an absolute cell reference?

• $B4

• B$4

• $B$4

• B4

The ____ function is useful when you want to assign a value to a cell based on a logical test.

• IF

• NOW

• AN

• OR

A(n) _____ chart provides a simple way to show trends and variations in a range of data within a single cell.

• section

• sparkline

• special

• sparkle

The path to the Format Painter button is _____.

• (HOME tab | Number group)

• (HOME tab | Clipboard group)

• (HOME tab | Painting group)

• (HOME tab | Font group)

If the contents of a cell copied using the fill handle is Sunday and Tuesday, what are the next three values of the extended series?

• Wednesday

• Thursday

• Saturday

• Monday