Elements of the EXCEL Screen
Formulas
7 Steps to Worksheet Success
Common Keyboard Shortcuts
Bits & Pieces
100
The strip of buttons and icons above the work area.
What is the RIBBON?
100
A dash is used for this math calculation in EXCEL formulas.
What is SUBTRACTION?
100
Steps #1 & #2 to worksheet success.
What are DESIGN & BUILD?
100
The keyboard shortcut for CUT.
What is CTRL + X?
100

This keyboard shortcut allows you to create a chart with one click.

What is F11?

200
An individual spreadsheet with rows & columns or a chart.
What is a WORKSHEET?
200
Formulas always start with this symbol.
What is the EQUALS sign?
200
Steps #3 to worksheet success.
What is CALCULATE?
200
The keyboard shortcut to bring up formatting options.
What is CTRL + 1?
200

Start a list (like days of the week or months of the year) and finish automatically using this Excel feature.

What is Autofill?

300
A file containing multiple worksheets.
What is a WORKBOOK?
300
The forward slash is used for this math calculation in EXCEL Formulas.
What is DIVISION?
300
Step #4 to worksheet success.
What is FORMAT?
300
The keyboard shortcut to add new worksheets.
What is Shift + F11?
300
Pie, Line & Bar.
What are Chart Types?
400
Stores shortcuts to frequently used features.
What is the Quick Access Toolbar?
400
Please Excuse My Dear Aunt Sally or PEMDAS.
What is Order of Operation?
400
Step #5 to worksheet success.
What is REPORT?
400
The keyboard shortcut for UNDO.
What is CTRL + Z?
400
Clicking this "paint brush" button makes it easy to apply the same formatting to multiple cells.
What is Format Painter?
500
A collection of functionally-related controls and menus.
What is a TAB?
500
These symbols are used to group numbers together that are the first to be calculated in an EXCEL formula.
What are PARENTHESES?
500
Steps #6 & #7 to worksheet success.
What are PRINT & AUTOMATE?
500
The keyboard shortcut for "Save As".
What is F12?
500
This Fred Pryor program gives members access to unlimited live seminars and online training for FREE for a full year.
What is Pryor Plus?
M
e
n
u