Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I am absolutely stuck and need help on these steps Excel 206 I Module 8: SAM Project 1a sam Refresh Pilates Studio ANALYZING TABLE DATA

image text in transcribed

I am absolutely stuck and need help on these steps

Excel 206 I Module 8: SAM Project 1a sam Refresh Pilates Studio ANALYZING TABLE DATA GETTING STARTED Open the file IL EX16 8a FirstLastName 1.xlsx, available for download from the SAM website. Save the file as IL EX16 8a FirstLastName 2.xlsx by changing the "1 to a "2". If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. with the file IL EX16 8a_FirstLastName_2.xlsx still open, ensure that vour frst and last name is displayed in cell B6 of the Documentation sheet Tf cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Kecia Gill is the co-owner of Refresh Pilates Studio. You are working part-time 1 at the studio to help Kecia organize the class information and analvze.the studio income using Excel. You begin by improving the accuracy of the input data. Switch to the Schedule worksheet and use data validation to create an in-cell dropdown list that restricts data in the Room column in the table (E7:E15) using Mat Room, Equipment Room as the source values. Kecia is adding a new stretch class on Wednesday mornings. You will add that information to the schedule. 2. Add a new record on the Schedule worksheet, entering the data shown in Table 1 below into row 16. Use the in-cell dropdown list to enter the text Mat Room into cell E16. Table 1: Data for the Schedule Worksheet Table G F D C A B 16 PL109 Stretch 11:00 AM Wednesday Mat Room $15 Flood Excel 206 I Module 8: SAM Project 1a sam Refresh Pilates Studio ANALYZING TABLE DATA GETTING STARTED Open the file IL EX16 8a FirstLastName 1.xlsx, available for download from the SAM website. Save the file as IL EX16 8a FirstLastName 2.xlsx by changing the "1 to a "2". If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. with the file IL EX16 8a_FirstLastName_2.xlsx still open, ensure that vour frst and last name is displayed in cell B6 of the Documentation sheet Tf cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Kecia Gill is the co-owner of Refresh Pilates Studio. You are working part-time 1 at the studio to help Kecia organize the class information and analvze.the studio income using Excel. You begin by improving the accuracy of the input data. Switch to the Schedule worksheet and use data validation to create an in-cell dropdown list that restricts data in the Room column in the table (E7:E15) using Mat Room, Equipment Room as the source values. Kecia is adding a new stretch class on Wednesday mornings. You will add that information to the schedule. 2. Add a new record on the Schedule worksheet, entering the data shown in Table 1 below into row 16. Use the in-cell dropdown list to enter the text Mat Room into cell E16. Table 1: Data for the Schedule Worksheet Table G F D C A B 16 PL109 Stretch 11:00 AM Wednesday Mat Room $15 Flood

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

The Financial Services Marketing Handbook

Authors: Evelyn Ehrlich

2nd Edition

1118065719, 978-1118065716

More Books

Students also viewed these Finance questions

Question

What is electroosmosis?

Answered: 1 week ago