MATCHING
Identify the letter of the choice that best matches the phrase or definition.
-A named operation that returns a value
A)function
B)workbook
C)worksheet
D)range
E)order of precedence
F)Name box
G)Ctrl
H)Normal view
I)AutoSum button
J)what-if analysis
K)formula view
L)sheet tabs

Question

Quizplus · Accepted Answer

A function is a named operation that returns a value.

Answer: I
 The AutoSum button is a tool used to easily create a formula that adds up a column or row of numbers.

Answer: J
 What-if analysis is a tool used to explore the impact of changing one or more variables in a formula.

Answer: K
 Formula view shows the formulas and calculations behind the values in a worksheet.

Answer: D
 A range is a group of selected cells in a worksheet.

Answer: F
 The Name box displays the name of the selected cell or range in a worksheet.

Answer: H
 Normal view is the default view in Excel, where a worksheet is displayed for editing and formatting.

Answer: L
 Sheet tabs are used to switch between sheets in a workbook.

MATCHING Identify the Letter of the Choice That Best Matches the the Phrase