Question
1. Using the following information, write a formula that calculates in the order fulfill time in hours as shown for the first two orders in
1. Using the following information, write a formula that calculates in the order fulfill time in hours as shown for the first two orders in the table. Once the order fulfill time for each order is calculated, next write formulas to calculate: Average number of hours to fulfill orders (in cell E18); Average for Tim to fulfill orders (in cell E19); Most time taken by an order (in E20); Least time for order fulfillment (in E21).
2. Exercise 1: In this exercise, you will use LEN and SUBSTITUTE functions to calculate how many times the letters a, e, p, r, s, and t are present in texts in cells A2:A4. Next, you will calculate the average sentence length and average word size for each of the three text samples.
3. Exercise 3: You are given a worksheet of Green Landscaping Company. Such a worksheet is prepared for each project by the company on a daily basis. It lists different workers, their start and stop times, and hourly rate as shown. Your task is to write a formula for the wage column to calculate how much wage is due for each worker by automatically calculating the number of hours worked. You should also calculate the total wages in the cell shown in the worksheet.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started