Excel Spreadsheet Quiz (10 points each)
Write the correct/best response on a separate sheet of notebook paper. You do not need to rewrite the question. Read each question and the choices carefully. Number each item carefully.

  1. A formula always starts with:
    • An exclamation point (!)
    • Sum
    • An equal sign (=)
    • A cell name
  2. The operator for multiplication is the:
    • *
    • $
    • !
    • /
  3. The function for addition is:
    • ADD
    • SUM
    • PLUS
    • TOTAL
  4. The symbol to show a range of cells is:
    • The colon :
    • The comma ,
    • The equal sign =
    • The addition sign +
  5. To automatically make a column as wide as you need it to be:
    • This is a trick question: columns cannot be resized
    • Double click on the line between the column headers
    • Use "Autofill"
    • Double click on the line between the row headers
  6. Autofill is useful for:
    • Quickly repeating formulas or replicating patterns
    • Disposing of old spreadsheets
    • Coloring in the background of cells
    • Deleting cells
  7. Rows are organized by:
    • Letters
    • Numbers
    • Colors
    • Shapes
  8. Columns are organized by:
    • Letters
    • Numbers
    • Colors
    • Shapes
  9. The basic unit of the spreadsheet is the:
    • Cell
    • Row
    • Column
    • Box
  10. To format cells for currency or percentage, right click and go to:
    • Copy
    • Chart Wizard
    • Format Cells
    • Paste Special
Hosted by www.Geocities.ws

1