Excel Spreadsheet
Final Review
questions and answers
2025
"AZ" is an example of a
Column heading
=IF (G22="x", SUM(H22:J22), "") will display ___ if G22 is not equal to
"x".
a blank cell
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.
nested
A column chart turned on its side is called a bar chart, with the
length of the bar determined by the data value.
True
A logical function is a function that works with values that are either
__.
true or false
A(n) __ is a group of cells in a rectangular block.
Range
According to the order of operations in Excel:
Excel performs exponentiation, then multiplication and division,
then addition, and subtraction.
An Excel formula always begins with a(n) ____.
equals sign
An adjacent range is a collection of separate ranges.
, False
An argument can be any type of value including text, numbers, cell
references, or even other formulas or functions.
True
Antoinette wants all her worksheets to have the same formatting
for text, colors, and graphical effects applied to create a specific
look and feel. Antoinette needs to apply a _____.
Theme
Each worksheet will contain a specific class with the students'
grades for the entire term. In order to determine the current
student grade, Antoinette would have to use the ____ function.
Average
Antoinette's workbook has all the data entered and students'
current grades displayed. She would like the current grade cells to
display the value in red if it is less than 60. Antoinette needs to add
_____ to the cell.
Conditional formatting
When Antoinette shares her worksheet with other colleagues, she
wants to ensure that everyone knows why certain cells are
highlighted. To accomplish this, she will create a ____.
Legend
Harold would like to center a title across the top of his data. His
data runs across five columns, from column A to column E. One way
he could accomplish this is to _____.
Type the data in A1 and Merge cells A1:E1
Ellen has entered all of her monthly expenses. She needs to create a
formula that will deduct her monthly expenses from her monthly
income. Since her monthly income is the same amount each month,
she uses a(n)____ to identify the cell containing the income value.
Absolute reference
Ellen is expecting to get a 3% raise next year. She enters .03 in cell
D2 so that she can predict her monthly income for the next year.
What function key will make D2 an absolute reference?
F4
Final Review
questions and answers
2025
"AZ" is an example of a
Column heading
=IF (G22="x", SUM(H22:J22), "") will display ___ if G22 is not equal to
"x".
a blank cell
=ROUND(AVERAGE(A1:A100),2) is an example of a(n) ____ function.
nested
A column chart turned on its side is called a bar chart, with the
length of the bar determined by the data value.
True
A logical function is a function that works with values that are either
__.
true or false
A(n) __ is a group of cells in a rectangular block.
Range
According to the order of operations in Excel:
Excel performs exponentiation, then multiplication and division,
then addition, and subtraction.
An Excel formula always begins with a(n) ____.
equals sign
An adjacent range is a collection of separate ranges.
, False
An argument can be any type of value including text, numbers, cell
references, or even other formulas or functions.
True
Antoinette wants all her worksheets to have the same formatting
for text, colors, and graphical effects applied to create a specific
look and feel. Antoinette needs to apply a _____.
Theme
Each worksheet will contain a specific class with the students'
grades for the entire term. In order to determine the current
student grade, Antoinette would have to use the ____ function.
Average
Antoinette's workbook has all the data entered and students'
current grades displayed. She would like the current grade cells to
display the value in red if it is less than 60. Antoinette needs to add
_____ to the cell.
Conditional formatting
When Antoinette shares her worksheet with other colleagues, she
wants to ensure that everyone knows why certain cells are
highlighted. To accomplish this, she will create a ____.
Legend
Harold would like to center a title across the top of his data. His
data runs across five columns, from column A to column E. One way
he could accomplish this is to _____.
Type the data in A1 and Merge cells A1:E1
Ellen has entered all of her monthly expenses. She needs to create a
formula that will deduct her monthly expenses from her monthly
income. Since her monthly income is the same amount each month,
she uses a(n)____ to identify the cell containing the income value.
Absolute reference
Ellen is expecting to get a 3% raise next year. She enters .03 in cell
D2 so that she can predict her monthly income for the next year.
What function key will make D2 an absolute reference?
F4
