Microsoft Excel Exercise #5

Enter Here |  Excel Quiz One Search |

code y3t1- 05

Excel Passenger Worksheet
A B C D E
10       Function Y 2.0   
1                   
2 Passenger No of trips Accompaning family members Pieces of luggage Luggage charge
3 Parris 12 0 1     
4 More 4 1 2     
5 Green 2 2 3     
6 Sweeny 9 1 2     
7 Walrond 1 1 2     
8        
9    Function X 10     

All questions relate to the passenger worksheet displayed above

1) How many rows are displayed above?

2) How many columns are displayed above?

3) In which cell is the number of pieces of luggage recored for Green?

4)The range   A2 : E2    contains    labels values formulae

5) The range   B3 :B7    contains    labels values formulae

6) What is the range of cells which contains the ALL values?

7) Enter a formula in cell D9 to output 10

8) Enter a formula in cell D10 to output 2.0

9) Enter a formula in cell E3 to output Yes if a passenger has more than 2 pieces of luggage ___________