Module 5 - Quiz 1

3 Questions

Settings
Please wait...
Excel Quizzes & Trivia

.


Questions and Answers
  • 1. 
    When you refer to an entire column of an Excel table, you are using...
    • A. 

      Structured references.

    • B. 

      Unstructured references.

    • C. 

      R1C1 notation.

    • D. 

      Dynamic scroll bars.

  • 2. 
    What is the first recommended course of action when creating a new Excel table?
    • A. 

      Change the default table name (e.g. "Table1") to something descriptive.

    • B. 

      Delete overlapping columns.

    • C. 

      Place clipart over important numerical regions.

    • D. 

      Nothing, the table is perfect without changes.

  • 3. 
    What happens if you add additional data in the cells adjacent to the bottom of an Excel table?
    • A. 

      The table automatically grows to capture the new added data.

    • B. 

      Nothing.

    • C. 

      Excel will ask if you'd like to add the new row of data to the preexisting table.

    • D. 

      Whatever you place at the bottom of the table will be overwritten with summary data.