©BRAINBARTER 2024/2025
Spreadsheet Modeling Final Exam Questions
With Verified 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
Which of the following Excel features recognizes a pattern in the data of a worksheet? -
answer✔Flashfill
Spreadsheet Modeling Final Exam Questions
With Verified 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
Which of the following Excel features recognizes a pattern in the data of a worksheet? -
answer✔Flashfill
