Computer Applications II-excel

10 Questions | Total Attempts: 162

SettingsSettingsSettings
Please wait...
Computer Application Quizzes & Trivia

This is to help you review for the Excel Portion of the Computer Applications II website.


Questions and Answers
  • 1. 
    What do you type into an exmpty cell to start a formula?
    • A. 

      *

    • B. 

      (

    • C. 

      =

  • 2. 
    What is a function?
    • A. 

      A prewritten formula

    • B. 

      A math operator

  • 3. 
    A formula result is in cell C6.  You wonder how you got the result.  To see the formula, you:
    • A. 

      Click in cell C6, and then press CTRL+SHIFT

    • B. 

      Click in cell C6, and then press F5

    • C. 

      Click in cell C6

  • 4. 
    Which cell reference refers to a range of cells in column B, rows 3 through 6?
    • A. 

      (B2:B6)

    • B. 

      (B3,B6)

  • 5. 
    Which of these is an absolute reference?
    • A. 

      B4: B12

    • B. 

      $A$1

  • 6. 
    If you copy the formula =c4*$D$9 from cell C4 to cell C5, what wil lthe formula be in cell C5?
    • A. 

      =C5*$D$9

    • B. 

      =C4*$D$9

    • C. 

      =C5*$E$10

  • 7. 
    You can customize Excel 2007 by adding comands to the Quick Access Toolbar.
    • A. 

      True

    • B. 

      False

  • 8. 
    To insert a new column, you start by clicking in teh Cells group on the Home Tab.
    • A. 

      True

    • B. 

      False

  • 9. 
    Too add a column, click a cell in the column to the right of where you want the new column.
    • A. 

      True

    • B. 

      False

  • 10. 
    To add a new row, click a cell in the row immediately above where you want the new row.
    • A. 

      True

    • B. 

      False