Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design For Mere Mortals

Authors: Michael J Hernandez

4th Edition

978-0136788041

More Books

Students also viewed these Databases questions

Question

Explain briefly what is meant by an online real-time system.

Answered: 1 week ago

Question

What are the Five Phases of SDLC? Explain each briefly.

Answered: 1 week ago

Question

How can Change Control Procedures manage Project Creep?

Answered: 1 week ago