Lesson 4: Change Workbook Appearance
Quiz Summary
0 of 20 Questions completed
Questions:
Information
You have already completed the quiz before. Hence you can not start it again.
Quiz is loading…
You must sign in or sign up to start the quiz.
You must first complete the following:
Results
Results
0 of 20 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- 1
- 2
- 3
- 4
- 5
- 6
- 7
- 8
- 9
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- Current
- Review
- Answered
- Correct
- Incorrect
-
Question 1 of 20
1. Question
How to make the data labels or any other data stand out?
CorrectIncorrect -
Question 2 of 20
2. Question
How to delete a selected cell’s formatting?
CorrectIncorrect -
Question 3 of 20
3. Question
Clicking Clear All will remove __________________.Â
CorrectIncorrect -
Question 4 of 20
4. Question
Clicking the body of the Border, Fill Colour, or Font button applies the most recently applied formatting to the currently selected __________.
CorrectIncorrect -
Question 5 of 20
5. Question
You can display the most commonly used formatting controls by ______________.
CorrectIncorrect -
Question 6 of 20
6. Question
How to change the attributes of every cell in a row or column?
CorrectIncorrect -
Question 7 of 20
7. Question
One task you can’t perform by using the tools on the ribbon is to change the default ________ for a workbook, which is used in the formula bar.
CorrectIncorrect -
Question 8 of 20
8. Question
The default font when you install Excel is ________, a simple font that is easy to read on a computer screen and on the printed page.
CorrectIncorrect -
Question 9 of 20
9. Question
How to change the default font?
CorrectIncorrect -
Question 10 of 20
10. Question
The new standard font doesn’t take effect until _________________________________.Â
CorrectIncorrect -
Question 11 of 20
11. Question
How to change the font used to display cell contents?
-
In the font list, click the font you want to apply
-
On the Home tab of the ribbon, in the Font group, click the Font arrow
-
Select the cell or cells you want to format
View Answers:
CorrectIncorrect -
-
Question 12 of 20
12. Question
How to change the size of characters in a cell or cells?
-
Click the Font Size arrow
-
Click the size you want to apply
-
Select the cell or cells you want to format
View Answers:
CorrectIncorrect -
-
Question 13 of 20
13. Question
How to change the size of characters in a cell or cells by one increment?
-
Click the Increase (or Decrease) Font Size button
-
Select the cell or cells you want to format
View Answers:
CorrectIncorrect -
-
Question 14 of 20
14. Question
How to change the colour of a font?
-
Click the colour you want to apply
-
Select the cell or cells you want to format
-
Click the Font Colour arrow (not the button)
View Answers:
CorrectIncorrect -
-
Question 15 of 20
15. Question
How to change the background colour of a cell or cells?
-
Click the colour you want to apply
-
Click the Fill Colour arrow (not the button)
-
Select the cell or cells you want to format
View Answers:
CorrectIncorrect -
-
Question 16 of 20
16. Question
How to add a border to a cell or cells?
-
Select the cell or cells you want to format
-
Click the border pattern you want to apply
-
Click the Border arrow (not the button)
View Answers:
CorrectIncorrect -
-
Question 17 of 20
17. Question
How to change the font appearance by using the controls on the Font tab of the Format Cells dialog box?
-
Make the formatting changes you want, and then click OK
-
Click the Font dialog box launcher
View Answers:
CorrectIncorrect -
-
Question 18 of 20
18. Question
How to copy formatting between cells?
-
Select the cell that contains the formatting you want to copy
-
Select the cells to which you want to apply the formatting
-
Click the Format Painter button
View Answers:
CorrectIncorrect -
-
Question 19 of 20
19. Question
How to delete cell formatting?
-
Click Clear Formats in the menu that appears
-
Click the Clear button in the Editing group
-
Select the cell or cells from which you want to remove formatting
View Answers:
CorrectIncorrect -
-
Question 20 of 20
20. Question
How to change the default font of a workbook?
-
Click the font size you want in the Font size list, and then click OK
-
Display the Backstage view, and then click Options
-
Exit and restart Excel to complete the default font change
-
On the General page of the Excel Options dialog box, in the Use this as the default font list, click the font you want to use
View Answers:
CorrectIncorrect -