Excel 2010 Skills Assessment

20 Questions  I  By Carlson95602 on March 21, 2012
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.

  

Question Excerpt

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
1.  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.
2.  What does this symbol on the status bar of Excel indicate?
A.
B.
C.
D.
E.
3.  How is the function COUNTA different from the function COUNT?
A.
B.
C.
D.
E.
4.  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.
5.  What steps do you take to create the following conditional format?
A.
B.
C.
D.
E.
6.  What does this icon do?
A.
B.
C.
D.
E.
7.  What is wrong with this formula?  =IF(D3=<90,"A-",0)
A.
B.
C.
D.
E.
8.  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.
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.  How do you select noncontiguous cells?
A.
B.
C.
D.
E.
11.  Which function would you use to find the largest number of a selected range?
A.
B.
C.
D.
E.
12.  How many columns have been set to be filtered?
A.
B.
C.
D.
E.
13.  What is the purpose of this icon?
A.
B.
C.
D.
E.
14.  Where is the Name Box located?
A.
B.
C.
D.
E.
15.  What Excel feature was used to input the note to the user?
A.
B.
C.
D.
E.
16.  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.
17.  Where can you insert and edit Headers and Footers in Live View?
A.
B.
C.
D.
E.
18.  This format of numbers is known as what type?
A.
B.
C.
D.
E.
19.  Which icon below would used to create the formatted headings shown below?
A.
B.
C.
D.
E.
20.  What is the Average, Count, and Sum of the selected cells?
A.
B.
C.
D.
E.
Back to top
Quiz Comments (1)
Thanks Nelson, this was indeed a great learning for me irrespective of the how badly I scored. Needless to say , this has given me a realisation how much there is to learn and explore in excel. Appreciate you taking time and compiling this test for me.
to post comments.

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz