Microsoft Excel 2003 Basics: Quiz!

15 Questions | Total Attempts: 786

SettingsSettingsSettings
Please wait...
Microsoft Excel 2003 Basics: Quiz!

Are you familiar with Microsoft Excel 2003? Do you want to see if you can correctly answer the questions? Excel 2003 can help you work better in teams and help protect and manage access to your work. You can read data in any customer identified XML schema without reformatting. You can manipulate XML data sources using charts, tables, or graphs. If you want to learn more about Microsoft Excel 2003, try this quiz.


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 a 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

Back to Top Back to top