Answered step by step
Verified Expert Solution
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
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 FloodStep 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