{"id":66835,"date":"2022-05-30T14:38:52","date_gmt":"2022-05-30T14:38:52","guid":{"rendered":"https:\/\/assignmenttutors.net\/blog\/excel-chapter-4-grader-project-assessment-1\/"},"modified":"2022-05-30T14:38:52","modified_gmt":"2022-05-30T14:38:52","slug":"excel-chapter-4-grader-project-assessment-1","status":"publish","type":"post","link":"https:\/\/assignmenttutors.net\/blog\/excel-chapter-4-grader-project-assessment-1\/","title":{"rendered":"Excel chapter 4 grader* project [assessment 1]"},"content":{"rendered":"
\n\n\n

1<\/span><\/strong><\/p>\n<\/td>\n\n

Start Excel. Open the downloaded Excel file named exploring_e04_grader_a1.xlsx<\/em>.<\/span><\/p>\n<\/td>\n\n

0<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

2<\/span><\/strong><\/p>\n<\/td>\n\n

In the Dining Out worksheet, convert the data to a table. Apply Table Style Light 14.<\/span><\/p>\n<\/td>\n\n

10<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

3<\/span><\/strong><\/p>\n<\/td>\n\n

Remove duplicate rows in the Dining Out worksheet.<\/span><\/p>\n<\/td>\n\n

5<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

4<\/span><\/strong><\/p>\n<\/td>\n\n

Sort the table by Description in alphabetical order, then by Store in alphabetical order, and then by Amount from the smallest to the largest.<\/span><\/p>\n<\/td>\n\n

10<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

5<\/span><\/strong><\/p>\n<\/td>\n\n

Filter the records using the check box filters to show personal (i.e., non-business) lunch and dinner expenses.<\/span><\/p>\n<\/td>\n\n

10<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

6<\/span><\/strong><\/p>\n<\/td>\n\n

Display the Total Row. In cell D48, select the function to total the Amount values. In cell E48, do not show a total.<\/span><\/p>\n<\/td>\n\n

10<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

7<\/span><\/strong><\/p>\n<\/td>\n\n

In the June Expenses worksheet, apply the conditional formatting style that displays a Green Data Bar Gradient Fill in the range D2:D47.<\/span><\/p>\n<\/td>\n\n

5<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

8<\/span><\/strong><\/p>\n<\/td>\n\n

Create a conditional formatting rule with these specifications to the range A2:C47:
<\/span>\u2022<\/span> Formula to determine which cells to format
<\/span>\u2022<\/span> Formula:\u00a0 <\/span>=(AND(argument1,argument2))<\/span><\/strong> where argument1 compares $D2 to see if it is greater than or equal to 100<\/span><\/strong> and argument 2 compares $E2 to see if the text is “Yes”<\/span><\/strong>.
<\/span>\u2022<\/span>Light Green (Standard) fill color
<\/span>\u2022<\/span> Green border color
<\/span>\u2022<\/span> Outline preset border style<\/span><\/p>\n<\/td>\n\n

10<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

9<\/span><\/strong><\/p>\n<\/td>\n\n

Create a conditional formatting rule with these specifications to the range A2:C47:
<\/span>\u2022<\/span> Formula to determine which cells to format
<\/span>\u2022<\/span> Formula:\u00a0 <\/span>=(AND(argument1,argument2)) <\/span><\/strong>where argument1 compares $D2 to see if it is less than 100<\/span><\/strong> and argument 2 compares $E2 to see if the text is “Yes”<\/span><\/strong>.
<\/span>\u2022<\/span>Orange (Standard) fill color
<\/span>\u2022<\/span> Green border color
<\/span>\u2022<\/span> Outline preset border style<\/span><\/p>\n<\/td>\n\n

10<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

10<\/span><\/strong><\/p>\n<\/td>\n\n

Create a custom color sort for the Description column with these specifications:
<\/span>\u2022<\/span> Sort on cell color to display the Light Green (Standard) fill color on Top as the primary sort.
<\/span>\u2022<\/span> Sort on cell color to display the Orange (Standard) fill color on Top as the secondary sort.<\/span><\/p>\n<\/td>\n\n

10<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

11<\/span><\/strong><\/p>\n<\/td>\n\n

Freeze the top row.<\/span><\/p>\n<\/td>\n\n

5<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

12<\/span><\/strong><\/p>\n<\/td>\n\n

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.<\/span><\/p>\n<\/td>\n\n

5<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

13<\/span><\/strong><\/p>\n<\/td>\n\n

Repeat the titles on row 1 on all pages.<\/span><\/p>\n<\/td>\n\n

5<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

14<\/span><\/strong><\/p>\n<\/td>\n\n

Insert a custom footer with the text Exploring Series<\/span><\/strong> 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.<\/span><\/p>\n<\/td>\n\n

5<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

15<\/span><\/strong><\/p>\n<\/td>\n\n

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Dining Out<\/em>, June Expenses<\/em>. Save the workbook. Close the workbook, and then exit Excel. Submit the workbook as directed.<\/span><\/p>\n<\/td>\n\n

0<\/span><\/p>\n<\/td>\n<\/tr>\n\n\n

\u00a0<\/span><\/p>\n<\/td>\n\n

Total Points<\/span><\/strong><\/p>\n<\/td>\n\n

100<\/span><\/span><\/strong><\/p>\n<\/td>\n<\/tr>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

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 […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-66835","post","type-post","status-publish","format-standard","hentry","category-education"],"_links":{"self":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/66835","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/comments?post=66835"}],"version-history":[{"count":0,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/posts\/66835\/revisions"}],"wp:attachment":[{"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/media?parent=66835"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/categories?post=66835"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/assignmenttutors.net\/blog\/wp-json\/wp\/v2\/tags?post=66835"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}