Practice Module 2 – Excel (Part 2)
You are currently viewing a sample of the Cram Kit. Click here to unlock everything.
Time limit: 0
Practice Exercise Summary
0 of 15 Questions completed
Questions:
Information
You have already completed the practice exercise before. Hence you can not start it again.
Practice Exercise is loading…
You must sign in or sign up to start the practice exercise.
You must first complete the following:
Results
Practice Exercise complete. Results are being recorded.
Results
0 of 15 Questions answered correctly
Your time:
Time has elapsed
You have reached 0 of 0 point(s), (0)
Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)
Categories
- Not categorized 0%
- Review / Skip
- Answered
- Correct
- Incorrect
-
Question 1 of 15
1. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 2 of 15
2. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 3 of 15
3. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 4 of 15
4. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 5 of 15
5. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 6 of 15
6. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 7 of 15
7. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 8 of 15
8. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 9 of 15
9. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 10 of 15
10. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 11 of 15
11. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 12 of 15
12. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 13 of 15
13. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 14 of 15
14. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect -
Question 15 of 15
15. Question
- Open the “Excel Cram Kit (Test #2).xlsx” file.
- Go to the Documentation worksheet and complete the following:
- Enter your name into cell B2.
- Enter a date function into B3 that returns the current date.
- Enter a date function into B4 that returns the current date and time.
- In H3, use a function to determine the resulting date when 7 years and 3 days are added to the start date in D3.
- In H4, use a function to determine the resulting date when 2 months and 1 day are added to the start date in D4.
- In H5, use a function to determine the resulting date when 3 years are added to the start date in D5.
- Move to the Comparison Operators worksheet.
- Fill in the comparison operators in cells B2:B7. Make sure to surround each operator with quotes.
- Go to the Frat Recruits worksheet. This worksheet holds data concerning the newest fraternity recruits at Coding for Crammers University.
- Copy this worksheet and name this copy Totals. Position this Totals worksheet after the Frat Recruits worksheet.
- In the Totals worksheet, create an Excel table. Use the totals row to compute the following:
- Select only Freshmen recruits
- Count the total number of Freshmen recruits
- Find the minimum GPA
- Determine the average FTB (For the Boys) Rating
- Save the file.
- Go back to the Frat Recruits worksheet and copy it again. Name this copy SortFilter. Position this new worksheet after the Frat Recruits worksheet.
- Create an Excel table from the data in the SortFilter worksheet.
- Within this table, perform the following:
- Select only recruits who have a FTB (For the Boys) Rating greater than or equal to 6 and a GPA above 2.5.
- Sort the data by: Vibe (Ascending), FTB (For the Boys) Rating (Descending)
- Save the file.
- Go back to the Frat Recruits worksheet.
- Create a PivotTable with the following characteristics:
- Created the PivotTable on a new worksheet named GPA Stats, positioned after the SortFilter worksheet.
- For each State, then Year, display the Average GPA by FTB (For the Boys) Rating.
- Reduce the Average GPA values to have 1 decimal point and only include the Grand Totals at the bottom of the PivotTable.
- Style the PivotTable with “White, Pivot Style Light 1”.
- Move Ohio to the top.
- Alter Average GPA to appear as Mean GPA.
- Group the FTB (For the Boys) Rating values in groups of 2 so that 3-4, 5-6, 7-8, and 9-10 are together.
- Do not include recruits with a Fake vibe in the display.
- Every state except for Illinois should be selected.
- Save the file.
CorrectIncorrect