Test Your Knowledge: Microsoft Excel 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.
- 1.
Excel is an electronic version of a(n)
- A.
Database
- B.
Spreadsheet
- C.
Expression
- D.
Formula
Correct Answer
B. SpreadsheetExplanation
Page EX 2Rate this question:
-
- 2.
Excel stores its documents as files called
- A.
Worksheets
- B.
Sheet tabs
- C.
Workbooks
- D.
Books
Correct Answer
C. WorkbooksExplanation
Page EX 4Rate this question:
-
- 3.
A(n) ____ is a group of cells.
- A.
Cluster
- B.
Adjunct
- C.
Selection
- D.
Range
Correct Answer
D. RangeExplanation
Page EX 21Rate this question:
-
- 4.
The characters +, -, *, and / are examples of:
- A.
Formulas
- B.
Values
- C.
Arithmetic operators
- D.
Calculations
Correct Answer
C. Arithmetic operatorsExplanation
Page EX 28Rate this question:
-
- 5.
The formula used to multiply cell A1 by cell C1 is ____.
- A.
=A1*C1
- B.
C1*A1
- C.
=A1/C1
- D.
A1*C1
Correct Answer
A. =A1*C1Explanation
Page EX 28Rate this question:
-
- 6.
Formatting changes only the appearance of data - it does not affect the data itself.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Page EX 58Rate this question:
-
- 7.
You can use a picture or image as the background for all the cells in a worksheet.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
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.
Background images do not print in Excel.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Page EX 63Rate this question:
-
- 9.
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.
- A.
True
- B.
False
Correct Answer
B. FalseExplanation
Page EX 88Rate this question:
-
- 10.
In Excel, if the built-in styles don’t meet your needs, you can modify an existing style or create a new one.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Page EX 78Rate this question:
-
- 11.
The PMT function is a(n) ____ function.
- A.
Date
- B.
IF
- C.
Financial
- D.
Statistical
Correct Answer
C. FinancialExplanation
Page EX 146Rate this question:
-
- 12.
The F FV function stands for ____.
- A.
Function value
- B.
Future value
- C.
Financial value
- D.
Formulated value
Correct Answer
B. Future valueExplanation
Page EX 147Rate this question:
-
- 13.
Absolute references are marked with a ____.
- A.
- B.
:
- C.
$
- D.
!
Correct Answer
C. $Explanation
Page EX 116Rate this question:
-
- 14.
When you copy a formula that contains an absolute reference to a new location, the reference ____.
- A.
Is updated automatically
- B.
Does not change
- C.
Becomes bold
- D.
Has a dotted outline in its cell
Correct Answer
B. Does not changeExplanation
Page EX 116Rate 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?
- A.
SUM
- B.
COUNT
- C.
COUNTA
- D.
AUTOSUM
Correct Answer
B. COUNTExplanation
Page EX 122Rate this question:
-
- 16.
Every chart must have a data source.
- A.
True
- B.
False
Correct Answer
A. TrueExplanation
Page EX 163Rate this question:
-
- 17.
For which of the following reasons would you choose to use a chart or graph?
- A.
To organize information in columns and rows
- B.
To show trends or relationships across data
- C.
To present data using text only
- D.
To add color to a report
Correct Answer
B. To show trends or relationships across dataExplanation
Page EX 162Rate this question:
-
- 18.
To move or resize an embedded chart, ____.
- A.
Select the chart and drag the selection box
- B.
Drag the resize handle on the selection box
- C.
Select the chart and press Tab
- D.
Both a and b
Correct Answer
D. Both a and bExplanation
Page EX 167Rate this question:
-
- 19.
A(n) ____________________ is a visual representation of a set of data.
- A.
Chart
- B.
Graph
Correct Answer(s)
A. Chart
B. GraphExplanation
Page EX 162Rate this question:
-
- 20.
Excel supports ____________________ built-in charts.
- A.
73
- B.
75
Correct Answer
A. 73Explanation
Page EX 164Rate this question:
-
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 22, 2023Quiz Edited by
ProProfs Editorial Team -
Jul 01, 2009Quiz Created by
Pragin
Back to top