Excel Skills for Business: Essentials Coursera Quiz Answers – Get All Weeks Quiz Solutions
Table of Contents
Excel Skills for Business: Essentials Week 01 Quiz Answers
Taking Charge of Excel: Test your skills, Part 1 Quiz Answers
Q1. The large toolbar that stretches across the top of the Excel window is known as the Excel bar.
Correct Answer: False
Explanation: The large toolbar is called the Ribbon, not the Excel bar.
Q2. The Excel Ribbon can be minimized or collapsed by double-clicking (single-clicking for Mac) on one of the Ribbon Tabs.
Correct Answer: True
Explanation: Double-clicking on a Ribbon tab (or single-clicking on Mac) collapses or minimizes the Ribbon.
Q3. Columns are referenced using numbers.
Correct Answer: False
Explanation: Columns are referenced using letters (A, B, C, etc.), while rows are referenced using numbers.
Q4. Rows are referenced using numbers.
Correct Answer: True
Explanation: Rows in Excel are identified by numbers (1, 2, 3, etc.).
Q5. The first cell (top-left) in a standard Excel spreadsheet is known as 1A.
Correct Answer: False
Explanation: The first cell in Excel is referred to as A1, not 1A.
Q6. Cell B2 is below cell B3.
Correct Answer: False
Explanation: Cell B2 is above cell B3, as row numbers increase as you move downward.
Q7. Cells A1, A2, A3, …, A20 are all in the same row.
Correct Answer: False
Explanation: These cells are in the same column (column A), not the same row.
Q8. The Quick Access Toolbar can be customized to show the tools you use most often.
Correct Answer: True
Explanation: The Quick Access Toolbar is customizable to include frequently used tools for convenience.
Q9. Clicking on cell C3 and clicking Freeze Panes will freeze the top 3 rows and the first 3 columns.
Correct Answer: False
Explanation: Clicking on cell C3 and selecting Freeze Panes will freeze rows above C3 and columns to the left of C3 (not necessarily 3 rows and 3 columns).
Q10. You can navigate to the right-hand side of your spreadsheet using the scroll bars on the bottom right of the Excel window.
Correct Answer: True
Explanation: The horizontal scroll bar at the bottom of the window allows navigation to the right-hand side of the spreadsheet.
Q11. If you notice an error in a cell, you can correct it by typing over the error.
Correct Answer: True
Explanation: You can directly type over a cell’s content to correct any error.
Q12. If Excel intelligently suggests what you intend to type, you can ignore this suggestion by continuing to type.
Correct Answer: True
Explanation: You can override Excel’s suggestions by simply continuing to type.
Q13. You cannot copy and paste numbers into Excel from another Office software such as Microsoft Word.
Correct Answer: False
Explanation: Excel supports copying and pasting numbers (or text) from other Office applications like Word.
Q14. If you want to remove some information from your spreadsheet, you can highlight this information and press Delete.
Correct Answer: True
Explanation: Highlighting information and pressing Delete will clear the contents from the selected cells.
Q15. It is impossible to reverse more than one task at a time in Excel using the Undo tool.
Correct Answer: False
Explanation: Excel’s Undo tool allows reversing multiple tasks, depending on the action history.
Taking Charge of Excel: Test your skills, Part 2 Quiz Answers
Q1. How many columns in an Excel worksheet (version 2007 and later)?
Correct Answer: 16,384
Explanation: Excel worksheets (versions 2007 and later) have a total of 16,384 columns, which are labeled from A to XFD.
Q2. In a blank Excel workbook, go to the Insert tab on the ribbon. Which of the following is NOT available?
Correct Answer: Columns (not Column chart)
Explanation: While Column charts, SmartArt, Shapes, and Pictures are available in the Insert tab, “Columns” (not referring to Column charts) is not an option on this tab.
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?
Correct Answer: 3-Feb-20
Explanation: When you use the fill handle with a date, Excel automatically increments the date by one day for each subsequent cell. Starting with 20-Jan-20 in A2, the date in A15 will be 3-Feb-20 (14 days after the starting date).
Q3. Which key do you hold down when selecting cells that are in different areas of a worksheet?
Correct Answer: The Control (PC)/Command (Mac) key
Explanation: To select non-adjacent cells in an Excel worksheet, you hold down the Control key on a PC or the Command key on a Mac while clicking the cells you want to select.
Q4. Which of the following components must be part of any formula? (One or more answers are possible – partial credit will be awarded)
Correct Answer:
- The = sign
- A mathematical operator, e.g., +
Explanation:
- The = sign is required to indicate the beginning of a formula in Excel. Without it, the entry will be treated as text or a value.
- A mathematical operator (e.g., +) is usually present when performing calculations.
- Brackets, Parenthesis, and Functions are not mandatory for all formulas. They are used only for specific cases like complex calculations or using functions.
Q5. To change the relative cell reference A1 to an absolute cell reference, you use:
Correct Answer: $A$1
Explanation: The $ symbol before the column letter and row number (e.g., $A$1) indicates an absolute reference, meaning that the reference will not change when copied to another cell.
Q6. You have some cells formatted the way that you want them, and you want to copy this format to some new cells that already contain data.
Correct Answer: You can use the Format Painter to copy only the formats from the old cells to the new cells.
Explanation: The Format Painter tool allows you to copy the formatting (but not the data) from one cell or range of cells to another.
Q7. You want to insert 3 columns. Which of the following will get you there?
Correct Answers:
- 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.
Explanation:
- Selecting 3 columns and using the Insert option will insert 3 new columns.
- Repeatedly clicking the Insert button on the Home tab will insert one column at a time, so clicking it 3 times will achieve the same result.
- There is no option to type the number of columns to insert directly.
Q8. You have a column of numbers and you want to only show those values that are more than 1,000. The fastest way is to:
Correct Answer: Apply a number filter using ‘is greater than’ 1,000.
Explanation: The number filter option in Excel allows you to quickly filter the data to show only values that meet specific criteria, such as being greater than 1,000.
Q9. You want to print your rather large data set which spans 3 pages across according to the Print Preview. You want to fit it onto 2 pages. Which of the options below are useful techniques to achieve this?
Correct Answers:
- Use the Scale to Fit tools to reduce the size of your sheet.
- Remove some of the less important columns.
- Use narrower margins.
Explanation:
- Scale to Fit tools adjust the size of the data to fit within the desired page width.
- Removing less important columns reduces the total data width.
- Narrower margins can help fit the content onto fewer pages.
- Using the “Page Layout view” and setting the width to 2 pages will not automatically span 3 pages across into 2; it requires scaling or adjustments.
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
