Take Another Quiz

Excel 2010 Skills Assessment

20 Questions
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.

Questions and Answers
  • 1. 
    • 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. 
    • 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. 
    • 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. 
    • A. 

      GRANDTOTAL

    • B. 

      SUMPRODUCT

    • C. 

      TOTAL

    • D. 

      PRODTOTAL

    • E. 

      I don't know the answer to this question.

  • 5. 
    • A. 

      None

    • B. 

      3

    • C. 

      2

    • D. 

      4

    • E. 

      I don't know the answer to this question.

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

      Comment

    • B. 

      Note

    • C. 

      Data Validation Input Entry

    • D. 

      Unhidden Comment

    • E. 

      I don't know the answer to this question.

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