Double Platinum
Where is BRI?
Sedona, Arizona
All formulas start with this symbol
An equal sign
Suppose you have the formula =B$3. You decide to drag the cell reference one space down. What will be the formula in the new cell?
B$3
What are Columns identified by?
Letters
What Control Key is used to Print a Document?
Ctrl + P
Where is TMH?
Honolulu, Oahu, Hawaii
A prewritten formula that is built in Excel is called this.
A Function
Suppose A1 = "Adventures", A2 = "in", and A3 = "Authoring". What is the result of =concatenate(A1, A2, A3)?
AdventuresinAuthoring
Numbers in Excel align to which direction?
Left
What is the Control Key used to Undo?
Ctrl + Z
Where is CAZ?
Cabo San Lucas, Baja California Sur
This function adds all the data in a cell range.
The Sum function
What is the result of =odd(8.5)?
9
A selection of 2 or more cells is called?
A Range
What is the Control Key used to Redo an action in a document?
Where is VSF?
Santa Fe, New Mexico
If a VLOOKUP does not find a referenced value in your table, you will receive the following result
Suppose cell B12 contains the text “Golf Ball”. What does the formula =Search(“ball”,B12,1) return?
6
What is the spreadsheet feature that will quickly copy a formula to other cells
Fill
What is the Control Key to go to the beginning of the document?
Ctrl + Home
Where is JDS?
Lanzarote, Canary Islands
This function will return the highest number in a cell range.
MAX
If the word "alphabet" is in A1, then what does the function =mid(A1, 3, 4) display?
phab
What do you call a formula that changes when copied?
A Relative Formula
What is the Control Key used to write the Current Date on a Document?
Ctrl + ;