Formulas
Functions
Sorting/Filtering
Formatting
Random
100
This is a mathematical process with numbers and symbols
What is a formula
100
This is an excel process that uses a key word to create a calculation
What is a function
100
What is the term for arranging items in a certain way, such as according to kind?
What is sorting
100
Shading, font and borders are types of this
What is formatting
100
When you do this, the formulas will be displayed on the screen and not the answers
What is Show Formulas
200
A $ will create this in a cell reference.
What absolute cell reference?
200
It is a shortcut for common formulas, it automatically selects cell ranges, and copies to adjacent cells
What are the benefits of using a function
200
How can you sort items in a spreadsheet?
What is by row, column, or criteria
200
To merge two or more cells together, use the ________command
What is Merge and Center
200
A cell reference that change when copied or filled is called a(n) __________
What is relative reference
300
What section of this formula is relative =$A$10/100
/100
300
Which function is used to find the highest number in a list of data?
What is MAX
300
What order is shown by this set of numbers? 100, 200, 300, 400, 500
What is assending
300
This setting will turn number values into labels
What is text
300
You can use _______ to narrow down the data in your worksheet or hide parts of it from view
What are filters
400
What section of this formula is absolute =$A$10/100
$A$10
400
What is the argument of =SUM(B3:B12)
What is (B3:B12)
400
When you do this, only the relevant data is shown.
What is filtering
400
List 3 true statements about AutoFilling formulas?
Pick winners as a team
400
You should use this command to save a worksheet under a different name
What is Save As
500
What symbol must all formulas in a spreadsheet begin with?
What is equal sign
500
By using this symbol and the AND function, you can perform a logic test that determines if values are greater than another.
What is >
500
What do custom filters allow you to do that standard filters do not?
This one you should be able to figure out as a team
500
True/False - Formatted Tables include filters on each column
What is True
500
This button will decrease the decimal on a value.
What is Decrease Decimal
M
e
n
u