Microsoft Excel - Excel from Beginner to Advanced Flashcards
Comprehensive Excel Course
What are the different forms of launching Excel?
Shortcut, File Menu, Template
What is name and function of the top left portion of the interface?
It is the quick access toolbar.
What is located below the quick access toolbar of the interface?
The ribbon; which contains menus and submenus– which are configurable.
What is located below the ribbon of the interface?
The formula bar; which is configurable and can also be turned off.
What happens if you double click a tab in the ribbon?
You toggle between hiding and unhiding it.
How do you customize the quick access toolbar?
You click on the downward arrow and select which tools to activate. You can also right click a menu option and choose add to quick access toolbar.
What’s at the bottom of the Excel interface?
The status bar; which contain view buttons and zoom control; among other things.
How can you customize the status bar in Excel?
By right clicking it.
What’s at the center of the interface and occupies most of the screen space?
The workbook.
What’s at the bottom of the workbook?
The sheet tab(s) and an add button.
How is each worksheet organized?
Each sheet is organized into lettered columns and numbered rows.
How do you save a spreadsheet in Excel?
You go to the File tab
and select Save or Save As option.
How do you open an existing document in Excel?
You go to the File tab
and select Open.
What are some common Excel shortcut keys?
Close a spreadsheet: Ctrl+W
Open a spreadsheet: Ctrl+O
Go to the Home tab: Alt+H
Save a spreadsheet: Ctrl+S
Copy: Ctrl+C
Paste: Ctrl+V
Undo: Ctrl+Z
How do you save a workbook?
Options-Save As
Options-Save
Ctrl+S
Where does text align in a cell?
Text aligns to the left.
Where do numbers align to in a cell?
Numbers align to the right.
What do you put in a cell to signal a function?
You put the equals sigh (“=”) to signal a function.
What are the two type of cell references?
Relative and absolute.
What is a relative cell reference?
It is a reference where the referenced cell is relative to the position of the current cell.
What is absolute cell reference?
It is a reference where the referenced is independent to the position of the current cell and does not change.
How do you signal absolute cell references?
You signal absoluto cell references by putting a dollar sign ($) before the column and row.
What is the order of (arithmetic) operations in Excel?
PEMDAS:
Parentheses
Exponents
Multiplication
Division
Add
Subtract.
Or BODMAS:
Brackets
Orders
Division
Multiplaction
Add
Subtract
How can you evaluate a formula?
Selecting Formulas tab,
then Formula Auditing section,
then Evaluate formula.