1

Start Excel. Open the downloaded Excel improve calld exploring_e04_grader_a1.xlsx.

0

2

In the Dining Out worksheet, alter the basis to a consultation. Integralot Consultation Mode Light 14.

10

3

Remove counterfeit enjoins in the Dining Out worksheet.

5

4

Condition the consultation by Description in alphabetical adjust, then by Store in alphabetical adjust, and then by Amount from the last to the largest.

10

5

Filter the records using the sextreme smack filters to illusion separate (i.e., non-business) lunch and dinner expenses.

10

6

Spread-out the Sum Enjoin. In cell D48, prime the exercise to sum the Amount values. In cell E48, do referable illusion a sum.

10

7

In the June Expenses worksheet, integralot the restricted cematting mode that spread-outs a Green Basis Bar Gradient Supply in the place D2:D47.

5

8

Create a restricted cematting government with these specifications to the place A2:C47:
Cemula to designate which cells to cemat
Cemula:  =(AND(argument1,argument2)) where dispute1 compares $D2 to understand if it is superior than or resembling to 100 and dispute 2 compares $E2 to understand if the quotation is “Yes”.
Light Green (Standard) supply complexion
Green badjust complexion
Outline preset badjust mode

10

9

Create a restricted cematting government with these specifications to the place A2:C47:
Cemula to designate which cells to cemat
Cemula:  =(AND(argument1,argument2)) where dispute1 compares $D2 to understand if it is short than 100 and dispute 2 compares $E2 to understand if the quotation is “Yes”.
Oplace (Standard) supply complexion
Green badjust complexion
Outline preset badjust mode

10

10

Create a manner complexion condition ce the Description shaft with these specifications:
Condition on cell complexion to spread-out the Light Green (Standard) supply complexion on Extreme as the first condition.
Condition on cell complexion to spread-out the Oplace (Standard) supply complexion on Extreme as the resultant condition.

10

11

Freeze the extreme enjoin.

5

12

Set the Scale to Fit percentage to 115%. Spread-out the workshuffle in Page Destroy Preview and incorporate a page destroy so that enjoin 36 starts on a upstart page.

5

13

Repeat the titles on enjoin 1 on integral pages.

5

14

Incorporate a manner footer with the quotation Exploring Series on the left border, the shuffle call command in the nature, and the improve call command on the suitable benjoin of the June Expenses worksheet.

5

15

Ensure that the worksheets are appropriately calld and placed in the subjoined adjust in the workbook: Dining Out, June Expenses. Save the workbook. Close the workbook, and then debouchure Excel. Submit the workbook as directed.

0

 

Sum Points

100

~~~For this or similar assignment papers~~~