# Microsoft Excel Quiz

20 Questions  I  By Pragin
MULTIPLE CHOICE QUESTIONSAND TRUE/FALSEPut your answers to the left of the numberaNS

Changes are done, please start the quiz.

 1 Tutorial 1Excel is an electronic version of a(n)
 A. Database
 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
 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
Take Another Quiz