NEW
Font size
WorksheetsExcel
Total questions: 25
Worksheet time: 24mins
What is pictured here?
Dialog Box Launcher
Ribbon
Formula Bar
Group
This formula helps Excel to type Last Name - First Name.
PROPER
SUMIF
IF
CONCATENATE
This formula helps Excel type Pass or Fail next to each student. True or False next to each statement. Or, it can help write Yes or No next to each entry.
SUMIF
IF
CONCATENATE
MAX
What is pictured here?
Insert Function
Group
Ribbon
Dialog Box Launcher
What is circled in blue here?
Dialog Box Launcher
Auto Fill Handle
Group
Ribbon
Automatically add it up. Your total will appear after the selected cells.
Find & Select
Conditional Formatting
Sort & Filter
AutoSum
Easily spot trends and patterns in your data using bars, colors, and icons to visually highlight important values.
Conditional Formatting
Sort & Filter
Insert Function
Find & Select
Freeze a portion of the sheet to keep it visible while you scroll through the rest of the sheet.
Sort & Filter
Freeze Panes
Format as Table
Find & Select
This is located to the left of the formula bar. It normally displays the address of the "active cell" on the worksheet.
Name Box
Dialog Box Launcher
Auto Sum
Sort & Filter
the largest number =MAX(the first cell address:then the second cell address) For Example: =MAX(C1:C33)
Average
Minimum
Filter
Maximum
In an excel formula, this means to divide
Forward Slash /
Back Slash \
Skip
Multiply
In an excel formula, this means to subtract.
Add sign
Minus sign
Divide sign
Average Sign
The sum of all numbers divided by the amount of numbers.
Maximun
Minimum
Median
Average
This formula adds up only those items over a specific amount.
SUMIF
AVERAGEIF
AutoSum
Max
The AutoSum feature in Excel does all of the following except:
SUM
Average
Count Numbers
Divide
In Excel, you use this symbol to multiply.
/
*
\
+
