SNHU ACC 202 BOARD EVALUATION 2026
GUARANTEED PASS ANSWERS GRADED A+
● If you discover and error immediately after you have confirmed a cell
entry, what of the following would you use next?
The Undo button on the Quick Access toolbar
The Cancel button on the Formula bar
The Enter button on the Formula bar
The Save button on the Quick Access toolbar Answer: The undo button
in the quick access bar.
● When you double click a cell's right column border, what occurs?
AutoFit resizes the column to 8.43 characters wide.
The column is deleted.
AutoFit resizes the column to the widest cell entry.
A column is added to the right of the column's border. Answer: Autofit
resizes the column to the widest cell entry.
● Your worksheet contains confidential information in column c; to
prevent others from seeing the data you can _____ column C.
hide
conditionally format
edit
,delete Answer: Hide
● To enter a range of text based on examples that are already in your
worksheet, which of the following can you use?
Quick Analysis tools
Business Intelligence
Flash Fill
What-if analysis Answer: Flashfill
● Which of the following Paste options will copy only the number from
the copied cell and not the formula?
Paste Formula
Paste Format
Paste Value
Paste Link Answer: Paste value
● What happens when you click on the wrap text button?
Borders are placed around all sides of the cell
The column width is increased to display all text
The row height is increased to display all text
The text is centered between multiple cells Answer: The row height is
increased to display all text.
, ● After you delete a worksheet column,
the columns to its left shift right
only its formats are deleted
the columns to its right shift left
the row remains but its contents are deleted Answer: the columns to its
right shift left
● To select nonadjacent cells or ranges on a worksheet, you can press
and hold ______ while selecting each one.
CTRL
ALT
ESC
SHIFT Answer: CTRL
● If you want to toggle your worksheet to show your formulas instead of
your data, what should you click. (click all that apply)
View-Formula Bar
Review-Smart Lookup
Ctrl-Tilde
Formulas-Show Formulas Answer: ctrl-tilde
formulas-show formulas
GUARANTEED PASS ANSWERS GRADED A+
● If you discover and error immediately after you have confirmed a cell
entry, what of the following would you use next?
The Undo button on the Quick Access toolbar
The Cancel button on the Formula bar
The Enter button on the Formula bar
The Save button on the Quick Access toolbar Answer: The undo button
in the quick access bar.
● When you double click a cell's right column border, what occurs?
AutoFit resizes the column to 8.43 characters wide.
The column is deleted.
AutoFit resizes the column to the widest cell entry.
A column is added to the right of the column's border. Answer: Autofit
resizes the column to the widest cell entry.
● Your worksheet contains confidential information in column c; to
prevent others from seeing the data you can _____ column C.
hide
conditionally format
edit
,delete Answer: Hide
● To enter a range of text based on examples that are already in your
worksheet, which of the following can you use?
Quick Analysis tools
Business Intelligence
Flash Fill
What-if analysis Answer: Flashfill
● Which of the following Paste options will copy only the number from
the copied cell and not the formula?
Paste Formula
Paste Format
Paste Value
Paste Link Answer: Paste value
● What happens when you click on the wrap text button?
Borders are placed around all sides of the cell
The column width is increased to display all text
The row height is increased to display all text
The text is centered between multiple cells Answer: The row height is
increased to display all text.
, ● After you delete a worksheet column,
the columns to its left shift right
only its formats are deleted
the columns to its right shift left
the row remains but its contents are deleted Answer: the columns to its
right shift left
● To select nonadjacent cells or ranges on a worksheet, you can press
and hold ______ while selecting each one.
CTRL
ALT
ESC
SHIFT Answer: CTRL
● If you want to toggle your worksheet to show your formulas instead of
your data, what should you click. (click all that apply)
View-Formula Bar
Review-Smart Lookup
Ctrl-Tilde
Formulas-Show Formulas Answer: ctrl-tilde
formulas-show formulas
