# Excel Skills for Business Essentials Coursera Quiz Answers 100% Free

# Excel Skills for Business Essentials – Coursera

Stars (26,322 ratings)

### Instructor: Nicky Bull

### Enroll Now

# Excel Skills for Business Essentials Coursera Quiz Answer

### Week-1 (Critical Core Of Excell)

## Taking Charge of Excel: Test your skills, Part 1

**True**- False

**True**- False

- True
**False**

**True**- False

- True
**False**

**B2**is below cell

**B3**.

**True**- False

- True
**False**

**True**- False

- True
**False**

**True**- False

**True**- False

- True
**False**

- True
**False**

**True**- False

**True**- False

## Taking Charge of Excel: Test your skills, Part 2

- 50,000
**16,348**- More than 1 million

- Table
- Pictures
**Rows**- Shapes

**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

**B1**to

**B3**enter the following:

**B2**and

**B3**then use the fill handle to drag down to row 20. What is the value in

**B15**?

18.72

13

3

C3

**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?

**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

**B4:B7**and

**D14:D17**. What is the Average showing on your status bar for the two ranges?

**####.##**)

5549.49

**C13**to be

**4675.24**. What is the new value in

**C18**?

**#####.##**)

62277.02

### Week-2 (Performing calculations)

## Taking Charge of Excel: Test your skills, Part 3

**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

**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

**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

**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

**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

**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

**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

**F17:J17**calculate the maximum

**Gross Pay**?

**Please enter the number only, no dollar sign.**

1231.36

**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

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

**Gross Pay**for Edenvale and Sandown. What was the Total

**Gross Pay**for Sandown?

**Please enter the number only, no dollar sign.**

2020.51

### Week-3

## Taking Charge of Excel: Test your skills, Part 4

**B2**, but every time he clicks on the cell, A1 becomes the active cell instead.

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

36

- Middle Align
- Wrap Text
**Merge and Center**- Increase Indent

**A3**?

- Italics
- Bold
- Center
**Middle Align**

**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

**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%

**C38:U38**? (Hint: Look in the Cell Styles gallery, when you hover over a style it tells you the name.)

total

**B3**?

- Underline
- Double Underline
**Thick Bottom Border**- Outside Borders

**Merge and Center**- Rotate Text Up
- Wrap Text
- Vertical Text

- Merge and Center
**Wrap Text**- Middle Align
- Center

**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

**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?