Question about Computers & Internet

add all the numbers in the selection and get a sum total

divide that sum by the number of numbers in the selection and that is the average

for example the numbers are from 1 to 10 inclusive = sum total=55

divide 55 by the number of numbers --(10) = 5.5 = average

divide that sum by the number of numbers in the selection and that is the average

for example the numbers are from 1 to 10 inclusive = sum total=55

divide 55 by the number of numbers --(10) = 5.5 = average

Feb 03, 2017 | Computers & Internet

In the case of Boston university, 57k is the cost per year, 4 years(bachelors degree) would be around 221k.

Jan 04, 2017 | Financial aid

You need to create a database with six fields: Roll Number, Name, Marks1, Marks 2, Marks 3 and MarksT (sum of marks1+2+3)

Sort database on MarksT in decending order.

Easily one in Excel - other programs will be similar

Sort database on MarksT in decending order.

Easily one in Excel - other programs will be similar

Mar 09, 2015 | The Computers & Internet

The total mass is the sum of the masses of the individual pails

Total mass =18.49*2 kg =36.98 kg

Total mass =18.49*2 kg =36.98 kg

Aug 21, 2014 | Office Equipment & Supplies

Total alkalinity can be lowered by adding muriatic acid or
sodium bisulfate. Acid may be added in doses of up to 1 quart per 10,000 gallons. Total
alkalinity tests and further required additions of acid can be made every 2 hours.

Jun 28, 2011 | Pentair Clean & Clear Plus Ccp320 Pool...

The average is 20, it means the total is 60. The sum of ratio is 15 (3+5+7)

Therefore the age of a girl is calculated by multiplying the respective ration with total and dividing by sum of ratio

Age of Eldest girl = 7 x 60 /15 = 28

Hope it helps! Good Luck!

CreativeTECH

Therefore the age of a girl is calculated by multiplying the respective ration with total and dividing by sum of ratio

Age of Eldest girl = 7 x 60 /15 = 28

Hope it helps! Good Luck!

CreativeTECH

Feb 15, 2011 | Computers & Internet

Assuming the Belvedere Arms sells only food and drink:

a) Total sales for the week is the sum of the drink sales and food sales, £11,800 + £5,600 = £17,400

b) Sales budget is £16,200, so performance is (17,400-16,200)/16,200 = 1200/16200 = .074 which is up by 7.4%

c) Profit on food is £3,640 on total food sales of £5,600. 3640/5600 = .65 or 65%

d) Profit on drink is £8,496 on total drink sales of £11,800. 8496/11,800 = .72 or 72%

e) Total profit is £12,036 on total sales of £17,400. 12,136/17,400 = .697 or 70%

a) Total sales for the week is the sum of the drink sales and food sales, £11,800 + £5,600 = £17,400

b) Sales budget is £16,200, so performance is (17,400-16,200)/16,200 = 1200/16200 = .074 which is up by 7.4%

c) Profit on food is £3,640 on total food sales of £5,600. 3640/5600 = .65 or 65%

d) Profit on drink is £8,496 on total drink sales of £11,800. 8496/11,800 = .72 or 72%

e) Total profit is £12,036 on total sales of £17,400. 12,136/17,400 = .697 or 70%

Aug 31, 2010 | Vivendi Excel@ Mathematics Study Skills...

I have had my machine for the past 6 years, I do on average ten loads per week, and it has never failed me. A bit noisy but for the price I could n`t complain. I have just broken the door handle which has cost me a total of #8.50. Not bad for six years hard labour

Dec 04, 2009 | Indesit W 123 Front Load Washer

For example, you have three numbers from A1 to A3. On row A4, type =SUM(A1:A3).

That should do it. :)

That should do it. :)

Sep 16, 2009 | Microsoft Office Excel 2007

Hi saleem_share,

I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:

Description

Amount

Formula

Sales Product A

1,000.00

Sales Product B

1,000.00

Total Sales

2,000.00

SUM(C1:C2)

Cost of Sales Product A

500.00

Cost of Sales Product B

200.00

Total Cost of Sales

700.00

SUM(C5:C6)

Gross Profit

1,300.00

SUM(C4-C7)

Auto

25.00

Utilities

50.00

Payroll

300.00

Office Supplies

20.00

Total Expenses

395.00

Net Profit

905.00

SUM(C8-C14)

I hope this helps

Mark

I'm not sure why you would want to use excel to create a P&L, but the same formula would apply to excel as it would for a standard P&L. In one section of the spreadsheet add all of your income accounts. Then Subtract your cost of sales from that. That would equal your Gross Profit. After that add all the rest of your Expenses, and subtract from the Gross Profit, which would give you your net Profit or Loss Example:

Description

Amount

Formula

Sales Product A

1,000.00

Sales Product B

1,000.00

Total Sales

2,000.00

SUM(C1:C2)

Cost of Sales Product A

500.00

Cost of Sales Product B

200.00

Total Cost of Sales

700.00

SUM(C5:C6)

Gross Profit

1,300.00

SUM(C4-C7)

Auto

25.00

Utilities

50.00

Payroll

300.00

Office Supplies

20.00

Total Expenses

395.00

Net Profit

905.00

SUM(C8-C14)

I hope this helps

Mark

Jan 05, 2009 | Microsoft Computers & Internet

Aug 19, 2017 | Computers & Internet

Aug 19, 2017 | Computers & Internet

Aug 19, 2017 | Computers & Internet

29 people viewed this question

Usually answered in minutes!

×