Check Your Knowledge On Excel Formatting 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 SquareExplanation
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. FalseExplanation
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. AccountingExplanation
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 BorderExplanation
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 FormattingExplanation
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. FalseExplanation
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.00Rate 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 + iExplanation
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 FormattingExplanation
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, 2023Quiz Edited by
ProProfs Editorial Team -
May 01, 2011Quiz Created by
Enzanblaze
Back to top