Excel 2007 Engr 112 Quiz

11 Questions | Total Attempts: 129

SettingsSettingsSettings
Please wait...
Microsoft Excel Quizzes & Trivia

Quiz for ENGR 112 on microsoft excel.


Questions and Answers
  • 1. 
    What is the correct cell entry for the following scenario (no spaces):You wish to add cell c46 and d53.
  • 2. 
     The colon (:) in B3:B6 indicates a ______ in column B, rows 3 through 6. 
    • A. 

      Cell argument

    • B. 

      Cell range

    • C. 

      Cell reference

  • 3. 
    What is a function?
    • A. 

      A prewritten formula

    • B. 

      A math operator

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

  • 5. 
    Cell reference A10,A20 refers to values in:
    • A. 

      The range of cells in column A and rows 10 through 20

    • B. 

      The range of cells in columns A through E and rows 10 through 20

    • C. 

      Cell A10 and A20

  • 6. 
    Cell references are __________ by default.
    • A. 

      Absolute

    • B. 

      Relative

  • 7. 
    If you copy the formula =C4*$D$9 from cell C4 to cell C5, what will the formula be in cell C5?
    • A. 

      =C4*$D$9

    • B. 

      =C5*$D$9

    • C. 

      =C5*$E$10

  • 8. 
    What does ##### mean?
    • A. 

      The column is not wide enough to display the content.

    • B. 

      The cell reference is not valid.

    • C. 

      You have misspelled a function name or used a name that Excel doesn't recognize.

  • 9. 
    You create a chart. But later on you don't see the Chart Tools. What do you do to get them back?
    • A. 

      Create another chart.

    • B. 

      Click inside the chart.

    • C. 

      Click the Insert tab.

  • 10. 
    You can't change the chart type after you create a chart.
    • A. 

      True

    • B. 

      False

  • 11. 
    You want to add data labels above each column to show a value for each column. How can you do this? (You learned this in the practice.)
    • A. 

      Add the labels manually.

    • B. 

      Change the chart style.

    • C. 

      Change the chart layout.

Back to Top Back to top