Quizalize logo
placeholder image to represent content

Excel Lesson 1 and 2

Quiz by Iris Chilcutt

Feel free to use or edit a copy

includes Teacher and Student dashboards

Measure skills
from any curriculum

Tag the questions with any skills you have. Your dashboard will track each student's mastery of each skill.

With a free account, teachers can
  • edit the questions
  • save a copy for later
  • start a class game
  • automatically assign follow-up activities based on students’ scores
  • assign as homework
  • share a link with colleagues
  • print as a bubble sheet

Our brand new solo games combine with your quiz, on the same screen

Correct quiz answers unlock more play!

New Quizalize solo game modes
36 questions
Show answers
  • Q1
    A spreadsheet is a software program that allows you to
    All of these
    Enter data quickly and accurately
    Chart data
    Analyze and calculate data
    30s
  • Q2
    A collection of worksheets are stored in a
    Workbook
    All of these
    Spreadsheet
    Book
    30s
  • Q3
    The spreadsheet formula, =E6-(F6+G6) directs the spreadsheet to
    Add two numbers first and then subtract this sum from the value of E6
    Multiply two numbers(values of F6, G6) first and then subtract the value of E6
    Multiply the value of E6 by the sum of the values of F6 and G6
    None of these
    45s
  • Q4
    Which of the following built-in formulas is used to total numeric values?
    Maximum
    Average
    Sum
    Minimum
    30s
  • Q5
    Which spreadsheet command allows you to make changes to the font, cells, rows, and columns?
    File
    Help
    Format
    Insert
    30s
  • Q6
    How do you format data into dollars and cents?
    Click the Increase Decimal con
    Click the Accounting Number format icon
    None of these
    Both of these
    30s
  • Q7
    How do you increase the width of a column?
    Place the mouse pointer on the vertical column line, then click and drag the double arrow to the left
    Place the mouse pointer on the horizontal row line, then click and drag the double arrow to the left
    Place the mouse pointer on the horizontal row line, then click and drag the double arrow to the right
    Place the mouse pointer on the vertical column line, then click and drag the double arrow to the right
    30s
  • Q8
    What may need to be done to a column when ##### appears after entering data into a cell?
    A header needs to be added to the column
    The column should be sorted
    The column needs to be widened because it may be too narrow for the data.
    A footer needs to be added to the column.
    30s
  • Q9
    Which icon on the image would you click to merge cells?
    Question Image
    D
    A
    C
    B
    30s
  • Q10
    The tool that allows you to automatically change the width of a column to fit the longest entry, or change the height of a row to fit the contents is called___________
    Auto Fill Options
    AutoSum
    AutoFit
    The Update file
    30s
  • Q11
    How do you insert a new column?
    Click the Insert tab, then click the Insert button
    Click the Home tab, then click the Cells button
    Click the Insert tab, then click the Text Box
    Click the Home tab, then click the Insert button
    30s
  • Q12
    A pie chart compares data:
    Vertically
    Horizontally
    Over a period of time
    As parts of a whole
    30s
  • Q13
    How do you change the label for Worksheet #1
    Left Click on Sheet1, select Rename and type the new label
    Select File, Save, and Rename
    Right Click on Sheet1, Select Insert and type the new label
    Right click on Sheet1, select Rename and then type the new label
    30s
  • Q14
    When you want to repeat the same information at the top or bottom of every page of a spreadsheet, you would which of the following?
    Heading
    Formatting
    Page Numbering
    Headers and Footers
    30s
  • Q15
    How would you print a range of cells?
    Select range of cells, click File, select Print, select Print Entire Workbook
    Select range of cells, click File select Print, select Print Active Sheet
    Select the range of cells, click File, select Print, and select Print Selection
    Click File, select Range of Cells, click Print
    30s

Teachers give this quiz to your class