Module 3 Review

Module 3 Review

Open Ended

What is your name?

Multiple Choice

Cell references in a formula are called ____.

• assumptions

• comments

• numbers

• content

Multiple Choice

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

• logical

• constant

• consistent

• calculated

Multiple Choice

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

• Quarter 1

• Qtr1

• Qtr2

• Quarter4

Fill in the Blanks

The Copy button copies the contents and format of the source area to the Office

, a temporary storage area in the computer’s memory.

Multiple Choice

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

• drop and drag

• drag and drop

• drag and copy

• drag and paste

Multiple Choice

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

• #NULL!

• #DIV/0!

• #N/A

• #REF!

Multiple Choice

Which of the following is not a valid format symbol?

• semi-colon (;)

• percent sign (%)

• dollar sign ($)

• comma (,)

Fill in the Blanks

When assigned to a cell, the

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

Multiple Choice

Which of the following formulas contains an absolute cell reference?

• =$B4

• =B$4

• =$B$4

• =B4

Fill in the Blanks

The

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

Multiple Choice

Which comparison operator means “not equal to”?

• <=

• >

• <

• <>

Multiple Choice

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

• included

• other

• nested

• duplicate

Multiple Choice

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

Multiple Choice

You should use a ____ chart to compare values side by side, broken down by category.

• Column

• Bar

• Line

• Clustered Column

Multiple Choice

Charts can either be embedded in a worksheet or placed in a separate ____.

• worksheet

• dialog box

• chart sheet

• range

Multiple Choice

When working with a large worksheet, you can split the window into ____ panes.

• three or four

• four or five

• two or six

• two or four

Fill in the Blanks

seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.

Multiple Choice

A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

• true

• false

Multiple Choice

A relative cell reference instructs Excel to adjust the cell reference as it copies it to the destination area.

• true

• false

Multiple Choice

A cell reference with only one dollar sign before either the column or the row is called an absolute reference.

• true

• false

Multiple Choice

A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.

• true

• false

Multiple Choice

Excel includes four types of sparkline charts: line, column, win/loss, and stock.

• true

• false

Multiple Choice

You can select nonadjacent ranges using the SHIFT key.

• true

• false

Multiple Choice

You can press the CTRL+ACCENT MARK(` or ~) keys to display the formulas in a worksheet.

• true

• false

Poll

How accurate is this statement?

"I understand how functions work and how to use them."

• I have no clue about functions!

• I only understand if you guide us

• I kind of understand without help

• This statement is true!