Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help to do step # 15 for column J D G L A B C 1 Schedule-Week of June 1-8 2 Day Shift

image text in transcribed

image text in transcribed

I need help to do step # 15 for column J

D G L A B C 1 Schedule-Week of June 1-8 2 Day Shift Server 3 Sun Evening Alishia 4 Sun Day Alishia 5 Sun Evening Carol 6 Sun Evening Hugo 7 Sun Evening Meredith 8 Sun Day Bryan 9 Sun Evening Bryan 10 Sun Evening Todd 11 Sun Evening Mary 12 Sun Evening Margo 13 Sun Day Jake 14 Sun Jerri 15 Sun Evening Jerri 16 Mon Day Rhea 17 Mon Evening 18 Mon Day Carol 19 Mon Evening Carol 20 Mon Day Meredith 21 Mon Evening Meredith E F Servers-Day Shift Server Number of Shifts Alishia Arty Bryan Carol Hugo Jake Janna Jerri Josh Justina Lexi Marcus Margo Mary Meredith Rhea Todd OWANNANOWO H I J K Day Shift Servers of the Week Server 2-5 Shifts MorT Eligible Alishia TRUE Arty FALSE Bryan TRUE Carol FALSE Hugo FALSE Jake TRUE Janna FALSE Jerri TRUE Josh TRUE Justina TRUE Lexi TRUE Marcus FALSE Margo FALSE Mary FALSE Meredith TRUE Rhea TRUE Todd FALSE Day Rhea 15 In cell J3, enter a COUNTIFS function to calculate the number of Monday shifts each server is scheduled to work. Edit the formula in cell J3 by adding a second COUNTIFS function to calculate the number of Tuesday shifts each server is scheduled to work. Copy the formula down through cell J19. 16 In the range K3:K19, enter an IF function with a nested AND function to determine which employees are scheduled for at 2-5 shifts, including a Monday or Tuesday. The function should return the world Eligible if true, and leave the cell blank if false. 17 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Scenario Summary, Projected Income, Sales Trend Chart, Sales, Schedules. Save the workbook. Close Excel. Submit the workbook as directed

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

SQL Instant Reference

Authors: Gruber, Martin Gruber

2nd Edition

0782125395, 9780782125399

More Books

Students also viewed these Databases questions