Excel 2010 Skills Assessment

20 Questions  I  By Carlson95602
Please take the quiz to rate it.

 Excel 2010 Skills Assessment
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.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 1. 
    What is wrong with this formula?  =IF(D3=<90,"A-",0)
    • A. 

      The operator symbols are in reverse order

    • B. 

      There is no need to place quotation marks around the letter A

    • C. 

      Excel doesn't use a Function named IF

    • D. 

      The number of arguments is incorrect

    • E. 

      I don't know the answer to this question.


  • 2. 

    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. 

      =TRANSPOSE(B2, C2)

    • B. 

      =COMBINE(B2,", ",C2)

    • C. 

      =CONCATENATE(B2,", ",C2)

    • D. 

      =TEXT (B2:C2, PROPER)

    • E. 

      I don't know the answer to this question.


  • 3. 

    What does this symbol on the status bar of Excel indicate?
    • A. 

      That the workbook is ready to be used.

    • B. 

      That the user can click and drag the mouse to create a square

    • C. 

      That there are currrently NO spelling errors on the worksheet

    • D. 

      That a macro is currently being recorded

    • E. 

      I don't know the answer to this question.


  • 4. 

    What function would be used to find the total sales of both the High School and Jr High food as shown below:
    • A. 

      GRANDTOTAL

    • B. 

      SUMPRODUCT

    • C. 

      TOTAL

    • D. 

      PRODTOTAL

    • E. 

      I don't know the answer to this question.


  • 5. 

    How many columns have been set to be filtered?
    • A. 

      None

    • B. 

      3

    • C. 

      2

    • D. 

      4

    • E. 

      I don't know the answer to this question.


  • 6. 

    This format of numbers is known as what type?
    • A. 

      General

    • B. 

      Number

    • C. 

      Currency

    • D. 

      Accounting

    • E. 

      I don't know the answer to this question.


  • 7. 

    What is the purpose of this icon?
    • A. 

      To search for, insert, and get help with functions

    • B. 

      To add special Effects (Fx) to the worksheet

    • C. 

      To determine if the syntax of the current formula is correct

    • D. 

      To use the Tool Analysis AddOn feature

    • E. 

      I don't know the answer to this question.


  • 8. 
    How do you select noncontiguous cells?
    • A. 

      Click a cell, then hold down SHIFT on the keyboard and select the other cells

    • B. 

      Click in a cell, then hold down ALT on the keyboard as you select the other cells

    • C. 

      Click in a cell, hold down CTRL on the keyboard and then select the other cells

    • D. 

      Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard

    • E. 

      I don't know the answer to this question.


  • 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. 

      Watch Window

    • B. 

      Show Formulas

    • C. 

      What If Scenario

    • D. 

      Formula Watch

    • E. 

      I don't know the answer to this question.


  • 10. 
    Where is the Name Box located?
    • A. 

      On the Formulas tab, Defined Names group

    • B. 

      Directly above Column A

    • C. 

      Just to the right of the Fx (Insert Function) icon

    • D. 

      On the View tab, Windows group

    • E. 

      I don't know the answer to this question.


  • 11. 
    Where can you insert and edit Headers and Footers in Live View?
    • A. 

      Insert, Header & Footer

    • B. 

      Print Preview window

    • C. 

      Page Break Preview

    • D. 

      Page Layout View

    • E. 

      I don't know the answer to this question.


  • 12. 

    What is the Average, Count, and Sum of the selected cells?
    • A. 

      Average: 46,265 Count: 6 Sum: 323,857

    • B. 

      Average: 46,265 Count: 7 Sum: 212,313

    • C. 

      Average: 46,265 Count: 7 Sum: 323,857

    • D. 

      Average: 46,550 Count: 7 Sum: 43,440

    • E. 

      I don't know the answer to this question.


  • 13. 

    What steps do you take to create the following conditional format?
    • A. 

      Select the desired data. Home Tab. Conditional Formatting. Data Bars. Choose one.

    • B. 

      Select the desired data. Home Tab. Conditional Formatting. Color Sets. Choose one.

    • C. 

      Select the desired data. Home Tab. Conditional Formatting. Icon Sets. Choose one.

    • D. 

      Select the desired data. Data Tab. Conditional Formatting. Icon Sets. Choose one.

    • E. 

      I don't know the answer to this question.


  • 14. 

    What does this icon do?
    • A. 

      Copies the font, font size, font color, etc. from a selected cell to other cells

    • B. 

      Copies the font, font size, font color, and formulas from a selected cell to other cells

    • C. 

      Copies all formatting, including Conditional Formatting, to other cells

    • D. 

      Creates headings styles that can be used throughout the workbook

    • E. 

      I don't know the answer to this question.


  • 15. 
    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. 

      Page Layout tab, Cell Styles, Save Style, type a name for the style, click OK

    • B. 

      Insert Tab, New Style, type a name for the style, click OK

    • C. 

      Home Tab, New Style, Save Style, type a name for the style, click OK

    • D. 

      Home Tab, Cell Styles, New Cell Style, type a name for the new style, click OK

    • E. 

      I don't know the answer to this question.


  • 16. 
    Which function would you use to find the largest number of a selected range?
    • A. 

      MAXIMUM

    • B. 

      LARGEST

    • C. 

      MAX

    • D. 

      LARGE

    • E. 

      I don't know the answer to this question.


  • 17. 
    How is the function COUNTA different from the function COUNT?
    • A. 

      COUNTA counts the number of cells that are not empty in a range

    • B. 

      COUNTA counts only the cells that contain numbers

    • C. 

      COUNTA counts only the cells that contain text

    • D. 

      COUNTA counts every cell in a range regardless of whether they are empty, contain text, or contain numbers

    • E. 

      I don't know the answer to this question.


  • 18. 

    Which icon below would used to create the formatted headings shown below?
    • A. 
    • B. 
    • C. 
    • D. 
    • E. 

      I don't know the answer to this question.


  • 19. 

    What Excel feature was used to input the note to the user?
    • A. 

      Comment

    • B. 

      Note

    • C. 

      Data Validation Input Entry

    • D. 

      Unhidden Comment

    • E. 

      I don't know the answer to this question.


  • 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. 

      You would need to view each department as a separate Pivot Table first, then copy the worksheet to its own tab

    • B. 

      Options contextual tab, Options icon, Show Report Filter Pages, OK

    • C. 

      Display all departments, Options contextual tab, Move Worksheet icon, choose "New Worksheet", OK

    • D. 

      Design tab, Move Pivot Table icon, "Move to Individual Worksheet", OK

    • E. 

      I don't know the answer to this question.


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.