Excel Skills for Business Essentials – Coursera
Stars (26,322 ratings)
Instructor: Nicky Bull
Enroll Now
In this first course of “Excel Skills for Business: Essentials” the specialization Excel Skills for Business, you will gain proficiency with the fundamentals of Microsoft Excel. Inside about a month and a half, you will have the option to expertly explore the Excel user interface, perform essential calculations with formulas and functions, expertly format spreadsheets, and make perceptions of information through diagrams and charts.
Here you will find all the questions and quiz answers related to “Excel Skills for Business Essentials Coursera”
N.B. We endeavored our best to keep this site invigorated for our customers in vain. You can similarly contribute by reviving new requests or existing request answer(s). There are various requests on our site, it is hard for us to check them reliably. It will be exceptional if you can help us with refreshing the site. Simply let us know whether you locate any new inquiries through mail or remark . We will endeavor to invigorate the request/answer ASAP.
Excel Skills for Business Essentials Coursera Quiz Answer
(adsbygoogle = window.adsbygoogle || []).push({});
Week-1 (Critical Core Of Excell)
Taking Charge of Excel: Test your skills, Part 1
1. The large toolbar that stretches across the top of the Excel window is known as the Excel bar.
- True
- False
2. If the Ribbon is not visible, double-click (single-click for Mac) on one of the Ribbon Tabs to maximise or restore it.
- True
- False
3. Columns are referenced using numbers.
- True
- False
4. Rows are referenced using numbers.
- True
- False
5. The first cell (top-left) in a standard Excel spreadsheet is known as 1A.
- True
- False
6. Cell B2 is below cell B3.
- True
- False
7. Cells D1, D2, D3, …, D20 are all in the same column.
- True
- False
8.The Quick Access toolbar can be customised to show the tools you use most often.
- True
- False
9. Clicking on cell C3 and clicking Freeze Panes will freeze the top 3 rows and the first 3 columns.
- True
- False
10. You can navigate to the right of your spreadsheet by scrolling the scroll wheel of your mouse.
- True
- False
11. If you notice an error in a cell, you can correct it by typing over the error.
- True
- False
12. If text has already been entered in a column and you start typing in the same column, Excel will suggest existing values that begin with what you have typed.
- True
- False
13. You cannot copy and paste text into Excel from another Office software such as Microsoft Word.
- True
- False
14. If you want to remove some information from your spreadsheet, you can highlight this information and press Delete.
- True
- False
15. 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
(adsbygoogle = window.adsbygoogle || []).push({});
Taking Charge of Excel: Test your skills, Part 2
1. How many rows in an Excel spreadsheet (version 2007 and later)?
Infinite (no limit)
- 50,000
- 16,348
- More than 1 million
2. In a blank Excel workbook, go to the Insert tab on the ribbon. Which of the following is NOT available?
- Table
- Pictures
- Rows
- Shapes
3. 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-28
4. 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
5.Close your workbook without saving and open the attached workbook. What value is in cell Q83 on the Orders sheet?
13
6. How many worksheets are there in this workbook?
3
7. Go to the Sales 2016 worksheet. Which cell contains the heading Qtr2?
C3
8. 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 #####.##)
62272.98
9. 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 ####.##)
5549.49
10.Change the value in C13 to be 4675.24. What is the new value in C18?
(Please use the number format #####.##)
62277.02
(adsbygoogle = window.adsbygoogle || []).push({});
Week-2 (Performing calculations)
Taking Charge of Excel: Test your skills, Part 3
1. 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.00
2. 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
3.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
4. 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.35
5. 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.
643.01
6. 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.
294.73
7. 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.01
8.In cells F17:J17 calculate the maximum
for each of the columns. What was the Maximum Gross Pay?
Please enter the number only, no dollar sign.
1231.36
9.In cells F18:J18 calculate the minimum for each of the columns. What was the Minimum Tax?
Please enter the number only, no dollar sign.
15.7
10. 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.51
(adsbygoogle = window.adsbygoogle || []).push({});
Week-3
Taking Charge of Excel: Test your skills, Part 4
1. 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 have been merged.
- A1:B2 are a range and cannot be selected separately.
- A1:B2 are linked through an absolute reference.
- A1:B2 have been set to Wrap Text.
2. 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
3. Which alignment option has been applied to the heading in row 1?
- Middle Align
- Wrap Text
- Merge and Center
- Increase Indent
4. Which formatting options have been applied to cell A3?
(One or more answers are possible — partial credit will be awarded)
- Italics
- Bold
- Center
- Middle Align
5. The date in B3 has lost its formatting. Apply a Long Date format. What day of the week was this data last modified?
- Monday
- Tuesday
- Wednesday
- Thursday
- Friday
- Saturday
- Sunday
6. 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 T9?
92.50%
7. 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
8. Which of the following formats has been added to B3?
- Underline
- Double Underline
- Thick Bottom Border
- Outside Borders
9. Which alignment option has been applied to the headings in D6:T6?
- Merge and Center
- Rotate Text Up
- Wrap Text
- Vertical Text
10. Which alignment option has been applied to cell U31?
- Merge and Center
- Wrap Text
- Middle Align
- Center
11. 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 ##.###).
30.867
(adsbygoogle = window.adsbygoogle || []).push({});
The above questions are from “Excel Skills for Business: Essentials “. You can discover all the refreshed questions and answers related to this on the “Excel Skills for Business Essentials Coursera” page. If you find the updated questions or answers, do comment on this page and let us know. We will update the answers as soon as possible.
Is there are explanation of calculation?
Which question?