Question

Step 1 Instructions Start Excel. Download and open the file named Excel_BU03_Assessment1_Fitness.xlsx. Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. 2 On the Data worksheet, create a ClassInfo named range for the cell range B4:H8. 3 Create a Class_IDs named range for the cell range B4:H4. 4 Select the range B11:H14. Create named ranges using the top row as the name for your named ranges. Each range is the list of instructors that can teach individual classes. 5 Select the range B11:H11 and create a ClassNames named range for all of the different fitness classes offered at the hotel. 6 On the Enrollment worksheet, in cell D15, enter an HLOOKUP function that will look up the class ID in cell B15 and will use the Classinfo table_array to return the Fee from the fifth row of the table. 7 In cell E14, create a new column header named Class_Name. In cell E15, enter an HLOOKUP function that will look up the class number in cell B15 and use the Classinfo table to return the Class Category name from the second row of the table with an exact match. 8 In cell G3, use the FILTER function to retrieve records from the data set for Males who have enrolled in either a Zumba class or a Step Aerobics class. Format the Fee values as Currency with 2 decimal places. 9 Setup the Enrollment worksheet to use Database functions. Select A14:E107, and then name the cell range Enrollment Copy range A14:E14, and then paste in range A1:E1 to set up criteria area.

          Step
1
Instructions
Start Excel. Download and open the file named Excel_BU03_Assessment1_Fitness.xlsx.
Grader has automatically added your last name to the beginning of the filename. Save the file
to the location where you are storing your files.
2
On the Data worksheet, create a ClassInfo named range for the cell range B4:H8.
3
Create a Class_IDs named range for the cell range B4:H4.
4
Select the range B11:H14. Create named ranges using the top row as the name for your
named ranges. Each range is the list of instructors that can teach individual classes.
5
Select the range B11:H11 and create a ClassNames named range for all of the different
fitness classes offered at the hotel.
6
On the Enrollment worksheet, in cell D15, enter an HLOOKUP function that will look up the
class ID in cell B15 and will use the Classinfo table_array to return the Fee from the fifth row
of the table.
7
In cell E14, create a new column header named Class_Name.
In cell E15, enter an HLOOKUP function that will look up the class number in cell B15 and use
the Classinfo table to return the Class Category name from the second row of the table with
an exact match.
8
In cell G3, use the FILTER function to retrieve records from the data set for Males who have
enrolled in either a Zumba class or a Step Aerobics class. Format the Fee values as Currency
with 2 decimal places.
9
Setup the Enrollment worksheet to use Database functions.
Select A14:E107, and then name the cell range Enrollment
Copy range A14:E14, and then paste in range A1:E1 to set up criteria area.

Step
1
Instructions
Start Excel. Download and open the file named ExcelBU03Assessment1Fitness.xlsx.
Grader has automatically added your last name to the beginning of the filename. Save the file
to the location where you are storing your files.
2
On the Data worksheet, create a ClassInfo named range for the cell range B4:H8.
3
Create a ClassIDs named range for the cell range B4:H4.
4
Select the range B11:H14. Create named ranges using the top row as the name for your
named ranges. Each range is the list of instructors that can teach individual classes.
5
Select the range B11:H11 and create a ClassNames named range for all of the different
fitness classes offered at the hotel.
6
On the Enrollment worksheet, in cell D15, enter an HLOOKUP function that will look up the
class ID in cell B15 and will use the Classinfo tablearray to return the Fee from the fifth row
of the table.
7
In cell E14, create a new column header named ClassName.
In cell E15, enter an HLOOKUP function that will look up the class number in cell B15 and use
the Classinfo table to return the Class Category name from the second row of the table with
an exact match.
8
In cell G3, use the FILTER function to retrieve records from the data set for Males who have
enrolled in either a Zumba class or a Step Aerobics class. Format the Fee values as Currency
with 2 decimal places.
9
Setup the Enrollment worksheet to use Database functions.
Select A14:E107, and then name the cell range Enrollment
Copy range A14:E14, and then paste in range A1:E1 to set up criteria area.

Added by Iker C.

Question

Please give Ace some feedback