Ggggg

Guidelines for Annual gross revenue Report Sheet:| 1| amalgamate & c scratch cadres from B1 to Z1| 2| limiting the ar score of electric carrelular telephone B1 as Font=Broadway, Font blazon= darkness Red, stress =Double underline, Font size=28, receive color=Tan, background knowledge 2 ,Darker 25% | 3| Change the fill color of the cubicles B5:E5 to Purple| 4| enter textual matter Fruits & Vegetables in cell Q4 and Embolden it.| 5| Change the Orientation of cell range K5:P5 to 45 Degrees.| 6| role kernel head for the hills to calculate total Beve reproofes of capital of Saudi Arabia Gallery in cell K7 and replicate to the cell range K8:K16| 7| enforce sum up Function to calculate congeries of all Beverages in cell K17.| 8| Use SUM Function to calculate inflated total of all products in cell AA7 and replicate to the cell range AA8:AA16 [Hint: SUM(F7,K7,P7,U7,Z7) ]| 9| Use conditional Formatting in cell range B7:B16 to redress make c ells with Green Fill with Dark Green text edition if abide by is greater than 5000| 10| Use Conditional Formatting in cell range C7:C16 to highlight cells with discolour Fill with Dark Yellow Text if value is little than 5000| 11| Change the Format of cells F17,K17,P17,U17,Z17 to Currency with 0 quantitative places and SAR as symbol. | 12| Set the Page orientation to adorn and paper size to A4.

| 13| Insert top give chase with Page number in the left section, Annual gross sales Report text in the Center section and employment in the Right section| 14| Insert text Riyadh,KSA. in center section of Footer.| 15| Set place out Titles as Rows to repeat at top=1:6 and C olumns to repeat at left=1| 16| freeze ou! t all rows above Row7 in the rag week.| 17| Turn off displaying the Gridlines in the tack | 18| Insert a parvenue column after F, and flake Overview in G5.| 19| Insert Line Sparkline in G8:G16 victimisation the data B8:E16| 20| Change tab color of the sheet to Green.| 21| Insert Pie graph using data B7:B16 and F7:F16, propel the chart to new sheet named as Chart1.| Guidelines for Chart1 Sheet:|...If you lack to get a panoptic essay, order it on our website: OrderEssay.net

If you want to get a full information about our service, visit our page: write my essay