Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with this question please. On the Year worksheet, enter a 3D formula in cell range C5:G19 to calculate the total items sold

I need help with this question please.

On the Year worksheet, enter a 3D formula in cell range C5:G19 to calculate the total items sold for each department. If you use the fill handle to copy the formulas, click the Auto Fill Options and choose Fill Without Formatting.

image text in transcribed

File Home Insert Page Layout Formulas Data Review View Developer Help fx AutoSum 2 Logical Lookup & Reference Recently Used A Text Math & Trig Insert Function Financial Date & Time More Functions Function Library Define Name Use in Formula Name Manager Eo Create from Selection Defined Names Ey Trace Precedents a Trace Dependents FRemove Arrows -60 Watch Window Formula Auditing G29 > A B C D E F H | J 1 2 Yearly Uniform Orders 3 Sales Front Desk Grounds Room keeping Other Total 0 0 0 0 0 0 0 Price $19.95 $14.95 $10.95 $13.95 $23.95 $26.95 $36.95 $42.95 $45.95 $50.95 $36.95 $24.95 $12.95 $11.95 $10.95 0 0 0 0 0 0 4 Item 5 Women's long sleeve 6 Men's long sleeve 7 Short sleeve 8 Vest 9 Women's Jacket 10 Men's Jacket 11 Women's sweater 12 Men's sweater 13 Women's pants 14 Men's pants 15 Long skirt 16 Short skirt 17 Hat 18 Scarf 19 Tie 20 Total 21 22 23 24 25 26 27 28 29 30 31 32 33 34 0 0 0 0 0 0 0 0 Q1 Q2 03 Q4 Year YearLinked Prices + File Home Insert Page Layout Formulas Data Review View Developer Help fx AutoSum 2 Logical Lookup & Reference Recently Used A Text Math & Trig Insert Function Financial Date & Time More Functions Function Library Define Name Use in Formula Name Manager Eo Create from Selection Defined Names Ey Trace Precedents a Trace Dependents FRemove Arrows -60 Watch Window Formula Auditing G29 > A B C D E F H | J 1 2 Yearly Uniform Orders 3 Sales Front Desk Grounds Room keeping Other Total 0 0 0 0 0 0 0 Price $19.95 $14.95 $10.95 $13.95 $23.95 $26.95 $36.95 $42.95 $45.95 $50.95 $36.95 $24.95 $12.95 $11.95 $10.95 0 0 0 0 0 0 4 Item 5 Women's long sleeve 6 Men's long sleeve 7 Short sleeve 8 Vest 9 Women's Jacket 10 Men's Jacket 11 Women's sweater 12 Men's sweater 13 Women's pants 14 Men's pants 15 Long skirt 16 Short skirt 17 Hat 18 Scarf 19 Tie 20 Total 21 22 23 24 25 26 27 28 29 30 31 32 33 34 0 0 0 0 0 0 0 0 Q1 Q2 03 Q4 Year YearLinked Prices +

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 Finance questions