Excel Skills for Business: Essentials Coursera Quiz Answers

All Weeks Excel Skills for Business: Essentials Coursera Quiz Answers

Excel Skills for Business: Essentials Week 1 Quiz Answers

Quiz 1: View Options

Q1. After entering data into a cell, which option(s) will move your cursor into the next cell underneath your active cell?

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

• Click the mouse pointer into the cell underneath.
• Press Enter.
• Press Tab.

Q2. Which tool should we use to help keep headings visible when we scroll through a large workbook?

• Freeze Panes
• Split
• Headings
• Page Break Preview

Q3. You are going to use the Freeze Pane function.

Take a look at the screenshot below. Which cell do you need to click in order to freeze columns A and B as well as rows 1-4? If you are finding this tricky – why don’t you download the workbook and have a play?Warehouse inventory1XLSX

• C5
• D5
• B5

Q4. How do you switch between different workbooks inside Excel?

• Click on the View tab and select this tool:
• Use the View Options in the Status Bar.
• Click on the tab that you want to navigate to.

Q5. Which tool was used here to produce the view below?

• Page Layout View
• Page Break View
• Print Preview

Quiz 2: Data Entry

Q1. Which of the following will Excel recognize as a date? (One or more answers are possible – partial credit will be awarded)

• 05/09/2016
• 05 Sept 16
• 5 9 2016

Q2. To clear the contents of a cell (without affecting the surrounding cells), single-click on the cell and…

(You might want to try this out in Excel. One or more answers are possible. Partial credit will be awarded)

• Click Delete on the Home tab in the Ribbon.
• Click No Fill on the Home tab of the Ribbon.
• Press Backspace then Enter on your keyboard (Delete and Return on Mac).
• Press the Delete key on your keyboard (Fn+Delete on Mac).

Q3. Before you can enter data in an empty cell you must double click on the cell.

• True
• False

Q4. Which of the statements below are correct regarding Excel’s behaviour when you enter data into an empty cell?

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

• Numbers and text entered together are automatically aligned on the right.
• Any number entered is automatically aligned on the right.
• Any number entered is automatically aligned on the left.
• Any text entered is automatically aligned on the left

Q5. Sean used a tool to create the contents of cell B7. Which one did he use?

• Is this correct?
• Is this correct?
• Is this correct?

Quiz 3: Fill handle

Q1. What is one of the main purposes of the fill handle that we have demonstrated?

• To automatically create a series based on existing data.
• To automatically enter data into an empty spreadsheet.
• To easily fill the background color of a large range of cells.

Q2. What does your mouse cursor need to look like in order to activate the fill handle?

• Four black, crossed arrows
• A bold, black plus sign
• A thick, white plus sign

Q3. Take a look at the screenshot below. Sean needed to separate the first names from Column C. This would normally take quite a long time but he managed to fill Column D within seconds. How did he do that?

If you are not sure, download the workbook below and have a go yourself. You can figure it out!First namesXLSX FileDownload file

NOTE: This question refers to a feature in Excel that is not available in the Mac version of Excel. However, you can still answer the question by watching the Practice Video on the Fill Handle in this week.

• He selected cell C2, then he dragged the fill handle to D7. All the first names appeared automatically.
• Sean typed “Christopher” into cell D2, then he dragged the fill handle to D7. He changed the tool option to Flash Fill.
• Sean selected cell D2, then he dragged the fill handle to D7. All the first names appeared.

Q4. How do you activate the fill functionality? Remember, if you are not sure, head over to Excel and explore!

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

• You right-click on your active cell and choose Fill handle from the context menu.
• You hover over the small square in the bottom right-hand corner of your active cell until you see the thick black cross, then click and drag.
• You select a range of cells and click on this icon in the Home tab.

Q5. Take a look at the screenshot below. What do you expect to see in the cells A3, B3, C3 and D3 when you drag the fill handle all the way down to D6?

If you are not sure, download the workbook below and give it a go in Excel.Fill handleXLSX

• A3: 5071-2
• B3: 2013-05-06
• C3: ######
• D3: 6
• A3: 5071-1
• B3: 2013-05-06
• C3: Christopher Schild
• D3: 7
• A3: 5071-2
• B3: 2013-05-06
• C3: Christopher Schild
• D3: 7

Quiz 4: Taking Charge of Excel: Test your skills, Part 1

Q1. The large toolbar that stretches across the top of the Excel window is known as the Excel bar.

• True
• False

Q2. The Excel Ribbon can be minimised or collapsed by double-clicking (single-clicking for Mac) on one of the Ribbon Tabs.

• True
• False

Q3. Columns are referenced using numbers.

• True
• False

Q4. Rows are referenced using numbers.

• True
• False

Q5. The first cell (top-left) in a standard Excel spreadsheet is known as 1A.

• True
• False

Q6. Cell B2 is to the right of cell A2.

• True
• False

Q7. Cells A1, A2, A3, …, A20 are all in the same row.

• True
• False

Q8. The Quick Access toolbar can be customised to show the tools you use most often.

• True
• False

Q9. Clicking on cell C3 and clicking Freeze Panes will freeze the top 3 rows and the first 3 columns.

• True
• False

Q10. You can navigate to the right-hand side of your spreadsheet using the scroll bars on the bottom right of the Excel window.

• True
• False

Q11. If you notice an error in a cell, you can edit the contents of the cell in the formula bar.

• True
• False

Q12. If Excel intelligently suggests what you intend to type, you can accept this suggestion by pressing Enter or Tab.

• True
• False

Q13. You cannot copy and paste text into Excel from another Office software such as Microsoft Word.

• True
• False

Q14. If you want to remove some information from your spreadsheet, you can highlight this information and press Delete.

• True
• False

Q15. If you want to reverse most previously conducted tasks, you can click the Undo button at the top left of the Excel window.

• True
• False

Quiz 5: Taking Charge of Excel: Test your skills, Part 2

Q1. How many columns in an Excel worksheet (version 2007 and later)?

• 13,500
• Infinite (no limit)
• 5,000
• 16,384

Q2. In a blank Excel workbook, go to the Insert tab on the ribbon. Which of the following is NOT available?

• Pictures
• Shapes
• SmartArt
• Columns (not Column chart)

Q3. In cell A1 type in the heading Date then press Enter. In cell A2 type in the following: 20-Jan-20. Use the fill handle to drag the date you have just typed down to row 20. What is the date in A15? Enter as shown or use Year-Month-Day format if you are not using an English version of Excel (for example 2020-01-20).

2020-01-20

Q4. In cells B1 to B3 enter the following:

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

18.72

Q5. Close your workbook without saving and open the attached workbook. What value is in cell Q101 on the Orders sheet?

13

Q6. How many worksheets are there in this workbook?

3

Q7. Go to the Sales 2016 worksheet. Which cell contains the heading Qtr4?

c3

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

(Hint: the range B8:E10 means to select all of the cells between B8 and E10. We go into this in more detail next week. Please use the number format #####.##)

6227

Q9. Select the two non-contiguous ranges (not next to each other) B4:B7 and D14:D17. What is the Average showing on your status bar for the two ranges?

(Please use the number format ####.##)

5224

Q10. Change the value in C13 to be 4675.24. What is the new value in C18?

(Please use the number format #####.##)

62277

Excel Skills for Business: Essentials Week 2 Quiz Answers

Quiz 1: Performing Calculations: Test your skills

Q1. Open the attached workbook. In F7 calculate Base Pay by multiplying the Hours by the Rate. Copy the formula down to F12. What is Sandy Smith’s Base Pay for the week?

Please enter the number only, no dollar sign.

10833

Q2. In G7 calculate the Commission amount by multiplying the Base Pay by the Commission Rate in J3. Copy the formula down to G12. What is Sandy Smith’s Commission for the week?

Please enter the number only, no dollar sign.

33.90

Q3. In H7 calculate Gross Pay by adding Base Pay and Commission. Copy the formula down to H12. What is Steve Welgemoed’s Gross Pay for the week?

Please enter the number only, no dollar sign.

409.34

Q4. In I7 calculate Tax by multiplying Gross Pay by the Tax Rate in J4 (in this instance all staff are on the same tax rate). Copy the formula down to I12. What is John McGregor’s Tax for the week?

Please enter the number only, no dollar sign.

299.34

Q5. In J7 calculate Net Pay by subtracting Tax from Gross Pay. Copy the formula down to J12. What is Steve Welgemoed’s Net Pay for the week?

Please enter the number only, no dollar sign.

642

Q6. In cells F14:J14 calculate totals for each of the columns. What was the total Gross Pay?

Please enter the number only, no dollar sign.

1231

Q7. In cells F16:J16 calculate an average for each of the columns. What was the Average Net Pay?

Please enter the number only, no dollar sign.

643

Q8. In cells F17:J17 calculate the maximum for each of the columns. What was the Maximum Tax?

Please enter the number only, no dollar sign.

254

Q9. In cells F18:J18 calculate the minimum for each of the columns. What was the Minimum Commission?

Please enter the number only, no dollar sign.

15.7

Q10. Click into the Branch Summary worksheet. First, we want to calculate the Total Commission for Edenvale (see the Branch column on both sheets). In B6 type in =SUM( then click into Pay Details and select G7:G9, then press Enter. Repeat the process, selecting the appropriate cells, to get the Total Commission for Sandown.

Use the fill handle to get Total Gross Pay for Edenvale and Sandown. What was the Total Gross Pay for Sandown?

Please enter the number only, no dollar sign.

2020.5

Excel Skills for Business: Essentials Week 3 Quiz Answers

Quiz 1: Number Formats

Q1. Sean applied number formatting to cells D4 to D10. What formatting did he apply?

• Number, 1 decimal place
• Percentage, 0 decimal place
• Percentage, 1 decimal place
• Number, no decimal place

Q2. Sean made some more changes to the number format of his data. What format did he apply in Column B?

• He changed the number format to Long Date format and then added the weekdays manually.
• He changed the number format to Long Date format.
• He changed the number format to Short Date format.

Q3. What is the main difference between the Accounting and the Currency number format in Excel? If you are not sure, head on over to Excel and have a play with some numbers before you attempt to answer this question.

• In the Currency format, negative values are automatically displayed in red
• In the Accounting format, decimal points are aligned in a column.
• The main difference is that in the Accounting format, the currency symbol is left aligned, away from the number.

Quiz 2: Styles and Themes

Q1. The color settings in Cell Styles on the Home tab can only be changed by selecting preset Excel themes.

• True
• False

Q2. Choosing a different theme will override all previous formatting.

• True
• False

Q3. When changing the theme on any worksheet in a workbook, all sheets will be affected.

• True
• False

Quiz 3: Formatting: Test your skills

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

What is most likely happening here?

• A1:B2 are linked through an absolute reference.
• A1:B2 have been merged.
• A1:B2 are a range and cannot be selected separately.
• A1:B2 have been set to Wrap Text.

Q2. Open the attached workbook and observe how the heading in row 1 has been formatted. What is the name of the font used in the heading?

36

Q3. Which alignment option has been applied to the heading in row 1?

• Increase Indent
• Wrap Text
• Middle Align
• Merge and Center

Q4. Which formatting options have been applied to cell A3?

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

• Center
• Italics
• Bold
• Middle Align

Q5. The date in B3 has lost its formatting. Apply a Long Date format. What month of the year was this data last modified?

• May
• June
• July
• August

Q6. The percentages in T9 and T10 also have the wrong number format. Change them to the correct number format (to match the rest of the data in the column). What value now shows in T10?

92.5

Q7. Which Cell Style has been added to cells C38:U38? (Hint: Look in the Cell Styles gallery, when you hover over a style it tells you the name.)

Total

Q8. Which of the following formats has been added to B3?

• Double Underline
• Thick Bottom Border
• Underline
• Outside Borders

Q9. Which alignment option has been applied to the headings in D6:T6?

• Rotate Text Up
• Vertical Text
• Wrap Text
• Merge and Center

Q10. Which alignment option has been applied to cell U31?

• Merge and Center
• Wrap Text
• Middle Align
• Center

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

3.8

Excel Skills for Business: Essentials Week 4 Quiz Answers

Quiz 1: Working with Data: Test your skills

Q1. 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

Q2. 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.
• There is only one way, he needs to select the next column and then set up the Conditional Formatting rules again.
• He can copy and paste the original column and then delete the content of the cells using the Clear tool.

Q3. 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?

35A

Q4. 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)

790.5

Q5. You need to find out about the most recent shipment. Sort the data by Ship Date. What was the Order Quantity for the most recent item?

55

Q6. 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 Customer Type for the most recently ordered Furniture Item?

• Corporate
• Small Business
• Home Office
• Consumer

Q7. 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 were High Priority?

Total

Q8. Clear the previous filter. Use filters to find out how many orders were for Home Office customers, where the Account Manager is Leighton Forrest, with a High priority.

Nill

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

Rhythm

Q10. 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).

M1-55

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

90.5

Q12. 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.

Excel Skills for Business: Essentials Week 5 Quiz Answers

Quiz 1: Printing: Test your skills

Q1. The attached workbook is needed to answer all the s 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?

F1

Q2. What Margin setting has been selected?

• Narrow
• Normal
• Wide
• No Margin

Q3. Which Orientation has been selected?

• Landscape
• Letter
• A4
• Portrait

Q4. A Custom Scale has been applied.

• True
• False

Q5. 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.

Q6. 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.

20 and extend it

Q7. 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)

• Total Number of pages has been added to the footer
• 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

Q8. 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

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

• We get another page break
• Nothing changes
• We now have 6 pages to print
• The custom scaling changes

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

• Set Page Width to Automatic
• Remove Print Titles
• Set Orientation to Landscape
• Reset Page Breaks

Excel Skills for Business: Essentials Week 6 Quiz Answers

Quiz 1: Charts: Test your skills

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

• The chart area is the part of the chart that displays the data visualization.
• The chart area is the entire chart with all of its elements.
• A worksheet in the workbook that only contains one chart.

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

• The plot area refers to the values from cells on your worksheet.
• 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.

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

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

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

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

Q5. 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-workbookXLSX FileDownload file

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 United States
• Crime in the United States by Volume, 1994-2013
• Crime in the USA – FBI Data

Q6. 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?

• A1:B9
• A4:B9
• B5:B9
• A5:B9

Q7. 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 clustered bar chart.
• A line chart.
• A scatter chart.
• A trendline chart.

Q8. 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.

• There is no legend to explain the value category.
• The x-axis information is missing.
• The y-axis information is missing.
• There are no gridlines.
• The chart title is meaningless.

Q9. 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?

Option A
Option B
Option C
Option D

Q10. 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.

• Option A
• Option B
• Option C
• Option D

Get All Course Quiz Answers of Excel Skills for Business Specialization

Excel Skills for Business: Essentials Coursera Quiz Answers

Excel Skills for Business: Intermediate I Coursera Quiz Answers

Excel Skills for Business: Intermediate II Coursera Quiz Answers

Excel Skills for Business: Advanced Coursera Quiz Answers