Excel Prestest Session#1
Excel Prestest Session#1
Excel Prestest Session#1
Income
-1000
30000
29000
98000
104000
2. Suppose that a product’s price changes over time. The date when the
product was sold is given. How to write a formula to compute the product’s
price?
4. Given monthly sales for several products, how to write a formula that will calculate
the sales of a product during a given month? For example, how much of product 2
was sold during June?
5. Given a list of baseball player salaries, how to write a formula that yields the player
with the highest salary? How about the player with the fifth highest salary?
6. You are thinking of advertising Microsoft products on a sports telecast. As you buy more
ads, the price of each ad drops as described in the following table.
Ads bought
22
3
7
13
0
For example, if you buy 8 ads, you pay $12,000 per ad for the first 5 ads and $11,000 for
each of the next 3 ads. If you buy 14 ads, you pay $12,000 for each of the first 5 ads, $11,000
for each of the next 5 ads, and $10,000 for each of the last 4 ads. Write a formula that yields
the total cost of purchasing any number of ads.
Student Student
exam 1 exam 2 exam 3 exam 4
names id
w 2 94 74 89 90
x 1 93 60 57 80
y 3 80 55 75 65
z 6 95 94 90 90
t 7 56 45 60 60
e 8 40 45 50 55
r 9 55 60 56 65
f 10 67 70 40 65
h 11 40 60 57 65
j 12 50 53 54 57
D. Sort the data grade wise and within same grades sort names alphabetically.