Check Your Knowledge On Excel Formatting Quiz

Approved & Edited by ProProfs Editorial Team
The editorial team at ProProfs Quizzes consists of a select group of subject experts, trivia writers, and quiz masters who have authored over 10,000 quizzes taken by more than 100 million users. This team includes our in-house seasoned quiz moderators and subject matter experts. Our editorial experts, spread across the world, are rigorously trained using our comprehensive guidelines to ensure that you receive the highest quality quizzes.
Learn about Our Editorial Process
| By Enzanblaze
E
Enzanblaze
Community Contributor
Quizzes Created: 3 | Total Attempts: 12,734
Questions: 9 | Attempts: 2,965

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 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

    Correct Answer
    A. Dark Blue Square
    Explanation
    The Dark Blue Square is around the Merge & Center button, which combines highlighted cells to become one cell. The Yellow Square is around Wrap Text which makes text visible in one cell by expanding the row. The Red Square is around the font face and font size section. The Light Blue Square is around the Number Format section. The Green Square is around the alignment section.

    Rate this question:

  • 2. 

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

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    In Excel, you can change the format of a cell to make a cell automatically format numbers inside it as currency.

    Rate this question:

  • 3. 

    Which of the following are types of Cell Formatting that excel features?

    • A.

      General

    • B.

      Number

    • C.

      Currency

    • D.

      Accounting

    • E.

      Finance

    Correct Answer(s)
    A. General
    B. Number
    C. Currency
    D. Accounting
    Explanation
    General is the default Cell Formatting in cells in Excel, it does not apply any type of special formatting.
    The Number format automatically adds decimals to all numbers. (Ex: 1 turns into 1.00)
    The Currency and Accounting formats are very similar, they both automatically apply the $ sign to the cell and convert the number into cash amounts. (Ex: 1 becomes $1.00 or $ 1.00 depending on which is selected)
    There is no Finance format, however, one could create one by making a custom format.

    Rate this question:

  • 4. 

    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

    Correct Answer
    B. Bottom Border
    Explanation
    Underline will only line the text inside a cell.
    Bottom border will add a line border below an entire cell.
    There is no such thing as Important Border in Excel.
    Top Border will add a border on top of a cell.
    Thick Box Border adds a thick border around the entire cell.

    Rate this question:

  • 5. 

    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

    Correct Answer
    A. Content Formatting
    Explanation
    Content Formatting refers to the formatting done to the content of the spreadsheets. In other words, in refers to the different types of formatting that can be applied to the text in a cell, including Bold, Italicize, Underline, Currency Formatting, Highlighting, etc...
    General Formatting is a specific cell format that does nothing to a cell. (This is the default format for cells)
    Structural Formatting refers to the way the spreadsheet in formatted. In other words, how the rows and columns are formatted.
    There is no Auto-Fill Formatting, but there is an auto-fill feature.

    Rate this question:

  • 6. 

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

    • A.

      True

    • B.

      False

    Correct Answer
    B. False
    Explanation
    The default format for text inside cells is General, which applies no special formatting to a cell.
    Number adds the decimal values to a whole number. Example: 1 becomes 1.00

    Rate this question:

  • 7. 

    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.

    Correct Answer
    A. False, it is possible to resize a row.
    Explanation
    Rows may be re-sized easily by simply dragging the line below a row.

    Rate this question:

  • 8. 

    What is the shortcut for italicizing text?

    • A.

      CTRL + i

    • B.

      CTRL + b

    • C.

      CTRL + u

    Correct Answer
    A. CTRL + i
    Explanation
    CTRL + i will italicize font.
    CTRL + b will bold font.
    CTRL + u will underline font.

    Rate this question:

  • 9. 

    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

    Correct Answer
    C. Structural Formatting
    Explanation
    Structural formatting refers to the formatting of columns and rows in a document or spreadsheet. It involves adjusting the width and height of columns and rows, merging or splitting cells, and applying borders and gridlines to create a well-organized and visually appealing layout. This type of formatting helps in structuring and organizing the data, making it easier to read and understand.

    Rate this question:

Quiz Review Timeline +

Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.

  • Current Version
  • Sep 29, 2023
    Quiz Edited by
    ProProfs Editorial Team
  • May 01, 2011
    Quiz Created by
    Enzanblaze
Back to Top Back to top
Advertisement
×

Wait!
Here's an interesting quiz for you.

We have other quizzes matching your interest.