Excel Skills for Business Essentials Quiz Answers

Excel Skills for Business Essentials course are offered by Coursera. In this post you will get Excel Skills for Business Essentials Quiz Answers | 100% Correct Answers. At first try to solve by your own effort if you face problem then take help from this post.

Excel Skills for Business Essentials Quiz

Offered By “Macquarie University”

⭐4.9 Stars (26,835 ratings)

N.B. We attempted our best to keep this site refreshed for our clients for nothing. You can likewise contribute by refreshing new inquiries or existing inquiry answer(s). There are numerous inquiries on our site, it is difficult for us to check them consistently. It will be extraordinary on the off chance that you can assist us with updating the site. Just let us know if you find any new questions through mail or comment . We will attempt to refresh the inquiry/answer ASAP.

Use “Ctrl+F” To Find Any Questions Answer. & For Mobile User You Just Need To Click On Three dots In Your Browser & You Will Get A “Find” Option There. Use These Option to Get Any Random Questions Answer.

To get Excel Skills for Business Essentials Quiz Answers | Week (1-3), Please click bellow:

Week- 1

Click Here To View Answers

Week- 2

Click Here To View Answers

Week-3

Click Here To View Answers

Week-4

Working with Data: Test your skills

1. You want to insert 3 columns. Which of the options below will help you to achieve that?

Multiple answers are possible. Partial credit will be awarded.

You select 3 columns, right-click and go to Insert
You select a column then click the Insert button on the Home tab 3 times
You right-click on the column header and go to Insert, then type the number 3

2. Sean has carefully set up some complicated Conditional Formatting to one of the columns in his worksheet. He now wants to apply the same rules to another column in his worksheet. What is the quickest way for him to do this?

He can use the Format Painter.
He can copy and paste the original column and then delete the content of the cells using the Clear tool.

There is only one way, he needs to select the next column and then set up the Conditional Formatting rules again.

3. Open the attached workbook. You will notice that some columns have been hidden. Unhide the columns. What is the Product Name for order 5023-1?

W04-Assessment.xlsx

Enter answer here

pencils

4. Order 5024-1 was cancelled. Delete row 11 (not just the data). What is the updated average in cell S1? (Please put the number only, no currency symbols)

Enter answer here

$1,156.53

5. You need to find out about the most recent shipment. Sort the data by Ship Date. What was the Ship Date for the most recent item? Enter using yyyy-mm-dd format.

Enter answer here

2017-02-08

6. You need to check the most recent furniture item. Sort the data by Product Category (A-Z) and then Order Date (Newest to Oldest). What is the Order Priority for the most recently ordered Furniture Item?

Critical
High
Medium

Low
Not Specified

7. You have been asked to find out about orders placed by the customer Cindy Chapman. Filter the data to show only her orders. How many orders had Tina Carlton as the Account Manager?

1 point
Enter answer here

8.Clear the previous filter. Use filters to find out how many orders were for Small Business customers, where the Account Manager is Natasha Song, with a High priority.

1 point
Enter answer here

9.
Question 9
Clear the previous filters. Use filters to find out how many orders were for Technology and had a Total over $20,000.

1 point
Enter answer here

10.
Question 10
Clear the previous filters. Apply a new filter to show the top 1% of orders by Total. What is the Average Quantity for the top 1% (cell M1043).

1 point
Enter answer here

11. Use the find tool to find order number 6044-1. What is the Priority for this order?

Enter answer here

Medium

12. Tina Carlton has recently married and has chosen to take her partner’s name. Start by clicking in 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. Enter answer here

137

Week-5

Printing: Test your skills

1. The attached workbook is needed to answer all the questions associated with this quiz. Open the attached workbook and investigate what this document will look like when printed (do not actually print). How many pages will print?

W05-Assessment.xlsx

Enter answer here

2. What Margin setting has been selected?

Wide
Normal
Narrow

No Margin

3. Which Orientation has been selected?

A4
Landscape
Portrait

Letter

4. A Custom Scale has been applied.

True
False

5. How many page breaks have been added?

For Mac users, switch to the Page Layout view, then back to Normal to see the page breaks. Manual page breaks will still be dotted lines.

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

Enter answer here

6. If we wanted to insert another page break between rows 20 and 21 we would need to click on which cell first? (We only want to add a horizontal page break). For your answer, enter a cell reference e.g. B5.

Enter answer here

A21

7. For the printed version of the page, based on the existing setup, which of the following is true? (One or more answers may be correct)

A page number has been added to the header
Total Number of pages has been added to the header

A page number has been added to the footer
Total Number of pages has been added to the footer

8. For the printed version of the page, based on the existing setup, the first four rows repeat on every page. To stop this we would:

Untick Headings (on Page Layout Tab)
Adjust settings in Print Titles

Adjust settings in Custom Margins
Remove Page Breaks

9.If we insert a column between C and D which of the following happens? (One or more answer may be correct)

We now have 6 pages to print
We get another page break

Nothing changes
The custom scaling changes

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

Set Orientation to Landscape
Set Page Width to Automatic

Reset Page Breaks
Remove Print Titles

Week-6

Charts: Test your skills

1. Creating charts is pretty straightforward but it’s important we know the terminology Excel uses. What is the Chart Area?

A worksheet in the workbook that only contains one chart.

The chart area is the entire chart with all of its elements.
The chart area is the part of the chart that displays the data visualization.

2. Creating charts is pretty straightforward but it’s important we know the terminology Excel uses. What is the Plot Area?

The plot area is the part of the chart that displays the data visualization. It is located in the area framed by the y and x axis.
The plot area contains all the information about the data source underneath the horizontal axis.

The plot area refers to the values from cells on your worksheet.

3. Creating charts is pretty straightforward but it’s important we know the terminology Excel uses. What is meant by the word Legend?

The legend is the explanation next to each of the axis.
The legend decodes the data labels and adds explanation to the chart.
This is not a valid term relating to Charts.

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

Multiple answers are possible, partial credit will be awarded.

Carefully select all the data you want to include in the chart.
Select any headings in rows and/or columns.
Ensure that your selection doesn’t contain any empty rows or columns.

5. Download the workbook below. It contains a slightly altered and abbreviated version of the FBI Crime Statistics, 1994-2013. You will need to work with it in order to answer the next questions in this assignment.

W06-workbook.xlsx
You have been given the task to provide some visual summaries to support a presentation on trends and volume of certain types of crime in the United States. Take a moment to familiarize yourself with the workbook. What is the title of Table 1?

Crime in the USA – FBI Data
Crime in the United States by Volume, 1994-2013
Crime in the United States

6. Take a look at the screenshot below and then head over to Excel to your W06-workbook file. Which cell ranges were selected to create this chart?

A4:B9

A5:B9
B5:B9
A1:B9

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

If you are unsure, go over to Excel and have a play with the different chart types to figure out which one we are seeing here.

A trendline chart.
A scatter chart.
A clustered bar chart.

A line chart.

8. Take a look at the chart below. What’s missing from this chart to make it a useful visualization for a presentation on Violent Crime rates between 1994-2013?

Multiple answers are possible, partial credit will be awarded.

The x-axis information is missing.
The chart title is meaningless.

There is no legend to explain the value category.
The y-axis information is missing.
There are no gridlines.

9. Using the data in the W06-workbook, create a 2-D Pie Chart for 2004, including labels. Which of the following best represents what you have created?

This:

10. Create a Line Chart for Violent crime, Burglary and Motor vehicle theft. Use the Quick Layout to show the data table below the chart (hint: hover over the Quick Layout options to find which one includes a data table). Change the colors so that Violent crime is green, Burglary is blue and Motor vehicle theft is 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 does your chart most closely resemble?

This:

Course 1 Final Assessment

1. Download the workbook and save it on your computer. Open the workbook and then come back here to start answering the questions.

C1 Assessment Workbook.xlsx
TIP: Make sure that you save your progress on the workbook in Excel frequently 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 your first job is to address some of the formatting.

The heading in cell A1 cannot be seen properly. Change the alignment so that you can see what it says.

In which year was this data collected?

Enter your answer in four digits ####

Enter answer here

2015

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

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

Enter answer here

2016-03-20

3. Apply the style Accent1 to the range A2:Z2. Apply the style Heading 3 to the range A4:Z4. Which of the following looks most like your data?

This:

4. There are also some corrections you need to make to the data. One of the data entries is missing. You have been asked to Insert a row after Case ID 49 (row 15) and enter the following data:

Case ID 51
Economic Position Full-time working
Occupation Type Managerial or Professional
Home Owned
Gender Male
Region Wales
Adults 2
Children 2
Jan Income 5924.00
Feb Income 5924.00
Mar Income 5924.00
Apr Income 5924.00
May Income 5924.00
Jun Income 5924.00
Jan Expenditure 2803.57
Feb Expenditure 2242.86
Mar Expenditure 2512.00
Apr Expenditure 2361.28
May Expenditure 2219.60
Jun Expenditure 2596.93
What is the total March Expenditure now? (cell Q2)

In your answer, you should use the number format #####.## with a period as a decimal point and two decimals.

Enter answer here

4429863.16

4. There are also some corrections you need to make to the data. One of the data entries is missing. You have been asked to Insert a row after Case ID 49 (row 15) and enter the following data:

In your answer, you should use the number format #####.## with a period as a decimal point and two decimals.

Enter answer here

4534401.10

4. There are some corrections you need to make to the data. One of the data entries is missing. You have been asked to Insert a row after Case ID 49 (row 15) and enter the following data:

In your answer, you should use the number format #####.## with a period as a decimal point and two decimals.

Enter answer here

4307242.05

5. An incorrect value has been entered for Case ID 5299. Use the Find tool to find this Case ID and change the January Income to $200. What is the total January Income now? (cell I2)

In your answer, you should use the number format #####.##

Enter answer here

6074344.46

6. There are several calculations missing which need to be added. An additional column showing the total number of people per household is required. Perform all the following steps and then answer the question.

Insert a column after column H
In I4 type the heading Household
In I5 enter a calculation to add the number of adults in G5 to the number of children in H5
Copy the formula down to fill the column
In cell I2, enter a calculation to get the total number of people in all the households represented, or copy the formula across from cell H2
QUESTION: What is the total Household value in cell I2?

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

Enter answer here

6378

7. In cell V5 enter a calculation to get an average of income from January to June (J5 to O5). Copy the formula down the column. What is the Average Income for Case 15 (cell V8)?

In your answer, you should use the number format #####.##

Enter answer here

3936.27

7. In cell V5 enter a calculation to get an average of income from January to June (J5 to O5). Copy the formula down the column. What is the Average Income for Case 20 (cell V10)?

In your answer, you should use the number format #####.##

Enter answer here

4019.36

8. In cell W5 enter a calculation to add up the total income from January to June. Copy the formula down the column. Widen the column so that you can see the results. What is the total income for Case 9 (cell W6)?

In your answer, you should use the number format #####.##

Enter answer here

19943.28

9. In cell X5 enter a calculation to add up the total expenditure from January to June (P5 to U5). Copy the formula down the column. What is the total expenditure for Case 15?

In your answer, you should use the number format #####.##

Enter answer here

12754.83

10. In cell Y5 enter a calculation to subtract Total Expenditure from Total Income. Copy the formula down the column. What is the Net for Case 9?

In your answer, you should use the number format #####.##

Enter answer here

9233.45

10. In cell Y5 enter a calculation to subtract Total Expenditure from Total Income. Copy the formula down the column. What is the Net for Case 20?

In your answer, you should use the number format #####.##

Enter answer here

17423.96

11. Cost of living has been estimated at going up by 3.93% over the next 6 months. We would like to forecast what the expenditure will be over that period. In cell Z2 enter the value 3.93%. In Z5 enter a formula to calculate the forecast expenditure. 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 expenditure. Copy the formula down the column. (Make sure that all the calculations are using the value in Z2!).

QUESTION: What is the Forecast Expenditure for Case 20?

In your answer, you should use the number format #####.##

Enter answer here

6955.18

QUESTION: What is the Forecast Expenditure for Case 15?

In your answer, you should use the number format #####.##

Enter answer here

13256.09

12. Now select the Stats Worksheet. Enter simple formulas in B3 and B4 to pull through the calculated Total Expenditure and Total Net from the Data worksheet (cells X2 and Y2). If you have done it correctly the pie chart should now show how income is proportioned between expenditure and net.

QUESTION: According to the pie chart, what percentage of Income is made up by Expenditure?

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

Enter answer here

QUESTION: According to the pie chart, what percentage of Income is made up by Net?

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

13. Still on the Stats sheet, enter a formula in B5 to add up the total income for Quarter 1 using the calculated totals for January, February and March in the Data worksheet. If you have done it correctly the cell should change colour.

QUESTION: What colour is the cell B5?

White
Purple
Yellow
Grey
Black

14. The organisation has decided to have one Region for the Midlands instead of two, so both East Midlands and West Midlands need to be replaced with just Midlands. We then need to answer some questions for the organisation.

In the Data worksheet, use Find and Replace to replace all instances of East Midlands with Midlands. Repeat the operation, this time replacing West Midlands with Midlands. Now filter the data so that only cases from the Midlands are visible.

QUESTION: What is the total number of Adults recorded for the Midlands?

Enter answer here

629

QUESTION: What is the total number of Children recorded for the Midlands?

476

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

QUESTION: How many households in Wales have 6 or more people?

Enter answer here

16. Clear all filters. Sort the data by Total Income in descending order (largest to smallest).

QUESTION: Which Case ID has the highest Total Income?

Enter answer here

566

16. Clear all filters. Sort the data by Total Income in descending order (largest to smallest).

QUESTION: What is the highest Total Income for a case?

In your answer, you should use the number format #####.##

40001.26

17. Change the sort to order the data so that you can easily identify the lowest Average Income for Cases with an Intermediate occupation.

QUESTION: What is the lowest Average Income for people with an Intermediate occupation?

In your answer, you should use the number format #####.##

Enter answer here

18.35

18. You are concerned there may be duplicates in the data set. Add conditional formatting to the Case ID column to show all duplicates in red. Sort the data by Case ID but instead of by values, sort by colour.

QUESTION: How many cases have been duplicated (entered twice)?

19. Delete one of each of the duplicate rows.

QUESTION: What is the new total in G2?

Enter answer here

3513

20. To help represent the data graphically you have been asked to create a few charts. You will need to go back to the Stats worksheet.

Select the data from A8 to B12. Insert a Pie Chart to compare the Average Incomes for different Economic Positions. Add a quick layout that shows a percentage for each segment.

QUESTION: What is the percentage for Full-time working?

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

Enter answer here

20. To help represent the data graphically you have been asked to create a few charts. You will need to go back to the Stats worksheet.

Select the data from A8 to B12. Insert a Pie Chart to compare the Average Incomes for different Economic Positions. Add a quick layout that shows a percentage for each segment.

QUESTION: What is the percentage for Part-time working?

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

Enter answer here

20. To help represent the data graphically you have been asked to create a few charts. You will need to go back to the Stats worksheet.

Select the data from A8 to B12. Insert a Pie Chart to compare the Average Incomes for different Economic Positions. Add a quick layout that shows a percentage for each segment.

QUESTION: What is the percentage for Economically Inactive?

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

Enter answer here

21. Create a line chart showing the Total Income for each Month. Ensure you select month names and Total Income values.

QUESTION: Which of these charts looks most like your line chart?

This:

22. Insert a Stacked Column Chart to show the Jan, Feb and Mar income for each Region.

QUESTION: Which Region has the fourth highest income for Jan-Mar (fourth largest stack)?

London

22. Insert a Stacked Column Chart to show the Jan, Feb and Mar income for each Region. Which region has the second lowest income for Jan-Mar (second smallest stack)?

Enter answer here

wales