How to create and use a spreadsheet

Assignment Help Basic Computer Science

Reference no: EM131895530

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

Reference no: EM131895530

Questions Cloud

Factors that will affect demand and prices of product : You have been given the responsibility of working with your organization's CEO to do a competitive market analysis of the potential success.

Find the gross earnings of a salesperson : Find the gross earnings of a salesperson who has total sales of $23,600. (No commission is paid on the first $15,000 of sales.)

Determine whether f is one-to-one : A function F : N ? S is defined by F (n) = k, where k is that odd positive integer for which 3n + 1 = (2^m)k for some nonnegative integer m.

What is the probability that this runner : If one runner is selected at random, what is the probability that this runner will complete the road race in less than 210 minutes?

How to create and use a spreadsheet : The purpose of this assignment is to learn how to create and use a spreadsheet. You will make two sheets: one for a table of data and one for a column chart.

Find the net cost of a tool case list-priced : Assuming a service department earns the cash discount, find the net cost of a tool case list-priced at $213.

How have you used the pythagorean theorem to perform a task : How have you used the Pythagorean Theorem to perform a task before? Decribe the context and how the calculations were applied.

Do you have any money invested in an account : Do you have any money invested in an account? If so, does it collect compound or simple interest?

Explain the concepts of in-group bias : Describes the "Us Versus Them" mentality, including the concepts of in-group bias and out-group homogeneity. Provide an example from the Bible.

User Account

All Pages