Check Your Knowledge On Excel Formatting Quiz

Reviewed by Editorial Team
The ProProfs editorial team is comprised of experienced subject matter experts. They've collectively created over 10,000 quizzes and lessons, serving over 100 million users. Our team includes in-house content moderators and subject matter experts, as well as a global network of rigorously trained contributors. All adhere to our comprehensive editorial guidelines, ensuring the delivery of high-quality content.
Learn about Our Editorial Process
| By Enzanblaze
E
Enzanblaze
Community Contributor
Quizzes Created: 3 | Total Attempts: 14,401
| Attempts: 3,150
SettingsSettings
Please wait...
  • 1/9 Questions

    What is the shortcut for italicizing text?

    • CTRL + i
    • CTRL + b
    • CTRL + u
Please wait...
About This Quiz

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

Check Your Knowledge On Excel Formatting Quiz - Quiz

Quiz Preview

  • 2. 

    It is not possible to resize a row.

    • False, it is possible to resize a row.

    • True, it is impossible to resize a row.

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

  • 3. 
    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. - ProProfs

    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.

    • Dark Blue Square

    • Yellow Square

    • Red Square

    • Light Blue Square

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

  • 4. 

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

    • True

    • False

    Correct Answer
    A. 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:

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

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

    • Underline

    • Bottom Border

    • Important Border

    • Top Border

    • Thick Box Border

    Correct Answer
    A. 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:

  • 6. 

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

    • Content Formatting

    • General Formatting

    • Structural Formatting

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

  • 7. 

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

    • Currency Formatting

    • General Formatting

    • Structural Formatting

    • Content Formatting

    • CIS Formatting

    Correct Answer
    A. 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:

  • 8. 

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

    • True

    • False

    Correct Answer
    A. 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:

  • 9. 

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

    • General

    • Number

    • Currency

    • Accounting

    • Finance

    Correct Answer(s)
    A. General
    A. Number
    A. Currency
    A. 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:

Quiz Review Timeline (Updated): Sep 29, 2023 +

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.