Office 2013 - myitlab:grader - Instructions Exploring Access Chapter 4: Assessment Project 1 National Farm and Agriculture Conference Project Description: You are helping a small nonprofit group organize their national farm and agriculture conference. You have been tasked with creating a form to organize input, a report to display the finalized schedule, and mailing labels. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Points Possible Instructions 1 Start Access. Open the file named exploring_a04_grader_a1.accdb. Save the database as exploring_a04_grader_a1_LastFirst. 0 2 Create a form using the Form tool based on the Presenters table. Change the title of the form to Enter/Edit Presenters. 10 3 Reduce the field widths to approximately half their original size. Delete the subform. 5 4 Sort the records by LastName in Ascending order. Save the form as Edit Presenters. Close the form. 5 5 Open the Location Information form in Layout View. Apply the Stacked Layout to the form. Save and close the form. 10 6 Create a new report based on the Exhibits with Presenters query using the Report Wizard. Select all available fields, choose to view the data by Presenters, ensure the FirstName, LastName is the only grouping level, use Date as the primary sort field, in Ascending order, accept the default Stepped option, and change the layout to Landscape. Save the report as Presenter Schedule. 20 7 Apply the Integral theme to this report only. Save the report. 10 8 Modify the Presenter Schedule report so that the StartingTime field from the Exhibits table is added as the last field (appearing to the right of LocationID). 10 9 Change the title of the Presenter Schedule report to Schedule by Presenter. 5 Updated: 03/18/2013 1 A_CH04_EXPV1_A1_Instructions.docx Step 10 Points Possible Instructions Change the sort so the StartingTime is a secondary sort field (that is, so that the first sort is Date, and the second sort is StartingTime). Save and close the report. 5 Create a new labels report based on the Presenters table. Use the Avery USA 8660 label template. Accept the default font options, and set the labels up so the first and last name appear on the top line, the Address on the second line, and the City, State, and ZipCode appear on the final line. Your first label should look like: 11 20 Shannon Beck 368 Graham Avenue Graham, KY 42344 Do not add any sorting. Name the report Presenter Mailing Labels. Close the labels. 12 Close the database, and submit based on your instructor's directions. 0 Total Points 100 Office 2013 - myitlab:grader - Instructions Exploring Excel Chapter 4: Assessment Project 1 Credit Card Expenses Project Description: You started recording every credit card transaction so that you can analyze your monthly expenses. You used an Excel worksheet to track dates, places, categories, and amounts. Because you are a consultant who travels periodically, you also have business expenses. You included a column to indicate the businessrelated transactions. Now you need to convert the data to a table, sort and filter the data to analyze it, and apply conditional formatting to apply a visual effect for further analysis. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Points Possible Instructions 1 Start Excel. Open the downloaded Excel file named exploring_e04_grader_a1.xlsx. 0 2 In the Dining Out worksheet, convert the data to a table. Apply Table Style Light 14. 10 3 Remove duplicate rows in the Dining Out worksheet. 5 4 Sort the table by Description in alphabetical order, then by Store in alphabetical order, and then by Amount from the smallest to the largest. 10 5 Filter the records to show personal (i.e., nonbusiness) lunch and dinner expenses. 10 6 Display the Total Row. In cell D48, select the function to total the Amount values. In cell E48, do not show a total. 10 7 In the June Expenses worksheet, apply the conditional formatting style that displays a Green Data Bar Gradient Fill in the range D2:D47. 5 8 Create a conditional formatting rule with these specifications to the range A2:C47: Formula to determine which cells to format Formula: =(AND(argument1,argument2)) where argument1 compares $D2 to see if it is greater than or equal to 100 and argument 2 compares $E2 to see if the text is "Yes". Medium Green fill color (7th color on the 4th row) Green border color Outline preset border style 10 Updated: 04/04/2013 1 E_CH04_EXPV1_A1_Instructions.docx Office 2013 - myitlab:grader - Instructions Step Exploring Excel Chapter 4: Assessment Project 1 Points Possible Instructions 9 Create a conditional formatting rule with these specifications to the range A2:C47: Formula to determine which cells to format Formula: =(AND(argument1,argument2)) where argument1 compares $D2 to see if it is less than 100 and argument 2 compares $E2 to see if the text is "Yes". Light Green fill color (7th color on the 2nd row) Green border color Outline preset border style 10 10 Create a custom color sort for the Description column with these specifications: Sort on cell color to display the Medium Green fill color on Top as the primary sort. Sort on cell color to display the Light Green fill color on Top as the secondary sort. 10 11 Freeze the top row. 5 12 Set the Scale to Fit percentage to 115%. Display the worksheet in Page Break Preview and insert a page break so that row 36 starts on a new page. 5 13 Repeat the titles on row 1 on all pages. 5 14 Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side of the June Expenses worksheet. 5 15 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Dining Out, June Expenses. Save the workbook. Close the workbook, and then exit Excel. Submit the workbook as directed. 0 Total Points Updated: 04/04/2013 2 100 E_CH04_EXPV1_A1_Instructions.docx Date Store 6/1/2016 Barnes & Noble 6/1/2016 Wendy's 6/2/2016 United 6/2/2016 Applebee's 6/3/2016 Marriott 6/3/2016 Subway 6/4/2016 Costco 6/4/2016 Costco 6/4/2016 Costco 6/5/2016 Theater 6/6/2016 Amazon.com 6/6/2016 PC Connection 6/6/2016 Hallmark 6/8/2016 Wendy's 6/8/2016 Wendy's 6/9/2016 Dillard's 6/9/2016 Subway 6/12/2016 Chili's 6/12/2016 Theater 6/12/2016 Theater 6/12/2016 Sam's Club 6/13/2016 Costco 6/14/2016 Delta 6/14/2016 Delta 6/14/2016 Texas Roadhouse 6/15/2016 Applebee's 6/15/2016 Hampton Inn 6/15/2016 McGrath's 6/16/2016 Delta 6/18/2016 Sam's Club 6/18/2016 Sam's Club 6/18/2016 Costco 6/19/2016 Costco 6/20/2016 McDonald's 6/20/2016 McDonald's 6/22/2016 Dillard's 6/22/2016 Hallmark 6/22/2016 Subway 6/22/2016 Wendy's 6/22/2016 Wendy's 6/24/2016 Costco 6/25/2016 American 6/25/2016 American 6/25/2016 Texas Roadhouse 6/26/2016 Hampton Inn 6/26/2016 Applebee's 6/27/2016 Tucano's 6/27/2016 Sam's Club 6/27/2016 Red Robin 6/28/2016 Amazon.com 6/30/2016 Theater 6/30/2016 Subway Description Books Lunch Airline Ticket Dinner Hotel Lunch Gas Gas Groceries Entertainment Books Computer Equipment Gifts Lunch Lunch Clothes Lunch Dinner Entertainment Entertainment Gas Groceries Airline Ticket Baggage Dinner Dinner Hotel Lunch Baggage Books Gas Groceries Computer Equipment Lunch Lunch Gifts Gifts Lunch Lunch Lunch Gas Airline Ticket Airline Ticket Dinner Hotel Lunch Dinner Groceries Lunch Books Entertainment Lunch Amount $24.95 $10.76 $385.16 $30.15 $214.80 $7.50 $23.45 $23.45 $100.33 $20.00 $26.55 $250.85 $25.38 $7.45 $7.45 $155.65 $7.50 $18.61 $20.00 $20.00 $22.85 $114.44 $385.00 $25.00 $34.18 $14.12 $95.85 $16.44 $15.00 $18.44 $24.11 $120.44 $885.12 $5.65 $5.65 $54.42 $12.18 $6.40 $7.65 $7.65 $26.18 $400.15 $400.15 $36.14 $112.44 $15.81 $30.14 $85.67 $14.42 $22.15 $20.00 $6.40 Business Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Date Store 6/1/2016 Barnes & Noble 6/1/2016 Wendy's 6/2/2016 United 6/2/2016 Applebee's 6/3/2016 Marriott 6/3/2016 Subway 6/4/2016 Costco 6/4/2016 Costco 6/5/2016 Theater 6/6/2016 PC Connection 6/6/2016 Amazon.com 6/6/2016 Hallmark 6/8/2016 Wendy's 6/9/2016 Dillard's 6/9/2016 Subway 6/12/2016 Chili's 6/12/2016 Theater 6/12/2016 Sam's Club 6/13/2016 Costco 6/14/2016 Delta 6/14/2016 Delta 6/14/2016 Texas Roadhouse 6/15/2016 Applebee's 6/15/2016 Hampton Inn 6/15/2016 McGrath's 6/16/2016 Delta 6/18/2016 Sam's Club 6/18/2016 Sam's Club 6/18/2016 Costco 6/19/2016 Costco 6/20/2016 McDonald's 6/22/2016 Dillard's 6/22/2016 Hallmark 6/22/2016 Subway 6/22/2016 Wendy's 6/24/2016 Costco 6/25/2016 American 6/25/2016 Texas Roadhouse 6/26/2016 Hampton Inn 6/26/2016 Applebee's 6/27/2016 Tucano's 6/27/2016 Sam's Club 6/27/2016 Red Robin 6/28/2016 Amazon.com 6/30/2016 Theater 6/30/2016 Subway Total Description Books Lunch Airline Ticket Dinner Hotel Lunch Gas Groceries Entertainment Computer Equipment Books Gifts Lunch Clothes Lunch Dinner Entertainment Gas Groceries Airline Ticket Baggage Dinner Dinner Hotel Lunch Baggage Books Gas Groceries Computer Equipment Lunch Gifts Gifts Lunch Lunch Gas Airline Ticket Dinner Hotel Lunch Dinner Groceries Lunch Books Entertainment Lunch Amount $24.95 $10.76 $385.16 $30.15 $214.80 $7.50 $23.45 $100.33 $20.00 $250.85 $26.55 $25.38 $7.45 $155.65 $7.50 $18.61 $20.00 $22.85 $114.44 $385.00 $25.00 $34.18 $14.12 $95.85 $16.44 $15.00 $18.44 $24.11 $120.44 $885.12 $5.65 $54.42 $12.18 $6.40 $7.65 $26.18 $400.15 $36.14 $112.44 $15.81 $30.14 $85.67 $14.42 $22.15 $20.00 $6.40 Err:508 Business Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes Yes GradeIT Submission MarkUp This is a machine generated report of your submission document containing error details as annotations. Details of all points deducted in the submitted document are listed on this sheet. Assignment Details Submission ID 1933226600 Assignment Name Submission Date 23 April, 2015 Report Generated on 23 April, 2015 Points Obtained 3/100 (3%) Worksheet: 'Dining Out' (Points Deducted: 42.000) Points Deducted Details Error Description 12/30/1899 Missing: Row 17 This action did not result in any loss of points. 12/30/1899 Missing: Row 18 This action did not result in any loss of points. 12/30/1899 Missing: Cell D47 This action did not result in any loss of points. 1/2/1900 Missing: Cell D48 3.000 point(s) deducted in instruction #6: In cell D48, the function was not selected to total the Amount values. 2/7/1900 Missing: Table(s) 10.000 point(s) deducted in instruction #2: In the Dining Out worksheet, the data was not converted to a table. In the table with name 'Table2' the 'Range Reference' was not set to 'A1:E48'. Table Style Light 14 was not applied. 5.000 point(s) deducted in instruction #3: Duplicate rows in the Dining Out worksheet were not removed. 10.000 point(s) deducted in instruction #4: The table was not sorted by Description in alphabetical order. The table was not sorted by Store in alphabetical order. The table was not sorted by Amount from the smallest to the largest. 10.000 point(s) deducted in instruction #5: The records were not filtered to show personal (i.e., nonbusiness) lunch and dinner expenses. 4.000 point(s) deducted in instruction #6: The Total Row was not displayed. 12/30/1899 Extra: Row 31 This action did not result in any loss of points. 12/30/1899 Extra: Row 32 This action did not result in any loss of points. 12/30/1899 Extra: Row 33 This action did not result in any loss of points. 12/30/1899 Extra: Row 34 This action did not result in any loss of points. 12/30/1899 Extra: Header(s)/Footer(s) This action did not result in any loss of points. 12/30/1899 Extra: Data This action did not result in any loss of points. 12/30/1899 Extra: Sort This action did not result in any loss of points. 12/30/1899 Extra: Conditional Format(s) This action did not result in any loss of points. 12/30/1899 Extra: Named Ranges(s) This action did not result in any loss of points. Worksheet: 'June Expenses' (Points Deducted: 55.000) Points Deducted 1/9/1900 Details Error Description Incorrect Actions: Sheet (June Expenses) 5.000 point(s) deducted in instruction #11: The top row was not frozen. 5.000 point(s) deducted in instruction #12: A page break was not inserted so that row 36 starts on a new page. In this sheet, the 'Scaling of Page' was not set to '115'. 1/4/1900 Missing: Header(s)/Footer(s) 5.000 point(s) deducted in instruction #14: A footer with the text Exploring Series was not inserted on the left side. A footer with the sheet name code in the center was not inserted. A footer with the file name code on the right side of the June Expenses worksheet was not inserted. 12/30/1899 Missing: Row 4 This action did not result in any loss of points. 12/30/1899 Missing: Row 8 This action did not result in any loss of points. 12/30/1899 Missing: Row 9 This action did not result in any loss of points. 12/30/1899 Missing: Row 11 This action did not result in any loss of points. 12/30/1899 Missing: Row 12 This action did not result in any loss of points. 12/30/1899 Missing: Row 13 This action did not result in any loss of points. 12/30/1899 Missing: Row 14 This action did not result in any loss of points. 12/30/1899 Missing: Row 15 This action did not result in any loss of points. 12/30/1899 Missing: Row 16 This action did not result in any loss of points. 12/30/1899 Missing: Row 17 This action did not result in any loss of points. 12/30/1899 Missing: Row 18 This action did not result in any loss of points. 12/30/1899 Missing: Row 19 This action did not result in any loss of points. 12/30/1899 Missing: Row 20 This action did not result in any loss of points. 1/9/1900 Incorrect Actions: Table(s) 10.000 point(s) deducted in instruction #10: Sort on cell color was not applied on Top as the secondary sort. Light Green fill color was not applied on Top as the secondary sort. Sort on cell color was not applied on Top as the primary sort. Medium Green fill color was not applied on Top as the primary sort. 1/24/1900 Missing: Conditional Format(s) 5.000 point(s) deducted in instruction #7: In the Conditional Format, the 'Conditional Format Range' was not set to 'D2:D47'. In the June Expenses worksheet, the conditional formatting 'type' was not set to 'Data Bar'. In the June Expenses worksheet, the conditional formatting 'color' was not set to 'Green'. In the June Expenses worksheet, the conditional formatting gradient was not applied. 10.000 point(s) deducted in instruction #8: In the Conditional Format, the 'Conditional Format Range' was not set to 'A2:C47'. A conditional formatting rule was not created with Medium Green fill color. A conditional formatting rule was not created with Outline preset Border type. A conditional formatting rule was not created with Green Border color. In the Conditional Format, the 'Conditional Formatting Formula(e)' was not set to '(AND($D2>=100,$E2="Yes"))'. 10.000 point(s) deducted in instruction #9: In the Conditional Format, the 'Conditional Format Range' was not set to 'A2:C47'. A conditional formatting rule was not created with Light Green fill color. A conditional formatting rule was not created with Outline preset Border Type. A conditional formatting rule was not created with Green Border color. In the Conditional Format, the 'Conditional Formatting Formula(e)' was not set to '(AND($D2<100,$E2="Yes"))'. 1/4/1900 Missing: Named Ranges(s) 5.000 point(s) deducted in instruction #13: The titles on row 1 on all pages were not repeated. 12/30/1899 Extra: Row 11 This action did not result in any loss of points. 12/30/1899 Extra: Row 21 This action did not result in any loss of points. 12/30/1899 Extra: Row 22 This action did not result in any loss of points. 12/30/1899 Extra: Row 23 This action did not result in any loss of points. 12/30/1899 Extra: Row 24 This action did not result in any loss of points. 12/30/1899 Extra: Row 25 This action did not result in any loss of points. 12/30/1899 Extra: Row 26 This action did not result in any loss of points. 12/30/1899 Extra: Row 27 This action did not result in any loss of points. 12/30/1899 Extra: Row 31 This action did not result in any loss of points. 12/30/1899 Extra: Row 38 This action did not result in any loss of points. 12/30/1899 Extra: Row 39 This action did not result in any loss of points. 12/30/1899 Extra: Row 40 This action did not result in any loss of points. 12/30/1899 Extra: Row 41 This action did not result in any loss of points. Dining Out, June Expenses. Date Store 6/20/2016 McDonald's 6/30/2016 Subway 6/22/2016 Subway 6/8/2016 Wendy's 6/3/2016 Subway 6/9/2016 Subway 6/22/2016 Wendy's 6/1/2016 Wendy's 6/22/2016 Hallmark 6/15/2016 Applebee's 6/27/2016 Red Robin Description Lunch Lunch Lunch Lunch Lunch Lunch Lunch Lunch Gifts Dinner Lunch Amount $5.65 $6.40 $6.40 $7.45 $7.50 $7.50 $7.65 $10.76 $12.18 $14.12 $14.42 6/16/2016 Delta Baggage $15.00 6/26/2016 Applebee's Lunch $15.81 6/15/2016 McGrath's Lunch $16.44 6/18/2016 Sam's Club Books $18.44 6/12/2016 Chili's Dinner $18.61 6/5/2016 Theater Entertainment $20.00 6/12/2016 Theater Entertainment $20.00 6/30/2016 Theater Entertainment $20.00 6/28/2016 Amazon.comBooks $22.15 6/12/2016 Sam's Club Gas $22.85 6/4/2016 Costco Gas $23.45 6/18/2016 Sam's Club Gas $24.11 6/1/2016 Barnes & Noble Books $24.95 6/14/2016 Delta Baggage $25.00 6/6/2016 Hallmark Gifts $25.38 6/24/2016 Costco Gas $26.18 6/6/2016 Amazon.comBooks $26.55 6/27/2016 Tucano's Dinner $30.14 6/2/2016 Applebee's Dinner $30.15 6/14/2016 Texas Roadhouse Dinner $34.18 6/25/2016 Texas Roadhouse Dinner $36.14 6/22/2016 Dillard's Gifts $54.42 6/27/2016 Sam's Club Groceries $85.67 Date Store Description Amount 6/15/2016 Hampton InnHotel $95.85 6/4/2016 Costco Groceries $100.33 6/26/2016 Hampton InnHotel $112.44 6/13/2016 Costco Groceries $114.44 6/18/2016 Costco Groceries $120.44 6/9/2016 Dillard's Clothes $155.65 6/3/2016 Marriott Hotel $214.80 6/6/2016 PC Connection Computer Equipment $250.85 6/14/2016 Delta Airline Ticket $385.00 6/2/2016 United Airline Ticket $385.16 6/25/2016 American Airline Ticket $400.15 6/19/2016 Costco Computer Equipment $885.12 $3,955.88 Exploring Series Business Yes Yes Yes Yes Yes Yes Yes Yes Yes Business Yes Yes Yes Yes Yes Yes Yes Yes Date Store 6/1/2016 Barnes & Noble 6/1/2016 Wendy's 6/2/2016 United 6/2/2016 Applebee's 6/3/2016 Marriott 6/3/2016 Subway 6/4/2016 Costco 6/4/2016 Costco 6/5/2016 Theater 6/6/2016 PC Connection 6/6/2016 Amazon.com 6/6/2016 Hallmark 6/8/2016 Wendy's 6/9/2016 Dillard's 6/9/2016 Subway 6/12/2016 Chili's 6/12/2016 Theater 6/12/2016 Sam's Club 6/13/2016 Costco 6/14/2016 Delta 6/14/2016 Delta 6/14/2016 Texas Roadhouse 6/15/2016 Applebee's 6/15/2016 Hampton Inn 6/15/2016 McGrath's 6/16/2016 Delta 6/18/2016 Sam's Club 6/18/2016 Sam's Club 6/18/2016 Costco 6/19/2016 Costco 6/20/2016 McDonald's 6/22/2016 Dillard's 6/22/2016 Hallmark 6/22/2016 Subway 6/22/2016 Wendy's 6/24/2016 Costco 6/25/2016 American 6/25/2016 Texas Roadhouse 6/26/2016 Hampton Inn 6/26/2016 Applebee's 6/27/2016 Tucano's 6/27/2016 Sam's Club 6/27/2016 Red Robin 6/28/2016 Amazon.com 6/30/2016 Theater 6/30/2016 Subway Total Description Books Lunch Airline Ticket Dinner Hotel Lunch Gas Groceries Entertainment Computer Equipment Books Gifts Lunch Clothes Lunch Dinner Entertainment Gas Groceries Airline Ticket Baggage Dinner Dinner Hotel Lunch Baggage Books Gas Groceries Computer Equipment Lunch Gifts Gifts Lunch Lunch Gas Airline Ticket Dinner Hotel Lunch Dinner Groceries Lunch Books Entertainment Lunch Amount Business 24.95 10.76 385.16 Yes 30.15 Yes 214.8 Yes 7.5 Yes 23.45 100.33 20 250.85 Yes 26.55 25.38 7.45 155.65 7.5 18.61 20 22.85 114.44 385 Yes 25 Yes 34.18 Yes 14.12 Yes 95.85 Yes 16.44 Yes 15 Yes 18.44 24.11 120.44 885.12 Yes 5.65 54.42 12.18 6.4 7.65 26.18 400.15 Yes 36.14 Yes 112.44 Yes 15.81 Yes 30.14 85.67 14.42 22.15 20 6.4 #NAME? GradeIT Submission MarkUp This is a machine generated report of your submission document containing error details as annotations. Details of all points deducted in the submitted document are listed on this sheet. Assignment Details Submission ID 1933226600 Assignment Name Submission Date 23 April, 2015 Report Generated on 23 April, 2015 Points Obtained 3/100 (3%) Worksheet: 'Dining Out' (Points Deducted: 42.000) Points Deducted Details Error Description 12/30/1899 Missing: Row 17 This action did not result in any loss of points. 12/30/1899 Missing: Row 18 This action did not result in any loss of points. 12/30/1899 Missing: Cell D47 This action did not result in any loss of points. 1/2/1900 Missing: Cell D48 3.000 point(s) deducted in instruction #6: In cell D48, the function was not selected to total the Amount values. 2/7/1900 Missing: Table(s) 10.000 point(s) deducted in instruction #2: In the Dining Out worksheet, the data was not converted to a table. In the table with name 'Table2' the 'Range Reference' was not set to 'A1:E48'. Table Style Light 14 was not applied. 5.000 point(s) deducted in instruction #3: Duplicate rows in the Dining Out worksheet were not removed. 10.000 point(s) deducted in instruction #4: The table was not sorted by Description in alphabetical order. The table was not sorted by Store in alphabetical order. The table was not sorted by Amount from the smallest to the largest. 10.000 point(s) deducted in instruction #5: The records were not filtered to show personal (i.e., nonbusiness) lunch and dinner expenses. 4.000 point(s) deducted in instruction #6: The Total Row was not displayed. 12/30/1899 Extra: Row 31 This action did not result in any loss of points. 12/30/1899 Extra: Row 32 This action did not result in any loss of points. 12/30/1899 Extra: Row 33 This action did not result in any loss of points. 12/30/1899 Extra: Row 34 This action did not result in any loss of points. 12/30/1899 Extra: Header(s)/Footer(s) This action did not result in any loss of points. 12/30/1899 Extra: Data This action did not result in any loss of points. 12/30/1899 Extra: Sort This action did not result in any loss of points. 12/30/1899 Extra: Conditional Format(s) This action did not result in any loss of points. 12/30/1899 Extra: Named Ranges(s) This action did not result in any loss of points. Worksheet: 'June Expenses' (Points Deducted: 55.000) Points Deducted 1/9/1900 Details Error Description Incorrect Actions: Sheet (June Expenses) 5.000 point(s) deducted in instruction #11: The top row was not frozen. 5.000 point(s) deducted in instruction #12: A page break was not inserted so that row 36 starts on a new page. In this sheet, the 'Scaling of Page' was not set to '115'. 1/4/1900 Missing: Header(s)/Footer(s) 5.000 point(s) deducted in instruction #14: A footer with the text Exploring Series was not inserted on the left side. A footer with the sheet name code in the center was not inserted. A footer with the file name code on the right side of the June Expenses worksheet was not inserted. 12/30/1899 Missing: Row 4 This action did not result in any loss of points. 12/30/1899 Missing: Row 8 This action did not result in any loss of points. 12/30/1899 Missing: Row 9 This action did not result in any loss of points. 12/30/1899 Missing: Row 11 This action did not result in any loss of points. 12/30/1899 Missing: Row 12 This action did not result in any loss of points. 12/30/1899 Missing: Row 13 This action did not result in any loss of points. 12/30/1899 Missing: Row 14 This action did not result in any loss of points. 12/30/1899 Missing: Row 15 This action did not result in any loss of points. 12/30/1899 Missing: Row 16 This action did not result in any loss of points. 12/30/1899 Missing: Row 17 This action did not result in any loss of points. 12/30/1899 Missing: Row 18 This action did not result in any loss of points. 12/30/1899 Missing: Row 19 This action did not result in any loss of points. 12/30/1899 Missing: Row 20 This action did not result in any loss of points. 1/9/1900 Incorrect Actions: Table(s) 10.000 point(s) deducted in instruction #10: Sort on cell color was not applied on Top as the secondary sort. Light Green fill color was not applied on Top as the secondary sort. Sort on cell color was not applied on Top as the primary sort. Medium Green fill color was not applied on Top as the primary sort. 1/24/1900 Missing: Conditional Format(s) 5.000 point(s) deducted in instruction #7: In the Conditional Format, the 'Conditional Format Range' was not set to 'D2:D47'. In the June Expenses worksheet, the conditional formatting 'type' was not set to 'Data Bar'. In the June Expenses worksheet, the conditional formatting 'color' was not set to 'Green'. In the June Expenses worksheet, the conditional formatting gradient was not applied. 10.000 point(s) deducted in instruction #8: In the Conditional Format, the 'Conditional Format Range' was not set to 'A2:C47'. A conditional formatting rule was not created with Medium Green fill color. A conditional formatting rule was not created with Outline preset Border type. A conditional formatting rule was not created with Green Border color. In the Conditional Format, the 'Conditional Formatting Formula(e)' was not set to '(AND($D2>=100,$E2="Yes"))'. 10.000 point(s) deducted in instruction #9: In the Conditional Format, the 'Conditional Format Range' was not set to 'A2:C47'. A conditional formatting rule was not created with Light Green fill color. A conditional formatting rule was not created with Outline preset Border Type. A conditional formatting rule was not created with Green Border color. In the Conditional Format, the 'Conditional Formatting Formula(e)' was not set to '(AND($D2<100,$E2="Yes"))'. 1/4/1900 Missing: Named Ranges(s) 5.000 point(s) deducted in instruction #13: The titles on row 1 on all pages were not repeated. 12/30/1899 Extra: Row 11 This action did not result in any loss of points. 12/30/1899 Extra: Row 21 This action did not result in any loss of points. 12/30/1899 Extra: Row 22 This action did not result in any loss of points. 12/30/1899 Extra: Row 23 This action did not result in any loss of points. 12/30/1899 Extra: Row 24 This action did not result in any loss of points. 12/30/1899 Extra: Row 25 This action did not result in any loss of points. 12/30/1899 Extra: Row 26 This action did not result in any loss of points. 12/30/1899 Extra: Row 27 This action did not result in any loss of points. 12/30/1899 Extra: Row 31 This action did not result in any loss of points. 12/30/1899 Extra: Row 38 This action did not result in any loss of points. 12/30/1899 Extra: Row 39 This action did not result in any loss of points. 12/30/1899 Extra: Row 40 This action did not result in any loss of points. 12/30/1899 Extra: Row 41 This action did not result in any loss of points. Dining Out, June Expenses. Date Store 6/20/2016 McDonald's 6/30/2016 Subway 6/22/2016 Subway 6/8/2016 Wendy's 6/3/2016 Subway 6/9/2016 Subway 6/22/2016 Wendy's 6/1/2016 Wendy's 6/22/2016 Hallmark 6/15/2016 Applebee's 6/27/2016 Red Robin Description Lunch Lunch Lunch Lunch Lunch Lunch Lunch Lunch Gifts Dinner Lunch Amount $5.65 $6.40 $6.40 $7.45 $7.50 $7.50 $7.65 $10.76 $12.18 $14.12 $14.42 6/16/2016 Delta Baggage $15.00 6/26/2016 Applebee's Lunch $15.81 6/15/2016 McGrath's Lunch $16.44 6/18/2016 Sam's Club Books $18.44 6/12/2016 Chili's Dinner $18.61 6/5/2016 Theater Entertainment $20.00 6/12/2016 Theater Entertainment $20.00 6/30/2016 Theater Entertainment $20.00 6/28/2016 Amazon.comBooks $22.15 6/12/2016 Sam's Club Gas $22.85 6/4/2016 Costco Gas $23.45 6/18/2016 Sam's Club Gas $24.11 6/1/2016 Barnes & Noble Books $24.95 6/14/2016 Delta Baggage $25.00 6/6/2016 Hallmark Gifts $25.38 6/24/2016 Costco Gas $26.18 6/6/2016 Amazon.comBooks $26.55 6/27/2016 Tucano's Dinner $30.14 6/2/2016 Applebee's Dinner $30.15 6/14/2016 Texas Roadhouse Dinner $34.18 6/25/2016 Texas Roadhouse Dinner $36.14 6/22/2016 Dillard's Gifts $54.42 6/27/2016 Sam's Club Groceries $85.67 Date Store Description Amount 6/15/2016 Hampton InnHotel $95.85 6/4/2016 Costco Groceries $100.33 6/26/2016 Hampton InnHotel $112.44 6/13/2016 Costco Groceries $114.44 6/18/2016 Costco Groceries $120.44 6/9/2016 Dillard's Clothes $155.65 6/3/2016 Marriott Hotel $214.80 6/6/2016 PC Connection Computer Equipment $250.85 6/14/2016 Delta Airline Ticket $385.00 6/2/2016 United Airline Ticket $385.16 6/25/2016 American Airline Ticket $400.15 6/19/2016 Costco Computer Equipment $885.12 $3,955.88 Exploring Series Business Yes Yes Yes Yes Yes Yes Yes Yes Yes Business Yes Yes Yes Yes Yes Yes Yes Yes Date Store 6/1/2016 Barnes & Noble 6/1/2016 Wendy's 6/2/2016 United 6/2/2016 Applebee's 6/3/2016 Marriott 6/3/2016 Subway 6/4/2016 Costco 6/4/2016 Costco 6/5/2016 Theater 6/6/2016 PC Connection 6/6/2016 Amazon.com 6/6/2016 Hallmark 6/8/2016 Wendy's 6/9/2016 Dillard's 6/9/2016 Subway 6/12/2016 Chili's 6/12/2016 Theater 6/12/2016 Sam's Club 6/13/2016 Costco 6/14/2016 Delta 6/14/2016 Delta 6/14/2016 Texas Roadhouse 6/15/2016 Applebee's 6/15/2016 Hampton Inn 6/15/2016 McGrath's 6/16/2016 Delta 6/18/2016 Sam's Club 6/18/2016 Sam's Club 6/18/2016 Costco 6/19/2016 Costco 6/20/2016 McDonald's 6/22/2016 Dillard's 6/22/2016 Hallmark 6/22/2016 Subway 6/22/2016 Wendy's 6/24/2016 Costco 6/25/2016 American 6/25/2016 Texas Roadhouse 6/26/2016 Hampton Inn 6/26/2016 Applebee's 6/27/2016 Tucano's 6/27/2016 Sam's Club 6/27/2016 Red Robin 6/28/2016 Amazon.com 6/30/2016 Theater 6/30/2016 Subway Total Description Books Lunch Airline Ticket Dinner Hotel Lunch Gas Groceries Entertainment Computer Equipment Books Gifts Lunch Clothes Lunch Dinner Entertainment Gas Groceries Airline Ticket Baggage Dinner Dinner Hotel Lunch Baggage Books Gas Groceries Computer Equipment Lunch Gifts Gifts Lunch Lunch Gas Airline Ticket Dinner Hotel Lunch Dinner Groceries Lunch Books Entertainment Lunch Amount Business 24.95 10.76 385.16 Yes 30.15 Yes 214.8 Yes 7.5 Yes 23.45 100.33 20 250.85 Yes 26.55 25.38 7.45 155.65 7.5 18.61 20 22.85 114.44 385 Yes 25 Yes 34.18 Yes 14.12 Yes 95.85 Yes 16.44 Yes 15 Yes 18.44 24.11 120.44 885.12 Yes 5.65 54.42 12.18 6.4 7.65 26.18 400.15 Yes 36.14 Yes 112.44 Yes 15.81 Yes 30.14 85.67 14.42 22.15 20 6.4 #NAME