Homework Answers
Task 1:
Click cell H10, and enter an AVERAGEIFS function to determine the average salary of full-time employees with at least one dependent. Format the results in Accounting Number Format.
Step 1:
Open the excel and go to Insurance worksheet. The Insurance worksheet is as shown below:
Step 2:
Go to cell H10 and enter the formula =AVERAGEIFS(D5:D34,B5:B34,"FT",C5:C34,">=1") as shown in the screenshot below:
Format the result in Accounting Number Format as shown in the screenshot below:
The result is as shown in the screenshot below:
Task 2:
Use Advanced Filtering to restrict the data to only display full-time employees with at least one dependent. Place the results in cell A37. Use the criteria in the range H24:M25 to complete the function.
Step 1:
Select the Data tab and click on Advanced in the Sort & Filter group as shown in the screen shot below:
Step 2:
The Advanced Filter window is as shown below: The List range is specified as the
range of data on which criteria is
to be specified.
Step 3:
The Criteria range is specified as the range in which the criteria are specified as shown below.
Step 4:
As the filtered data is to be placed in another location without disturbing the original data, select the radio button Copy to another location in the Advanced Filter window and specify the location as A37 as shown on the screenshot below:
Step 5:
After the List range and Criteria range are specified correctly, click on Ok button. The result is as shown in the screenshot below:
Add Answer to:
Click cell H10, and enter an AVERAGEIFS function to determine the average salary of full-time...
You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts
EX16_XL_COMP_GRADER_CAP_AS - Manufacturing 1.6 Project Description:You have recently become the CFO for Beta Manufacturing, a small cap company that produces auto parts. As you step into your new position, you have decided to compile a report that details all aspects of the business, including: employee tax withholding, facility management, sales data, and product inventory. To complete the task, you will duplicate existing formatting, utilize various conditional logic functions, complete an amortization table with financial functions, visualize data with PivotTables, and lastly...
EXCEL AppCapestone
Click cell H 10 and enter an averageifs function to determine the average salary of full-time employees with at least one dependent. format the results in accounting number format
Oject Description: u own five apartment complexes. You created a dataset listing the apartment nu...
please post with pictures of step by step solution
oject Description: u own five apartment complexes. You created a dataset listing the apartment numbers, apartment complex mes, as last remodeled. You want artments need to number of bedrooms, rental price, whether the apartment is occupied or not, and the date the apartment to insert some functions to perform calculations to help you decide which be remodeled. To focus on the apartments that need to be remodeled, you will use vanced...
Next, redefine the Lookup function to classify employees as “Above Average” and “Below Average” based on whether they s...
Next, redefine the Lookup function to classify employees as
“Above Average” and “Below Average” based on whether they scored
above or below an average of 5 in their three performance scores.
Place the results in the 7th Column, or Column G. (can
someone explain to me how this formula is typed) i HAVE THIS
=LOOKUP(E2,{0,6,10},{"Below Average","Above Average"})
should the number be a 5 or a 6.
Managers often like to rank employees performance. One scheme called "20-70-10," or more disparagingly...
I have completed these but wanting to compare such as Question 14. Is the word "Total"...
I have completed these but wanting to compare such as Question 14. Is the word "Total" added in the row or written as "Average" or "Total Average" Also Question 8 is not clear what fill color. Is it supposed to stay as blue and just select gradient fill? Very unclear questions. Thank you. Question: EX16_XL_VOL1_GRADER_CAP_AS – Travel Vacations 1.4 ( Excel, Chapter 4) Project Description: 1 Start Excel. Download and open the file named exploring_ecap_grader_a1.xlsx. 2 On the DC worksheet,...
In cell C6, insert a Scatter Chart for the Returns Completed versus Return Price data from...
In
cell C6, insert a Scatter Chart for the Returns
Completed versus Return Price data from the Data
worksheet. You may be used to seeing Price placed on the Y-axis
from other economics courses, but in this problem we are using
price as the independent variable.
Inserting Chart
Select the Scatter chart from the provided chart options in the
Charts group of the Insert tab of the Ribbon.
Selecting Data Series
Then choose Select Data in the Design tab on...
Hello, I need some help with some Excel formulas. a. Open Excel_Ch11HW.xlsx and save it as...
Hello, I need some help with
some Excel formulas.
a. Open Excel_Ch11HW.xlsx and save it as
Excel_Ch11HW_LastNameFirstName.
b. Click cell H4, the cell containing the ending date for the first
loan. Enter the formula to compute the ending date, based on the
starting date and the term of the loan. For the sake of simplicity,
you don’t have to account for leap year. To compute the ending
date, multiply the term of the loan by 365 and add that result...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty pl...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty plant types in the Category column. 9 In cell H13, type Stock Level. In cell H14, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 50, the Value if true is Order. Otherwise the Value if false is OK. Fill the formula down through cell H42. 10 Apply Conditional Formatting to the Stock Level...
please disregard the excel question А B D Question 1 -- Stacy's Travel Agency 2 3...
please disregard the excel question
А B D Question 1 -- Stacy's Travel Agency 2 3 8 Instructions 4. You are an agent at a local travel agency. Your manager has asked you to track your sales of next winter's holiday packages. For each package, customers can schoose whether or not to include a flight in the package. For each sale, an initial down payment of 20% of the total package cost is required. 6 Customers can pay the remainder...
please use python and provide run result, thank you! click on pic to make it bigger...
please use python and provide run result, thank you!
click on pic to make it bigger
For this assignment you will have to investigate the use of the Python random library's random generator function, random.randrange(stop), randrange produces a random integer in the range of 0 to stop-1. You will need to import random at the top of your program. You can find this in the text or using the online resources given in the lectures A Slot Machine Simulation Understand...
please post with pictures of step by step solution
oject Description: u own five apartment complexes. You created a dataset listing the apartment numbers, apartment complex mes, as last remodeled. You want artments need to number of bedrooms, rental price, whether the apartment is occupied or not, and the date the apartment to insert some functions to perform calculations to help you decide which be remodeled. To focus on the apartments that need to be remodeled, you will use vanced...
Next, redefine the Lookup function to classify employees as
“Above Average” and “Below Average” based on whether they scored
above or below an average of 5 in their three performance scores.
Place the results in the 7th Column, or Column G. (can
someone explain to me how this formula is typed) i HAVE THIS
=LOOKUP(E2,{0,6,10},{"Below Average","Above Average"})
should the number be a 5 or a 6.
Managers often like to rank employees performance. One scheme called "20-70-10," or more disparagingly...
In
cell C6, insert a Scatter Chart for the Returns
Completed versus Return Price data from the Data
worksheet. You may be used to seeing Price placed on the Y-axis
from other economics courses, but in this problem we are using
price as the independent variable.
Inserting Chart
Select the Scatter chart from the provided chart options in the
Charts group of the Insert tab of the Ribbon.
Selecting Data Series
Then choose Select Data in the Design tab on...
Hello, I need some help with
some Excel formulas.
a. Open Excel_Ch11HW.xlsx and save it as
Excel_Ch11HW_LastNameFirstName.
b. Click cell H4, the cell containing the ending date for the first
loan. Enter the formula to compute the ending date, based on the
starting date and the term of the loan. For the sake of simplicity,
you don’t have to account for leap year. To compute the ending
date, multiply the term of the loan by 365 and add that result...
Assignment Instructions In cell B10, use the COUNTIF function to count the number of Specialty plant types in the Category column. 9 In cell H13, type Stock Level. In cell H14, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 50, the Value if true is Order. Otherwise the Value if false is OK. Fill the formula down through cell H42. 10 Apply Conditional Formatting to the Stock Level...
please disregard the excel question
А B D Question 1 -- Stacy's Travel Agency 2 3 8 Instructions 4. You are an agent at a local travel agency. Your manager has asked you to track your sales of next winter's holiday packages. For each package, customers can schoose whether or not to include a flight in the package. For each sale, an initial down payment of 20% of the total package cost is required. 6 Customers can pay the remainder...
please use python and provide run result, thank you!
click on pic to make it bigger
For this assignment you will have to investigate the use of the Python random library's random generator function, random.randrange(stop), randrange produces a random integer in the range of 0 to stop-1. You will need to import random at the top of your program. You can find this in the text or using the online resources given in the lectures A Slot Machine Simulation Understand...
Most questions answered within 3 hours.
-
B. If compound Y has approximately the same values of solubility
in toluene as compound X,...
asked 6 minutes ago -
Oscar Inc. has inventory in Japan valued at 39,051,000 Yen one
year ago. One year ago...
asked 13 minutes ago -
4. How many input & output Key Value Pairs are passed into,
and emitted out of...
asked 17 minutes ago -
If Canada suffered from "fundamental disequilibrium," and its
government choose not to devalue its currency, a...
asked 21 minutes ago -
Why would your heart not function well if constructed of
skeletal muscle? What is the particular...
asked 25 minutes ago -
Please respond to this essay question in full essay form for
Chemistry 1102 Organic and Biochemistry:...
asked 25 minutes ago -
Determine the head loss and velocity of flow in a water supply main
of 15.0 cm...
asked 28 minutes ago -
A marketing executive who knowingly authorizes a shoddy
defective product to be brought to market is...
asked 36 minutes ago -
Write a psudocode:
1. Define a function called authorize that takes in 2 strings,
uName, and...
asked 41 minutes ago -
What Hall voltage (in mV) is produced by a 0.180 T field applied
across a 2.60...
asked 40 minutes ago -
What mass of ethylene glycol (C2H6O2) must be added to 211.0 g
of water to obtain...
asked 43 minutes ago -
Mary's employer has a defined benefits retirement plan, which
pay 3.2% of her last year's salary...
asked 46 minutes ago