Excel 2010 Skills Assessment

20 Questions  I  By Carlson95602
This quiz is designed to provide an assessment of team members' level of cometency in key features and functions of Excel 2010.   The results of this quiz will be used to determine course placement for each team member based on total score achieved.   Please answer quiz questions without using any reference materials so that we may get an accurate measurement of skill level. If you don't know the answer to a question, please make sure to select, "I don't know the answer to this question. " instead of guessing.   This will give us a more accurate assessment.

  
Changes are done, please start the quiz.


Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  Where can you insert and edit Headers and Footers in Live View?
A.
B.
C.
D.
E.
2.  How do you select noncontiguous cells?
A.
B.
C.
D.
E.
3.  What is the Average, Count, and Sum of the selected cells?
A.
B.
C.
D.
E.
4.  What Excel feature was used to input the note to the user?
A.
B.
C.
D.
E.
5.  Where is the Name Box located?
A.
B.
C.
D.
E.
6.  How is the function COUNTA different from the function COUNT?
A.
B.
C.
D.
E.
7.  What does this icon do?
A.
B.
C.
D.
E.
8.  Which icon below would used to create the formatted headings shown below?
A.
B.
C.
D.
E.
9.  If you have a lot of rows of data and the totals are displayed in the very last row, what Excel feature can you use so that when you are working with the data you can automatically see how your edits and changes to the data affects that very last row without having to scroll down to it?
A.
B.
C.
D.
E.
10.  What is wrong with this formula?  =IF(D3=<90,"A-",0)
A.
B.
C.
D.
E.
11.  What is the purpose of this icon?
A.
B.
C.
D.
E.
12.  What function would be used to find the total sales of both the High School and Jr High food as shown below:
A.
B.
C.
D.
E.
13.  This format of numbers is known as what type?
A.
B.
C.
D.
E.
14.  Which of the following is the correct formula to use in order to combine the last name and first name in this example so that the end result is what you see in Cell D2?
A.
B.
C.
D.
E.
15.  What does this symbol on the status bar of Excel indicate?
A.
B.
C.
D.
E.
16.  Which function would you use to find the largest number of a selected range?
A.
B.
C.
D.
E.
17.  What steps do you take to create the following conditional format?
A.
B.
C.
D.
E.
18.  If I have formatted a row of cells in a particular way...for instance, purple fill color, white font color, Calibri, 14 pt Bold...I can save these format choices as a Cell Style by clicking in any of the formatted cells and then clicking the...
A.
B.
C.
D.
E.
19.  How many columns have been set to be filtered?
A.
B.
C.
D.
E.
20.  In this Pivot Table, the Dept field is used for a Report Filter.  How can you get all of the different departments to automatically display on their own separate sheet tabs at the bottom of the workbook?
A.
B.
C.
D.
E.
Back to top


to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz