WGU C268 SPREADSHEETS EXAM PREP
TEST BANK VERIFIED QUESTIONS AND
CORRECT ANSWERS
●● To enter data in a cell, you must first select the
Answer: cell
●● ____ is/are used to place worksheet, column, and row titles on a
worksheet
Answer: text
●● The ____ is a blinking vertical line that indicates where the next
typed character will appear.
Answer: insertion point
●● By default, text is ____ in a cell.
Answer: left-aligned
●● The ____ is the small black square located in the lower-right corner
of the heavy border around the active cell.
Answer: fill handle
,●● The ____ preceding a formula alerts Excel that you are entering a
formula or function and not text
Answer: equal sign =
●● You ____ a worksheet to emphasize certain entries and make the
worksheet easier to read and understand.
Answer: format
●● You can apply the Bold font style by pressing the ____ keyboard
shortcut keys.
Answer: CTRL+B
●● Combining two or more selected cells into one cell is called ____
cells.
Answer: merging
●● Which of the following is the Ribbon path to the Cell Styles button?
Answer: (HOME tab | Styles group)
●● Pressing the ____ keyboard shortcut key(s) selects cell A1.
Answer: CTRL +HOME
●● How many chart types does Excel offer?
,Answer: 10
●● A pie chart with one or more slices offset is referred to as a(n) ____
pie chart.
Answer: exploded
●● The date you change a file is an example of a(n) ____ property.
Answer: automatically updated
●● To erase an entire entry in a cell and then reenter the data from the
beginning, press the ____ key.
Answer: ESC
●● Which of the following keys moves the insertion point to the end of
data in a cell?
Answer: End
●● Excel remembers the last ____ actions you have completed.
Answer: 100
●● Press ____ to select the entire worksheet.
Answer: CTRL+A
, ●● A ____ is a prewritten formula that is built into Excel.
Answer: Function
●● To start a new line in a cell, press the ____ keys.
Answer: alt+enter
●● When you enter a two-digit year that is less than 30, Excel changes
the year to ____.
Answer: 20xx
●● A(n) ____ circular reference occurs when a formula in a cell refers to
another cell or cells that include a formula that refers back to the original
cell.
Answer: indirect
●● All of the following are valid Excel arithmetic operators EXCEPT
____.
Answer: >
●● When more than one arithmetic operator is involved in a formula,
Excel follows the same basic order of ____ that you use in algebra.
Answer: operations
TEST BANK VERIFIED QUESTIONS AND
CORRECT ANSWERS
●● To enter data in a cell, you must first select the
Answer: cell
●● ____ is/are used to place worksheet, column, and row titles on a
worksheet
Answer: text
●● The ____ is a blinking vertical line that indicates where the next
typed character will appear.
Answer: insertion point
●● By default, text is ____ in a cell.
Answer: left-aligned
●● The ____ is the small black square located in the lower-right corner
of the heavy border around the active cell.
Answer: fill handle
,●● The ____ preceding a formula alerts Excel that you are entering a
formula or function and not text
Answer: equal sign =
●● You ____ a worksheet to emphasize certain entries and make the
worksheet easier to read and understand.
Answer: format
●● You can apply the Bold font style by pressing the ____ keyboard
shortcut keys.
Answer: CTRL+B
●● Combining two or more selected cells into one cell is called ____
cells.
Answer: merging
●● Which of the following is the Ribbon path to the Cell Styles button?
Answer: (HOME tab | Styles group)
●● Pressing the ____ keyboard shortcut key(s) selects cell A1.
Answer: CTRL +HOME
●● How many chart types does Excel offer?
,Answer: 10
●● A pie chart with one or more slices offset is referred to as a(n) ____
pie chart.
Answer: exploded
●● The date you change a file is an example of a(n) ____ property.
Answer: automatically updated
●● To erase an entire entry in a cell and then reenter the data from the
beginning, press the ____ key.
Answer: ESC
●● Which of the following keys moves the insertion point to the end of
data in a cell?
Answer: End
●● Excel remembers the last ____ actions you have completed.
Answer: 100
●● Press ____ to select the entire worksheet.
Answer: CTRL+A
, ●● A ____ is a prewritten formula that is built into Excel.
Answer: Function
●● To start a new line in a cell, press the ____ keys.
Answer: alt+enter
●● When you enter a two-digit year that is less than 30, Excel changes
the year to ____.
Answer: 20xx
●● A(n) ____ circular reference occurs when a formula in a cell refers to
another cell or cells that include a formula that refers back to the original
cell.
Answer: indirect
●● All of the following are valid Excel arithmetic operators EXCEPT
____.
Answer: >
●● When more than one arithmetic operator is involved in a formula,
Excel follows the same basic order of ____ that you use in algebra.
Answer: operations
