Excel Workbook

User Generated

Znggu95

Business Finance

Description

Looking for Someone to help me to lean as how to do addition in MS office Excel with the help of basic formulas

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

This guide has all the functions needed to perform your task. Kindly let me know if you have any questions.

Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
TOTAL

Month
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar

Prod-1
Prod-2
Prod-4
30.000
45.000
35.000
30.750
46.125
35.875
31.519
47.278
36.772
32.307
48.460
37.691
33.114
49.672
38.633
33.942
50.913
39.599
34.791
52.186
40.589
35.661
53.491
41.604
36.552
54.828
42.644
37.466
56.199
43.710
38.403
57.604
44.803
374.504 561.756 436.921
Week
Sun
Mon
Tue
Wed
Thu
Fri
Sat
Sun
Mon
Tue

Repitition
Sun
Sun
Sun
Sun
Sun
Sun
Sun
Sun
Sun
Sun

Prod-1
Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Item1
Item2
Item3
Item4
Item5
Item6
Item7
Item8
Item9
Item10
Item11
Item12
Item13
Item14
Item15

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Jan
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar

sun
mon
tue
wed
thu
fri
sat
sun
mon
tue
wed
thu
fri
sat
sun

Prod-2

Paul
Paul
Paul
Paul
Paul
Paul
Paul
Paul
Paul
Paul
Paul
Paul
Paul
Paul
Paul

Prod-3

Prod-4

Prod-5

REFERENCING
ABSOLUTE AND RELATIVE REFERENCING

INVOICE
Sl. No.
1
2
3
4
5
6
7
8

Item
Quantity Unit Price Discount
Total
Cabinet
7
1250
437,5 8312,50
Hard Disk
5
1500
375 7125,00
Pen Drive
3
650
97,5 1852,50
Combo Drive
5
1650
412,5 7837,50
Keyboards
3
900
135 2565,00
Mouse
7
250
87,5 1662,50
Monitors
5
5600
1400 26600,00
ZIP Drives
4
750
150 2850,00

Grand Total
Discount

5%

Discount

7%

58805,00

MIXED REFERENCING

Length

Width
2
3
4
5

3
6
9
12
15

4
8
12
16
20

5
10
15
20
25

6
12
18
24
30

Quantity Unit Price Sales Tax
7
1250
656,25
5
1500
562,5
3
650
146,25
5

Total
9406,25
8062,5
2096,25

3D - REFERENCING
100

Sl. No.
1
2
3
4

Item
Cabinet
Hard Disk
Pen Drive
CD ROM

7,50%

1
1,5
2

1
1
1,5
3

Area

1,5
1,5
2,25
6,75

2
3
6,75
45,5625

2
3
4

2
4
12
48

3
4
12
48
144
6912
6912 47775744

NAMING CELLS
Named Cells
Cost
140
150

Price
168
35

213

Profit
28
115

321

321

Named Range
213
321

321

354

351

INVOICE
Sl. No.
1
2
3
4
5
6
7
8

Item
Quantity Unit Price Discount
Total
Cabinet
7
1250
437,5 8312,50
Hard Disk
5
1500
375 7125,00
Pen Drive
3
650
97,5 1852,50
Combo Drive
5
1650
412,5 7837,50
Keyboards
3
900
189 2511,00
Mouse
7
250
122,5 1627,50
Monitors
5
5600
1960 26040,00
ZIP Drives
4
750
210 2790,00

Grand Total
Discount1

5%

Discount2

7%

58096,00

Use of a Function with named Range
Sum F...


Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags