Excel 2003 Basics Pmclp

15 Questions

Settings
Please wait...
Microsoft Excel Quizzes & Trivia

15 question quiz to test basic knowledge of Excel 2003


Questions and Answers
  • 1. 
    Which option allows you to delete a spreadsheet from a workbook
    • A. 

      Left click on spreadsheet tab and press delete

    • B. 

      Right click on spreadsheet tab and select "delete"

    • C. 

      Press "Ctrl" and the spreadsheet tab

    • D. 

      None of the above

  • 2. 
    Which option will NOT allow you to copy a cell
    • A. 

      Right click and select "copy"

    • B. 

      Right click and select "insert"

    • C. 

      Go to "Edit" and select "copy"

    • D. 

      None of the above

  • 3. 
    On an Excel sheet 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 cell in the column 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. 

      B1:G10

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

      Print Preview

    • B. 

      Normal

    • C. 

      Page Break Preview

    • D. 

      None of the above

  • 7. 
    Using the AutoSum button will place in the selected cell
    • A. 

      The sum of values in the cell's column

    • B. 

      Nothing until you select a range of cells

    • C. 

      The sum of the cell's row unless you change the range

    • D. 

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

  • 8. 
     A spreadsheet shows in Page Break Preview that cells in Rows 1 - 25 have white background. The cells in Row 26 that contain data have a dark gray background. When you click the Print button,
    • A. 

      Nothing will print because some cells with data have been omitted

    • B. 

      Only the cells with gray background will print

    • C. 

      The whole sheet will print

    • D. 

      Only the cells with white background will print.

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

      Tools | Sort

    • B. 

      Data | Sort

    • C. 

      Edit | Data | Sort

    • D. 

      None of the above

  • 10. 
    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 column is too narrow to show all the digits of the number

    • D. 

      Either b or c

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

      Portrait

    • B. 

      Landscape

    • C. 

      Whatever was last used

  • 12. 
    To print just part of a sheet, you would select what you want to print and select Print selection in the Print dialog and then print
    • A. 

      True

    • B. 

      False

  • 13. 
    The formula that will add the value of cell D4 to the value of C2 and then multiply by the value in B2 is
    • A. 

      (D4+C2)*B2

    • B. 

      D4+C2*B2

    • C. 

      =(D4+C2)*B2

    • D. 

      =(B2*(D4+C2)

  • 14. 
    If you select a cell with a date in it and drag the fill handle down across several cells, what happens is:
    • 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

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