Question

1. Compute the total sale of each item at cell G3 and respectively.
2. Find out the maximum sale amount of an item at cell in the month Jan D11
3. Find out the average of complete sale of Feb at cell D13
4. Find out the minimum sale price among all the sales at cell D12.
5. Find out the mm sale price among all the sales at cell D12
6. What will be content of cell E14 if formula =E3*3 is entered.
7. What will be the content of cell B11 of formula =MAX(B3:B9) is entered

8. What will be the content of cell B12 of formula =LOWER(C7) is entered.​

Answer 1

Answer:

Formulas in Excel are basically mathematical expressions that use cell references (e.g., “A5”,” D17”) as arguments. For example, a formula that adds the contents of cell E5 and E6 could be written as follows:

= E5+E6

(Note: all formulas in Excel need to be preceded by an “=” sign.) If the values contained in E5 and E6 are 6 and 11, respectively, the formula will produce 17 as the value it displays. If you change E5 to 7, the result will automatically change to 18.

Example

Let's say you were putting together an office supply order, and you wanted to keep track of much you were spending. You could put together a spreadsheet like the one below, with the list of items to be purchased, their unit prices, the number of each item ordered, and the total spent for each. It would make sense to enter the things you know in advance (like the price of individual items and the number ordered), but you could let Excel calculate the totals for you. For the first item listed below (pencils), this could be done by making the value of the total price (cell D2), the value of the unit price (held in cell C2) multiplied by the number of items ordered (held in D2). This formula would be written "=B2*C2".