Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Need help with the attached. Acct 104 ASSGN2 - CHART Your Name Here (cell A4) Expense Salary Benefits Supplies Services Other $ 3,509,899 $ $

Need help with the attached.image text in transcribed

image text in transcribed

Acct 104 ASSGN2 - CHART Your Name Here (cell A4) Expense Salary Benefits Supplies Services Other $ 3,509,899 $ $ 877,475 $ $ 1,403,960 $ $ 2,105,939 | $ $ 280,792 $ 2016 3,685,394 | $ 921,348 $ 1,474,158 $ 2,211,236 $ 294,832 $ 2017 3,869,664 967,416 1,547,865 2,321,798 309.573 INSTRUCTIONS -score is based on 60% accuracy (formulas, instructions & requirements) and 40% presentation/formatting DATA Create the spreadsheet above (exactly as you see it). Formatting must be similar. Use Arial 11 pt font. Center the headings in the cells Put your name where it says "Your Name Here" in cell A3. ACCT 104 goes in cell A1 and ASSGN2 - CHART goes in cell A2. 3 Start the column headings in cell B6. (EXPENSE is in cell B6, etc) 4 After you enter the headings in row 6, enter all the data as you see it In cells B7 through E11. 5 Name the sheet "DATA". Make sure sheet will print to one page. 6 Use proper footer formatting for full credit (based on File & Sheet Naming Lecture). Set your print range to landscape and make sure it will print to one page if you were to actually print (do a print preview) Save the file following the file naming conventions per that lecture with the assignment name as "CHART". PIE 1 Create a Pie Chart using the data for 2017. Title the chart 2017 Expense" 2 Place the Pie Chart on a separate sheet and name the sheet "PIE". 3 Resave the file with the same name

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

Auditing For Dummies

Authors: Maire Loughran

1st Edition

0470530715, 978-0470530719

More Books

Students also viewed these Accounting questions

Question

Draw a truth table for PT(P+Z) = X A B C D P T Z 0) 01 1 1 0

Answered: 1 week ago