# 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 maximumfor 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 “____” 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.__**Excel Skills for Business Essentials Coursera**
Is there are explanation of calculation?

Which question?