I need help to do questions 3 and 5 in the Excel Worksheet given. Provide the proper steps too. WAutoSave Instructions SC EX19_3a (2)-Instructions SC EX19_3a (2) Protected View Saved to this PC ✓Page 1 of 4Draw DesignLayoutReferences Mailings ReviewViewHelpFile Home Inserti PROTECTED VIEWBe careful files from the Internet can contain viruses. Unless you need to edit, it's safer to stay in Protected View.SUBSCRIPTION CANCELLED On Sunday, December 18, 2022, most features of Word will be disabled.Reactivatefrom the SAM website.930 words78°FSunnyText Predictions: OnPROJECT STEPS1.2.3.4.5.6.7.Lindsey Sawyer is the director of recruiting and business development for RaybridgeRecruiting in Washington, D.C. She has been analyzing sales and commissions forrecruiters in an Excel workbook and has asked you to help her complete the analysis.O Search (Alt+Q)Go to the Sales worksheet. Rename the Sales worksheet as Sales and Dividends,which is a more accurate name.Unfreeze column A so it is not displayed when you scroll horizontally.Middle-align the contents of the merged cell A1 to improve the appearance of theworksheet title.In cell B3, insert a formula that uses the NOW function to display today's date.Fill the range C6:G10 with the formatting from the range B6:B10 to use a consistentnumber format for the sales data.a.Lindsey wants to show the sales trend for each position and month from January toJune. Provide this information as follows:b.Enable EditingC.d.In cell H6, insert a Line sparkline based on the data in the range B6:G6.Use the Fill Handle to fill the range H7:H10 without formatting based on thecontents of cell H6.Change the color of the sparklines in the range H6:H10 to Dark Purple, Text 2(4th column, 1st row of the Theme Colors palette) to emphasize them.Show a High Point and a Low Point in the sparklines to make those values easy toidentify.Copy the formula in cell 16 and paste it in the range 17:110, pasting only the formula andnumber formatting, to include sales totals.hpJeffrey Wang W #FocusComments AutoSaveFile5.e2.UndePicture 7Home Insert Draw Page LayoutXLG9 Interim10 TotalPaste14155 Position Type6 Executives7 Managers8 ProfessionalsClipboard FyVraybridge23 Last updated:4Off HSC EX19_3a_JeffreyWang_21112 Percentage per Month13 Share16 Monthly Dividend17 Amount18 Net AmountReadyNet Dividend % (After19 Deductions)202122 Position Type23 Executives24 Managers25 Professionals26 Interim27 Total28X✓ fxBIU78°FSunny10/2/2022January$98,348.50$ 74,474.35$31,330.21$ 18,307.52$ 222,460.58$January$$$$$DocumentationAccessibility: InvestigateMJuly62%Fent$SalesC98,000 $78,500 $31,000 $22,000 $229,500 $VFormulas Data ReviewFebruaryFebruary-A AY(+)A$DAugust89,000 $65,000 $29,000 $15,000 $198,000 $VIsRaybridge RecruitingSales and DividendsMarch89532.965742.1229667.7415002.26 15721.80654182459.6465199915.0781522.6756330.6928884.48✓ = = =Monthly SalesAprilMarch===Merge & CenterEDividends PaidApril$September90,000 $70,000 $30,000 $16,000 $206,000 $75279.2652540.5827274.0912382.1167476,03View Help Picture FormatEstimated SalesOctoberAlignment92,000 $72,000 $31,000 $18,000 $213,000 $29 Wrap TextMay91610.2468080.6727281.9620009.22206982.09May$November94,000 $74,000 $33,000 $19,500 $220,500 $Search (Alt+Q)GJune97352.6878107.7630099.4321272.37226832.24June-December91,500 $71,000 $30,000 $19,000 $211,500 $ESHTrendTrendTotalGeneral$-% 9554,500430,500184,000109,5001,278,500$%900$$NumberTotal533,646.25Totalhp432015Avg. Placements Estimates only2228100 DE ECellConditional Format asFormatting Table Styles YStylesKLMME CSXInsert Delete FormatNCellsOPJeffrey Wang JWWEOMV28CSort & Find EFilter SelectEditingForma> Shadow> Reflecti> Glow> Soft Edg> 3-D Form> 3-D Rota> ArtisticD

Ans 3 : Select the cell that you want to align. Now on the home tab select alignment options. For…

j 3. 4. 5. Middle-align the contents of the merged cell A1 to improve the appearance of the worksheet title. In cell B3, insert a formula that uses the NOW function to display today's date. Fill the range C6:G10 with the formatting from the range B6:B10 to use a consistent number format for the sales data.

j 3. 4. 5. Middle-align the contents of the merged cell A1 to improve the appearance of the worksheet title. In cell B3, insert a formula that uses the NOW function to display today's date. Fill the range C6:G10 with the formatting from the range B6:B10 to use a consistent number format for the sales data.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

What statuses on your list, if any, would not have made your list a year ago? Five years ago?
Please submit an Excel file that may be used to calculate imputed interest and taxable social security benefits. The spreadsheet should include formulae to help with the computations.
It is permitted in some cases to supply the customer with copies of the auditor's earlier documents. If this is the case, are there any situations that the auditors should be aware of before presenting the client's documentation? Make a list of at least three things that come to mind.
Task 7 - Task 10 Task 7: List the square footage, owner number, owner last name, and owner first name for each property managed by the StayWell-Columbia City office. Task 8: Repeat Task 7, but this time include only those properties with three bedrooms. Task 9: List the office number, address, and monthly rent for properties whose owners live in Washington State or own two-bedroom properties. Task 10: List the office number, address, and monthly rent for properties whose owners live in Washington State and own a two-bedroom property.
Which of the following are valid objectives for incident reports?
It is necessary for all of the information that is found in the records of the table that serves as the report's foundation to be included in the report.True False
What is the objective of the notes page view in your own words? Explain.
Describe many ways for acquiring meeting control. What justification is there for this?
Please show the working steps in excel, thank you.
Please describe DBA technical function design and implementation tasks.
Can you name the wildcards in Excel?
Please provide a description of the duties that are typically associated with the design and implementation services provided by the DBA's technical function.