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.
| By Enzanblaze
E
Enzanblaze
Community Contributor
Quizzes Created: 3 | Total Attempts: 12,734
Questions: 9 | Attempts: 2,965

Settings

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

• 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

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

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

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

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

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

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.

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

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

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

Related Topics