Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Display all the formula in excel and also need a graph | The goal of this assignment is to practice preparing Excel spreadsheet making use

image text in transcribed

Display all the formula in excel and also need a graph

| The goal of this assignment is to practice preparing Excel spreadsheet making use of some of its numerous features. WHAT TO DO Prepare using Microsoft Excel a spreadsheet similar to the one below; use OTHER numbers (choose randomly). For the "TOTAL" column, and "AVERAGE" and "TOTAL" rows use Excel functions "SUM" and "AVERAGE" to calculate the amounts for you automatically. For the date use "TODAY" function. You should use auto-fill feature for the first column (with numbers), second column (months) last column (total) and last two rows (average and total). Highlight the rows and/or columns in which you used auto-fill feature and formulas. If you use this auto-fill feature, the whole spreadsheet should take just a few minutes to finish. Include a graphical chart to visualize your work. WHAT TO SUBMIT Submit spreadsheet file through the canvas. Keep the file till the end of the semester and be prepared to e-mail it upon request. 1 January 2 February 3 March 4 April 5 May 6 June 7 July 8 August 9 September 10 October 11 November 12 December 13 14 AVERAGE 15 TOTAL Food Rent 150 190 340 200 220 235 149 276 312 322 123 234 Car 700 700 700 700 700 700 700 710 710 710 825 Other 23 15 644 27 48 30 31 28 TOTAL 35 500 22 33 32 58 128 23 908 1405 1706 960 1000 1023 1008 1037 1051 1315 1091 1141 21 257 8 26 31 30 112 52 825 229.25 2751 723.3333 8680 78.41667 941 106.0833 1273 1137.083 13645

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

Financial Accounting For Decision Makers

Authors: DeFond, Mark

3rd Edition

1618534432, 9781618534439

More Books

Students also viewed these Accounting questions