September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

1. The large toolbar that extends across the top of the 1 / 1 point
Excel window is known as the Excel toolbar.

True

False

Correct
Yes, your answer is correct. The statement is false. This bar of
tools are not known like Excel bar.

The Excel ribbon can be minimized or collapsed by double-clicking (a single click on

1 / 1 point
Mac) in one of the tabs of the ribbon.

True

False

Correct
Yes, your answer is correct. The Excel ribbon can be minimized or collapsed.
double-clicking (a single click on Mac) on one of the tabs in the ribbon.

Columns are referred to by letters of the alphabet. 1 / 1 point

True

False

Correct
Yes, your answer is correct. The columns are referenced by
letters of the alphabet.

Rows are referred to by letters of the alphabet. 1 / 1 point

True

False

Unable to access the content of the provided URL. 1/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
Yes, your answer is correct. The statement is false. It refers to the
lines by numbers.

5. The first cell (top left) in a standard Excel spreadsheet is 1 / 1 point

know how1A.

True

False

Correct
Yes, this is the correct answer. The statement is false: the first cell of
A standard Excel spreadsheet is not called 1A.

6. Cell B2 is below cell B3. 1 / 1 point

Certain

False

Correct
Yes, you are correct. The statement is false. The cell B2 is not below
the cell B3.

The cells A1, A2, A3, ..., A20 are all in the same row. 1 / 1 point

True

False

Correct
Yes, you are right. The statement is false. The cells A1, A2, A3, ..., A20
they are not in the same row.

8.
Unable to access external links. 2/5
9/7/2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

The Quick Access Toolbar can be customized to display the 1 / 1 punto

tools that he/she uses most frequently.

True

False

Correct
Yes, you are right. The quick access toolbar can be
customize to show the tools you use most frequently.

9. By clicking on cell C3 and clicking on Freeze panes, all will be frozen.1 / 1 point
The rows above C3 will freeze all columns to the left of C3.

True

False

Correct
Yes, you are right! This is a useful feature. When you select
a cell and then clicks on Freeze Panes, Excel freezes all rows
and columns to the left and above the selected cell.

10. You can navigate to the bottom of your spreadsheet using the keys. 1 / 1 point
arrow key.

True

False

Correct

11. You can write directly in a cell by clicking on it and proceeding to 1 / 1 point
write.

True

False

Unable to access external links. 3/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct

12. If text has already been entered in a column and you start typing in the same column, 1 / 1 point
Excel will suggest existing values that start with what you have typed.

True

False

Correct

13. You cannot copy and paste numbers in Excel from other Office software like 1 / 1 point
Microsoft Word.

True

False

Correct

14. If you wish to delete any information from your spreadsheet, you can highlight it. 1 / 1 point
information and press Delete.

True

False

Correct

15. If you want to revert most of the tasks performed earlier, you can click 1 / 1 point
in the Undo button in the top left corner of the Excel window.

Sure

False

Invalid input. Please provide text for translation. 4/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
The Undo tool is very useful when you make a mistake and can be
use in most situations in Excel.

Unable to access or translate the content of the provided URL. 5/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Taking the reins of Excel: Put on

test your skills, Part 2
RATING OF THE LAST SHIPMENT

100%

1. How many rows are in an Excel spreadsheet (version 2007 and later)? 1 / 1 point

50,000

16,348

More than 1 million

Infinite (without limit)

Correct
Yes, isn't it amazing? This would make a great dataset!

2. In a blank Excel workbook, go to the Insert tab in the ribbon. What is the
1 / 1 point
is not available?

Columns (not column chart)

Forms

Photos

Smart art

Correct
You hit the nail on the head! There are several ways to insert columns, use the tab
INSERT is not one of them. Go back to Excel and see if you can find the
button to Insert columns.

3. In cell A1, write the header Date and then press Enter. In cell A2, 1 / 1 point
write the following: 20-Jan-20. Use the fill handle to drag the date
What you just wrote up to row 20. What is the date in A10? Enter as it is.
show or use the Year-Month-Day format if not using an English version of
Excel (for example, 2020-01-20).
Invalid request. Please provide text for translation. 1/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

20-Jan-28

Correct
Yes, excellent work on using the filling handle. Isn't it surprising what
Can you do it in Excel now?

4. In cells B1 to B3 enter the following: 1 / 1 point

Select cells B2 and B3 and then use the fill handle to drag.
Down to row 20. What is the value in B7?

18.72

Correct
Yes, excellent work in using the filling handle. This is a tool for
such good productivity.

5. Close your book without saving and open the attached book. What value is in cell 1Q101
/ 1 pointof the
orderSheet?

[Link]

49

Correct
Yes, good navigation skills!

6. How many worksheets are there in this workbook? 1 / 1 point

Unable to access external links. 2/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
Yes, correct.

7. Go to the worksheet Sales 2016. Which cell contains the header Qtr4? 1 / 1 point

E3

Correct
Yes, that is the correct cell. Check your understanding of the terminology of
Excel. Well done.

8. Even in Sales 2016, select the range B8: E10. Look at the status bar 1in/ 1 point
the
bottom of the screen. You should see Sum followed by a number. What is the
number?

(Suggestion: the range B8:E10 means selecting all the cells between B8 and E10.
We will analyze this in more detail next week. Use the number format.
#####. ##)

50933.77

Correct
Yes, good use of the status bar. Isn't that a useful feature of
Excel?

Select the two non-contiguous ranges (not next to each other) C8:C11 and E8:E11.
1 / 1 point
What is displayed in the status bar average for the two ranges?

(Use the format number####. ##)

5549.49

The provided link does not contain translatable text. 3/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
Everyone says wow! Good selection and navigation skills!

[Link] the value in D6 to 1033.5. What is the new value in D18? 1 / 1 point

(Use the number format #####. ##)

62277.02

Correct
Good job entering data into a spreadsheet correctly.

Unable to access or translate content from external links. 4/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Carrying out calculations: test your

skills
RATING OF THE LAST SHIPMENT

100%

1. Open the attached workbook. In F7, calculate the base salary by multiplying the hours.
1 / 1 point
by the rate. Copy the formula to F12. What is Sophie Yang's base salary for
the week?

Enter only the number, without the dollar sign.

W02_Assessment.xlsx

1083.00

Correct
Yes, 100% good job.

2. InG7, calculate the amount of the Commission by multiplying the Base Payment by the Rate of
1 / 1 point
Commission in J3. Copy the formula down to G12. What is Diepak's commission?
Kumar for the week?

Enter only the number, without the dollar sign.

39.90

Correct
Well done! You are ready to move on.

3. In H7, calculate the gross salary by adding the base salary and the commission. Copy the
1 / 1 point
formula until H12. What is Diepak Kumar's gross salary for the week?

1037.40

Unable to access the content of the link provided. 1/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
Good job!

4.EnI7, calculate the taxes by multiplying the gross salary by the tax rate in 1 / 1 point
J4(in this case, all staff have the same tax rate). Copy the formula
until I12. What is John McGregor's tax for the week?

Enter only the number, without the dollar sign.

299.35

Correct
Yes, great job, you are doing very well.

5.EnJ7, calculate the Net Payment by subtracting the Taxes from the Gross Payment. Copy the
1 / 1 point
Formula until J12. What is Sophie Yang's net pay for the week?

Enter only the number, without the dollar sign.

810.95

Correct
Good job getting the correct formula and using the fill handle.
Great skills.

6. In cells F14: J14, calculate the totals for each of the columns. What was
1 / 1 point
the total gross salary?

Enter only the number, without the dollar sign.

5358.39

Correct
Yes, 100%.
The provided text is a URL and does not contain translatable content. 2/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

7. In the cells F16: J16 calculate an average for each of the columns. What
1 / 1 point
Was it the Media Commission?

Enter only the number, without the dollar sign.

34.35

Correct
Yes, great job. Your hard work and tenacity are paying off.
wonderfully.

8. In cells F17: J17 calculate the maximum for each of the columns. What 1 was
/ 1 point
the maximum gross salary?

Enter only the number, without the dollar sign.

1231.36

Correct
Yes, well done. Did you think you could do this just two weeks later?
of the course?

9. In the cells F18: J18 calculate the minimum for each of the columns. What was
1 / 1 point the
Minimum Commission?

Enter only the number, without the dollar sign.

15.74

Correct
Very well done.

The provided text is a URL and cannot be translated. 3/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

10. Click on the Branch Summary worksheet. First, we want to calculate the 1 / 1 point
Total commission for Edenvale (see the branch column in both sheets). In B6,
write = SUM (then click on Pay Details and select G7: G9, then press
Enter. Repeat the process, selecting the appropriate cells, to obtain the
Total commission for Sandown.

Use the filling controller to obtain the total gross payment of Edenvale and
Sandown. What was the total gross salary of Sandown?

Enter only the number, without the dollar sign.

3337.88

Correct
Wonderful. He has combined a whole range of skills that he already has.
learned to solve this. Excellent job.

Unable to access the provided URL to translate content. 4/4

9/7/2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Formatting: test your skills

RATING OF THE LAST SHIPMENT

100%

Sean wants to make a change in cell B2, but every time he clicks on the
1 / 1 point
cell, A1 becomes the active cell.

What is most likely happening here?

A1 and B2 are linked through an absolute reference.

A1 and B2 have merged.

A1: B2 are a range and cannot be selected separately.

A1: B2 has been configured to Wrap text.

Correct
Yes, right. Well done, your hard work is paying off.

[Link] the attached workbook and observe how the row header has been formatted. 1 / 1 point
What is the name of the font used in the header?

[Link]

Candara

Correct
Yes, it is an excellent job.

3. What alignment option has been applied to the header of row 1? 1 / 1 point
The provided text is a URL and does not contain translatable content. 1/5
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Merge and center

Adjust text

Increase indentation

Average alignment

Correct
Yes, 100%. Well done.

4. What formatting options have been applied to cell A3? 1 / 1 point

(One or more answers are possible; partial credit will be awarded)

Bold

Correct
In fact, the font now appears in bold.

Average alignment

Correct
Yes, that's correct, you solved it quite quickly!

Italic

Correct
Yes, italics have been applied to the font.

Center

5. The date in B3 has lost its format. Apply a long date format. What day
1 / 1 point
When was this data last modified during the week?

Monday

Unable to access the content of the provided URL. 2/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Tuesday

Wednesday

Thursday

Friday

Saturday

Sunday

Correct
Yes! By applying the long date format, you were able to solve this.

6. The percentages in T9 and T10 also have the wrong number format. 1 / 1 point
Change them to the correct numerical format (so that they match the rest of the data)
from the column). What value is now shown in T9?

92.50%

Correct

7. What cell style has been added to cells C38:U38? (Hint: look in the 1 / 1 point
cell style gallery, when you hover over a style, it shows you the name.

Total

Correct
Yes, 100%. Cell styles are a very common formatting tool.
take into account.

8. Which of the following formats has been added to B3? 1 / 1 point

Thick bottom border

Link provided does not contain translatable text. 3/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

External borders

Double explanation

Underline

Correct
Yes, you have it. The preset border styles are useful. Use them too.
to maintain consistency.

9. What alignment option has been applied to the titles in D6: T6? 1 / 1 point

Vertical text

Merge and center

Turn text upwards

Adjust text

Correct
Yes well done. You identified this format correctly.

10. What alignment option has been applied to cell U31? 1 / 1 point

Merge and center

Adjust text

Center

Average alignment

Correct
Yes, correct. You have been working hard and it is really paying off!

11. Click on cell S38 and increase the number of decimal places to 3. What is the 1 / 1 point
value in the cell now? (Enter using the number format ##. ###).

Unable to access external links. 4/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

30.867

Correct
Well done. You have this answer exactly correct.

Unable to retrieve content from the provided link. 5/5

September 7, 2021 Taking the Reins of Excel: Test Your Skills, Part 1 | Coursera

Working with data: test your skills

RATING OF THE LAST SHIPMENT

100%

1. Do you want to insert 3 columns? Which of the following options will help you achieve
1 / 1 point
this?

Multiple answers are possible. Partial credit will be granted.

Select a column and then click the Insert button in the Home tab
3 times

Correct
If that is correct. Can you think of other ways that could be more
quick?

Right-click on the column header and go to Insert,

then write the number 3

Select 3 columns, right-click and go to Insert

Correct
Yes, correct! Isn't it a good way to insert more than one column?

Sean has carefully set up a complicated conditional formatting in one of 1 / 1 point

the columns of your worksheet. Now you want to apply the same rules to another
column of your worksheet. What is the quickest way to do this?

You can copy and paste the original column and then delete the content from the
cells using the Erase tool.

There is only one way, you must select the next column and then configure the
rules of conditional format again.

You can use the format painter.

Correct
Yes, 100% The deforming painter copies ALL formats, this includes the
conditional formatting. This is definitely the quickest way to apply
the same formatting rules to another column.

Invalid request. Please provide text for translation. 1/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

3. Open the attached workbook. You will notice that some columns have been hidden. 1 / Show
1 point
the columns. What is the product name for order 5023-1?

[Link]

Pencils

Correct
If that is correct. Well done.

4. The order 5024-1 was canceled. Delete row 11 (not just the data). What 1 is the
/ 1 point
updated average in cell S1? (Please enter only the number, without symbols
of currency)

1,156.53

Correct
Yes, that is the correct answer. You have done a great job with this.
question.

5. You need to know the most recent shipment. Sort the data by shipping 1date. What
/ 1 point
What was the amount of orders for the most recent article?

31

Correct
Yes, well done. Great detective work! Your Excel skills are improving.
day by day.

6. You should verify the most recent piece of furniture. Sort the data by product category.
1 / 1 point
(AZ) and then by order date (most recent to oldest). What is the type of
customer for the most recently ordered furniture?

Unable to access or translate the content of the provided URL. 2/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Corporate

Small businesses

Home office

Consumer

Correct
If that's it. Well done, onto the next challenge

7. You have been asked to report on the orders made by the client Cindy. 1 / 1 point
Chapman. Filter the data to show only your orders. How many orders did you have?
Tina Carlton as account manager?

Correct
If that is correct. You really have the Filtering section.

8. Clear the previous filter. Use filters to find out how many orders were for the
1 / 1 point
clients of the headquarters, where the account manager is Leighton Forrest,
with a high priority.

Correct
Good job. Your skills are constantly expanding. Your hard work
is bearing fruit.

9. Clear the previous filters. Use filters to find out how many orders were 1from
/ 1 point
technology and had a total of over $20,000.

10

Correcto
Unable to access the provided link. 3/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Yes well done. You have used the Filter correctly to obtain the response.
correct.

10. Clear the previous filters. Apply a new filter to show the top 1% 1 / 1 point
orders by total. What is the average amount for the top 1% (cell M1043)?

46

Correct
Yes, great job. You have applied the correct filter arguments to obtain the
correct answer.

11. Use the search tool to find order number 6044-1. 1 / 1 point
What is the priority of this order?

Medium

Correct
That is exactly correct. The Search tool is a quick way to
navigate to specific sections in a large worksheet.

12. Tina Carlton has recently gotten married and has chosen to take her husband's name. 1 / 1 point
couple. Start by clicking on cell A1. Use Find and replace to
replace all instances of Tina Carlton with Tina Shaw. Check the message:
How many replacements were made?

On a Mac, go to the Edit menu > Find > Replace.

137

Correct
Good job. Your skills are constantly expanding. Give yourself a
pat on the shoulder.

The provided text is a URL and cannot be translated. 4/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Printing: Test your skills

RATING OF THE LAST SHIPMENT

100%

1. The attached workbook is necessary to answer all the associated questions.

1 / 1 point
with this questionnaire. Open the attached workbook and investigate how this will look
document when printed (do not print it). How many pages will be printed?

[Link]

Correct
Good job. Now that you're ready, let's continue with the next ones.
questions!

2. What margin setting has been selected? 1 / 1 point

Without margin

Normal

Spacious

Narrow

Correct
Yes, excellent job. Did you find where you needed to look for the answer to
immediate?

3. What orientation has been selected? 1 / 1 point

Landscape

Lyrics

Unable to access the content at the provided link. 1/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

A4

Portrait

Correct
Horizontal is the correct page orientation for this worksheet.

4. A custom scale has been applied. 1 / 1 point

True

False

Correct
Good job. Your skills are constantly expanding. Your hard work
is bearing fruit.

5. How many page breaks have been added? 1 / 1 point

For Mac users, switch to Page Layout view, then go back to

Normally to view page breaks. Manual page breaks will remain
dotted lines.

You can also use the Print Preview to find out the number of
pages. The number of added page breaks is 1 less than the number of
pages.

Correct
Yes, good job. There are two page breaks on this worksheet.

6. If we wanted to insert another page break between rows 20 and 21, we would have to 1 / 1 point
click on which cell first. (We just want to add a page break
horizontal). For your answer, enter a cell reference, for example, B5.

A21

Unable to access or process the content from the provided link. 2/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
Yes, fantastic work. Whenever I need to add a page break,
select the cell just below and to the right of where you want it to occur
jump.

7. For the printed version of the page, according to the existing configuration, which one of the 1 / 1 point
Which of the following statements is true? (One or more answers may be correct)

The total number of pages has been added to the header.

A page number has been added to the header

A page number has been added to the footer.

Correct
Yes, that is the correct answer. The page number is located right in the
footer center

The total number of pages has been added to the footer.

8.
1 / 1 point
For the printed version of the page, according to the existing settings, the first
Four rows are repeated on each page. To stop this, we would do:

Uncheck Headers (in the Page Layout tab)

Adjust the settings in the print titles

Adjust the settings in the custom margins

Remove page breaks

Correct
Yes, that is exactly right.

9. If we insert a column between C and D, which of the following occurs? (One or more 1 / 1 point
answers can be correct

The provided link does not contain any translatable text. 3/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Nothing changes

Now we have 6 pages to print

We get another page break

The custom scale changes

Correct
Yes, that's right. Excel behaves this way in a very intelligent manner.

10. Before we can manually change the custom scale, we must:

1 / 1 point

Remove printed titles

Set the page width to automatic

Reset page breaks

Set horizontal orientation

Correct
Yes, great job. You should be very proud of yourself. Your skills
With Excel, they are getting better and better!

The provided link does not contain any translatable text. 4/4
September 7, 2021 Taking the Reins of Excel: Test Your Skills, Part 1 | Coursera

Graphics: test your skills

RATING OF THE LAST SHIPMENT

100%

[Link] graphs is quite simple, but it is important that we understand the 1 / 1 point
Terminology used in Excel. What is the graph area?

The area of the graph is the complete graph with all its elements.

A worksheet in the workbook that only contains a chart.

The area of the chart is the part of the chart that displays the data visualization.

Correct
Yes, that is correct. The area of the graph is the entire canvas on which it appears.
chart.

2. Creating graphs is quite simple, but it is important that we know the 1 / 1 point
Terminology used by Excel. What is the area of the plot?

The area of the graph contains all the information about the data source below.
of the horizontal axis.

The area of the graph is the part of the chart that shows the data visualization.
It is located in the area framed by the axes y and x.

The area of the chart refers to the values of the cells in your worksheet.

Correct
Yes, that is perfect. Well done.

Creating graphs is quite simple, but it is important that we know the 1 / 1 point
Terminology used by Excel. What is understood by the word legend?

This is not a valid term related to graphics.

The legend decodes the data labels and adds an explanation to the chart.

The legend is the explanation next to each of the axes.

The content at the provided link cannot be translated as it is not accessible. Please provide text directly for translation. 1/10
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
If that is correct. The legend can be displayed on the left, on the right,
below or above the area of the plot.

4. When you want to create a chart, what should you observe?

1 / 1 point

Several answers are possible, partial credit will be granted.

Carefully select all the data you wish to include in the chart.

Correct
If that is correct.

Select any header in rows and/or columns.

Correct
Yes, always select the row and column labels to help Excel to
interpret the data and create the correct categories.

Make sure your selection does not contain empty rows or columns.

Correct
This is very important. If you accidentally include empty rows or columns
in your selection, Excel will attempt to create a new category and will alter its
graph.

5. Download the workbook below. It contains a slightly altered version and 1 / 1 point
abbreviated from FBI crime statistics, 1994-2013. You must work with it to
to be able to answer the following questions of this task.

[Link]

You have been assigned the task of providing some visual summaries for
backing up a presentation on the trends and volume of certain types of crimes
in the United States. Take a moment to familiarize yourself with the workbook.
What is the title of Table 1?

Crime in the U.S. - FBI Data

Unable to access external content or URLs. 2/10

9/7/2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Crime in the United States by volume, 1994-2013

Crime in the United States

Correct
Yes, great job. This is the full title of the table. When later I ...
Provide the graphs to your manager, it is important that he/she can quote them.
correct reference for your dataset.

6. Take a look at the screenshot below and then head to Excel to your 1 / 1 point
W06 workbook file. What cell ranges were selected to create
this chart?

B5: B9

B9

A5: B9

A4: B9

Correct
Correct, this is the range that produced this graph.

7. 1 / 1 point

Unable to access or translate content from the provided URL. 3/10

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Take a look at the screenshot below. What type of chart is this?

If you are not sure, go to Excel and play around with the different types of charts to
find out which one we are looking at here.

A trend line graph.

A scatter plot.

A grouped bar chart.

A line graph.

Correct
Yes well done. You have solved this correctly. Fantastic.

8. 1 / 1 point

The provided text is a URL and does not require translation. 4/10
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Take a look at the table below. What is missing in this chart for it to be
a useful visualization for a presentation on violent crime rates among
1994-2013?

Multiple answers are possible, partial credit will be granted.

There are no grid lines.

The title of the graph doesn't make sense.

Correct

The information for the y-axis is missing.

The information for the x-axis is missing.

Correct

There is no legend that explains the value category.

Correct

9. With the data from the W06 workbook, create a 2-D pie chart for 2004.1 / 1 point
including the labels. Which of the following options best represents what has
created?

Unable to access external links or content. 5 out of 10

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

This:

This:

The provided link does not contain translatable text. 6 out of 10

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

This:

This:

I cannot access external content such as URLs. Please provide the text you'd like translated. 7/10
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

This:

Correct
Correct! You have created a 2-D pie chart for the 2004 data.

10. Create a line graph for violent crime, robbery, and vehicle theft 1 / 1 point
motor. Use the Quick Design to display the data table below the chart.
(suggestion: hover over the Quick Design options to find
which includes a data table). Change the colors so that violent crime is
green, the burglary shall be blue and the theft of motor vehicles shall be
yellow. Change the chart title to Crime in the USA 1994-2013. Change the
Vertical axis label to be Number of crimes.

Which of the following options does your graph resemble the most?

The provided text is a URL and does not contain translatable content. 8/10
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

This:

This:

Unable to access or retrieve content from the provided URL. 9/10

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

This:

This:

Correct
Correct! You have successfully followed those complicated steps to create a graph.
attractive

The provided link is not translatable text. 10/10

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Final evaluation of course 1

RATING OF THE LAST SHIPMENT

100%

Download the workbook and save it to your computer. Open the workbook. 1 / 1 point
I work and then I return here to start answering the questions.

C1 Assessment [Link]

SUGGESTION: make sure to save your progress in the Excel workbook

often as you progress through the exam.

Here is the first question:

The workbook contains data downloaded from a government database. It is not

very easy to read, so its first task is to address some of the formats.

The title of cell A1 cannot be seen correctly. Change the alignment so that
I can see what it says.

In what year was this data collected?

Enter your answer in four digits ####

2015

Correct
If that is correct. The title of this spreadsheet is Expense Report
the households of 2015, so the data was collected in 2015.

2. Somehow, the date in cell B2 has lost its format. Change the format. 1 / 1 point
to a date. What date is now shown in B2?

Enter your answer in Year-Month-Day format (for example, 2016-12-31).

March 20, 2016

Correct
Yes, the date in B2 is 2016-03-20.

Invalid input. Please provide text for translation. 1/10

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

3. Apply the Accent1 style to the range A2:Z2. Apply the Title 3 style to the range A4:Z4. 1 / 1 point
Which of the following options is most similar to your data?

This:

This:

This:

This:

Correct
Yes, well done. You have correctly applied the correct format and identified the
correct answer.

4.
2 / 2 points

Unable to access the content from the provided link. 2/10

9/7/2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

There are also some corrections that need to be made to the data. One of the is missing.
data entries. You have been asked to insert a row after case ID 49 (row 15)
and enter the following data:

Case identification 51
Economic position Full-time work
type of occupation Managerial or Professional

House Property
Genre Male
Region Gales
Adults 2
Children 2
January income 5924.00
February income 5924.00
To my income 5924.00
April income 5924.00
May revenues 5924.00
June income 5924.00
January expenses 2803.57
February expenses 2242.86
March expenses 2512.00
April expenses 2361.28
May expenses 2219.60
June expenses 2596.93

What is the total expenditure for March now? (cell Q2)

In your response, you should use the numeric format #####.## with a point as
decimal point and two decimal places.

4429863.16

Correct
Yes well done. The March expenditure is now 4429863.16

5.
1 / 1 point

The provided link cannot be translated as it does not contain translatable text. 3/10
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

An incorrect value was entered for case ID 5299. Please use the Search tool.
to find this case ID and change the January income to $200. What is the
total income for January now? (cell I2)

In your response, you must use the number format #####. ##

6074344.46

Correct
Yes, this is the correct answer. The total income for January is now
6074344.46

6. Several calculations are missing that need to be added. An additional column is required that 1 / 1 point
show the total number of people per household. Perform all the following steps and
then answer the question.

1. Insert a column after column H

2. InI4write the headerHome
3. Enter a calculation to sum the number of adults and the number of children.
4. Copy the formula down to fill the column
5. In cell I2, enter a calculation to obtain the total number of people in all the
homes represented, or copy the formula from cell H2

QUESTION: What is the total value of the home in cell I2?

Enter your answer in numerical digits: ######

6378

Correct
Yes, well done. The total value of the home is 6378.

7. In cell V5, enter a calculation to obtain an average income from January to 1 / 1 point
June (J5aO5). Copy the formula in the column. What is the average income for
case 9 (cell V6)?

In your response, you must use the number format #####. ##

3323.88

Unable to access or translate the content from the provided URL. 4/10
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
Well done, that's correct. The average income for Case 9 is 3323.88.

8. In cell W5, enter a calculation to sum the total income from January to June. 1 / 1 point
Copy the formula in the column. Widen the column so you can see the
results. What is the total income for Case 9 (cell W6)?

In your response, you must use the number format #####. ##

19943.28

Correct
Yes, that is correct. The total income for Case 9 is 19943.28

9. In cell X5, enter a calculation to sum the total expense from January to June (P5 to U5) 1 / 1 point
Copy the formula in the column. What is the total expense for Case 15?

In your response, you must use the number format #####. ##

12754.83

Correct
Yes, that's correct. The total expenditure for Case 15 is 12754.83

10. In cell Y5, enter a calculation to subtract the total expenses from the total income. Copy the
1 / 1 point
formula in the column. What is the network for case 20?

In your response, you must use the number format #####. ##

17423.96

Correct
Yes, this is the correct answer. The network for Case 20 is 17423.96

The provided link does not contain any text to translate. 5/10
September 7, 2021 Taking the Reins of Excel: Test Your Skills, Part 1 | Coursera

11. It is estimated that the cost of living will increase by 3.93% over the next 6 months.
2 / 2 points
months. We would like to forecast what the spending will be during that period. In the cell
Z2 enter the value 3.93%. In Z5 enter a formula to calculate the projected expense.
To do this, you will need to calculate the increase in expenditure (current total expenditure
multiplied by the percentage increase) and add it to the current total expense. Copy the
formula in the column. (Make sure all calculations are using the value
enZ2!).

What is the estimated expense for case 15?

In your response, you must use the number format #####.##

13256.09

Correct
Yes, that is the correct answer. The expected expenditure for case 15 is
13256.09

12. Now select the statistics worksheet. Enter simple formulas in B3 and
2 / 2 points
B4 to extract the total calculated expense and the net total from the data worksheet
(cellsX2eY2). If done correctly, the pie chart should show
Now how is the income distributed between expenditure and net.

QUESTION: According to the pie chart, what percentage of the income is made up of
of expenses?

Do not enter the % symbol in the response box below, only the
number.

75

Correct

13. Even in the statistics sheet, enter a formula in B5

1 / 1 point
to sum the total income for the first quarter using the calculated totals for
January, February, and March in the data worksheet. If you have done it correctly,
the cell should change color.

QUESTION: What color is cell B5?

Unable to access the content of the provided URL. 6/10

September 7, 2021 Taking the reins of Excel: Put your skills to the test, Part 1 | Coursera

white

Black

Yellow

Gray

Purple

Correct

14. The organization has decided to have one region for Midlands instead of two, so
2 / 2 points
both East Midlands and West Midlands should be replaced only with
Midlands. Then, we need to answer some questions for the organization.

In the worksheetData, useFind and replace to replace all the

instances of East Midlands with Midlands. Repeat the operation, this time
replacing West Midlands with Midlands. Now filter the data so that only the
Midlands cases be visible.

QUESTION: What is the total number of registered adults for the Midlands?

629

Correct

15. Clear the previous filter. Add filters so that we only see the cases from Wales with 6.
2 / 2 points
or more people in the household.

How many households in Wales have 6 or more people?

Correct
Yes, that is correct. There is only one home with 6 or more inhabitants.

16.
Unable to access external links. 7/10
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Clear all filters. Sort the data by Total Income in descending order (from 1 / 1 point
from greater to lesser.

What is the highest total income for a case?

In your response, you must use the number format #####. ##

40001.26

Correct
Yes, this is the correct answer. The highest total income for a case is
40001.26

17. Change the classification to sort the data so that I can identify it.
1 / 1 point
easily the lowest average income for cases with an occupation
intermediate.

QUESTION: What is the lowest average income for people with a

intermediate occupation?

In your response, you must use the number format #####. ##

18.35

Correct
Yes, this is the correct answer. The lowest Average Income for
people with an intermediate occupation is 18.35

18. You are concerned that there may be duplicates in the dataset. Add format.
2 / 2 points
conditional on the caseID column to display all duplicates in red.
Sort the data by case ID, but instead of by values, sort by color.

How many cases have been duplicated (entered twice)?

Invalid input. Please provide the text you would like to translate. 8/10
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct

19. Remove one of each of the duplicated rows.

1 / 1 point

What is the new total in G2?

3513

Correct

20. To help represent the data graphically, you have been asked to create some
2 / 2 points
Charts. You must return to the Statistics worksheet.

Select the data from A8 to B12. Insert a pie chart to compare them.
average income for different economic positions. Add a quick design
that shows a percentage for each segment.

What is the percentage of economically inactive individuals?

Do not enter the % symbol in the answer box below, only the
number.

27

Correct

21. Create a line chart that shows the total revenue for each month. Make sure
2 / 2 points
to select the names of the months and the total income values.

QUESTION: Which of these graphs looks most like your line graph?

The provided link is not a translatable text. 9/10

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

This:

This:

This:

Correct

22. Insert a stacked column chart to show the revenues for January, February and
1 / 1 point
March of each region.

QUESTION: Which region has the fourth highest income from January to March?
fourth largest group)?

London

Correct
Yes, London had the fourth highest income from January to March.

Invalid input. Please provide a text for translation. 10/10

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Data entry
TOTAL POINTS OF 5

Which of the following options will Excel recognize as a date? (One or more)
1 / 1 point
answers are possible; partial credit will be granted

September 5, 16

Correct
Yes, Excel will automatically convert it to a valid date format.

September 5, 2016

05/09/2016

Correct
Yes, Excel will automatically convert it to a valid date format.

Remember to check the regional settings on your computer as

affects data entry in Excel; depending on its configuration, this
Is it September 5, 2016, or May 9, 2016?

To clear the contents of a cell (without affecting the surrounding cells), click 1 / 1 point
in the cell y ...

You may want to try this in Excel. One or more answers are possible. It
will grant partial credit)

Press Backspace and then Enter on your keyboard (Delete and Return on Mac).

Correct
Yes, this will clear the content of an active cell.

Click on No Fill in the Home tab of the ribbon.

Press the Delete key on your keyboard (Fn+Delete on Mac).

Link provided is not translatable text. 1/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
Yes, this will delete the content of an active cell.

Click on Delete in the Home tab on the ribbon.

[Link] you can enter data into an empty cell, you must double-click on the1 / 1 point
cell.

True

False

Correct
You are in this, well done. You only need to double click when you want to
modify the existing data in a cell.

4. Which of the following statements are correct regarding behavior? 1 / 1 point

in Excel when entering data into an empty cell?

One or more answers are possible. Partial credit will be awarded.

Any entered number is automatically aligned to the right.

Correct
Yes, correct. Excel automatically aligns numbers to the right.

Any entered text is automatically aligned to the left.

Correct
Yes, that's exactly right: do you remember this from the video or did you review it in
Excel?

Any entered number is automatically aligned to the left.

The numbers and the text entered together align automatically to the right.

The provided text is a URL and cannot be translated. 2/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

5. Sean used a tool to create the content of cell B7. Which one did he 1 /use?
1 point

Is this correct?

Is this correct?

Is this correct?

Correct
Yes, correct. The sigma sign means AUTOSUM. We will take care of this.
in more detail in week 2. Stay tuned!

Unable to access content from the provided link. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Are essential skills

too basic for me?
TOTAL POINTS OF 8

1. We believe this course has something for everyone, whether you have never used Excel. 1 / 1 point
before or have been using it for many years. Please answer this questionnaire
to get an idea of what we will cover in this course. If you don't know something, you can
guess: you will receive feedback at the end.

Which key is held down when selecting cells that are in

different areas of a worksheet?

The Shift key

Press the Control key (PC) / Command key (Mac) and the Shift key at the same time.

The Tab key

The Control key (PC) / Command key (Mac)

Press the Control key (PC) / Command key (Mac) and the Tab key at the same time.

Correct
Yes, it's great that you already have it!

2. Which of the following components must be part of any formula? (One or 1 / 1 point
more answers are possible; partial credit will be granted

A mathematical operator, for example, +.

Supports

A function (for example, SUM)

Parenthesis

Unable to access the content of the provided URL. 1/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

The sign =

Correct
Yes, 100%. It doesn't matter how simple or complicated its formula is or if it is
using a function or not, each formula MUST start with the equal sign.

3. Sean used a function for the cells in column Qtr1. What did he enter in the cell? 1 / 1 point
B7 to correctly calculate the average sales of the first quarter of
Aanya, Charlie, and Connor?

= AVERAGE(B4:B6)

= AVERAGE (B4): AVERAGE (B6)

= AVERAGE (B4: B6)

= AVERAGE (B4: 6)

= AVERAGE (B4 + B6)

Correct
Yes, this is the correct answer. You already have experience with functions and
formulas. We will have to challenge it with absolute cell references to
continuation (coming soon in week 2).

4. To change the relative cell reference A1 to an absolute cell reference, 1 / 1 point

usa

ABS (A1)

A1

Content cannot be accessed or translated from external links. 2/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

$A$1

a1

A$1$

Correct
It's great that you already have it! We'll have to find something a little more
challenging so you can further develop your skills!

5. It has some cells formatted the way you want and you want to copy this 1 / 1 point
format in some new cells that already contain data.

You can't do this. You need to format each of the new cells.
individually.

You can use the Cell Format option after clicking the button.
right in a cell to copy the formats from the old cells to the new ones.

You can use Format Painter to copy only the formats from the old cells to
the new cells.

Cells must be formatted before entering data into them.

You must copy the cells over the new cells and then rewrite the data.

Correct
Yes, correct. The format painter is definitely one of the tools
'Wow' of Excel. There is more than a simple copy formatting functionality.

6. You want to insert 3 columns. Which of the following options will take you there? (One or 1 / 1 point
more answers are possible; partial credit will be granted

Select a column and then click on the Insert button in the Home tab.
3 times.

Correct
Yes, he has been paying a lot of attention to how Excel works.

Unable to access the content of the provided URL. 3/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Right-click on the column header and go to Insert,

then write the number 3.

Select 3 columns, right-click and go to Insert.

Correct
It's great that you have it already! We will have to find something a little more
challenging for you!

7. It has a column of numbers and only wants to show those values that are more 1 / 1 point
of 1,000. The fastest way is:

Revise and move all values less than 1,000 to another sheet.

Apply a filter to the column and remove the check mark next to each value
less than 1,000

Apply a numerical filter using 'is greater than' 1,000

Sort the column from highest to lowest value

Use the MAX function to find out.

Correct
Yes, well done, this will take it super quick.

8. You want to print your quite large dataset that spans 3 pages of 1 / 1 point
agreement with the print preview. You want to adjust it to 2 pages. What are
Are the following options useful techniques to achieve it?

(One or more answers are possible; partial credit will be granted)

Remove some of the less important columns.

Use the Scale tools to adjust to reduce the size of your sheet.

Correct
Yes, that is correct. You can definitely create more space by reducing the
scale. However, be careful not to go too low on your scale, as
that could leave your data too small to read. There are others
ways to do this. We will cover this topic in week 5.
The provided link does not contain translatable text. 4/5
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Use narrower margins

Correct
Yes, that is correct. You can definitely create more space by reducing the
white margins on each page. There are other ways to do this.
We will cover this topic in week 5.

Use the Page Layout view and set the automatic width to 2 pages.

Correct
Yes, that is perfect. The automatic width adjustment is extremely useful.
We will cover this topic in week 5.

The provided link is not translatable text. 5/5

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Taking the reins of Excel

TOTAL POINTS OUT OF 5

[Link] is an example of what type of software? 1 / 1 point

Presentation package

Spreadsheet

Word processor

Correct
Yes. Other examples of spreadsheet software are Apple Numbers, Google
Sheets and LibreOffice Calc.

2. Which of the following is NOT part of the tape? 1 / 1 point

Data

Tools

Insert

House

Correct
You saw it: Tools is not a tab on the Ribbon. Well done.

[Link] love has disappeared, how can I get it back? 1 / 1 point

(One or more answers are possible. Partial credit will be given.)

Close Excel and open it again.

Double-click any of the tabs on the ribbon.

Correct

Invalid or inaccessible link. 1/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Your answer is correct. If you are working on a Mac, a single click will
the same effect.

Right-click on one of the tabs and uncheck Collapse the

love.

Correct
Good job: you have paid attention to Nicky's explanations in the video
of practice.

Change to another worksheet.

4. By clicking on the File tab, you will access the Backstage view. From here
1 / 1 point
you can

One or more answers are possible. Partial credit will be granted.

Configure the Excel options.

Correct
Yes, that is correct. Backstage is your one-stop shop for configuration, your
account, file management, and printing. To exit Backstage,
you can click on the back arrow in the upper left corner or
just press the Escape key.

Close a file.

Correct
Yes, you can close your files from here. Another quick and easy way to do it.
this is using the keyboard shortcut to close a file: CTRL / CMD + W
while you are in the main window.

Create a blank workbook.

Correct
Yes, you can create a blank book from here or choose from a wide range
from templates. A quick and easy way to create a blank workbook
is to use the keyboard shortcut: CTRL / CMD + N while you
find in the main window.
Unable to access the content at the provided link. 2/3
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Open a file.

Correct
Yes, you can open a new file from your computer from here, or even
open recently used files from a list. Another quick and easy way to
doing this is using the keyboard shortcut to open a file: CTRL / CMD + O
while in the main window.

5. The tools on the far right of the status bar (at the bottom of 1 / 1 point
the screen) allows him/her

(One or more answers are possible. Partial credit will be awarded).

Set a specific zoom percentage.

Correct
Yes, have you played with this tool? You can choose a particular percentage.
or to get closer to your selection. Super useful!

Switch between different viewing options.

Correct
Yes well done. We will learn more about the visualization options in the
next practice video.

Use the zoom slider.

Correct
Yes, absolutely. The zoom slider is excellent because you can
easily adjust the view of your spreadsheet to your needs.

Unable to access the content of the URL provided. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Navigate and select

TOTAL POINTS OF 5

1. In Excel, the following mouse pointer will allow us to 1 / 1 point

Delete data

Select data

Copy data

Move data

Correct
Yes, exactly correct. With this mouse pointer, you can move data.
comfortably from one location to another.

2. In the following graph, which is the active cell? 1 / 1 point

A2

A1

Invalid input format. Please provide text for translation. 1/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

C2

B1

Correct
Yes, correct! An active cell is easy to detect by looking for the green border and
the small solid square in the bottom right corner. This is called
filling control and we will see it in one of the videos this week.

3. To select the entire column B, we ... 1 / 1 point

Click on File, Select column

Double click on cell B1

Click on B

Click and drag from B1 to B1000

Correct
Yes, it is a very simple way to select a complete column.

4. What is the shortcut key to select all data in a block? 1 / 1 point

of data?

Ctrl + A

Ctrl + O

Ctrl + F

Ctrl + Home

Correct
If that is correct. A good way to remember is that A means Everyone.

5. How do we select two blocks of data that are not next to each other?1 / 1 point
contiguous)?

Unable to access the content at the provided link. 2/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Select the first block, hold down the Shift key to select the
second block.

Hold down the Shift key, select the first block, and then,
hold down the Shift key, select the second block.

Select the first block, hold down the Ctrl key (Cmd on Mac) and
select the second block.

Hold down the Ctrl key (Command on Mac), select the first block and,
then, hold down the Ctrl key and select the second block.

Correct
If that's correct. The Ctrl key helps you select non-contiguous data.

Invalid input. Please provide text for translation. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

See options
TOTAL POINTS OF 6

1. After entering data in a cell, which option(s) will move your cursor to the
1 / 1 point
next cell below your active cell?

(One or more answers are possible. Partial credit will be granted).

Click the mouse pointer on the cell below.

Correct
Yes, that's correct, you can use the mouse. However, this may be a
a little slow and requires me to take my hand off the keyboard and interrupt its flow of
work. What else could you do instead?

Press Enter.

Correct
Yes! Excellent. Acquiring the habit of pressing Enter to move to the next
the cell below is a great practice!

Press Tab.

2. What tool should we use to help keep the headers visible? 1 / 1 point
When do we move through a large workbook?

Separate

Freeze panels

Headings

The page break preview

Correct
Yes well done. You are ready for the next challenge. Don't wait, dive into it.

Unable to access the provided link. 1/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera
3. You are going to use the Freeze Pane function. 2 / 2 points

Take a look at the screenshot below. Which cell should I click on?
to freeze columns A and B, as well as rows 1-4? If you find this complicated,
Why doesn't it download the workbook and play?

Warehouse [Link]

C5

D5

B5

Correct
Everyone says WOW! This was a complicated question. You have been
working hard on this. Well done.

4. How do you switch between different workbooks in Excel? 1 / 1 point

Unable to access the provided URL content. 2/3

September 7, 2021 Taking the reins of Excel: Put your skills to the test, Part 1 | Coursera

Click on the tab and select this tool:

Use the display options in the status bar.

Click on the tab you want to navigate to.

Correct
Yes, that is perfect. He/She has been paying a lot of attention to the videos of
practice. Keep up the good work.

5. What tool was used here to produce the following view? 1 / 1 point

Print preview

Page break view

Page layout view

Correct
Yes well done. You are ready for the next challenge!

Unable to access or translate content from external links. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Fill the handle

TOTAL POINTS OF 8

What is one of the main purposes of the filling controller that we have? 1 / 1 point
demonstrated?

To easily fill the background color of a wide range of cells.

To automatically create a series based on existing data.

To automatically enter data into an empty spreadsheet.

Correct
Yes, that is exactly correct. The fill controller is a tool.
very powerful in Excel that allows you to create series based on the data that
He entered. Change to Excel and play with it. Can you come up with simple patterns with
those who can test the capabilities of the filling controller?

2. How should the mouse cursor look to activate the fill controller? 1 / 1 point

A thicker and white sign

A bold black plus sign

Four crossed black arrows

Correct
Yes, that's the only one: you have been paying a lot of attention.

3. Take a look at the screenshot below. They needed to separate the 2 / 2 points
first names of Column C. This would normally take quite a long time, but it
He fixed it to fill Column D in seconds. How did he do that?

Invalid input. Please provide text for translation. 1/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

If you are not sure, download the workbook below and try it yourself.
You can solve it!

[Link]

NOTE: This question refers to an Excel function that is not available in the
Excel version for Mac. However, you can still answer the question by looking at the
practice video on the filling handle this week.

He selected cell C2, then dragged the fill handle to D7. All the
names appeared automatically.

Sean selected cell D2, then dragged the fill handle to D7.
All the first names appeared.

Sean wrote 'Christopher' in cell D2, then dragged the fill handle.
aD7. Changed the tool option to Quick Fill.

Correct
Everyone says WOW. Excellent job: you put in effort and face challenges.
challenges like a champion.

4. How do you activate the fill function? Remember, if you are not sure, go to Excel
2 / 2 points and
explore.

One or more answers are possible. Partial credit will be granted.

Hover over the small square in the bottom right corner of your
active cell until you see the thick black cross, then click and drag.

Correct
Yes, 100%. You've been paying a lot of attention this week.

Unable to process the request as the input is a URL and not translatable text. 2/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Select a range of cells and click on this icon in the Home tab.

Correct
Fantastic detective work: we did not present this icon in the video, but
You have discovered it. Good thing.

Right-click on your active cell and select Driver

fill in the contextual menu.

5. Take a look at the screenshot below. What do you expect to see in the cells? 2 / 2 points
A3, B3, C3 and D3 when dragging the fill handle down to D6?

If you are not sure, download the workbook below and try it in Excel.

Fill the [Link]

A3: 5071-1

2013-05-06

C3: Christopher Schild

D3: 7

A3: 5071-2

May 6, 2013

Christopher Schild

D3: 7

URL not translatable. 3/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

A3: 5071-2

2013-05-06

C3: ######

D3: 6

Correct
Yes, a really excellent job. Did you try this in Excel first or
Did you simply solve it?

A2 was a number but it had a special character. So, the controller of

filler recognized this and created a series. A4 would have been 5071-3 and so on
successively.

B3: Excel recognized the date format and automatically inserted the date
the next day.

C3: Excel interpreted this as standard text and, as such, simply it

copied.

D3: Straight numbers are usually simply copied. In this case,

however, Excel assumed it is a series like the other columns.
Go back to Excel and observe what happens when you use the driver of
fill only in cell D2.

Unable to access the content from the provided link. 4/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Formulas
TOTAL POINTS OF 3

1. A calculation has been used in cell A3. Which of the following options do1 / 1you...
point
Did he/she join A3?

A1 / A2

= A2 / A1

= A1 * A2

= A2: A1

Correct
If that is correct. The formula divides the value in cell A1 by the
value in A2.

2. For the data shown, which of the following formulas will NOT give the 1 / 1 point
result 2?

Unable to access content from the provided URL. 1/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

= A2 / A3

= A1 - A2 / A3

= A1 / A1 * A3

=(A1-A2) / A3

Correct
Let's see, this formula translates to the following calculation: 8 minus the
results of 4 divided by 2 (remember the order of operations!).
So, 8 minus 2 equals 6! You were right. This formula is not equal to 2.
Well calculated!

3. What is the result of this simple calculation entered in the formula bar 1in/ 1 point
Excel? = 7 + 3 * 4

44

40

19

Correct
Yes, an impressive job. Were you already familiar with the order of the
operators or wrote this calculation in Excel to help you answer this
question?

URL provided cannot be translated as it does not contain translatable text. 2/2
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Formulas in context
TOTAL POINTS OF 3

A small company buys second-hand goods and then resells them. 1 / 1 point
local market. What formula introduced in C2 will help them calculate the profits
obtained from the item they bought for $10 and sold for $29.99?

= B2-A2

= A2-B2

= A2 * B2

SUM(B2-A2)

Correct
Yes, that is exactly right. You have worked well on this.

A customer has spent $3296.99 but we want to offer them a 5% discount. 1What
/ 1 point
Will the formula calculate the correct amount of discount?

A2 / B2

= A2-B2

= A2 * B2

A2 * B2 / 100

Correct

Unable to access external links. 1/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Yes, correct. He did well paying attention to the practice video about
formulas in context.

3. The payroll must calculate the tax for each employee. First, they must sum the
1 / 1 point
base salary to commission and then calculate the tax on the total. What formula
Is this done correctly?

If you are not sure how to answer this question, go directly to Excel and
experience.

= A2 + B2 / C2

= A2 + (B2 / C2)

(A2 + B2) * C2

= (A2 + B2 * C2)

Correct
Yes, that is exactly correct. This formula calculates the tax to be paid.

Unable to translate the content from the given URL. 2/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Functions I
TOTAL POINTS OF 3

1. Select the formula that correctly and efficiently adds all the cells from B31 / 1topoint
B6 (also known as raspberry).

= SUM (B3: B6)

= SUM (B3 + B4 + B5 + B6)

= SUM (B3, B6)

SUM (B3-B6)

Correct
Yes, nice. This is the correct syntax for the SUM function to assume all
the cells from B3 to B6. The colon (:) is what we use for
define a range.

[Link] pressing AutoSum you must write "= ". 1 / 1 point

True

False

Correct
You are above us. When Autosum is used, Excel does everything necessary.
for the 'automatic' formula.

3. Sean used AutoSum to create the calculation in D2 as shown. Then he used 1 /the
1 point
filler controller to copy to D4. What calculation is now in D4?

Unable to access external URLs for translation. 1/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

= SUM (C4: C4)

= SUM (A4: C4)

= SUM (A2: C4)

= SUM (A2: C2)

Correct
Yes, 100%. The fill controller reproduces the formula related to the
original cell references.

Unable to access the content from the provided URL. 2/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Functions II
TOTAL POINTS OF 3

1. The correct way to obtain an average of the values in the cells A3 to 1 /A9 would
1 point be

AVERAGE(A3:A9)

(AVERAGE A3:A9)

= AVERAGE(A3:A9) / 6

= AVERAGE(A3:A9)

Correct
Yes, you got it right. Well done. You are ready for the next challenge.

2. Using the screenshot below, which function would give us the value 4? 1 / 1 point

If you're not sure, why don't you quickly write down the next four numbers in
Excel and test the different functions? Remember, practice makes permanent.

= SUM (A2: A5)

= MIN (A2: A5)

= AVERAGE(A2:A5)

= MAX(A2: A5)

Correct
Unable to access external content. 1/2
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Yes, that is exactly right. This function returns the lowest value of
a specific range. In this case, the result is 4, just what we were looking for.
searching.

3. Using the screenshot below, which function would give us the answer 9? 1 / 1 point

If you're not sure, why not quickly write down the next four numbers in
Excel and test the different functions? Remember, practice makes permanent.

= MAX(A2: A5)

= MIN (A2: A5)

SUM(A2:A5)

= AVERAGE(A2:A5)

Correct
Yes, that is exactly correct. This function returns the highest value of
a specific range. In this case, the result is 9, just what we were looking for.
searching.

Unable to access external links or content. 2/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Absolute cell references

TOTAL POINTS OF 3

1. To change a relative cell reference A1 to an absolute cell reference, 1 / 1 point

usa

ABS (A1)

$A$1

A1!

A$1$

Correct
Yes, great! We'll have to find something more challenging for you. Good
work.

The keyboard shortcut to create an absolute cell reference is 1 / 1 point

Shift + F4 (Mac: Cmd + Shift + T)

F4 (Mac: Cmd + T)

Ctrl + A (Mac: Cmd + A)

Tab

Correct
Correct. A very useful shortcut to remember.

3. 1 / 1 point

Unable to access the content of the provided link. 1/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

The calculation shown will give the correct discount for the first item, but
When we copy the formula, it will not give the correct answer for the two items.
next. Which of the following will solve this problem?

= $ D $ 2 * A2

=$D$2*$A$2

= D2 * $ A $ 2

= $ D2 * $ A2

Correct
Yes, 100%. This was a delicate question. Give yourself a pat on the back.
Your hard work is paying off.

Unable to access or translate content from external links. 2/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Calculations in sheets
TOTAL POINTS OF 3

1. To use values from other worksheets in a calculation, you must first copy1 / 1them
point to
the worksheet that contains the calculation.

True

False

Correct
Well done. You have paid excellent attention to the content of the video.
this week on calculations on all sheets.

2. The formula = Sheet1! A2 * A2 tells Excel that: 1 / 1 point

Apply an absolute cell reference to A2

Multiply the value in A2 in Sheet1 by the value in A2 in the current sheet.

Put the value in A2 in the current sheet in A2 in Sheet1

Put the value in A2 in Sheet1 in A2 in the current sheet

Correct
Well done. This was a delicate question. You have paid attention
excellent content of this week's video about Calculations in sheets.

3. When referring to cells in other sheets in a calculation, you can use references
1 / 1 point
relative to copy that formula into other cells.

Sure

False

Correct
Yes well done.

The given link directs to a quiz on Coursera about calculations across sheets in an Excel Essentials course. 1/1
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Formatting
TOTAL POINTS OF 5

What does this tool do? 1 / 1 point

Increase all fonts to a size or reduce all fonts to a size

Increase / decrease the font size of the selected cell in a small

amount

CONVERT THE TEXT TO UPPERCASE

Correct
Yes, that is exactly correct. It is a convenient way to increase
any text or numbers on your worksheet consistently.

Before you can format specific cells, you must first select them. 1 / 1 point

True

False

Correct
Yes, you must inform Excel which cells you want to apply your formatting to.

3. When choosing what type of font to use for a business report, which of1 / 1the
point
What should be considered next? (One or more answers are possible; credit will be granted)
partial)

Whether the source is available for free or not.

The preferred source of your company.

Correct
Yes, absolutely.

Unable to access the provided URL to extract text for translation. 1/3
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Readability

Correct
This is an important factor that is sometimes overlooked.

Your personal preferences.

4. What should you do first to change the font of the entire spreadsheet? 1 / 1 point

Select all the data in your worksheet.

Double-click on the first cell of the worksheet.

Select an appropriate source.

Correct
If that is correct. Before you can make changes to your source, you must
select your data.

5. Your boss has not given you any instructions about the format. Which of 1 the following
/ 1 point
options is probably appropriate to use in a business report? (One or
more answers are possible; partial credit will be granted

Arial:

Correct
Arial is a sans-serif font and has long been a standard of
the industry due to its clean forms. It is a very suitable choice.

The link provided seems to lead to a course quiz on Coursera about Excel essentials, specifically about formatting. However, I cannot access external links
2/3 or content.
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Apple's Chancellery:

Times New Roman:

Correct
Times New Roman has long been an industry standard.
for reports in a wide range of sectors. It is a very good choice.

Unable to access the content of the provided link. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Borders
TOTAL POINTS OF 3

1. To add borders to a large block of data, simply select a cell 1 / 1 point

in the dataset.

True

False

Correct
You saw it, this statement is not correct. To apply borders (or any other
format), you must select the cells to which you want to apply that format.

2. Which Border option should we use to achieve the following result? 1 / 1 point

Top and bottom border

Double top and bottom border

All borders

Thick top and bottom border

Correct
Yes, correct. The screenshot shows the predefined border 'Border
superior and double inferior

3. How are the edges removed and changes in data minimized? (If not 1 / 1 point
Sure, go to Excel and experiment before answering the question.

Click on the cell(s) and press the backspace key.

Click on the cell(s) and press delete.

Invalid URL provided. Please provide text for translation. 1/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Click on the cell(s), go to the borders, and choose No borders.

Click on the cell(s), go to Clear, choose to clear all formats.

Correct
Yes, that's perfect. Well done. Your hard work is paying off!

Invalid URL or inaccessible content. 2/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Alignment tools
TOTAL POINTS OF 3

1. To obtain a header located precisely in the middle of several columns, 1 / 1 point

What tool should we use?

Is this the right tool?

Would you choose this tool?

Is this the correct answer?

Correct
Yes well done. You have correctly identified the 'Merge and Center' button.

2. Which of the following alignment options matches the text in this screenshot?
1 / 1 point
of the screen?

Horizontal alignment: left; Vertical alignment: center

Horizontal alignment: left; Vertical alignment: bottom

center

center

Correct

The provided link cannot be translated as it does not contain text. 1/2
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Yes, 100%. Alignment tools are very useful and they are everywhere.
parts. Well done.

3. The text entered in a cell does not fit and part of it is cut off. Which of
1 / 1 point the
the following options will make all the text visible without affecting the design of your
report?

Click on 'Adjust text'.

Widen the column.

Reduce the font size.

Correct
Yes, this is really your best option. By widening the column or reducing the
font size, it is likely to present issues with the design
summary of your report.

Unable to access the content of the URL provided. 2/2

September 7, 2021 Taking the Reins of Excel: Test Your Skills, Part 1 | Coursera

Format painter
TOTAL POINTS OF 4

1. Which of the following formats does Format Painter copy? (One or more answers
1 / 1 point are
possible; partial credit will be granted

Cell background fill

Correct
Yes, the Format Painter can definitely do that.

Numerical format

Correct
Yes, the Format Painter can definitely do that.

Text alignment

Correct
Yes, the Format Painter can definitely do that.

Type of font

Correct
Yes, the Format Painter can definitely do that.

Borders

Correct
Yes, the Format Painter can definitely do that.

Font size

Correct
Yes, the Format Painter can definitely do that.

Unable to access or translate content from external links. 1/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

2. Sean has created a good-looking table and has decided to format one of his others.
1 / 1 point
reports in the same way. How can this be done?

If you're not sure, why not try it in Excel? That's the best way to learn.
Download the workbook here.

[Link]

You need to select your entire worksheet, then click Copy once.
format it and then click anywhere on the new worksheet to
grab all the different formats.

You need to select your entire worksheet, click Copy once.

Format and then click on cell A1 or on the first cell of your new sheet.
of work.

You can use the format painter, but only in stages due to the differences
formats throughout the data. First, you need to create the headers, then
the main data and then the totals row.

Correct
Correct. Give yourself a high five. This was a complicated question, but
your hard work is clearly paying off.

3. What are banded rows and how can we create them? 1 / 1 point

The rows with bands are linked to each other by their format. They can be
configure in border format.

The rows with bands alternate in colors to improve the readability of the sheets.
of calculation. They can only be configured manually by selecting every two rows and
then changing the background fill. The format painter can be used to
transfer this to other worksheets

Unable to access the provided URL for translation. 2/3

September 7, 2021 Taking the reins of Excel: Put your skills to the test, Part 1 | Coursera

The rows with bands alternate in colors to enhance the readability of the sheets.
of calculation. They can be configured by manually filling in the background of a row and
then select that row and the next one without filling. Now use the format painter and
drag the rows in which you want to see the rows with bands.

Correct
Yes well done. You are ready for the next challenge.

4. What happens when you select a section of your spreadsheet, click on this1 / 1 point
dropdown menu and select the first option?

It will undo my last action.

It will delete the number format from my data.

It will put a red highlight on my data.

It will clean everything from that selection.

Correct
Yes, that is correct. It's worth using this tool with caution!

The provided link does not contain translatable text. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Number formats
TOTAL POINTS OF 3

1. Sean applied numeric formatting to the cells D4 to D10. What format did he apply?
1 / 1 point

Number, 1 decimal place

Percentage, 1 decimal

Percentage, 0 decimal places

Number, without decimal place

Correct
Yes, that is exactly correct. You already know the format of your number.
quite well!

Sean made some more changes to the numerical format of his data. What format
1 / 1 point
Did it apply in column B?

Changed the number format to short date format.

Unable to access content from the provided link. 1/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Changed the number format to long date format and then added the days of
the week manually.

Changed the number format to long date format.

Correct
Yes, that's right. Well done.

What is the main difference between accounting and the number format? 1 / 1 point
currency in Excel? If you're not sure, go to Excel and play with some numbers.
before attempting to answer this question.

In the accounting format, the decimal points are aligned in a column.

The main difference is that in the accounting format, the symbol of the
the currency is aligned to the left, far from the number.

In the currency format, negative values are automatically shown in

red

Correct
Correct. That is the main difference between these formats. There are others.
differences, but this is the main one.

The provided link does not contain text to translate. 2/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Styles and themes

TOTAL POINTS OF 3

1. The color configuration in Cell Styles on the Home tab can only be 1 / 1 point
change by selecting predefined themes from Excel.

True

False

Correct
You have this right. You can customize the color of each cell style in the
dialogCreate new theme colors.

2. Choosing a different topic will cancel all previous formatting. 1 / 1 point

True

False

Correct
Well done, you obviously paid attention to this week's video about
styles and themes. Once you have used standard formats or
customized, applying a theme will not change those cells.

3. When changing the theme on any worksheet in a workbook, all sheets will look
1 / 1 point the same.
affected.

True

False

Correct
Yes, well done. Nicky analyzes this in the practice video about styles and
themes.

Unable to access the content at the provided URL. 1/1

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Manage rows and columns

TOTAL POINTS OF 3

1. You can insert a column to the left of an existing column by ... (One1 / 1orpoint
more answers are possible; partial credit will be granted

In the Home tab, select Insert, then Insert Sheet Columns

Correct
Yes, that's correct. The Insert button in the HOME tab allows you to insert
columns.

Select a column and press the Insert key on your keyboard.

Right-click on the column header and select

Insert.

Correct
Yes, you are right. This is a quick way to insert a column.

2. Sean wants to delete the contents of the cells O3, O4, P3, and P4. He right-clicks.
1 / 1 point
and select Delete ... in the context menu. Can you explain what it is
Is it on the right path? (One or more answers are possible; it
will grant partial credit)

Unable to access the content from the provided link. Please provide the text to be translated. 1/3
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Sean got confused with the ways to delete the content of the cells instead
to delete rows and columns. If you press OK, it will create a mess in your worksheet.

Correct
Yes, you have understood this part very well. Not all 'Delete' tools
In Excel, they have the same functionality.

Sean got confused with the ways to delete the contents of the cells instead
to delete rows and columns. The correct way to do it would have been to select
the cells and then navigate to the Home tab, press Clear, then
selectDelete content.

Correct
Yes, this is certainly correct. It's a somewhat slower way of doing it,
But it works!

What he has done is fine. He just needs to click on Accept now and then the
the content of their cells will disappear. The rest of their data will remain intact.

3. Sean needs to add a new account manager to his desk, but he wants 1 / 1 point
maintain the same classification and format. How will you add Robert Demarko to your sheet
of calculation without losing the current alphabetical list? (One or more answers are possible; it
will grant partial credit)

The provided link does not contain translatable text. 2/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Aren't you 100% sure? Do you prefer to try rather than guess? Download the sheet of
calculate here and work on it in Excel.

[Link]

Right-click on the symbol of Row 10 and select Insert.

Correct
Good thing. This is an excellent way to insert a new row in between
the entries of Presidents and Fernandes.

Click on row 10 of the table and use the keyboard shortcut CTRL+SHIFT+=.

Correct
Great: he has already learned the keyboard shortcut to insert rows and
columns. Good job!

Click anywhere in row 10 and navigate to the Insert tool.

In the Home tab, select Insert Sheet Rows.

Correct
Well done, this will definitely insert a new row in the right place.

Right-click on the row 9 symbol and select Insert.

Click on A10 and add a new cell.

Unable to access the content of the provided link. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Find and replace

TOTAL POINTS OF 3

1. In the practice video, Sean needed to change Mrs. Kinney's address from 1 / 1 point
Sydney Fish Market, Bank Street, Sydney
Pyrmont. When Sean worked on the Find and Replace process, why
Did you use the full address? This seems a bit cumbersome. Could you just
have searched for "Sydney" and then replace all instances with "Pyrmont"?
Which of the following statements are correct? (One or more answers are
possible; partial credit will be granted

What he did was correct because Excel can only make changes to one cell.
when you enter the original content of the entire cell in 'Find what' and then the
updated content in Replace with.

What he did was right, but it could have been faster if he had just
written "Sydney" in the search field. You would have obtained the same results.

What he did was right. If he had done a search and replace for
"Sydney" only, would have inadvertently changed all instances of
"Sydney" in the complete database, and I just wanted to change the ones for the clients.
from the fish market of Sydney.

Correct
You are spot on. It really needs to be absolutely precise when
perform a search and replace in Excel.

2. Which of the following options are configured correctly in the window 1 / 1 point
search dialog to show all results for the word 'with' in
lowercase letters, anywhere in the workbook (it has several sheets)?

Unable to access external content. 1/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Are these adjustments correct?

Will these adjustments give you the correct results?

Take a close look, are they correct?

The provided text is a URL and contains no translatable content. 2/4

September 7, 2021 Taking the Reins of Excel: Test Your Skills, Part 1 | Coursera

Are these options configured correctly?

Correct
Yes well done. You have identified the correct configuration. This was a question
delicate. Excellent work.

Sean wants to find all the postal addresses that have the number 18. 1 / 1 point
embargo, there are so many numbers in the dataset that, when you use the
default search configuration, it gets 441 results and mostly,
they are in the columns with currency. Can you help him reduce the amount
of search results to get your answer more easily? (One or more
answers are possible; partial credit will be given)

You can check the box Match entire cell content.

You can select Column D (Address) before performing your search.

Now, Excel will only search in this particular column.

Correct
Yes, this is a very practical way to reduce the search area.

You can open the Find dialog and change the formatting settings.
General.

Correct

Unable to access the provided link. Please provide text for translation. 3/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Yes, use the Format setting in the Find dialog box is a

excellent way to narrow down your search. However, be careful with
this option. It totally depends on whether the data has been formatted from
in a coherent and correct manner in the first place.

The provided URL does not contain any text to translate. 4/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Filtration
TOTAL POINTS OF 4

What does this icon mean? 1 / 1 point

The filtering is active and the sorting is ascending.

Filtering is active.

The filtering is active and the sorting is descending.

Filtering is applied.

Correct
Yes, well done. Whenever you see this sign, you will know that what you see in the
screen probably not all your data, as some of it has been
filtered.

2. Which of the following are valid filter arguments for a filled column? 1 / 1 point
dates and without background filling? (One or more answers are possible; it will be granted
partial credit

Tomorrow

Correct
Yes, absolutely. Excel will base the filter argument on the settings of
date of your computer.

It's not the same

Correct
Yes, the date filter has this argument. You can activate it by using the
Custom automatic filter.

Only weekdays

Unable to access the content of the provided link. 1/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Filter by color

3. Why is it important to clear all filters once you are done with a 1 / 1 point
specific task? (One or more answers are possible; partial credit will be given)

If you leave filtering enabled and save the file, you will lose the filtered data.
The next time you open the file, that content will disappear.

If you forget that one or more of your columns are still filtered when you are
interpreting your data for the following task, you can easily extract
erroneous conclusions from your data.

Correct
Yes, absolutely. The filters are very powerful and the data seems
disappear once a filter is applied. It's easy to forget about the filter, outside
Out of sight, out of mind.

Filters can remain applied even when the columns are

hidden. It's easy to lose track, especially in large datasets.

Correct
Yes, that's right. It's a good practice to clear all filters once you have
finished with his work.

4. How can you tell that a filter has been applied somewhere in your sheet?1 / 1 Ifpointnot
Are you sure? Go directly to Excel and try it.

Any column that has an active filter applied will appear in a

light gray tone.

The icon in the column header looks like this:

The icon in the column header looks like this:

The provided text is a URL and cannot be translated. 2/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
Yes, well seen. This column shows that a filter has been applied.

Unable to access the content of the URL provided for translation. 3/3
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Classification
TOTAL POINTS OF 4

1. Sean wants to sort his dataset by Order Quantity. He made a single click.
1 / 1 point
In the column header, select the column and press Sort and Filter.
In the Home tab, select Sort from largest to smallest. Which of the
The following options show what your spreadsheet will look like below?

Should I expect to see this result on your screen?

Unable to access the provided URL. 1/4

9/7/2021 Taking the Reins of Excel: Test Your Skills, Part 1 | Coursera

Is this how your screen will look?

Is this what you will see?

Correct
If that is correct. This is exactly what you will see. Can you find out what
Did it go wrong? Can you find out the correct steps? Try it in Excel.

2. Needs to sort a large and quite disordered dataset that has just 1 / 1 point
receive from a different department. It contains entries like dates, numbers and
text. Before using the Sort tool, what should you do first? (One or
more answers are possible; partial credit will be granted

Unable to access the provided link. 2/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Add headers to the dataset.

Correct
Yes, it's a great idea and a very good practice. Don't forget to inform more.
forward to the Sort tool that your data contains headers.

Create borders and change the font colors.

Make sure that the numerical format of each column is

coherent, for example, currency, accounting, percentage.

Correct
Yes, it is definitely a good practice. The inconsistent number format.
it may cause problems in the future.

3. Sean wants to sort a subset of his data in order of priority. He wants 1 / 1 point
see the critical elements first, followed by High, Medium, Low and then No
specified. However, there may be a small problem, can you guess
which one is it?

No idea. I should be able to sort the Priority column of the order easily.
using descending classification.

No idea. I should be able to sort the priority column of the order easily.
through the use of ascending order.

Invalid request. Please provide text to translate. 3/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Excel does not understand the text at a conceptual level, meaning it will classify this column.
in the following order: Critical, High, Low, Medium, Not specified.

Correct
Yes, great detective work. Excel will use alphabetical order to sort.
this column. Seeing that L comes before M, Low will come before
Medium. This does not correspond to our list. Is there a way to resolve it?
this problem. Why not go to Excel and take a look at the options of
Custom lists and see if he can solve this by himself?

Sean has been asked to sort the Name column of his dataset in 1 / 1 point
ascending order. What does that mean since your column contains text, not
numbers?

Ascending order means that you need to sort your data from A to Z.

Ascending order means that you need to sort your data from Z to A.

When sorting the text, it is never referred to as ascending order /

descending, but in alphabetical order.

Correct
Yes, that is correct. Sorting numbers in ascending order means that the
the number goes from smallest to largest. For text, it means that the list will start with
words that begin with A and end with words that begin with
Z.

Unable to access or translate content from external links. 4/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Conditional formatting
TOTAL POINTS OF 4

1. What can we use conditional formatting for? (One or more answers are 1 / 1 point
possible; partial credit will be granted)

Discover and visualize the behavior of data, especially in sets.

big.

Correct
Yes, it is a great help when trying to understand a large dataset.

Improve the design of our spreadsheet.

Identify trends, variations, and similarities in a variety of data.

Correct
Yes, that is perfect. Conditional formatting is a tool
extremely powerful.

To automatically highlight cells when certain conditions are met.

Correct
Yes exactly. It is an excellent tool for this automation.
You tell Excel the conditions and Excel does the rest of the work for you.
you.

2. To apply conditional formatting to a worksheet, you can click on any 1 / 1 point

cell.

True

False

Correct
Well done, you were definitely paying attention to this video.
week. Just like with any other format, we need to tell Excel
exactamente qué celda (s) queremos formatear.
Unable to access the provided URL for translation. 1/2
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

In the workbook [Link], Sean wants to highlight the cells in 'Priority of 2 / 2 points
"requests" that are marked as "Critical" with yellow fill and dark yellow text.
Can you guide him on how to do this with conditional formatting? The practice becomes
permanent, so why not download the worksheet below, follow the
process and then select the correct answer below? (One or more answers
they are possible; partial credit will be granted)

[Link]

Click on one of the cells that contain Critical, click on Format

conditional - Highlight cell rules - Text that contains ..., write 'Critical',
select Yellow fill with dark yellow text in the dropdown menu and
press Accept.

Select the range I4: I54, click on Conditional Formatting - Highlight Rules of
cell - Equal to ..., write 'Critical', select Yellow fill with yellow text
dark in the dropdown menu and press OK.

Correct
Yes, that is 100% correct. Definitely, this is a good way to
achieve that Sean gets the result he wants.

Select any cell in the worksheet, click on Conditional Formatting -

Highlight cell rules - Text that contains ..., write 'Critical', select
Yellow fill with dark yellow text in the dropdown menu and press
Accept.

Select the range I4: I54, click on Conditional Formatting - Highlight Rules of
cell - Text that contains ..., write 'Critical', select Yellow fill with
dark yellow text in the dropdown menu and press Accept.

Correct
Great job. I hope you are feeling a great sense of achievement; this was
complicated.

Unable to access the content at the provided URL. 2/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Page breaks
TOTAL POINTS OF 3

[Link] do you find the tool that allows you to insert a page break? 1 / 1 point

Navigate to the DATA tab and click on Breaks

Navigate to the PAGE DESIGN tab and click on Breaks

Go to the INSERT tab and click on Breaks

Correct
If that is correct. This is the correct way to insert page breaks.
Make sure you have selected the cell where you want to insert the break.
in advance.

2. Note that the active cell (selected cell) in the screenshot at 1 / 1 point
continuation isD5. What will happen if we click on Salts and then select
Insert page break?

A vertical page break will be inserted to the right of column D.

A horizontal page break will be inserted below row 5.

A vertical page break will be inserted to the left of column D and a break
A horizontal page will be inserted above row 5.

Correct

The provided text is a URL and does not contain any translatable content. 1/2
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Yes well done. If you select a cell in the top row, you will only get a
vertical page break and if you select a cell in the first column, only
you will get a horizontal page break, but anywhere else and you will get
one on top of the selection and another on the left.

3. What can Excel do when it manually adjusts a page break? (One or 1 / 1 point
more answers are possible; partial credit will be granted

You can change the appearance of the page break.

Correct
Yes, you got it right. In Windows, Excel changes the blue dotted line to a
solid line, on Mac it changes to a slightly different dotted line.
This makes it easier to distinguish between manual and automatic page breaks.

You can change the scale of that page.

Correct
Yes, that is perfect. Excel automatically adjusts the scale of a page.
to adapt to the new design.

You can change the number of columns on that page.

Correct
Yes, depending on how you adjust the page break, Excel may change the
number of columns on a page.

It can show an error message if there are too many columns in that new one.
page.

The provided text is a URL and cannot be translated. 2/2

September 7, 2021 Taking the Reins of Excel: Test Your Skills, Part 1 | Coursera

Print preview
TOTAL POINTS OF 3

1. You are working on one of your worksheets. Which of the following options
1 / 1 point
Will it open the Print Preview area?

Click on the Page Layout tab in the ribbon and look for the Preview icon.
of printing

Use the keyboard shortcut: CTRL + SHIFT + P

Look for the Print Preview icon in the status bar at the bottom.
bottom of the screen

Click on the FILE tab in the ribbon to access 'Backstage'. Here

you click on Print.

Correct
Yes, great job. I can see you are having fun. Ready for the next one?
challenge?

2. Take a look at the screenshot. How many pages will be printed if you 1 /press
1 point
PRINT below?

(Download the screenshot file here to take a closer look :)

Unable to access the content at the provided URL. 1/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

105

151

Correct

Unable to access the content of the provided link. 2/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Yes, that is exactly right. You can see that Excel is getting a
preview of 1 of 105 pages and that the configuration is set to
print all active sheets.

3. Sean's spreadsheet is very wide as it has 20 columns, and he would like1 / 1 to

point
reduce the number of pages that will be used for printing. Which of the following
What options can help Sean achieve it? (One or more answers are possible; you...
will grant partial credit

You can widen the print margins.

You should use the option: Fit all columns on one page.

You can reduce the print margins

Correct
Yes, that is it. Reducing the margins can significantly reduce the number.
of pages.

You can change the layout of the page from vertical to horizontal.

Correct
Yes, this is usually a good option to reduce the number of pages. The
workbooks with wide multiple columns tend to benefit from
to be in a horizontal orientation.

Unable to access the content of the provided link. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Orientation, margins, and scale

TOTAL POINTS OF 4

1. Which of the following icons will take you to the Page Layout view? 1 / 1 point

Do you need to press on this?

Should you press this icon?

Is this the correct icon?

Is this the correct one?

Correct
Yes, you got it right on this one. There are four different views to choose from in the section.

Views of the workbook in the VIEW tab. This is the correct one that it
will lead to Page Design.

2.
1 / 1 point

The provided link does not contain translatable text. 1/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

What view option is Sean using in the screenshot below?

Page Design view

The normal view

Page break view

Correct
Yes, that was too easy. Now that you are warmed up, go straight to the
next question.

3. What is the purpose of the Page Layout view? 1 / 1 point

It is an alternative way to navigate to the Page Design tools.

It is a 'view only' option to check the page design. Here

No more changes can be made.

It shows us how the data will look on a printed page.

Correct

Unable to access content at the provided URL. 2/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Yes, that is exactly right. The normal view really cannot

help us with that. We activate the Page Design view to make adjustments to
What will our page look like on a page.

4. How can you center the print selection horizontally on your page for 1 / 1 point
print?

Use the keyboard shortcut CTRL + A and click on

Go to the PAGE DESIGN tab, click on the icon below and then
Center your data on the page using the Custom Margins option.

Go to the VIEW tab on the ribbon, click on

Correct
Fantastic detective work. This feature is quite good.
hidden but very useful.

The provided text is a URL and cannot be translated. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Print titles
TOTAL POINTS OF 3

1. Sean wants to print the titles of all the columns at the top of each 1 / 1 point
page. How can you do that?

You need to click on cell B4 and then navigate to Freeze Panes and select
Freeze Panes

You need to go to the PAGE DESIGN tab, select the icon below, then
define the ranges for 'Rows and columns to repeat at the top' in the
Print Settings dialog box.

You need to go to the PAGE DESIGN tab, select the icon below, then
check "Print row and column headers" in the dialog box
Print settings.

You must select the entire column A and the entire row 3. Then you must navigate to the
page DESIGN tab and click on:

Unable to access the specified URL for translation. 1/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Correct
Yes, outstanding work. This was a complicated question, but it has
worked hard to understand how printed titles work!

2. What is the difference between Print Titles and Freeze Panes? 1 / 1 point

Print titles give you greater flexibility than panels.

frozen regarding which rows/columns to correct.

Freezing panels should be used with very large datasets.

while print titles work better with datasets
small.

Freezing panels has no effect on the printed page.

Correct
Yes, you got it right on this one. Freezing panels are a tool
excellent and easy to use to fix certain rows on the screen. If you want
influence how their data is displayed on the printed page, it must print
titles.

3. Take a look at the screenshot below. What can we expect from 1 / 1 point
our impression? (One or more answers are possible; partial credit will be granted)

Unable to access the content of the provided URL for translation. 2/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Why not try this with this week's worksheet if you're not 100% sure?

W05-V04 - Printed [Link]

The entire sheet will be printed with row and column headers.

Each page of the print will repeat the columns Order Number and Date of
order on the far left.

Correct
Yes, correct. Columns A and B were entered as absolute references.
in the dialog box for repeating columns on the left.

Although the dataset has not been formatted with internal borders, all the
Grid lines will be printed anyway.

Correct
Yes, great detective work. The Print grid lines option
will ensure that we see the gridlines in the print.

Unable to access the provided URL for translation. 3/4

9/7/2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

The column headers of row 3 will be printed on each page.

Unable to access the content from the provided URL. 4/4

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Headers and footers

TOTAL POINTS OF 3

What view option do you need to select to edit the Header or Footer section?
1 / 1 point
page of your worksheet?

The page break view

The normal view

Page Design View

Print Titles View

Correct
Yes, good job. It should be in the page layout view. Access it at
through the status bar or via the PAGE DESIGN tab.

2. What is the difference between a page header and a header on your sheet?
1 / 1 point
work? (One or more answers are possible; partial credit will be given)

A header appears automatically on each printed page.

Excel must be manually configured to repeat the headers of the
columns.

Correct
Yes, great job. Headings are an excellent way to add a
specific data at the top of each printed page.

Page headers provide accurate information about the type of data.

what each column contains.

Page headers allow us to add important metadata.

in addition to the content of a worksheet.

Correct
Yes, correct. Headers usually contain the name and the logo of the
company, or the name of the report author, as well as the title.

Unable to access external content. 1/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

They are the same.

Sean wants to change some details about his header and remembers that he needs
1 / 1 point
make those changes in the Design tab. He is looking at his ribbon but cannot
find the tab. Can you help him?

You must select the Draw tab and then click on the Design options.
header / footer

You need to click on the Header row to activate the Design tab.

You can stay on the Home tab, click on the dropdown menu
Format to select the Header/Footer design options.

Correct
Yes, that was too easy for you. Are you ready for the next challenge?

Unable to access the link provided. 2/2

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Basic types of charts

TOTAL POINTS OF 4

1. Where can you find the graphic tools? 1 / 1 point

Navigate to the INSERT tab and locate the Charts group.

Go to the HOME tab and click on Insert ...

Navigate to the DATA tab and locate the Charts group.

Correct
Yes, that is exactly correct. The Graphics group is located in the
INSERT tab.

2. When creating a chart, it is better to first select your data and headers. 1 out of 1 point

Certain

False

Correct
Yes, absolutely correct. He has done a great job paying attention to
the practice videos.

3. 1 / 1 point

Unable to access or translate content from external links. 1/3

9/7/2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Sean wants to create a pie chart based on the selection below. But
When you click on Create pie chart, something goes wrong. What is happening here?

Sean did not select Charlie Bui's record correctly.

Sean selected too many columns. That is why the chart will not display the
Charlie Bui's history.

Sean selected the wrong type of chart to display more than one series.

Correct
Yes, you got it right. Pie charts can only handle one series of
data.

4. Sean created the table below, but something went wrong. Can you help him figure 1 it out?
/ 1 point
What is happening here?

The provided link cannot be translated as it does not contain text. 2/3
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

It can be useful to play with this in Excel. Here is the workbook:

[Link]

Sean should not have selected the header row (Administrators of

accounts, Qtr1, etc.). To select data to create a chart, you only need to
select the data and then add the labels manually.

Sean did everything correctly, except for one thing. While he included correctly
the row and column labels to help Excel interpret the data,
included empty cells.

Sean selected too many data series to display in a graph.

columns. This has created the empty chart in series 5 and the strange dates in the
y-axis (the vertical axis).

Correct
Yes, that is correct. When you select empty cells, Excel thinks this is
did it on purpose and, instead of interpreting row 3 as the header row,
It will try to interpret it as a series of data. Then interpret Qtr1, Qtr2,
etc., like dates, which makes all the data read as dates in
place of dollars.

Delete the chart and then select the range of cells A3: E7. Problem
resolved.

Unable to retrieve content from the provided URL. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Move and resize graphics

TOTAL POINTS OF 5

What happens when you select a chart in Excel? 1 / 1 point

(One or more answers are possible. Partial credit will be awarded)

The graph itself is now gray to highlight that it is selected.

The size handles appear in all corners and sides of the chart.

Correct
Yes, correct. You can easily adjust the size of your chart with your mouse.
using these controls.

The chart tools appear above the ribbon.

Correct
Yes, well stained. The graphics come with a wide range of options.
customization. The appearance of the graph tools has evolved
changing in different versions of Excel. In Excel 2016, two appear
new tabs in Chart Tools: Design and Format.

All the data on which the graph is based is selected.

Correct
Yes, that is exactly correct. This is a very useful function, as it allows you
allows you to quickly consult your data and see what data is represented
in the chart. This also allows you to add/remove data from the chart
manipulating the size controls in your data.

The Sort and Filter tools on the Home tab are grayed out.

Correct
Yes, these tools are not available while in 'mode.
graphs

The provided link does not contain translatable text. 1/4

September 7, 2021 Taking the Reins of Excel: Test Your Skills, Part 1 | Coursera

2. Sean wants to move his chart to a new worksheet 'Charts' in his book. 1 / 1 point
work. What are your options?

(One or more answers are possible. Partial credit will be granted)

You can select the chart and then use the Cut and Paste command.

Correct
Yes, that is correct. You can use keyboard shortcuts for this, the button on the
HOME tab or the context menu of the right button.

You can right-click on the chart and then select 'Move'

"graph" in the context menu.

Correct
Yes, this is an easy and quick way to access the Move Chart tool.

You can select the chart, then navigate to the TOOLS OF

CHARTS and use the 'Move Chart' tool.

Correct
Yes correct. This is an excellent way to move your chart to another sheet.
work.

You can select the chart and then drag it with the mouse to the tab of the
worksheet 'Charts'.

3. Which of the following are key modifiable elements of a chart? 1 / 1 point

One or more answers are possible. Partial credit will be granted.

Area of the plot

Correct
Yes, in the center of each chart is the area of the plot.

Title of the graph

C t
The provided text is a URL and cannot be translated. 2/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera
Correct
Yes exactly. The title of the chart is an intrinsic element and allows for a
wide range of format options.

Functions

Graph area

Correct
Yes, the area of the graph is, so to speak, the canvas on which it is.
graph. There are some excellent customization options available. Your
creativity is the limit.

Legend

Correct
The legend is an important part of any chart to communicate
vital information about the data shown in the chart to your audience.

Sean has used the 'Move Chart' tool to move one of his charts to a 1 / 1 point
from the other worksheets. Then he realizes that he moved the chart to the sheet of
wrong work. Don't worry, a quick CTRL + Z to undo the move,
except that nothing happens. What's going on?

The Undo function does not work with graphics.

Once a chart is moved to a different worksheet, it cannot be

undo.

When the Move Graphics tool is used, the Undo function does not work.

Correct
Yes, correct. You studied this week's video well. The Move tool.
graphs do not allow the Undo function.

5. To create a chart sheet, you must: 1 / 1 point

Use the 'Move Chart' tool and place the selected chart as a
object on a new sheet.

Unable to access the content from the provided link. 3/4

9/7/2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Go to the chart properties and select 'show in full screen'.

Use the 'Move Chart' tool and place the selected chart in a
new sheet.

Correct
Yes well done. This is how a chart sheet is created, that is, a sheet of
work that shows only a full-size graph.

The provided text is a URL and does not contain translatable content. 4/4
September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Change the style and type of chart

TOTAL POINTS OF 3

1. Once you have created a chart (for example, a column chart), what 1 / 1 point
Can you do, if you can do something, to change to a different type of chart?
(There may be several answers, partial credit will be granted)

Select your chart, navigate to the Insert tab, find the group
Graphs and then select the type of chart you want to change to.

Correct
Yes well done. You can change the type of graph in the same way that
I would create a new chart.

You can only format the chart elements once you have created a type of
graph. If you want to change to a different type of graph, you need to create a new one.

You can right-click on the chart area and then select a

different type of chart through one of the options.

Correct
Yes, you got it right, good detective work. In the contextual menu of the button
On the right there is an option called Change chart type.

Select your chart, go to the Design tab, and click on Quick Layout to
choose a different type of chart.

2. What design option did Sean use to change the chart in the sheet Act Mngrs 2016 for
1 / 1 point
that looks like the screenshot below? (Note: you may need to
hover the cursor over the design for a moment to see the label

Invalid URL input. Unable to translate the content. 1/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Work with this week's worksheet to solve this.

W06-V03 Change styles and [Link]

Quick Design 1

Quick design 2

Quick Design 3

Rapid design 4

Quick design 5

Correct
Yes, you solved it very well. They used Quick Layout 5 to change their chart.
to resemble the previous screenshot.

3. What is the difference between the Rapid Design tool and Chart Styles in the 1 / 1 point
Design tab?

The chart styles change the elements of the chart that Excel displays.

The quick design tool only produces black and white graphics.

Invalid input format. Please provide the text to be translated. 2/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

The graphic styles mainly change the font and the shading of the
existing chart elements, while Quick Design alters the types of
graph elements that are displayed and their location in the chart area.

Both do the same thing, but the Chart Styles tool has a range
wider range of colors to choose from.

Correct
Yes, that is exactly correct. The quick design allows you to change the
elements of the chart that it is showing and where they appear in the chart.
The chart styles simply change the appearance of your chart.

The provided link does not contain translatable text. 3/3

September 7, 2021 Taking the reins of Excel: Test your skills, Part 1 | Coursera

Modify elements of the chart

TOTAL POINTS OF 3

1. Once I copy and paste a chart into a different worksheet, the chart already
1 / 1 point
it will not automatically update every time your data changes.

True

False.

Correct
You solved it very well. Even after having copied and pasted a
graph, the new instance of the graph is still linked to the data and is
will update in case of changes to the original data.

2. The description of the horizontal axis of Sean's graph is missing, what can 1 / 1Sean
point do?
to solve it?

With the chart active, you must navigate to the Add Chart Element tool.
in the Design tab.

You can double-click below the x-axis and a box will appear for you to
write the title of the horizontal axis.

You can right-click on the chart area and then select

Change chart type in the contextual menu.

Cannot access external links or content. 1/2

September 7, 2021 Taking the Reins of Excel: Test Your Skills, Part 1 | Coursera

Correct
Yes, absolutely right. Once you have selected the chart,
the Chart Tools tabs will appear and you will be able to add a
horizontal axis label through the Add Element tool
graph.

3. Sean has inserted a chart and has formatted it very well according to the
1 / 1 point
requirements of your company. However, he discovers that one of the rooms is missing.
Is it still possible for him to change the data range that the chart refers to?
One or more answers are possible; partial credit will be given.

No, once the chart is finished, you will not be able to make any changes.
You will have to start over.

Yes, you can add more data to your chart; you need to navigate to the Design tab.
Chart Tools and then click on Quick Layout.

Yes, you can select the chart to activate range selection in your data.
Then, you can use the size controls to adjust the range of data that
it is visualized in the graph.

Correct
Yes, this is a quick and easy way to modify the data selection that
is included in the graph.

Yes, click on the Select data button in the Data group on the tab
Design to expand or reduce the data range.

Correct
Yes, that is definitely a way to achieve Sean's goal. Well
done.

The provided link does not contain any translatable text. Please provide text for translation. 2/2