Check Your Knowledge On Excel Formatting Quiz
10 Questions
| Attempts: 2787
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
Related Topics
Recent Quizzes
Featured Quizzes
Back to top