Excel Questions

Excel Questions

Table of Contents
TASK 1............................................................................................................................................3
Excel Sheet Attached..............................................................................................................3
TASK 2............................................................................................................................................3
TASK 3............................................................................................................................................4
TASK 4............................................................................................................................................5
TASK 5............................................................................................................................................6

TASK 1.
Excel Sheet Attached
TASK 2
(a.) 34.2% as a fraction:
Step By Step Answer:
For conversion of 34.2 % in a fraction, consider following steps:
Step 1: Percent is to be divided by 100 as:
34.2% = 34.2/100
Step 2: Then multiplication of both top & bottom by 10 for each number after decimal points:
34.2/100 = (34.2 x 10)/(100 x 10) = 342/1000
Step 3: Simplify (or reduce) above fraction by dividing both numerator & denominator by GCD
(Greatest Common Divisor) between them. In such case, GCD(342,1000) = 2
Thus,
(342÷2)/(1000÷2) = 171/500 when reduced to simplest form.
(b.) 0.023 is equivalent to 2.3%
Steps for conversion of decimal into percentage:
 Multiply both numerator and denominator by 100
 0.023 × 100/100
 (0.023 × 100) × 1/100 = 2.3/100
 Write in percentage notation: 2.3%
(c.) 0.444444444 as a fraction in its simplest form:
0.444444444 / 1000000000
(444444444 ÷ 4) / (1000000000 ÷ 4)
111111111/250000000 when reduced to simplest form.
(d.) In a psychometric test, Joseph scored 47/63
Then in percentage it would be:
47/63 = 47 ÷ 63
74.60317 %
or 74.60%
(e.) 2.05 % = 2.05 /100 = 0.0205