Spreadsheets
Cells and Cell Data
Formulas
Functions
Formatting
100
Describe a spreadsheet
What is a grid with rows and columns.
100
True or false: In protected view, Excel limits your ability to make changes
What is true
100
What is a formula?
An expression that results in a numerical value
100
What is a function?
What is a pre-made formula that computes a value.
100
This is the format used to format currency currency
What is numbers format.
200
These are the two components of a well formed spreadsheet
What are neatly organized and properly formatted.
200
If you press these two keys simultaneously, you can create two lines within the same cell
What is Alt (+) Enter
200
These are the arithmetic operators for formulas in Excel
What are addition (+), subtraction (-), multiplication (*), and division (/)
200
This is the one of the most popular functions, that adds the values in a specified range
What is the SUM function
200
The default way Excel formats text.
What is left aligned.
300
These are the four steps of planning a spreadsheet
What are identify the problem, gather relevant data, determine the needed calculations, and prepare an easy-to-read design.
300
This is the symbol that every Excel formula starts with
What is an equal sign (=)
300
This is where the formula auditing tools are found
What is the formulas tab
300
The reference change that happens when a formula is copied to a new cell.
What is relative reference
300
This is what you select in the "Sort and Filter" button to make an alphabetical sort.
What is the custom sort option?
400
This is the other name for a spreadsheet in Excel
What is a worksheet
400
This is a specific group of cells in a worksheet
What is a range
400
This is a name assigned to a cell or range
What is a defined name
400
These are two examples of advance functions that we learned in our eTextbook.
What is VLookup and PMT.
400
This is the formatting feature that is active only when certain criteria are met.
What is conditional formatting
500
This is a key design element in a well formed spreadsheet
What is separating the data variables.
500
In Microsoft Excel, this is the fastest way to copy and paste content from one cell range to another
What is a fill handle
500
This is an examination of a formula's contents to identify and correct errors
What is formula auditing
500
The symbol that helps explain when there is an error with a function
What is a green arrow
500
This is what you do to make a range of cells easier to make managing and analyzing data easier.
What is turn a range of cells into a Excel table.
M
e
n
u