SPREADSHEET MODELING TEST QUESTIONS AND ALL ANSWERS
CORRECT
The value or formula in the active cell (T/F) is shown by the Formula Bar;
ANSWER True
Which box displays the selected cell, and what is its name? The response The
Name Box
Which cell becomes the active cell when you type data in it and hit Tab? The
response The cell on the right
What is the name of the little square that allows you to automatically fill in the
formula or data? Respond to Fill Handle
To pick nonadjacent cells, hold down the ________ key. ANSWER Ctrl
Alongside your data, these little charts that are contained within a cell provide a
visual trend summary: Sparklines for the answers
The _____ - ANSWER Cell Styles Gallery contains commands to change the
style, such as the Total or Heading 1 style.
The ANSWER Design tab and the format tab are the two extra tabs (_____ and
_____) that appear when you click a chart.
In a function or formula, what symbol indicates that a cell is an absolute cell
reference? - REPLY $
The keyboard shortcut for the final cell in the active area's final column is
_____. ANSWER Ctrl + End
A table can be sorted using T/F (ascending and descending order). ANSWER
True
The grouping of the sheets is canceled (T/F) when you choose a single sheet
that is a member of a group. ANSWER: True
CORRECT
The value or formula in the active cell (T/F) is shown by the Formula Bar;
ANSWER True
Which box displays the selected cell, and what is its name? The response The
Name Box
Which cell becomes the active cell when you type data in it and hit Tab? The
response The cell on the right
What is the name of the little square that allows you to automatically fill in the
formula or data? Respond to Fill Handle
To pick nonadjacent cells, hold down the ________ key. ANSWER Ctrl
Alongside your data, these little charts that are contained within a cell provide a
visual trend summary: Sparklines for the answers
The _____ - ANSWER Cell Styles Gallery contains commands to change the
style, such as the Total or Heading 1 style.
The ANSWER Design tab and the format tab are the two extra tabs (_____ and
_____) that appear when you click a chart.
In a function or formula, what symbol indicates that a cell is an absolute cell
reference? - REPLY $
The keyboard shortcut for the final cell in the active area's final column is
_____. ANSWER Ctrl + End
A table can be sorted using T/F (ascending and descending order). ANSWER
True
The grouping of the sheets is canceled (T/F) when you choose a single sheet
that is a member of a group. ANSWER: True
