Answered step by step
Verified Expert Solution
Link Copied!

Question

00
1 Approved Answer

I need assistance with these particular questions: (with visiuals) Here is the Document: https://1drv.ms/x/s!AoQGMTkNnGG_hFyfzlgKERfi5Oqh (Step 10.) Add a total row to display the average percentage

I need assistance with these particular questions: (with visiuals) Here is the Document: https://1drv.ms/x/s!AoQGMTkNnGG_hFyfzlgKERfi5Oqh

(Step 10.) Add a total row to display the average percentage of list price and average number of days on market. Format the average number of days on market as a whole number. Use an appropriate label for the total row.

-The following was not accomplished in step 10: In the Cell 'G83' of Sheet 'Sales Data', the 'Content' was not set to '0.952'. In the Cell 'J83' of Sheet 'Sales Data', the 'Content' was not set to '72.185'

(Step 16.) Display the Filtered Data worksheet. Filter the data to display the cities of Alpine, Cedar Hills, and Eagle Mountain.

-The following was not accomplished in step 16: For the 'filter on column C', the 'Criteria' 'Equals Alpine, Equals Cedar Hills, Equals Eagle Mountain' was not applied.

(Step 17.) Filter the data to display records for houses that were on the market 30 days or more.

-The following was not accomplished in step 17: For the 'filter on column J', the 'Criteria' 'Greater Than or Equal To 30' was not applied.

(Step 18.) Apply the 3 Arrows (Colored) icon set to the Days on Market values.

-The following was not accomplished in step 18: Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'iconSet' on range 'J2:J66' of sheet 'Filtered Data', the 'Rule Type' was not set to 'Icon Set'.' Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'iconSet' on range 'J2:J66' of sheet 'Filtered Data', the 'Range' was not set to 'J2:J66'.' Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'iconSet' on range 'J2:J66' of sheet 'Filtered Data', the 'Icon Set Type' was not set to '3Arrows'.'

(Step 19.) Apply the Light Blue Data Bars conditional formatting in the Gradient Fill section to the selling prices.

-The following was not accomplished in step 19: Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'dataBar' on range 'F2:F66' of sheet 'Filtered Data', the 'Rule Type' was not set to 'Data Bar'.'Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'dataBar' on range 'F2:F66' of sheet 'Filtered Data', the 'DataBar Color' was not set as per the instruction.' Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'dataBar' on range 'F2:F66' of sheet 'Filtered Data', the 'DataBar Gradient' was not applied.' Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'dataBar' on range 'F2:F66' of sheet 'Filtered Data', the 'Range' was not set to 'F2:F66'.'

(Step 20.)Create a new conditional format that applies yellow fill and bold font to values that contain 98% or higher for the Percent of List Price column.

-The following was not accomplished in step 20: Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'cellIs' on range 'G2:G66' of sheet 'Filtered Data', the 'Rule Type' was not set to 'Cell Value'.' Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'cellIs' on range 'G2:G66' of sheet 'Filtered Data', the 'Range' was not set to 'G2:G66'.' Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'cellIs' on range 'G2:G66' of sheet 'Filtered Data', the 'Bold' was not set to 'Applied'.' Conditional Format(s) was not detected in the submission. Engine reported the failure as In the Conditional formatting 'cellIs' on range 'G2:G66' of sheet 'Filtered Data', the 'Background Color' was not set to 'Yellow'.'

(Step 21.) Add a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side.

-The following was not accomplished in step 21: Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as In the Sheet 'Filtered Data' the 'Center Footer Content' was not set to '&[Tab]'.' Header(s) and Footer(s) was not detected in the submission. Engine reported the failure as In the Sheet 'Filtered Data' the 'Right Footer Content' was not set to '&[File]'.'

(Step 22.) Select Landscape orientation and set appropriate margins so that the data will print on one page.

-The following was not accomplished in step 22: In the Sheet 'Filtered Data' the 'Orientation' was not set to 'Landscape'.

Thank You

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions

Question

what is a peer Group? Importance?

Answered: 1 week ago