0
How to Create a spreadsheet showing the total sales income for each month using the correct formula and the grand total for all 3 months?
The scenario
You are an administrative assistant working in a local company called "pear net" which speacialises in website hosting, registration, development and merchandise. Recently your company has launched a series of new customer services for new and existing customers.
The figures below show the sales income for the four main types of the services sold during the first financial quarter (April, May & June). These figures were supplied by the sales department on a scruffy handwritten note.
Service 001 Website Hosting: £30030, £36750, £40005
Service 002 Company Registration: £25095, £32025, £38010
Service 003 Website Development: £17000, £27000, £25000
Service 004 Merchandise (Printers): £30020, £40090, £32015
Both the website hosting and company registration retail for £105.00 each, the website development for £100.00 and the Merchandise (Printers) for £90.00
TASK
(written above)
Create a spread sheet showing the total sales income for each month using the correct formula and the grand total for all 3 months.
Please help me with this assignment work,
Thank You.
What else can I help you with?
How do you use spreadsheet in a sentence?
Example sentence - We had to create a spreadsheet in order to analyze the data.
Name two types of charts you can create using a spreadsheet package?
bar chart and pie chart
How is a way of showing your data in a pictorial form on a spreadsheet?
One effective way to show data in a pictorial form on a spreadsheet is by using charts or graphs, such as bar charts, line graphs, or pie charts. These visual representations help to illustrate trends, comparisons, and distributions in the data, making it easier for viewers to understand insights at a glance. Most spreadsheet software, like Microsoft Excel or Google Sheets, offers built-in tools to create these visualizations from selected data ranges. Simply highlight the data you want to visualize, choose the appropriate chart type, and the software will generate the pictorial representation for you.
How do you change all positive numbers in a sheet to negatives?
To change all positive numbers in a spreadsheet to negatives, you can use a simple formula. In Excel or Google Sheets, create a new column and enter the formula =-ABS(A1) (assuming A1 is the cell with the number). Drag the fill handle down to apply the formula to other cells. Finally, copy the new column and use "Paste Special" to overwrite the original column with the negative values.
Is equals C equals a correct bond?
Equals C equals is not a correct bond. In order to create a bond, you will need to have an elemental symbon on either side of the equal sign. C equals C would be a correct bond type.
What are the four steps that must be done to implement any LP problem in a spreadsheet?
1. Organize the data for the model on the spreadsheet 2. Reserve separate cells in the spreadsheet to represent each decision variable in the algebraic model. 3. Create a formula in a cell in the spreadsheet that corresponds to the objective function in the algebraic model. 4. For each constraint, create a formula in a separate cell in the spreadsheet that corresponds to the left-hand-side of the constraint.
How can you create a spreadsheet using sales invoice template?
how you can create a spreadsheet using sales invoice template
What must you type to start off a formula in Excel?
Excel formulas begin with an equal sign, for example:=SUM(A1:A7)will give you the total of the numbers in cells A1, A2, A3, A4, A5, A6 and A7.Array formulas start with = but are enclosed in brace bracket{}.You can also use the plus or minus sign to start a formula, but as soon as you press Enter, a plus will be converted into an equals sign and a minus sign will have an equals sign inserted before it, so the formula will still show as starting with an equals sign.+5+7 will become =5+7-10*2 will become =-10*2Lotus 123 was the big spreadsheet application before Excel. It used the @ sign to start its functions. In order to help people moving from using Lotus 123 to Excel, the ability to start functions with the @ sign was included in Excel, and you can still do that. This applies only to functions at the start of a formula, not any formula.
What is the type for the software are use for spreadsheet?
You use spreadsheet software to create spreadsheets.
How do you use spreadsheet in a sentence?
Example sentence - We had to create a spreadsheet in order to analyze the data.
Is an Excel spreadsheet an example of a file?
A spreadsheet that you create and save with Excel is an example of a file.
In open office is it possible to convert a spreadsheet to a graph?
Yes - you can create graphs from the data in a spreadsheet.
What do Spreadsheet programs create?
financial presentations
How are data organised in spreadsheet?
You can organize data horizontally or vertically. You can use the data to create a chart to display the data. You can alphabetize the data list or sort in a variety of ways.
Which excel command would you use to create a new spreadsheet without changing an existing spreadsheet?
Save As
What computer program do you use to create a spreadsheet and create charts?
Microsoft excel
Does open office give you the ability to create a spreadsheet?
Absolutely - I use them regularly. The spreadsheet part of OpenOffice is 'Calc'
