NEW
Font size
WorksheetsOffice T&T
Total questions: 12
Worksheet time: 4mins
True or False: By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.
True
False
Petra placed all of her grades from her science class into a worksheet. She wants to highlight all of the failing grades in red. Which of the following is a fast way for her to do this?
Page layout
Conditional formatting
Quick formatting
Cell alignment
True or False: Sparklines are tiny charts that fit into one cell.
True
False
Which orientation is best for displaying a wide chart?
Letter
Flyer
Landscape
Portrait
While reviewing her worksheet, Megan noticed she had made a mistake in several places and used the color name burgundy when she should have used maroon. Which feature will allow her to correct her mistake the fastest?
Sort and Replace
Search and Find
Sort and Format
Find and Replace
Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
=(C3+C5+C9)
=SUM(C2:C10)
=(C3+C5+C9)
Which of these formulas will add three cells and then divide the sum by 4?
=A1+A2+A3^4
=(A1+A2+A3)/4
(A1+A2) + A3/4
A1+A2+A3/4
Minh wanted to find the average of all of her grades, but she cannot get her function to work. Her spreadsheet is below. What error is she making in cell C11?
The colon should be replaced with a dash (-)
She has the wrong function name
She has incorrect arguments
She is missing an equals sign at the beginning of her formula
Which of the following Counts the number of cells that are not empty in a range
IF function
IFS function
COUNT function
COUNTA function
What tab do you go to to start a MAIL Merge
The Insert Tab
The Merging Tab
You do not go to a tab
The Mailings Tab
Which Short-cut button Adds the current date into a cell
Ctrl + 1
Ctrl + ;
Alt + Enter
Ctrl + Shift + ;
Which Short-cut button Selects entire column
Double click fill handle
Ctrl hold + click
Ctrl + Spacebar
Shift + Spacebar
