Scribd
Upload
18 views10 pages

Excel Practice FormulaFunctionsTest

The document contains various mathematical operations including addition, subtraction, multiplication, and division with corresponding totals. It also includes a shopping list with item prices and quantities. The final answer for a specific calculation is stated to be 8248.

Uploaded by

riya.uppal504
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
18 views10 pages

Excel Practice FormulaFunctionsTest

The document contains various mathematical operations including addition, subtraction, multiplication, and division with corresponding totals. It also includes a shopping list with item prices and quantities. The final answer for a specific calculation is stated to be 8248.

Uploaded by

riya.uppal504
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

3512 ADD THESE CELLS

1234 239 Total


5693 TOGETHER
4532
ANSWER

Add Subtract Multiply Divide


1275 1600 1275 1275
52 36 25 25
1327 1252

TOTAL 2654 TOTAL TOTAL TOTAL

ANSWER ANSWER ANSWER ANSWER


USE
ADD ADD ADD
56 96 96
85 85 85
96 48 45
5645 45 12
51 8 1
21 5 212
Total Total Total Total

ADD ADD ADD


69 61 15
85 15 18
15 15 19
15 14 54
15 15 14
Total Total Total Total
USE THE SUM FUNCTION
ADD ADD ADD
56 96 96
85 85 85
96 48 45
5645 45 12
51 8 1
21 5 212
Total Total

ADD ADD ADD


69 61 15
85 15 18
15 15 19
15 14 54
15 15 14
Total Total
Mary-Anne's SHOPPING LIST

Item Item Price Number of items Total


Subtract Subtract Subtract
9654 15000 25369
521 6954 9565
454 454 6824
12 158 1541
145 798 1587
21 1000 1458
Total Total Total

Subtract Subtract Subtract


17985 6548 3658
9658 4854 454
854 4254 154
3000 1247 154
1232 1259 14
Total Total Total
Multiply Multiply Multiply
42 65 45
14 54 18
Total Total Total

Multiply Multiply Multiply


3 10 96
50 16 10
Total Total Total

Multiply Multiply Multiply


15 60 15
32 12 14
Total Total Total

Multiply Multiply Multiply


12 69 15
12 65 14
Total Total Total
Divide Divide Divide
42 70 45
14 8 18
Total Total Total

Divide Divide Divide


100 20 150
50 10 10
Total Total Total

Divide Divide Divide


50 60 80
5 3 14
Total Total Total

Divide Divide Divide


96 49 80
12 7 4
Total Total Total
FUNCTIONS

SUM AVERAGE MAXIMUM MINIMUM


FUNCTION FUNCTION FUNCTION FUNCTION

98 96 85 85
78 25 74 45
45 14 52 12
21 15 52 14
12 18 41 50

TOTAL TOTAL TOTAL TOTAL

ANSWER ANSWER ANSWER ANSWER


ADD Subtract Divide Multiply
765 965 1650 769
754 541 50 5
965 123
854 11
751 9
Total Total Total Total Total

Create a formula in K14 to add up all the totals for


Add, Subtract, Divide and Multiply. Once you have
finished, check your answer! ANSWER
0

THE ANSWER
SHOULD BE 8248

ANSWER

You might also like