Microsoft Excel

10 Questions | Attempts: 533
Share

SettingsSettingsSettings
Excel Quizzes & Trivia

Choose the correct answer from the choices provided.


Questions and Answers
  • 1. 

    The ___calculates totals automatically.

    • A.

      Auto Format

    • B.

      Auto Sum

    • C.

      Auto Fill

    Correct Answer
    B. Auto Sum
  • 2. 

    Which one formats the data on the spreadsheet?

    • A.

      Autoformat

    • B.

      Autotext

    • C.

      Formatdata

    Correct Answer
    A. Autoformat
  • 3. 

    The ______copies the Sum command to the rest of the rows.

    • A.

      Autoformat

    • B.

      Fill Handle

    • C.

      Auto Fill

    Correct Answer
    B. Fill Handle
  • 4. 

    The term used to explain the chart data is ______.

    • A.

      Data Range

    • B.

      Legend

    • C.

      Range

    Correct Answer
    B. Legend
  • 5. 

    On which tab can you select a Chart Layout that includes a title?

    • A.

      Page layout

    • B.

      Home

    • C.

      Insert

    Correct Answer
    C. Insert
  • 6. 

    Formulas may be copied using_________.

    • A.

      Sizing Handles

    • B.

      Tab Key

    • C.

      Fill Handles

    Correct Answer
    C. Fill Handles
  • 7. 

    The Currency style where the $ is to the immediate left of the number no matter how large or small the number is called a _____.

    • A.

      Fixed$

    • B.

      Floating$

    Correct Answer
    A. Fixed$
  • 8. 

    The Sort feature is accessed on which tab?

    • A.

      Sort

    • B.

      Page Layout

    • C.

      Data

    Correct Answer
    C. Data
  • 9. 

    To rename tabs on a two-page spreadsheet and char, you would__________.

    • A.

      Double click on tab, Rename

    • B.

      Click on tab, Rename

    • C.

      Format tab, Rename

    Correct Answer
    A. Double click on tab, Rename
  • 10. 

    Best Fit refers to ____.

    • A.

      Fit to One Page for Printing

    • B.

      Changing Height of Cells

    • C.

      Changing Widths of Cells

    Correct Answer
    C. Changing Widths of Cells

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Jun 18, 2013
    Quiz Edited by
    ProProfs Editorial Team
  • Jun 18, 2013
    Quiz Created by
    Shillnunn
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.