Spreadsheets - 7th Grade

Mrs. Kwiecinski

If you have any questions or concerns about this quiz,
please contact the creator of the quiz.

Answer the questions below and then click "submit" to send your answers.

  1. The area where a row and column intersect is called a

    2. Your answer:
    block
    link
    tab
    cell

  2. A formula must begin with

    3. Your answer:
    *
    -
    /
    +
    =

  3. After typing data into a cell, which keys can be used to enter it?

    4. Your answer:
    alt key
    arrow keys only
    enter key only
    tab key, enter key, or any arrow key
    space bar

  4. Rows in a spreadsheet are named using

    5. Your answer:
    numbers
    letters
    bullets
    colons

  5. Columns in a spreadsheet are named using

    6. Your answer:
    colons
    letters
    numbers
    bullets

  6. Which of the following will fill in a series using the Autofill handle?

    7. Your answer:
    Friday
    March
    1st game
    All of these

  7. When you type a number into a cell, how is it automatically aligned?

    8. Your answer:
    Centered
    Merged
    Right
    Left

  8. To center a title across columns A, B, C, & D, enter the title in cell A1, then....

    9. Your answer:
    Hightlight cells A1 - D1 and press the Center align button
    Highlight cells A1 - D1 and press the Merge & Center button
    Press the Center Align button
    Press View menu, Header & Footer

  9. What 3 columns come after Column X?

    10. Your answer:
    AX, AY, AZ
    I, IV, IX
    Y, Z, AA
    YX, YY, YZ

  10. How many rows are possible in an Excel spreadsheet?

    11. Your answer:
    16,536
    As many as you want
    65,536
    256

  11. Which of the following is a correctly entered formula that will work?

    12. Your answer:
    A2 + B2
    =9C - 2B
    -G22 / G23
    =F5 * 0.08

  12. If you wanted to add a long column of numbers, which function would you use?

    13. Your answer:
    Min
    Average
    Sum
    Count

  13. To make column B wider, click and drag between columns

    14. Your answer:
    B & C
    A & B
    A & C

  14. If ###### appears in a cell, it means there is an error in the formula.

    15. Your answer:
    TrueFalse

  15. To format all the text in a row, the first thing you must do is

    16. Your answer:
    Go to the Format menu
    Go to the Edit menu
    Press the = sign
    Highlight the row

  16. What is the operation symbol for division?

    17. Your answer:
    /
    $
    +
    -
    *

  17. The formula =MAX(B1:B12)would tell you the largest number in the range B1 to B12.

    18. Your answer:
    TrueFalse

  18. You cannot use the Autofill handle to copy formulas down a column.

    19. Your answer:
    TrueFalse

  19. Batting averages are determined by using the AVERAGE function.

    20. Your answer:
    TrueFalse

  20. Batting averages should be formatted using 3 decimal places.

    21. Your answer:
    TrueFalse

Name:

Full email address:

Class:

NOTE TO THE STUDENT: If the answers are sent successfully, you will see another page come up in the web browser. If you don't see this page, it is possible that an error occurred during transfer and you should either resubmit your answers or notify your instructor.

QuizCenter © 2000 - 2002. This quiz was generated at Quiz Center on DiscoverySchool.com. All rights reserved.