SPREADSHEET MODELLING FINAL EXAM LATEST 2024 ACTUAL
EXAM
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
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
EXAM
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
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
