What's Your Formula?
Pot Pourri
Appearances Count
Function Junction
Tie an Excel Ribbon
100
This is the operator in Excel for multiplication.
What is the asterisk (*)?
100
This feature changes the look of cells that meet a specific condition.
What is Conditional Formatting?
100
These are vertical on the worksheet and are designated with letters.
What columns?
100
This function isn't hard or easy to use. It's just kind if average.
What is AVERAGE?
100
A very cold command keeps parts of the worksheet visible as the rest of the worksheet scrolls.
What is Freeze Panes?
200
This is the abbreviation for the Excel function that adds values in the worksheet.
What is SUM?
200
This type of reference does not change when the formula is copied or moved to another cell.
What is an Absolute Reference?
200
These are horizontal on the worksheet and are designated with numbers?
What are Rows?
200
Vlad the Impaler might enjoy using this function.
What is COUNT?
200
You can format your Excel worksheet if you use the right "conditions."
What is Conditional Formatting?
300
If you were going to find the total number of items in an Excel list, you would use this function (Hint ______ Dracula).
What is Count?
300
This command locks a row or column in place so you can compare data on the worksheet
What is Freeze?
300
This is a grouping of adjacent cells and is designated with a colon (:).
What is a Range?
300
There is no special recipe to find all the functions on the Excel worksheet. Just find it on the ribbon and click it!
What is Formulas?
300
With this command, you can Filter the text in an Excel worksheet (Sort of).
What is Sort and Filter?
400
A3=5, A5=6, and A7=10, _______ is the answer to this formula: (A3*A5)/A7
What is 3?
400
These sound like an old diet soda and are new worksheets at the bottom of the worksheet window.
What Sheet Tabs?
400
This is the name of the box that names your active cell.
What is the Name Box?
400
The function that requires you to use Maximum effort.
What is Maximum?
400
You can style and profile your text with this command from the Excel ribbon?
What is Cell Styles?
500
It sounds like what rabbits eat and is the operator in Excel for exponents.
What is the caret (^)?
500
This is the Tab on the worksheet you would select to check your spelling.
What is the Review tab?
500
This is the most widely used view of the Excel worksheet.
What is the Normal View?
500
You should have a lot of "Interest" in this function.
What is the Financial function?
500
You don't have to use a set of binoculars to find this command on the Excel worksheet.
What is Find & Select?
M
e
n
u