Excel Exercises 6-10

Exercise 6 Excel

  1. Open your work
  2. INSERT WORKSHEET
  3. Rename it “log ”
  4. Copy the following

 

A

 B

C

 D

 

1

 

base

 number

log

 

2

log

10.00

2

0.30

=log(NUMBER,BASE)

3

log

2.00

2

1.00

 

4

log

3.00

2

0.63

 

5

log

20.00

2

0.23

 
  1. Calculate number 2 for base 10,2,3,and 20
  2. Calculate the same for number 3
  3. Calculate the same for number 10
  4. Calculate the same for number 20
  5. Calculate the same for number 44.3333
  6. Save your work on the desk top under Yournameex06-10 and email it to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 06

 

Exercise 7 Excel

  1. Open your work
  2. INSERT WORKSHEET
  3. Rename it “Power”
  4. Copy the following:

 

A

 B

C

 

1

 

base

 number

 

2

power

1.00

10

=power(NUMBER,BASE)

3

 

2.00

10

 

4

 

3.00

10

 

5

 

4.00

10

 

6

 

5.00

10

 
  1. Calculate number 1.67 to the power of 2,3,4,5
  2. Calculate 22.34 to the power of 2,3,4,5
  3. Calculate 11.11 to the power of 2,3,4,5
  4. Calculate 10 to the power of 18
  5. Save your work on the desk top under Yournameex06-10 and email it to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 07

 

Exercise 8 Excel

  1. Open your work
  2. INSERT WORKSHEET
  3. Rename it “Square root”
  4. Copy the following:

 

A

 B

C

D

1

 

Number

Square root

 

2

SQRT

4

 

sqrt(NUMBER)

3

 

9

 

 

4

 

12

 

 

5

 

125

 

 

6

 

2495

 

 
  1. Find the square root of the numbers above
  2. Save your work on the desk top under Yournameex06-10 and email it to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 08

 

Exercise 9 Excel

  1. Open your work
  2. INSERT WORKSHEET
  3. Rename it “Sumofsquares”
  4. Copy the following:

 

A

 B

C

D

E

1

Array 1

Array 2

Sq of Array 1

Sq of Array 2

 

2

2

3

 

 

 

3

4

6

 

 

 

4

6

9

 

 

 

5

8

12

 

 

 

6

10

15

 

 

 

7

12

18

 

 

 

Total

 

 

 

 

1183 

Total Array 1 and 2

 

 

 

 

=SUMX2PY2(B2:B7,C2:C7)
  1. Calculate the squares of array 1
  2. Calculate the squares of array 2
  3. Sum array 1
  4. Sum array 2
  5. Sum the total of array 1 plus the total of array 2
  6. Now use the formula for the sum of the square of two arrays “=SUMX2PY2(B2:B7,C2:C7)”
  7. Save your work on the desk top under Yournameex06-10 and email it to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 09


 

Exercise 10 Excel

  1. Open your work
  2. INSERT WORKSHEET
  3. Rename it “Sumofproduct”
  4. Copy the following:

 

A

 B

C

D

E

F

1

Array 1

Array 2

Array 3

Array 4

Array 5

Array 6

2

2

3

4

5

6

7

3

4

6

8

25

30

14

4

6

9

12

75

36

21

5

8

12

16

125

42

28

6

10

15

24

225

48

35

7

12

18

36

1250

54

42

Total

 

 

 

'=SUMPRODUCT'(B2:B7,C2:C7)

 

 

 

 

 

 

                23,670,314,640.00

 

 
  1. Calculate the sum of the products of the corresponding ranges or arrays
  2. Use the formula provided
  3. Save your work on the desk top under Yournameex06-10 and email it to yourself and me at gk@fiu.edu Don't forget your subject line should have BOOTCAMP/YOUR NAME/Ex 10

     

     

 

 

Home  | Log in  |  Syllabus | Excel I Exercises | Excel II Exercises | Excel III Exercises | Excel IV Exercises | PowerPoint Exercises I |    Laptop and PC maintenance  Exercises I |  Exercises II  | Exercises III (Speed Test your connection)