EXCEL CRASH COURSE EXAM (updated ) Questions & Answers | With 100% Correct Answers graded A+ Guaranteed Success!!

EXCEL CRASH COURSE EXAM (updated 2026-2027)
Questions & Answers | With 100% Correct Answers
graded A+ Guaranteed Success!!



What is the keyboard shortcut to open the formatting cells dialog
box?


ANSWERS: Ctrl 1

What are the keyboard shortcuts for auto-fitting a range of
columns?

ANSWERS:
1) Select the columns by hitting Ctrl Spacebar. 2) Hold down the
shift key and use left and right arrow keys to highlight the range
of columns.
3) Hit Alt H O I to auto fit the columns.

, When you are in the Format Cells dialog (Ctrl 1):
What is the keyboard shortcut for moving across tabs (Number,
Alignment, Font Border, Fill, Protection)?
How do you move counter clockwise across form
elements? How do you select a checkbox (put a
checkbox next to it)

ANSWERS:
1) Ctrl Tab
2) Shift Tab
3) Spacebar

alt w f f


ANSWERS: freeze pane


alt w s


ANSWERS: split pane


F6


ANSWERS: jump between panes

, Alt H E A


ANSWERS: delete everything about a cell


Control Shift +


ANSWERS: insert new row



Control Shift !


ANSWERS: number format; 2 decimals


Control Shift $


ANSWERS: currency format; 2 decimals


Control Shift %


ANSWERS: percentage format with no decimal points


Control Shift _


ANSWERS: remove all borders