Excel 2010 Test

25 Questions  I  By Rpolete
A test for students beginning a unit on Excel 2010 to baseline their current knowledge of Excel and to determine their learning by comparing the results against a Post test to be given at the end of the unit of instruction.

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Is it possible to insert an image from a file into an Excel spreadsheet?
A.
B.
2.  A_________ is a built in mathematical formula included in excel.
A.
B.
C.
D.
3.  The Chart Tools commands are found in these three tabs? 
A.
B.
C.
D.
4.  Which of the following is a relative cell reference?
A.
B.
C.
D.
5.  Once data is entered into a cell, can it be edited?
A.
B.
C.
D.
6.  Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?
A.
B.
C.
D.
7.  What name is given to the chart background?
A.
B.
C.
D.
8.  How do you select noncontiguous cells?
A.
B.
C.
D.
9.  Which of the following is mixed cell reference with a fixed row address?
A.
B.
C.
D.
10.  How does a relative reference differ from an absolute reference?
A.
B.
C.
D.
11.  What does the following error mean - #REF! ?  
A.
B.
C.
D.
12.  According to the picture the selected cell in yellow corresponds to:
A.
B.
C.
D.
13.  What is a worksheet tab in Excel 2010?
A.
B.
C.
D.
14.  Which of the following is an absolute cell reference?
A.
B.
C.
D.
15.  Formulas in a cell start with a _______.
A.
B.
C.
D.
16.  What is the name given to a value that does NOT change when used within a formula?
A.
B.
C.
D.
17.  The cell range that starts in cell A1 and goes over to column J and down to row 15 is _____
A.
B.
C.
D.
18.  “Month 1, Month 2, Month 3” is an example of what?
A.
B.
C.
D.
19.  Which feature in Excel allows you to view two spreadsheets in one window?
A.
B.
C.
D.
20.  Inserting Page Number is in Header and Footer
A.
B.
21.  When changing the margins on your spreadsheet does not solve the problem with the printout width, what do you need to do?  
A.
B.
C.
D.
22.  Which of the following buttons on the Excel toolbar will format selected cells so that they appear as currency values?  
A.
B.
C.
D.
23.  Which function would you use to find the largest number of a selected range?
A.
B.
C.
D.
24.  Which of the following is an mixed cell reference with a fixed column address?
A.
B.
C.
D.
25.  When number signs (#####) are displayed in the cell, it means:  
A.
B.
C.
D.
Back to top
Quiz Comments (1)
my name Nguyen Tien Hoang - K43 CTTT i send you the online test 1 . Thank you !
to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz