Check Your Knowledge On Excel Formatting Quiz

10 Questions | Attempts: 2787
Share

SettingsSettingsSettings
Check Your Knowledge On Excel Formatting Quiz - Quiz

This quiz goes along with the website Learning Excel for Cal Poly Pomona. This quiz tests people on formatting in Excel.


Questions and Answers
  • 1. 
    In the screenshot above, which colored circle represents where a user must click to Bold the text inside a cell.
    • A. 

      Black Circle

    • B. 

      Yellow Circle

    • C. 

      Blue Circle

    • D. 

      Pink Circle

  • 2. 
    In the screenshot above, which rectangle is around the part the user must click on to combine the cells highlighted so that they may act as one cell for the title.
    • A. 

      Dark Blue Square

    • B. 

      Yellow Square

    • C. 

      Red Square

    • D. 

      Light Blue Square

    • E. 

      Green Square

  • 3. 
    In Excel, if you want a cell to represent currency you must always type the $ symbol yourself inside the cell.
    • A. 

      True

    • B. 

      False

  • 4. 
    Which of the following are types of Cell Formatting that excel features?
    • A. 

      General

    • B. 

      Number

    • C. 

      Currency

    • D. 

      Accounting

    • E. 

      Finance

  • 5. 
    To add a line below an entire cell, one must apply what to the cell?
    • A. 

      Underline

    • B. 

      Bottom Border

    • C. 

      Important Border

    • D. 

      Top Border

    • E. 

      Thick Box Border

  • 6. 
    When dealing with how the text/font appears in a spreadsheet, we are talking about:
    • A. 

      Content Formatting

    • B. 

      General Formatting

    • C. 

      Structural Formatting

    • D. 

      Auto-Fill Formatting

  • 7. 
    The default format for text inside cells is Number, which applies no special formatting to a cell.
    • A. 

      True

    • B. 

      False

  • 8. 
    It is not possible to resize a row.
    • A. 

      False, it is possible to resize a row.

    • B. 

      True, it is impossible to resize a row.

    • C. 

      False, a row may be resize but only if columns are also resized.

  • 9. 
    What is the shortcut for italicizing text?
    • A. 

      CTRL + i

    • B. 

      CTRL + b

    • C. 

      CTRL + u

  • 10. 
    When we are talking about the formatting of columns and rows, we are referring to what type of formatting.
    • A. 

      Currency Formatting

    • B. 

      General Formatting

    • C. 

      Structural Formatting

    • D. 

      Content Formatting

    • E. 

      CIS Formatting

Back to Top Back to top
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.