SPREADSHEET MODELLING FINAL EXAM LATEST 2024 ACTUAL EXAM 200 QUESTIONS AND CORRECT
DETAILED ANSWERS
The Formula Bar displays the value or formula in the active cell (T/F) - (answer) True
What is the name of box that displays the selected cell? - (answer) The Name Box
When you type data in a cell and press Tab, what cell becomes the active cell? - (answer) The cell to
the right
What is the name of small square that enables you to auto full data or formula> - (answer) Fill Handle
Hold down the ________ key to select nonadjacent cells. - (answer) Ctrl
Tiny charts embedded in a cell that give a visual trend summary alongside your data are: - (answer)
sparklines
There are commands to change style such as the Total or Heading 1 style in the _____ - (answer) Cell
Styles Gallery
When you click a chart, you will see two additional tabs (_____ and _____) for working with the chart -
(answer) Design tab and format tab
Which symbol represents that a cell is an absolute cell reference in a function or formula? - (answer) $
_____ is the keyboard shortcut to the last cell in the last column of the active area - (answer) Ctrl +
End
You can sort a table in ascending and descending order (T/F) - (answer) True
When you select a single sheet that is a part of a group, the grouping of the sheets is canceled (T/F) -
(answer) True
, SPREADSHEET MODELLING FINAL EXAM LATEST 2024 ACTUAL EXAM 200 QUESTIONS AND CORRECT
DETAILED ANSWERS
Which of the following Excel features recognizes a pattern in the data of a worksheet? - (answer)
Flashfill
The COUNTIF function has two arguments ______ - (answer) The range of cells to check and the
criteria
Deleting the ____ of a cell deletes the value or formula but does not clear formatting of that cell -
(answer) contents
The ____ function counts the number of cells within a range that meet the criteria entered - (answer)
COUNTIF Function
In a conditional format, we use _____ to represent the value of a cell relative to other cells - (answer)
Data bar
We can group multiple worksheets by right-clicking on the sheet tab, and then click _____ on the
shortcut menu - (answer) Select all sheets
The ____ command enables you to specify rows and columns that will be duplicated on each printed
page - (answer) Printed titles
We can find the ___ command button, which is used to apply the same formatting, in the clipboard
group - (answer) Format painter
The y-axis of a chart is also referred to as the category axis (T/F) - (answer) False
If you edit data in a worksheet that associated with a pie chart - (answer) The pie slices will be
automatically updated
In goal seek, you enter the specific value that you want to achieve in the ____ box - (answer) To Value
DETAILED ANSWERS
The Formula Bar displays the value or formula in the active cell (T/F) - (answer) True
What is the name of box that displays the selected cell? - (answer) The Name Box
When you type data in a cell and press Tab, what cell becomes the active cell? - (answer) The cell to
the right
What is the name of small square that enables you to auto full data or formula> - (answer) Fill Handle
Hold down the ________ key to select nonadjacent cells. - (answer) Ctrl
Tiny charts embedded in a cell that give a visual trend summary alongside your data are: - (answer)
sparklines
There are commands to change style such as the Total or Heading 1 style in the _____ - (answer) Cell
Styles Gallery
When you click a chart, you will see two additional tabs (_____ and _____) for working with the chart -
(answer) Design tab and format tab
Which symbol represents that a cell is an absolute cell reference in a function or formula? - (answer) $
_____ is the keyboard shortcut to the last cell in the last column of the active area - (answer) Ctrl +
End
You can sort a table in ascending and descending order (T/F) - (answer) True
When you select a single sheet that is a part of a group, the grouping of the sheets is canceled (T/F) -
(answer) True
, SPREADSHEET MODELLING FINAL EXAM LATEST 2024 ACTUAL EXAM 200 QUESTIONS AND CORRECT
DETAILED ANSWERS
Which of the following Excel features recognizes a pattern in the data of a worksheet? - (answer)
Flashfill
The COUNTIF function has two arguments ______ - (answer) The range of cells to check and the
criteria
Deleting the ____ of a cell deletes the value or formula but does not clear formatting of that cell -
(answer) contents
The ____ function counts the number of cells within a range that meet the criteria entered - (answer)
COUNTIF Function
In a conditional format, we use _____ to represent the value of a cell relative to other cells - (answer)
Data bar
We can group multiple worksheets by right-clicking on the sheet tab, and then click _____ on the
shortcut menu - (answer) Select all sheets
The ____ command enables you to specify rows and columns that will be duplicated on each printed
page - (answer) Printed titles
We can find the ___ command button, which is used to apply the same formatting, in the clipboard
group - (answer) Format painter
The y-axis of a chart is also referred to as the category axis (T/F) - (answer) False
If you edit data in a worksheet that associated with a pie chart - (answer) The pie slices will be
automatically updated
In goal seek, you enter the specific value that you want to achieve in the ____ box - (answer) To Value
