prepare a spreadsheet summarizing the following resources and power costs of the department for April: Electricity $287
Question:
prepare a spreadsheet summarizing the following resources and power costs of the department for April: Electricity $287 Gas $102 Office paper $1,098 Envelopes $309 Computer supplies $2,098 Stationery $1,092 2. Input the data into the spreadsheet. Carefully check you have entered the data correctly. 3. Give the spreadsheet a heading, including the month and current year. 4. Use the SUM function to tally the total expenditure. Use the MAX function to display the highest cost for the month. 5. Format the spreadsheet with a light green background for the title of the spreadsheet, and a dark thick green boarder outlining all the information in the report. Text is also to be green, and in Arial font. 6. Produce a pie chart showing expenditure for the month. The chart must include a title specific to the information being presented and state the organisation and department name, data labels are to be incorporated into the chart to show percentages of total expenditure. Make sure the pie chart is in one page, so you need to adjust your data range. 7. Preview and print the spreadsheet to pdf and the chart as two separate sheets in landscape orientation, centred on the page vertically and horizontally. Preview the document before printing. 8. Save the file to an appropriate location and name it customer-service-operating-expenditure 9. Prepare a checklist of the requirements of this spreadsheet and chart to verify that it meets organisational requirements and is suitable for the target audience.
Management information systems
ISBN: 978-0073376813
10th edition
Authors: James A. O Brien, George M. Marakas