Taking Charge of Excel
The Bar at the top of the spreadsheet with all icons
What is the the Ribbon?
The symbol that starts a formula
What is the "=" sign?
Icon is used to Increase Font size
What is Capital A with up arrow in Font Group ?
This is performed by hovering over a Column Letter, right clicking and selecting insert
What is insert a column to the Left?
This icon, located in the bottom Right of the sheet, shows how a sheet will print
What is Print Preview?
"A7" is an example of
What is a Cell Reference?
Gives the total in a column
What is Autosum "∑"?
Used to position information within a Cell
What is Alignment Group?
This Icon, Found in the Data Tab orders data
What is the Sort icon?
This function allows Information to be printed on all printed sheets
What is print title?
The Key is used to remove information from a cell
What is the Delete Key?
Provides the average of a set of values
What is Average function "=AVERAGE"?
Used to denote Numbers
What is the Numbers Group?
This Icon, Found in the Data Tab selects specific data
What is the Filter Icon?
This function allows custom resizing of printed area
What is The Page Breaks function?
The Key is used to navigate to the cell A1
What is the Home Key?
Locks the cell by use of the $ symbol
What is Absolute Cell Reference "$A$1"
Used to change the appearance of the entire spread sheet
What is the Styles Group?
This Icon, Found in the Editing Group allows to locate specific information
What is the Find Icon?
This Icon, denoted as a Page Long side Horizontal in front of a page Long side Vertical, allows for increasing or decreasing the number of columns on a printed sheet in a large worksheet
What is Orientation?
The Numerical information in a cell shows up as ####
What is when the cell width is too small?
The formula given below performs a function "=Sheet1!D6"
What is Referencing across sheets?
Used To copy a Format across multiple cells
What is the Format painter?
This allows selected data to be formatted based on predefined or custom parameters
What is conditional Formatting?
This Ribbon Group allows customizing of printing options
What is the Page Layout?