This quiz is incomplete! To play this quiz, please finish editing it.
Delete Quiz
This quiz is incomplete! To play this quiz, please finish editing it.
18 QuestionsShow answers
Question 1
SURVEY
60 seconds
Q. By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.
answer choices
True
False
Question 2
SURVEY
60 seconds
Q. The fill handle only allows you to copy formulas to several different cells.
answer choices
True
False
Question 3
SURVEY
60 seconds
Q. Any changes made to an Excel document can be tracked in a separate worksheet.
answer choices
True
False
Question 4
SURVEY
60 seconds
Q. The Subtotals command adds numbers in a designated column.
answer choices
True
False
Question 5
SURVEY
60 seconds
Q. Sparklines are tiny charts that fit into one cell.
answer choices
True
False
Question 6
SURVEY
180 seconds
Q. Luisa is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below.
Which of the following suggestions would help Luisa?
answer choices
Make the cell wider
Change the number formatting in the cell
Change the font format in the cell
Delete the data and re-type it
Question 7
SURVEY
180 seconds
Q. Lauren currently has each month’s sales entered into a spreadsheet. She wants to know what she will need to sell in the month of June in order to meet her quarterly average sales goal of $40,000.Which of the following features will allow her to easily calculate what she would need to make in June?
answer choices
Average
GoalSeek
Sparklines
PivotTables
Question 8
SURVEY
120 seconds
Q. What is an advantage, if any, to using cell references instead of just typing in values?
answer choices
It will automatically create a sparkline in the next cell
It will allow you to format your spreadsheet quicker
If the cell is changed, your formula will automatically update
There is no advantage
Question 9
SURVEY
120 seconds
Q. Petra placed all of her grades from her science class into a worksheet. She wants to highlight all of the failing grades with red. Which of the following is quick way for her to do this?
answer choices
Conditional Formatting
Page Layout
Quick Format
Cell Alignment
Question 10
SURVEY
300 seconds
Q. Jun is the director of a summer camp. This spreadsheet contains campers’ names, information, and their counselors.
Which two features will help him sort the list by counselor, and then print out a list containing only the campers’ and counselors’ names?
answer choices
Sort and Track Changes
Format and Hide Columns
Custom Sorting and Formatting
Custom Sorting and Hide Columns
Question 11
SURVEY
120 seconds
Q. What are predesigned spreadsheets called and where can they be found?
answer choices
Templates; Page Layout Tab
Design Documents; Backstage View
Templates; Backstage View
Design Documents; Page Layout Tab
Question 12
SURVEY
120 seconds
Q. What are Advanced Text Filters used for?
answer choices
Filtering cells that meet very specific requirements
Filtering cells containing misspelled words
Filtering cells containing formulas
Filtering cells containing cell references
Question 13
SURVEY
180 seconds
Q. Alex needs to add three cells and then divide the sum by 4. Which of the following is an example of the correct formula to do this?
answer choices
=(A1+A2+A3)/4
A1+A2+A3/4
=A1+A2+A3^4
(A1+A2) + A3/4
Question 14
SURVEY
180 seconds
Q. Minh wanted to find the average of all of her grades, but can not get her function work. Her spreadsheet is below. What error is Min making?
answer choices
She has the incorrect arguments
She has the wrong function name
She is missing an equal sign at the beginning of her formula
The colon should be replaced with a dash (-)
Question 15
SURVEY
180 seconds
Q. Gerilynn wanted to find the total amount of vanilla cakes ordered. Which of the following formulas should she use?
answer choices
=(C3+C5+C9)/3
=SUM(C2:C10)
=AVERAGE(C2:C10)
=(C3+C5+C9)
Question 16
SURVEY
120 seconds
Q. When creating a table in Excel, what will clicking the drop down arrows in the headings allow you to do?
answer choices
Fill the column with color
Filter the data
Format the cells
Hide the column
Question 17
SURVEY
120 seconds
Q. What is the purpose of the Document Inspector?
answer choices
To inspect the document for hidden properties and personal information
To inspect the document for spelling and grammar mistakes
To inspect the document for viruses
To inspect the document for cell reference errors
Question 18
SURVEY
120 seconds
Q. Which of the following best explains the difference between formatting your spreadsheet as a table and creating a PivotTable?
answer choices
Formatting as a table will only add color bands to your headers and rows. A PivotTable turns your data into a 3D graph.
Formatting your spreadsheet as a table will format all of your data in a separate worksheet. A PivotTable creates a table within your worksheet.
There is no difference.
Formatting your spreadsheet as a table changes the overall look and feel of your spreadsheet. PivotTables instantly calculate and summarize the data separately from your original spreadsheet.