Instructions Sort the table by city in alphabetical order and add a second level
ID: 3603173 • Letter: I
Question
Instructions Sort the table by city in alphabetical order and add a second level to sort by days on market with the houses on the market the kongest at the top wwithin each aty 7.000 s.000 12 Adjust column widths so that all data is visible. Wrap the column labels 4.000 13 Repeat the field names on all pages. 6.000 Add a page break at Row 36 so that city data does not span between pages, and change back 14 to Normal view 15 Add a footer with your name on the left side, the sheet name code in the center, and the file 16 | Display the Filtered Data worksheet. Fitter the data to display the ctes of Aapne, cedar rus, 2.000 name code on the right side. 5.000 and Eagle Mountain. 1 )Filter the data to display records for houses that were on the market 30 days or more. 18 Apply the conditional formatting 3 Arrows (Colored) ikcon set to the Days on Market values. 19 Apply the Light Blue Data Bars conditional formatting in the Gradient Fill section to the selling 5.000 7.000 7.000 Create a new conditional format that applies yellow fill (fourth color under Standard Colors) and bold font to values that contain 98% or higher for the Percent of List Price column. 20 7.000 Add a footer with your name on the left side, the sheet name code in the center, and the file 21 5.000 Select Landscape orientation and set appropriate margins so that the data will print on one page. 4.000 23 Save and close the file. Submit the file as directed 0.000 Total Points 100.00 pdated: 08/28/2017 Current_Instruction.Explanation / Answer
The information you provided in this question is not enough to answer this question.
There must be some information given in the question to make this document and then application of the tasks asked to be done in the question.
Please upload the full details to answer this in a single question. Some part of this questions seems to be missing here.