SKL ECH04 A2 – Tools 2.1
Project Description:
In this project, you will create an Excel table to sort and filter data at a hardware store. Use an IF function to determine if an inventory item is low and needs to be reordered.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel 2013, and then open the downloaded file skills_exl04_grader_a2.xlsx. |
0.000 |
|
2 |
On the First Half Sales worksheet, insert the NOW function in cell A13. |
7.000 |
|
3 |
On the First Half Sales worksheet, in the range H5:H8, insert a Column Sparkline for each row. |
10.000 |
|
4 |
On the Tools worksheet, in cell H5, enter an IF function that will display the word Order if the Total Inventory result is less than the Order Point value in the same row. Otherwise, the function will return the text No. Center the results in cell H5, and then AutoFill the function down through cell H38 |
11.000 |
|
5 |
On the Tools worksheet, select the range F5:F38, and apply a Solid Fill Blue Data Bar conditional format. |
9.000 |
|
6 |
On the Tools worksheet, format the data in the range A4:H38 as an Excel table with headers using Table Style Light 2. |
10.000 |
|
7 |
Create a copy of the Tools worksheet and move it to the end of the workbook. Rename the copied worksheet tab as Power Tools. |
8.000 |
|
8 |
On the Power Tools worksheet, sort the Order Point column from the largest to the smallest value. |
7.000 |
|
9 |
On the Power Tools worksheet, filter the Excel table to display only the category Power Tool. |
7.000 |
|
10 |
On the Power Tools worksheet, show the Total row. Display the sum of column F in the Total row. |
7.000 |
|
11 |
On the Power Tools worksheet, hide column B. |
7.000 |
|
12 |
Group the worksheets. Change the page orientation to print Landscape. |
7.000 |
|
13 |
On the Tools worksheet, change the Page Setup to repeat the titles in rows 1:4. Change the Width scale to fit on one page. |
10.000 |
|
14 |
Ensure that the worksheets are correctly named and placed in the following order in the workbook: First Half Sales, Tools, Power Tools. Save the workbook, close the workbook window, and then submit the workbook as directed. |
0.000 |
|
|
Total Points |
100.000 |
SKL ECH04 A2 – Tools 2.1
Project Description:
In this project, you will create an Excel table to sort and filter data at a hardware store. Use an IF function to determine if an inventory item is low and needs to be reordered.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel 2013, and then open the downloaded file skills_exl04_grader_a2.xlsx. |
0.000 |
|
2 |
On the First Half Sales worksheet, insert the NOW function in cell A13. |
7.000 |
|
3 |
On the First Half Sales worksheet, in the range H5:H8, insert a Column Sparkline for each row. |
10.000 |
|
4 |
On the Tools worksheet, in cell H5, enter an IF function that will display the word Order if the Total Inventory result is less than the Order Point value in the same row. Otherwise, the function will return the text No. Center the results in cell H5, and then AutoFill the function down through cell H38 |
11.000 |
|
5 |
On the Tools worksheet, select the range F5:F38, and apply a Solid Fill Blue Data Bar conditional format. |
9.000 |
|
6 |
On the Tools worksheet, format the data in the range A4:H38 as an Excel table with headers using Table Style Light 2. |
10.000 |
|
7 |
Create a copy of the Tools worksheet and move it to the end of the workbook. Rename the copied worksheet tab as Power Tools. |
8.000 |
|
8 |
On the Power Tools worksheet, sort the Order Point column from the largest to the smallest value. |
7.000 |
|
9 |
On the Power Tools worksheet, filter the Excel table to display only the category Power Tool. |
7.000 |
|
10 |
On the Power Tools worksheet, show the Total row. Display the sum of column F in the Total row. |
7.000 |
|
11 |
On the Power Tools worksheet, hide column B. |
7.000 |
|
12 |
Group the worksheets. Change the page orientation to print Landscape. |
7.000 |
|
13 |
On the Tools worksheet, change the Page Setup to repeat the titles in rows 1:4. Change the Width scale to fit on one page. |
10.000 |
|
14 |
Ensure that the worksheets are correctly named and placed in the following order in the workbook: First Half Sales, Tools, Power Tools. Save the workbook, close the workbook window, and then submit the workbook as directed. |
0.000 |
|
|
Total Points |
100.000 |
SKL ECH04 A2 – Tools 2.1
Project Description:
In this project, you will create an Excel table to sort and filter data at a hardware store. Use an IF function to determine if an inventory item is low and needs to be reordered.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel 2013, and then open the downloaded file skills_exl04_grader_a2.xlsx. |
0.000 |
|
2 |
On the First Half Sales worksheet, insert the NOW function in cell A13. |
7.000 |
|
3 |
On the First Half Sales worksheet, in the range H5:H8, insert a Column Sparkline for each row. |
10.000 |
|
4 |
On the Tools worksheet, in cell H5, enter an IF function that will display the word Order if the Total Inventory result is less than the Order Point value in the same row. Otherwise, the function will return the text No. Center the results in cell H5, and then AutoFill the function down through cell H38 |
11.000 |
|
5 |
On the Tools worksheet, select the range F5:F38, and apply a Solid Fill Blue Data Bar conditional format. |
9.000 |
|
6 |
On the Tools worksheet, format the data in the range A4:H38 as an Excel table with headers using Table Style Light 2. |
10.000 |
|
7 |
Create a copy of the Tools worksheet and move it to the end of the workbook. Rename the copied worksheet tab as Power Tools. |
8.000 |
|
8 |
On the Power Tools worksheet, sort the Order Point column from the largest to the smallest value. |
7.000 |
|
9 |
On the Power Tools worksheet, filter the Excel table to display only the category Power Tool. |
7.000 |
|
10 |
On the Power Tools worksheet, show the Total row. Display the sum of column F in the Total row. |
7.000 |
|
11 |
On the Power Tools worksheet, hide column B. |
7.000 |
|
12 |
Group the worksheets. Change the page orientation to print Landscape. |
7.000 |
|
13 |
On the Tools worksheet, change the Page Setup to repeat the titles in rows 1:4. Change the Width scale to fit on one page. |
10.000 |
|
14 |
Ensure that the worksheets are correctly named and placed in the following order in the workbook: First Half Sales, Tools, Power Tools. Save the workbook, close the workbook window, and then submit the workbook as directed. |
0.000 |
|
|
Total Points |
100.000 |
SKL ECH04 A2 – Tools 2.1
SKL ECH04 A2 – Tools 2.1SKL ECH04 A2 – Tools 2.1SKL ECH04 A2 – Tools 2.1
Project Description:
Project Description: Project Description: Project Description:
In this project, you will create an Excel table to sort and filter data at a hardware store. Use an IF function to determine if an inventory item is low and needs to be reordered.
In this project, you will create an Excel table to sort and filter data at a hardware store. Use an IF function to determine if an inventory item is low and needs to be reordered.In this project, you will create an Excel table to sort and filter data at a hardware store. Use an IF function to determine if an inventory item is low and needs to be reordered.In this project, you will create an Excel table to sort and filter data at a hardware store. Use an IF function to determine if an inventory item is low and needs to be reordered.
Instructions:
Instructions: Instructions: Instructions:
For the purpose of grading the project you are required to perform the following tasks:
For the purpose of grading the project you are required to perform the following tasks:
|
Step |
Instructions |
Points Possible |
|
1 |
Start Excel 2013, and then open the downloaded file skills_exl04_grader_a2.xlsx. |
0.000 |
|
2 |
On the First Half Sales worksheet, insert the NOW function in cell A13. |
7.000 |
|
3 |
On the First Half Sales worksheet, in the range H5:H8, insert a Column Sparkline for each row. |
10.000 |
|
4 |
On the Tools worksheet, in cell H5, enter an IF function that will display the word Order if the Total Inventory result is less than the Order Point value in the same row. Otherwise, the function will return the text No. Center the results in cell H5, and then AutoFill the function down through cell H38 |
11.000 |
|
5 |
On the Tools worksheet, select the range F5:F38, and apply a Solid Fill Blue Data Bar conditional format. |
9.000 |
|
6 |
On the Tools worksheet, format the data in the range A4:H38 as an Excel table with headers using Table Style Light 2. |
10.000 |
|
7 |
Create a copy of the Tools worksheet and move it to the end of the workbook. Rename the copied worksheet tab as Power Tools. |
8.000 |
|
8 |
On the Power Tools worksheet, sort the Order Point column from the largest to the smallest value. |
7.000 |
|
9 |
On the Power Tools worksheet, filter the Excel table to display only the category Power Tool. |
7.000 |
|
10 |
On the Power Tools worksheet, show the Total row. Display the sum of column F in the Total row. |
7.000 |
|
11 |
On the Power Tools worksheet, hide column B. |
7.000 |
|
12 |
Group the worksheets. Change the page orientation to print Landscape. |
7.000 |
|
13 |
On the Tools worksheet, change the Page Setup to repeat the titles in rows 1:4. Change the Width scale to fit on one page. |
10.000 |
|
14 |
Ensure that the worksheets are correctly named and placed in the following order in the workbook: First Half Sales, Tools, Power Tools. Save the workbook, close the workbook window, and then submit the workbook as directed. |
0.000 |
|
|
Total Points |
100.000 |
Step
Instructions
Points Possible
Step
Instructions
Points Possible
Step
Step
StepStepStep
Instructions
Instructions
InstructionsInstructionsInstructions
Points Possible
Points Possible
Points PossiblePoints PossiblePoints Possible
1
Start Excel 2013, and then open the downloaded file skills_exl04_grader_a2.xlsx.
0.000
2
On the First Half Sales worksheet, insert the NOW function in cell A13.
7.000
3
On the First Half Sales worksheet, in the range H5:H8, insert a Column Sparkline for each row.
10.000
4
On the Tools worksheet, in cell H5, enter an IF function that will display the word Order if the Total Inventory result is less than the Order Point value in the same row. Otherwise, the function will return the text No. Center the results in cell H5, and then AutoFill the function down through cell H38
11.000
5
On the Tools worksheet, select the range F5:F38, and apply a Solid Fill Blue Data Bar conditional format.
9.000
6
On the Tools worksheet, format the data in the range A4:H38 as an Excel table with headers using Table Style Light 2.
10.000
7
Create a copy of the Tools worksheet and move it to the end of the workbook. Rename the copied worksheet tab as Power Tools.
8.000
8
On the Power Tools worksheet, sort the Order Point column from the largest to the smallest value.
7.000
9
On the Power Tools worksheet, filter the Excel table to display only the category Power Tool.
7.000
10
On the Power Tools worksheet, show the Total row. Display the sum of column F in the Total row.
7.000
11
On the Power Tools worksheet, hide column B.
7.000
12
Group the worksheets. Change the page orientation to print Landscape.
7.000
13
On the Tools worksheet, change the Page Setup to repeat the titles in rows 1:4. Change the Width scale to fit on one page.
10.000
14
Ensure that the worksheets are correctly named and placed in the following order in the workbook: First Half Sales, Tools, Power Tools. Save the workbook, close the workbook window, and then submit the workbook as directed.
0.000
Total Points
100.000
1
Start Excel 2013, and then open the downloaded file skills_exl04_grader_a2.xlsx.
0.000
1
1
111
Start Excel 2013, and then open the downloaded file skills_exl04_grader_a2.xlsx.
Start Excel 2013, and then open the downloaded file skills_exl04_grader_a2.xlsx.
Start Excel 2013, and then open the downloaded file skills_exl04_grader_a2.xlsx. skills_exl04_grader_a2.xlsx.
0.000
0.000
0.000
2
On the First Half Sales worksheet, insert the NOW function in cell A13.
7.000
2
2
222
On the First Half Sales worksheet, insert the NOW function in cell A13.
On the First Half Sales worksheet, insert the NOW function in cell A13.
On the First Half Sales worksheet, insert the NOW function in cell A13.
7.000
7.000
7.000
3
On the First Half Sales worksheet, in the range H5:H8, insert a Column Sparkline for each row.
10.000
3
3
333
On the First Half Sales worksheet, in the range H5:H8, insert a Column Sparkline for each row.
On the First Half Sales worksheet, in the range H5:H8, insert a Column Sparkline for each row.
On the First Half Sales worksheet, in the range H5:H8, insert a Column Sparkline for each row.
10.000
10.000
10.000
4
On the Tools worksheet, in cell H5, enter an IF function that will display the word Order if the Total Inventory result is less than the Order Point value in the same row. Otherwise, the function will return the text No. Center the results in cell H5, and then AutoFill the function down through cell H38
11.000
4
4
444
On the Tools worksheet, in cell H5, enter an IF function that will display the word Order if the Total Inventory result is less than the Order Point value in the same row. Otherwise, the function will return the text No. Center the results in cell H5, and then AutoFill the function down through cell H38
On the Tools worksheet, in cell H5, enter an IF function that will display the word Order if the Total Inventory result is less than the Order Point value in the same row. Otherwise, the function will return the text No. Center the results in cell H5, and then AutoFill the function down through cell H38
On the Tools worksheet, in cell H5, enter an IF function that will display the word Order if the Total Inventory result is less than the Order Point value in the same row. Otherwise, the function will return the text No. Center the results in cell H5, and then AutoFill the function down through cell H38OrderTotal InventoryOrder Point.No
11.000
11.000
11.000
5
On the Tools worksheet, select the range F5:F38, and apply a Solid Fill Blue Data Bar conditional format.
9.000
5
5
555
On the Tools worksheet, select the range F5:F38, and apply a Solid Fill Blue Data Bar conditional format.
On the Tools worksheet, select the range F5:F38, and apply a Solid Fill Blue Data Bar conditional format.
On the Tools worksheet, select the range F5:F38, and apply a Solid Fill Blue Data Bar conditional format..
9.000
9.000
9.000
6
On the Tools worksheet, format the data in the range A4:H38 as an Excel table with headers using Table Style Light 2.
10.000
6
6
666
On the Tools worksheet, format the data in the range A4:H38 as an Excel table with headers using Table Style Light 2.
On the Tools worksheet, format the data in the range A4:H38 as an Excel table with headers using Table Style Light 2.
On the Tools worksheet, format the data in the range A4:H38 as an Excel table with headers using Table Style Light 2.
10.000
10.000
10.000
7
Create a copy of the Tools worksheet and move it to the end of the workbook. Rename the copied worksheet tab as Power Tools.
8.000
7
7
777
Create a copy of the Tools worksheet and move it to the end of the workbook. Rename the copied worksheet tab as Power Tools.
Create a copy of the Tools worksheet and move it to the end of the workbook. Rename the copied worksheet tab as Power Tools.
Create a copy of the Tools worksheet and move it to the end of the workbook. Rename the copied worksheet tab as Power Tools.Power Tools
8.000
8.000
8.000
8
On the Power Tools worksheet, sort the Order Point column from the largest to the smallest value.
7.000
8
8
888
On the Power Tools worksheet, sort the Order Point column from the largest to the smallest value.
On the Power Tools worksheet, sort the Order Point column from the largest to the smallest value.
On the Power Tools worksheet, sort the Order Point column from the largest to the smallest value.Order Point
7.000
7.000
7.000
9
On the Power Tools worksheet, filter the Excel table to display only the category Power Tool.
7.000
9
9
999
On the Power Tools worksheet, filter the Excel table to display only the category Power Tool.
On the Power Tools worksheet, filter the Excel table to display only the category Power Tool.
On the Power Tools worksheet, filter the Excel table to display only the category Power Tool.Power Tool
7.000
7.000
7.000
10
On the Power Tools worksheet, show the Total row. Display the sum of column F in the Total row.
7.000
10
10
101010
On the Power Tools worksheet, show the Total row. Display the sum of column F in the Total row.
On the Power Tools worksheet, show the Total row. Display the sum of column F in the Total row.
On the Power Tools worksheet, show the Total row. Display the sum of column F in the Total row.
7.000
7.000
7.000
11
On the Power Tools worksheet, hide column B.
7.000
11
11
111111
On the Power Tools worksheet, hide column B.
On the Power Tools worksheet, hide column B.
On the Power Tools worksheet, hide column B.
7.000
7.000
7.000
12
Group the worksheets. Change the page orientation to print Landscape.
7.000
12
12
121212
Group the worksheets. Change the page orientation to print Landscape.
Group the worksheets. Change the page orientation to print Landscape.
Group the worksheets. Change the page orientation to print Landscape.
7.000
7.000
7.000
13
On the Tools worksheet, change the Page Setup to repeat the titles in rows 1:4. Change the Width scale to fit on one page.
10.000
13
13
131313
On the Tools worksheet, change the Page Setup to repeat the titles in rows 1:4. Change the Width scale to fit on one page.
On the Tools worksheet, change the Page Setup to repeat the titles in rows 1:4. Change the Width scale to fit on one page.
On the Tools worksheet, change the Page Setup to repeat the titles in rows 1:4. Change the Width scale to fit on one page.
10.000
10.000
10.000
14
Ensure that the worksheets are correctly named and placed in the following order in the workbook: First Half Sales, Tools, Power Tools. Save the workbook, close the workbook window, and then submit the workbook as directed.
0.000
14
14
141414
Ensure that the worksheets are correctly named and placed in the following order in the workbook: First Half Sales, Tools, Power Tools. Save the workbook, close the workbook window, and then submit the workbook as directed.
Ensure that the worksheets are correctly named and placed in the following order in the workbook: First Half Sales, Tools, Power Tools. Save the workbook, close the workbook window, and then submit the workbook as directed.
Ensure that the worksheets are correctly named and placed in the following order in the workbook: First Half Sales, Tools, Power Tools. Save the workbook, close the workbook window, and then submit the workbook as directed.
0.000
0.000
0.000
Total Points
100.000
Total Points
Total Points
Total PointsTotal PointsTotal Points
100.000
100.000
100.000100.000100.000
