Test Your Knowledge: Microsoft Excel Quiz!

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Pragin
P
Pragin
Community Contributor
Quizzes Created: 1 | Total Attempts: 3,549
| Attempts: 3,558
SettingsSettings
Please wait...
  • 1/20 Questions

    In Excel, if the built-in styles don’t meet your needs, you can modify an existing style or create a new one.

    • True
    • False
Please wait...
About This Quiz

What do you know about Microsoft Excel, and do you think you can pass this quiz? Some people are skilled when it comes to computers, while others struggle to figure them out. Luckily, Microsoft Excel has useful features that anyone can appreciate. It reads like a spreadsheet, in which you can organize items into columns and rows. IF you want to learn more about Microsoft Excel, look no further than this quiz.

Test Your Knowledge: Microsoft Excel Quiz! - Quiz

Quiz Preview

  • 2. 

    Excel is an electronic version of a(n)

    • Database

    • Spreadsheet

    • Expression

    • Formula

    Correct Answer
    A. Spreadsheet
    Explanation
    Page EX 2

    Rate this question:

  • 3. 

    The formula used to multiply cell A1 by cell C1 is ____.

    • =A1*C1

    • C1*A1

    • =A1/C1

    • A1*C1

    Correct Answer
    A. =A1*C1
    Explanation
    Page EX 28

    Rate this question:

  • 4. 

    Formatting changes only the appearance of data - it does not affect the data itself.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Page EX 58

    Rate this question:

  • 5. 

    Every chart must have a data source.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Page EX 163

    Rate this question:

  • 6. 

    A(n) ____ is a group of cells.

    • Cluster

    • Adjunct

    • Selection

    • Range

    Correct Answer
    A. Range
    Explanation
    Page EX 21

    Rate this question:

  • 7. 

    You can use a picture or image as the background for all the cells in a worksheet.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    You can use a picture or image as the background for all the cells in a worksheet. This allows you to customize the appearance of your worksheet and add visual elements such as logos, watermarks, or backgrounds that complement the data. By selecting the option to use a picture as the background, you can choose an image file from your computer and apply it to the entire worksheet. This feature is available in most spreadsheet software programs and can enhance the overall design and presentation of your worksheet.

    Rate this question:

  • 8. 

    The characters +, -, *, and / are examples of:

    • Formulas

    • Values

    • Arithmetic operators

    • Calculations

    Correct Answer
    A. Arithmetic operators
    Explanation
    Page EX 28

    Rate this question:

  • 9. 

    For  which of the following reasons would you choose to use a chart or graph?

    • To organize information in columns and rows

    • To show trends or relationships across data

    • To present data using text only

    • To add color to a report

    Correct Answer
    A. To show trends or relationships across data
    Explanation
    Page EX 162

    Rate this question:

  • 10. 

    To move or resize an embedded chart, ____.

    • Select the chart and drag the selection box

    • Drag the resize handle on the selection box

    • Select the chart and press Tab

    • Both a and b

    Correct Answer
    A. Both a and b
    Explanation
    Page EX 167

    Rate this question:

  • 11. 

    The PMT function is a(n) ____ function.

    • Date

    • IF

    • Financial

    • Statistical

    Correct Answer
    A. Financial
    Explanation
    Page EX 146

    Rate this question:

  • 12. 

    Absolute references are marked with a ____.

    • :

    • $

    • !

    Correct Answer
    A. $
    Explanation
    Page EX 116

    Rate this question:

  • 13. 

    When using a data bar, changing the value of one cell in the range will not affect the size of all the other cells’ data bars.

    • True

    • False

    Correct Answer
    A. False
    Explanation
    Page EX 88

    Rate this question:

  • 14. 

    Excel stores its documents as files called

    • Worksheets

    • Sheet tabs

    • Workbooks

    • Books

    Correct Answer
    A. Workbooks
    Explanation
    Page EX 4

    Rate this question:

  • 15. 

    Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?

    • SUM

    • COUNT

    • COUNTA

    • AUTOSUM

    Correct Answer
    A. COUNT
    Explanation
    Page EX 122

    Rate this question:

  • 16. 

    Excel supports ____________________ built-in charts.

    • 73

    • 75

    Correct Answer
    A. 73
    Explanation
    Page EX 164

    Rate this question:

  • 17. 

    When you copy a formula that contains an absolute reference to a new location, the reference ____.

    • Is updated automatically

    • Does not change

    • Becomes bold

    • Has a dotted outline in its cell

    Correct Answer
    A. Does not change
    Explanation
    Page EX 116

    Rate this question:

  • 18. 

    Background images do not print in Excel.

    • True

    • False

    Correct Answer
    A. True
    Explanation
    Page EX 63

    Rate this question:

  • 19. 

    The F FV function stands for ____.

    • Function value

    • Future value

    • Financial value

    • Formulated value

    Correct Answer
    A. Future value
    Explanation
    Page EX 147

    Rate this question:

  • 20. 

    A(n) ____________________ is a visual representation of a set of data.

    • Chart

    • Graph

    Correct Answer(s)
    A. Chart
    A. Graph
    Explanation
    Page EX 162

    Rate this question:

Quiz Review Timeline (Updated): Mar 22, 2023 +

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

  • Current Version
  • Mar 22, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • Jul 01, 2009
    Quiz Created by
    Pragin
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.