Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please just show an example in excel of the combo IF and WEEKDAY function for this. i cannot figure it out 7. Ms. Sweet would

image text in transcribed
image text in transcribed
please just show an example in excel of the combo IF and WEEKDAY function for this. i cannot figure it out
7. Ms. Sweet would like you to create a chart that shows the trend in cookie sales over the four weeks under examination and highlights the periods with the highest sales. (See image of chart below.) TT d. To highlight the days with the highest sales a second column of data must be created on the All Weeks - By Date sheet. This column of data is named "Friday Saturday Sale?" because cookie sales are greatest on Fridays and Saturdays. A value of 1 should be assigned to Fridays and Saturdays. A value of 0 should be assigned to all other days. Enter a formula in cell C5 of the All Weeks - By Date sheet that uses the IF function and the WEEKDAY function to assign a value of 1 to Fridays and Saturdays and a value of 0 to all other days. Copy the formula in cell C5 down the column to cell C32. Catnday Sale data series to the line chart, 1.1 TH

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Using Financial Accounting Information The Alternative to Debits and Credits

Authors: Gary A. Porter, Curtis L. Norton

7th Edition

978-0-538-4527, 0-538-45274-9, 978-1133161646

More Books

Students also viewed these Accounting questions

Question

I wasnt sure how to talk about this situation. It was too personal.

Answered: 1 week ago