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,558
| Attempts: 3,558 | Questions: 20
Please wait...
Question 1 / 20
0 %
0/100
Score 0/100
1. In Excel, if the built-in styles don't meet your needs, you can modify an existing style or create a new one.

Explanation

Page EX 78

Submit
Please wait...
About This Quiz
Test Your Knowledge: Microsoft Excel Quiz! - 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... see moreto 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.
see less

2. Excel is an electronic version of a(n)

Explanation

Page EX 2

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

Explanation

Page EX 28

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

Explanation

Page EX 58

Submit
5. Every chart must have a data source.

Explanation

Page EX 163

Submit
6. A(n) ____ is a group of cells.

Explanation

Page EX 21

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

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.

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

Explanation

Page EX 28

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

Explanation

Page EX 162

Submit
10. To move or resize an embedded chart, ____.

Explanation

Page EX 167

Submit
11. The PMT function is a(n) ____ function.

Explanation

Page EX 146

Submit
12. Absolute references are marked with a ____.

Explanation

Page EX 116

Submit
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.

Explanation

Page EX 88

Submit
14. Excel stores its documents as files called

Explanation

Page EX 4

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

Explanation

Page EX 122

Submit
16. Excel supports ____________________ built-in charts.

Explanation

Page EX 164

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

Explanation

Page EX 116

Submit
18. Background images do not print in Excel.

Explanation

Page EX 63

Submit
19. The F FV function stands for ____.

Explanation

Page EX 147

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

Explanation

Page EX 162

Submit
View My Results

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
Cancel
  • All
    All (20)
  • Unanswered
    Unanswered ()
  • Answered
    Answered ()
In Excel, if the built-in styles don't meet your needs, you can modify...
Excel is an electronic version of a(n)
The formula used to multiply cell A1 by cell C1 is ____.
Formatting changes only the appearance of data - it does not affect...
Every chart must have a data source.
A(n) ____ is a group of cells.
You can use a picture or image as the background for all the cells in...
The characters +, -, *, and / are examples of:
For  which of the following reasons would you choose to use a...
To move or resize an embedded chart, ____.
The PMT function is a(n) ____ function.
Absolute references are marked with a ____.
When using a data bar, changing the value of one cell in the range...
Excel stores its documents as files called
Which function counts how many cells in a range contain numbers, where...
Excel supports ____________________ built-in charts.
When you copy a formula that contains an absolute reference to a new...
Background images do not print in Excel.
The F FV function stands for ____.
A(n) ____________________ is a visual representation of a set of data.
Alert!

Advertisement