Skip to content

MS Excel (Part 1)

Cell References

When to use relative vs. absolute?

Cell References – Practice!

Basic Calculations

Basic Calculations – Practice!

Advanced Calculations

PMT with annuities

Advanced Calculations – Practice!

Working with Dates

YEAR, MONTH, DAY

Working with Dates – Practice!

VLOOKUP – Practice!

Why are Excel charts necessary?

How to create an Excel chart

Insert Excel chart title

Change style of Excel chart

Edit the axis of Excel chart

Add data labels to Excel chart

Add trendline in Excel chart

Select data range for Excel chart

Excel Charts – Practice!

Why use text files?

How to import a text file

Text files – Practice!

Practice Module 1 – Excel (Part 1)

Practice Module 2 – Excel (Part 1)

Practice Module 3 – Excel (Part 1)

Practice Module 4 – Excel (Part 1)

Previous Practice Exercise

Next Practice Exercise

Practice Module 2 – Excel (Part 1)

You are currently viewing a sample of the Cram Kit. Click here to unlock everything.

MS Excel (Part 1)
Practice Module 2 – Excel (Part 1)

Click here to download the Excel file to do your work!
Click here to download the Answer Key!

Time limit: 0

Practice Exercise Summary

0 of 18 Questions completed

Questions:

Information

You have already completed the practice exercise before. Hence you can not start it again.

Practice Exercise is loading…

You must sign in or sign up to start the practice exercise.

You must first complete the following:

Results

Practice Exercise complete. Results are being recorded.

Results

0 of 18 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%

Review / Skip
Answered
Correct
Incorrect

Question 1 of 18

1. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 2 of 18

2. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 3 of 18

3. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 4 of 18

4. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 5 of 18

5. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 6 of 18

6. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 7 of 18

7. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 8 of 18

8. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 9 of 18

9. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 10 of 18

10. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 11 of 18

11. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 12 of 18

12. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 13 of 18

13. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 14 of 18

14. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 15 of 18

15. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 16 of 18

16. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 17 of 18

17. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect
Question 18 of 18

18. Question
This question is locked.
Practice with Me! Already purchased? Click here to login.
1. Navigate to the Sheet3 worksheet.
2. Rename Sheet3 to “Tinder Matches”.
3. Merge the cells A6:A9. Then, center the text vertically and horizontally and orient the text with the “Rotate Text Up” option.
4. Center the headers between C6:F6.
5. Indent the “City” labels by one character.
6. Format the values in E7:E9 to be the custom Number format with negative numbers represented as red numbers with parentheses around them, along with 0 decimal places.
7. In F7:F9 format the numbers to a Percentage format with 1 decimal place.
8. Apply the “60% – Accent1” cell style to A6, then increase font size to 16 and bold.
9. In the range E7:E9 apply the “Top/Bottom Rule” conditional format to display the highest number in dark green text with green fill.
10. In the range F7:F9 apply the “Top/Bottom Rule” conditional format to display the lowest percentage in dark red text with light red fill.
11. Use the Format Painter tool to copy everything from A6:F9 to A11:F14.
12. In cell C5 use the correct Sparkline for C7:C9 to visualize the comparison of Tinder matches in Week 1. Then, do the same for D5 and D7:D9.
13. Insert a page break above Row 10.
14. Set the 3 rows repeat themselves on each printout page.
15. Set orientation to Landscape.
16. Add a footer with your full name on the left section of the footer, then the page number on the right section, formatted like so: “Page (page number) of (total pages)”.
17. Use Print Preview to verify that you set the orientation, top repeated rows, and footer correctly.
18. Save your file.
- Click “Check” below for a step-by-step walkthrough!
Correct

Incorrect

Activate AutoScroll

Login

Accessing this cram kit requires a login. Please enter your credentials below!

Username or Email Address

Password

Remember Me

Lost Your Password?