Test Your Knowledge On Microsoft Excel Quiz
Settings
MULTIPLE CHOICE QUESTIONS AND TRUE/FALSE Put your answers to the left of the numberaNS
- 1.Tutorial 1Excel is an electronic version of a(n)
- A.
Database
- B.
Spreadsheet
- C.
Expression
- D.
Formula
- 2.Tutorial 1Excel stores its documents as files called
- A.
Worksheets
- B.
Sheet tabs
- C.
Workbooks
- D.
Books
- 3.Tutorial 1A(n) ____ is a group of cells.
- A.
Cluster
- B.
Adjunct
- C.
Selection
- D.
Range
- 4.Tutorial 1The characters +, -, *, and / are examples of
- A.
Formulas
- B.
Values
- C.
Arithmetic operators
- D.
Calculations
- 5.Tutorial 1The formula used to multiply cell A1 by cell C1 is ____.
- A.
=A1*C1
- B.
C1*A1
- C.
=A1/C1
- D.
A1*C1
- 6.Tutorial 2 TRUE/FALSE Formatting changes only the appearance of data - it does not affect the data itself.
- A.
True
- B.
False
- 7.Tutorial 2 TRUE/FALSE You can use a picture or image as the background for all the cells in a worksheet.
- A.
True
- B.
False
- 8.Tutorial 2 TRUE/FALSEBackground images do not print in Excel.
- A.
True
- B.
False
- 9.Tutorial 2 TRUE/FALSEWhen 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
- 10.Tutorial 2 TRUE/FALSEIn 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
- 11.Tutorial 3The PMT function is a(n) ____ function.
- A.
Date
- B.
IF
- C.
Financial
- D.
Statistical
- 12.Tutorial 3 The F FV function stands for ____.
- A.
Function value
- B.
Future value
- C.
Financial value
- D.
Formulated value
- 13.Tutorial 3 Abs Abolute references are marked with a ____.
- A.
- B.
:
- C.
$
- D.
!
- 14.Tutorial 3 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
- 15.Tutorial 3Which 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
- 16.Tutorial 4Every chart must have a data source.
- A.
True
- B.
False
- 17.Tutorial 4 For 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
- 18.Tutorial 4To 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
- 19.Tutorial 4A(n) ____________________ is a visual representation of a set of data.
- A.
Chart
- B.
Graph
- 20.Tutorial 4Excel supports ____________________ built-in charts.
- A.
73
- B.
75
Back to top