Microsoft Excel Quiz

20 Questions  I  By Pragin
           MULTIPLE CHOICE QUESTIONS AND TRUE/FALSE            Put your answers to the left of the numberaNS

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Tutorial 1Excel is an electronic version of a(n)
A.
B.
C.
D.
2.  Tutorial 1Excel stores its documents as files called
A.
B.
C.
D.
3.  Tutorial 1A(n) ____ is a group of cells.
A.
B.
C.
D.
4.  Tutorial 1The characters +, -, *, and / are examples of
A.
B.
C.
D.
5.  Tutorial 1The formula used to multiply cell A1 by cell C1 is ____.
A.
B.
C.
D.
6.            Tutorial 2 TRUE/FALSE          Formatting changes only the appearance of data - it does not affect the data itself.
A.
B.
7.            Tutorial 2 TRUE/FALSE                    You can use a picture or image as the background for all the cells in a worksheet.
A.
B.
8.  Tutorial 2 TRUE/FALSEBackground images do not print in Excel.
A.
B.
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.
B.
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.
B.
11.  Tutorial 3The PMT function is a(n) ____ function.
A.
B.
C.
D.
12.  Tutorial 3 The F  FV function stands for ____.
A.
B.
C.
D.
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.
B.
C.
D.
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.
B.
C.
D.
16.  Tutorial 4Every chart must have a data source.
A.
B.
17.  Tutorial 4 For     For  which of the following reasons would you choose to use a chart or graph?
A.
B.
C.
D.
18.  Tutorial 4To move or resize an embedded chart, ____.
A.
B.
C.
D.
19.  Tutorial 4A(n) ____________________ is a visual representation of a set of data.
A.
B.
20.  Tutorial 4Excel supports ____________________ built-in charts.
A.
B.
Back to top


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz