Assignment: Spreadsheet
Overview
The purpose of this assignment is to learn how to create and use a spreadsheet.
You are the Junior Accountant of the consulting firm Axxon Corporation in the third year of a four year business cycle. Since your third year is not yet complete, your sales and expenses are still unknown and have to be estimated. You will use a spreadsheet to prepare your budget.
You must use Microsoft Excel for this assignment. The instructions for this assignment use Microsoft Excel 2016. Other versions of Microsoft Excel are similar.
Task
A spreadsheet has sheets (i.e. the tab(s) near the bottom of the spreadsheet window that control which sheet is visible). Each sheet has a table and/or a chart. In this assignment, you will make two sheets: one for a table of data and one for a column chart.
To do this worksheet, you will need to:
- Change the name of the sheet;
- Adjust column widths and row heights;
- Merge cells;
- Input text and numbers;
- Set text colour;
- Set background colour of cells;
- Set border colour of cells;
- Make text bold;
- Align data horizontally and vertically;
- Wordwrap text within a cell;
- Enter formulas (including cell ranges);
- Format numbers.
Attachment:- Assignment-Spreadsheet-Instructions.rar