Excel Chapter 3 Study Guide

Use Insert Function to browse formulas and enter arguments and criteria.

• True

• False

Tina's spreadsheet contains more than three hundred students' scores for a recent math test. what function can she use to find the highest score?

• MAX
• COUNT
• AVERAGE
• MIN

Kelly wants to add cells E3, E4, and E5 and show the answer in cell E6. Which process will NOT produce the correct result?

• Using the AVERAGE function with the range E3:E5 in cell E6.
• Using the MAX function with the range E3:E5 in cell E6.
• Click cell E5, click AutoSum, and tap enter

• Using the MIN function with the range E3:E5 in cell E6.

What happens to a cell reference when you tap F4?

• The cell reference is deleted.
• The selected cell becomes absolute

• The cell reference becomes relative.
• The cell reference becomes absolute.

Philip's worksheet has several complicated formulas. What command can he use to display the formulas in the cells?

• Trace Formula Dependents

• Evaluate Formulas

• Show Formulas

• Trace formula Precedents

Name references are absolute and will NOT change when moved or copied.

• True

• False

What separates multiple arguments in a function?

• colon

• semicolon

• comma

• period

If you copy the formula =$C19+$D19 down one cell, the new formula will show as:

• =$D18+$D18

• =$C19+$D19
• =$C21+$D21
• =$C20+$D20

which name reference is NOT a valid cell name?

• Expenses

• Tax Rate

• Rates2019

• Quarter_1

Which statement is NOT true about cell names?

• Cell names are case-sensitive
• Cell names can be duplicated within a worksheet
• Cell names may contain spaces and underscores

• You can create, edit, and delete cell names in the Name Manager