Microsoft Excel
2 years ago
nurealom
Save
Edit
Host a game
Live GameLive
Homework
Solo Practice
Practice
18 QuestionsShow answers
  • Question 1
    60 seconds
    Q. By default, Microsoft Excel automatically saves a copy of your spreadsheet every 10 minutes.
    answer choices
    True
    False
  • Question 2
    60 seconds
    Q. The fill handle only allows you to copy formulas to several different cells.
    answer choices
    True
    False
  • Question 3
    60 seconds
    Q. Any changes made to an Excel document can be tracked in a separate worksheet.
    answer choices
    True
    False
  • Question 4
    60 seconds
    Q. The Subtotals command adds numbers in a designated column.
    answer choices
    True
    False
  • Question 5
    60 seconds
    Q. Sparklines are tiny charts that fit into one cell.
    answer choices
    True
    False
  • Question 6
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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
    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.
Report Quiz
Join a game