Cashback Offer from 1st to 15th March 2021. Get Flat 20% Cashback credited to your account for a minimum transaction of $80. Post Your Question Today!

Question DetailsNormal
$ 32.00

Exploring - Excel Chapter 4: Assessment Project 1 | Complete Solution

Question posted by
Online Tutor Profile
request

1
    

Start Excel. Open the downloaded Excel file named exploring_e04_grader_a1.xlsx.

2
    

In the Dining Out worksheet, convert the data to a table. Apply Table Style Light 14.

3
    

Remove duplicate rows in the Dining Out worksheet.

4
    

Sort the table by Description in alphabetical order, then by Store in alphabetical order, and then by Amount from the smallest to the largest.

5
    

Filter the records to show personal (i.e., non-business) lunch and dinner expenses.

6
    

Display the Total Row. In cell D48, select the function to total the Amount values. In cell E48, do not show a total.

7
    

In the June Expenses worksheet, apply the conditional formatting style that displays a Green Data Bar Gradient Fill in the range D2:D47.

8
    

Create a conditional formatting rule with these specifications to the range A2:C47:
 • Formula to determine which cells to format
 • Formula:  =(AND(argument1,argument2)) where argument1 compares $D2 to see if it is greater than or equal to 100 and argument 2 compares $E2 to see if the text is "Yes".
 • Light Green (Standard) fill color
 • Green border color
 • Outline preset border style

9
    

Create a conditional formatting rule with these specifications to the range A2:C47:
 • Formula to determine which cells to format
 • Formula:  =(AND(argument1,argument2)) where argument1 compares $D2 to see if it is less than 100 and argument 2 compares $E2 to see if the text is "Yes".
 • Orange (Standard) fill color
 • Green border color
 • Outline preset border style

10
    

Create a custom color sort for the Description column with these specifications:
• Sort on cell color to display the Light Green (Standard) fill color on Top as the primary sort.
• Sort on cell color to display the Orange (Standard) fill color on Top as the secondary sort.

11
    

Freeze the top row.

12
    

Set the Scale to Fit percentage to 115%. Display the worksheet in Page Break Preview and insert a page break so that row 36 starts on a new page.

13
    

Repeat the titles on row 1 on all pages.

14
    

Insert a custom footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side of the June Expenses worksheet.

15
    

Ensure that the worksheets are correctly named and placed in the following order in the workbook: Dining Out, June Expenses. Save the workbook. Close the workbook, and then exit Excel. Submit the workbook as directed.

Available Answer
$ 32.00

[Solved] Exploring - Excel Chapter 4: Assessment Project 1 | Complete Solution

  • This Solution has been Purchased 5 time
  • Submitted On 20 Dec, 2015 12:58:12
Answer posted by
Online Tutor Profile
solution
Wendy's Lunch $7.45 Dillard's Clothes $155.65 Subway Lunch $7...
Buy now to view the complete solution
Other Similar Questions
User Profile
AceTu...

Exploring Access 7 H1 | Complete Solution

This Tutorial is rated A+ previously,if you have any questions regarding this tutorial then you can contact me....
User Profile
vpqnr...

BTM8107-8 week 2 understanding and exploring assumptions correct answers

1..Why do we care whether the assumptions required for statistical tests are met? (Tip: You might also want to write your answer on a note card you paste to your computer.) Assumptions are needed to draw accurate conclusions ...
User Profile
Exper...

BTM8107-8 | Week: 2 | Activity: Understanding and Exploring Assumptions | Rated A+

For the variable “Day 1”:
From the histogram of the variable Day 1 we see that the histogram of day 1 looks like normal distribution but it’s curve is slightly above the normal curve so it is leptoku...

User Profile
austi...

PSYC 341 Exploring Schizophrenia | Complete Solution

Introduction Schizophrenia is a mental illness; those afflicted with schizophrenia have a distorted perception of reality and suffer from delusions and hallucinations. To a healthy person, a person with schizophrenia appea...
User Profile
Solut...

NR 305 Week 1 Graded Discussion Topic: Exploring the Nurse’s Role in Health Assessment

NR 305 Week 1 Graded Discussion Topic: Exploring the Nurse’s Role in Health Assessment SOLUTION. This week’s graded topics relate to the following Course Outcomes (COs). (CO #1) – Utilize prior knowledge o...

The benefits of buying study notes from CourseMerit

homeworkhelptime
Assurance Of Timely Delivery
We value your patience, and to ensure you always receive your homework help within the promised time, our dedicated team of tutors begins their work as soon as the request arrives.
tutoring
Best Price In The Market
All the services that are available on our page cost only a nominal amount of money. In fact, the prices are lower than the industry standards. You can always expect value for money from us.
tutorsupport
Uninterrupted 24/7 Support
Our customer support wing remains online 24x7 to provide you seamless assistance. Also, when you post a query or a request here, you can expect an immediate response from our side.
closebutton

$ 629.35