Question: Using the SUMIF or AVERAGEIF function accomplish the following: Use conditional formatting on the salaries in the range B2:B17. In the top/bottom rules, use Below

  • Using the SUMIF or AVERAGEIF function accomplish the following:
    • Use conditional formatting on the salaries in the range B2:B17. In the "top/bottom rules," use "Below Average" and Light Red Fill Color with Dark Red Font. This should display the lowest values in Red. Do this as closely as you can with your system.
    • In cell B19 calculate the combined salaries of all employees named Steve
    • In cell B20 calculate the combined salaries of all employees named Mary
    • In cell B21 calculate the combined salaries of all employees named Larry
    • In cell B22 calculate the combined salaries of all employees named Joe (Joseph,also)
    • In cell B23, calculate the AVERAGE salaries of all employees named Lisa

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Q:

| Modules 1-4: SAM Capstone Project 1b Format the range B6:K6 as described below: 7. a. Center cell contents. b. Change the font size to 11 point. 8. 9. C. Change the background color to Orange,...

Q:

PLEASE PROVIDE SCREENS SHOT WITH THE STEPS 7. Format The Range B6:K6 As Described Below: a. Center Cell Contents. b. Change The Font Size To 11 Points. c. Change The Background Color To Orange,...

Q:

Open the file NP _ EX 1 9 _ CS 1 - 4 a _ FirstLastName _ 1 . xlsx , available for download from the SAM website. Save the file as NP _ EX 1 9 _ CS 1 - 4 a _ FirstLastName _ 2 . xlsx by changing the 1...

Q:

PROJECT STEPS 1. Go to the CustomerList worksheet and complete the following actions: a. Apply a conditional formatting rule to the range A4:A32 that formats any duplicate values with Yellow Fill...

Q:

9. In cell E14 , use the Count function to count the values in the range E6 :E13 . Select the range A5:J14 and then add All Borders to each cell. Select the range H6:H14 and then format the range as...

Q:

Need help with Excel. 1. Jack Roscoe started running a sports blog two years ago, and since then, it has provided a second income for him and his family. Jack is reviewing the recent articles written...

Q:

PROJECT STEPS Jack Roscoe started running a sports blog two years ago, and since then, it has provided a second income for him and his family. Jack is reviewing the recent articles written for the...

Q:

please solve this project, subject:Computer Applications GETTING STARTED Save the file NP_EX365_2021_CS1-4a FirstLastName_1.xisx as NP_EX365_2021_CS1-4a_FirstLastName_2.xlsx Edit the file name by...

Q:

please solve this project, subject:Computer Applications GETTING STARTED Save the file NP _ EX 3 6 5 _ 2 0 2 1 _ CS 1 - 4 a FirstLastName _ 1 . xisx as NP _ EX 3 6 5 _ 2 0 2 1 _ CS 1 - 4 a _...

Q:

P L U G - I N T3 Problem Solving Using Excel 2010 LEARN IN G OUT C O ME S 1. 2. 3. 4. 5. Describe how to create and sort a list using Excel. Explain why you would use conditional formatting using...

Q:

You must have completed Exercise 10 in Chapter 10 for beginning this exercise and thus have used the SQL Data Definition Language to create tables for the three relations DRIVER, TICKET_TYPE, and...

Q:

Rampur is 100 km from Sitapur. At 3 pm Bharat Express leaves Rampur for Sitapur and travels at constant speed of 30 kmph. One hour later, Laxman Mail leaves Sitapur for Rampur and travels at a...

Q:

13. Bond Pricing (LO2) This problem refers to bond quotes in Figure 7.4. Calculate the price of the Canada Jun 01/18 to prove that it is 118.99 as shown. Assume that today is February 27, 2015.

Q:

Describe how total variable costs and unit variable costs behave with changes in the level of activity. If fixed costs increase, what would be the impact on the contribution margin and income from...