Vocabulary & Definitions
Excel spreadsheet file that can contain one or more worksheets.
Workbook
Relative Reference changes automatically relative to where the formula is moved or copied. T/F
TRUE
What is located at the very top-left of the window that gives access to one click actions?
The Quick-Access Toolbar
What is a Worksheet?
A single page or sheet contained within an Excel workbook file.
Absolute references lock a cell reference using dollar signs so it remains unchanged regardless of where the formula is copied. T/F
TRUE
To rename a worksheet tab, you click the worksheet, rename it, and click-off of it. T/F
FALSE; you Double-click the sheet tab, type the new name, and press Enter.
The top horizontal toolbar area that organizes commands into tabs and groups by topic.
The Ribbon
What automatically generates a summation formula for a selected column or row of related numbers?
The AutoSum tool
What is a link to another location or file?
A hyperlink
What is a Column and what is it identified by?
Columns are up and down; identified by capital letters
What is importing and where does the data come from?
Importing brings data into Excel from an external source
By typing an equal sign followed by the function name and the cell range in parentheses.
How to make a function?
The dashboard that you access through the file tab that lets you save, share, and protect a file.
The Backstage View
What joins text strings together into a single cell?
the Concatenate feature
What common formatting settings can be found in the Format Drop-Down Menu on the Home tab?
Row Height; Column Width; AutoFit; Hide/Unhide options; and Sheet Protection.