MS Excel 2003 Proficiency Quiz: Trivia!

19 Questions | Total Attempts: 4319

SettingsSettingsSettings
Please wait...
MS Excel 2003 Proficiency Quiz: Trivia!

.


Questions and Answers
  • 1. 
    Which of the following allows you to delete a spreadsheet from a workbook?
    • 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

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

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

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

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

  • 6. 
    Using the autosum button 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

  • 7. 
    To arrange rows in alphabetical order based on column A you need to use command.
    • A. 

      Tools/sort

    • B. 

      Data/sort

    • C. 

      Edit/data/sort

    • D. 

      None of the above

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

  • 9. 
    The default orientation for the printed page is?
    • A. 

      Portrait

    • B. 

      Landscape

    • C. 

      Whatever was last used

    • D. 

      Normal

  • 10. 
    • A. 

      D4 + (B1+B2)

    • B. 

      =D4+(B1*B2)

    • C. 

      D4+B1*B2

    • D. 

      =D4+(B1 + B2)

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

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

      Number

    • B. 

      Alignment

    • C. 

      Font

    • D. 

      Border

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

  • 14. 
    What best describes 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

  • 15. 
    What is wrong with the following function arguments
    • 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

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

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

  • 18. 
    How can you show data which was previously hidden?
    • 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

  • 19. 
    Why is this pivot chart showing only 1 for over 90 on all accounts? Why
    • 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