Excel Lesson 2-creating A Workbook

20 Questions | Total Attempts: 756

SettingsSettingsSettings
Excel Lesson 2-creating A Workbook - Quiz

This quiz concerns Excel Lesson 2-Creating a workbook.


Questions and Answers
  • 1. 
    Labels are aligned at the ________ edge of the cell.
    • A. 

      Left

    • B. 

      Right

    • C. 

      Top

    • D. 

      Bottom

  • 2. 
    You can complete a cell entry by pressing
    • A. 

      Enter

    • B. 

      Tab

    • C. 

      Shift+tab

    • D. 

      An arrow key

    • E. 

      Another cell

  • 3. 
    The default font keyed in a new work book is.
    • A. 

      12 pt. Times New Romans

    • B. 

      10 pt. Arial

    • C. 

      12 pt. Bradley Hand ITC

    • D. 

      10 pt. Times New Roman

  • 4. 
    True or False.  If you choose a larger font size, the height of the row is automatically made taller.
  • 5. 
    Which button allows you to copy cell formats from one cell to another?
    • A. 

      Enter

    • B. 

      Autofit

    • C. 

      Format painter

    • D. 

      Esc

  • 6. 
    A_______ is a group of cells that form a retangle on the screen.
    • A. 

      Label

    • B. 

      Workbook

    • C. 

      Worksheet

    • D. 

      Column

    • E. 

      Range

  • 7. 
    How do you know a range is active?
    • A. 

      It is highlighted on the screen.

    • B. 

      It has a marquee around it.

    • C. 

      The data changes to Bold to let me know it's active

    • D. 

      I'm psychic & I just Know!!

  • 8. 
    True or False.  A range has an address called an range address.
    • A. 

      True

    • B. 

      False

  • 9. 
    An example of a  range address.
    • A. 

      A1:B3

    • B. 

      A1;B3

    • C. 

      A1-B3

    • D. 

      A1=B3

    • E. 

      A1*B3

  • 10. 
    When you start to select a range of cells, you will see a thick white, cross shaped pointer called a ________________.
    • A. 

      Cell selecter

    • B. 

      Cell cross

    • C. 

      Selection pointer

    • D. 

      Range selecter

  • 11. 
    If labels spill onto the column to it's right & the column on the right is not empty you need to ________________.
    • A. 

      Resize the column

    • B. 

      Complete your calculations by hand, excel is too hard to learn.

    • C. 

      Select the column to delete it, you didn't need it anyway.

    • D. 

      Leave it the way it is.

    • E. 

      Widen it so the label is not cut off.

  • 12. 
    A__________ is a single point of color on the screen.
    • A. 

      Pixel

    • B. 

      Cell

    • C. 

      Border

    • D. 

      Margin

  • 13. 
    A value is always _____________ aligned in the cells & is included in calculations.
    • A. 

      Left

    • B. 

      Centered

    • C. 

      Justified

    • D. 

      Right

  • 14. 
    This button allows you to incorporate the currency format to data.
    • A. 

      .

    • B. 

      %

    • C. 

      =

    • D. 

      -

    • E. 

      $

  • 15. 
    When you key the date, excel applies a standard format that shows:
    • A. 

      2 digits for the month, 2 digits for the day, & either 2 or 4 digits for the year.

    • B. 

      Excel leaves it exactly the way I type it!

    • C. 

      The formula to change the date.

  • 16. 
    What does the function Sum do?
    • A. 

      Adds the values in the range & then divides by the number of cells in the range.

    • B. 

      Determines the largest value in a range.

    • C. 

      Multiplies the values in a range.

    • D. 

      Adds the values in the cell

  • 17. 
    You can check results of your calculations by using:
    • A. 

      Auto fit

    • B. 

      Auto replace

    • C. 

      Auto correct

    • D. 

      Auto calculate

  • 18. 
    A_________ is a built in mathematical formula included in excel.
    • A. 

      Cell

    • B. 

      Formula

    • C. 

      Range

    • D. 

      Range address

    • E. 

      Function

  • 19. 
    A________ is a series of instructions that performs a calculation & displays an answer.
    • A. 

      Function

    • B. 

      Formula

    • C. 

      Range

    • D. 

      Cell

  • 20. 
    Formula's always start with:
    • A. 

      =

    • B. 

      -

    • C. 

      *

    • D. 

      +

    • E. 

      /

Back to Top Back to top