Excel Proficiency Quiz

20 Questions

Settings
Please wait...
Excel Proficiency Quiz

A quick quiz to test proficiency in Excel 2003


Questions and Answers
  • 1. 
  • 2. 
    • A. 

      Left click on the spreadsheet tab and press delete

    • B. 

      Right click on spreadsheet tab and select "delete"

    • C. 

      Press control and click the spreadsheet tab

    • D. 

      None of the above

  • 3. 
    On an excel spreadsheet the active cell is indicated by
    • A. 

      A dark wide border

    • B. 

      A dotted border

    • C. 

      A blinking border

    • D. 

      None of the above

  • 4. 
    To Select a column the easiest method is to
    • A. 

      Double-click any cell in the column

    • B. 

      Drag from the top of the cell i the colmn to the last cell in the column

    • C. 

      Click the column heading

    • D. 

      Click the column label

  • 5. 
    The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is
    • A. 

      B1.G10

    • B. 

      B1-G10

    • C. 

      B1:G10

    • D. 

      1:10:B:G

  • 6. 
    The "view" that puts a blue line around each page that would be printed is the
    • A. 

      Print privew

    • B. 

      Normal

    • C. 

      Page break preview

    • D. 

      None of the above

  • 7. 
    Using the autosum botton will place in the selected cell
    • A. 

      The sum of the values in the cell column

    • B. 

      Nothing untill you select a range

    • C. 

      The sum of the cells row unless you change the range

    • D. 

      A formula which will add values in the range excel guesses you want to add

  • 8. 
    To arrange rows in alphabetical order baesed on colmn A you need to use command
    • A. 

      Tools/sort

    • B. 

      Data/sort

    • C. 

      Edit/data/sort

    • D. 

      None of the above

  • 9. 
    If a cell shows ##### it means that
    • A. 

      Your formula has a syntax error

    • B. 

      The row is too short to show the number at the current font size

    • C. 

      The colmn is too narrow to show all the digits of the number

    • D. 

      Either B or C

  • 10. 
    The default orientation for the printed page is
    • A. 

      Portrait

    • B. 

      Landscape

    • C. 

      Whatever was last used

    • D. 

      Normal

  • 11. 
    • A. 

      D4 + (B1+B2)

    • B. 

      =D4+(B1*B2)

    • C. 

      D4+B1*B2

    • D. 

      =D4+(B1 + B2)

  • 12. 
    • A. 

      The date is copied to each cell

    • B. 

      The date is increased by 1 day into each cell

    • C. 

      The date is increased by 1 week into each cell

    • D. 

      Nothing as autofill applies only to numbers

  • 13. 
    The settings to wrap text in a cell and to merge cells are found in the format cells dialoge on the _______ tab
    • A. 

      Number

    • B. 

      Alignment

    • C. 

      Font

    • D. 

      Border

  • 14. 
    When can conditional formating be most useful
    • A. 

      To add values together

    • B. 

      To change font sizes

    • C. 

      To use unique formating options

    • D. 

      To highlight cells if conditions are met

  • 15. 
    What best decribes a pivot table
    • A. 

      A useful tool for giving extra details on tables

    • B. 

      A useful tool for organizing data

    • C. 

      A useful tool for quickly rearanging data to meet your needs

    • D. 

      A annoying function which serves no purpose

  • 16. 
    • A. 

      The range lookup should never be 0

    • B. 

      The column value should only be 1 since the lookup consist of only 1 column

    • C. 

      The lookup value and table array should be switched

    • D. 

      There is nothing wrong with the Function

    • E. 

      Both B and C

  • 17. 
    What is the best describes the purpose of a macro
    • A. 

      Quickly sort data

    • B. 

      Show data in easy to analyse ways

    • C. 

      Make a chart quickly

    • D. 

      Perform multiple functions quickly and easily

    • E. 

      Both A and B

  • 18. 
    • A. 

      Sorting arranges and hides data

    • B. 

      Filtering just arranges data

    • C. 

      Sorting can handle multiple criteria

    • D. 

      Filtering hides data as well as can sort

  • 19. 
    • A. 

      Right click and select unhide

    • B. 

      Go to options and click unhide

    • C. 

      Hold down H and click the cell

    • D. 

      None of the above

  • 20. 
    why is this pivot chart showing only 1 for over 90 on all accountsWhy
    • A. 

      The columns and rows are switched

    • B. 

      There is no filter on

    • C. 

      The sum of values over 90 shouldnt be selected

    • D. 

      The Values box should be sum not count