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.  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.
2.  How do you select noncontiguous cells?
A.
B.
C.
D.
E.
3.  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.
4.  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.
5.  How many columns have been set to be filtered?
A.
B.
C.
D.
E.
6.  Where is the Name Box located?
A.
B.
C.
D.
E.
7.  Where can you insert and edit Headers and Footers in Live View?
A.
B.
C.
D.
E.
8.  Which icon below would used to create the formatted headings shown below?
A.
B.
C.
D.
E.
9.  What is wrong with this formula?  =IF(D3=<90,"A-",0)
A.
B.
C.
D.
E.
10.  This format of numbers is known as what type?
A.
B.
C.
D.
E.
11.  What is the purpose of this icon?
A.
B.
C.
D.
E.
12.  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.
13.  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.
14.  How is the function COUNTA different from the function COUNT?
A.
B.
C.
D.
E.
15.  Which function would you use to find the largest number of a selected range?
A.
B.
C.
D.
E.
16.  What does this symbol on the status bar of Excel indicate?
A.
B.
C.
D.
E.
17.  What is the Average, Count, and Sum of the selected cells?
A.
B.
C.
D.
E.
18.  What does this icon do?
A.
B.
C.
D.
E.
19.  What steps do you take to create the following conditional format?
A.
B.
C.
D.
E.
20.  What Excel feature was used to input the note to the user?
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