USING MICROSOFT EXCEL
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
5dre
|
|
|
345d
|
|
|
ek98
|
|
|
ghr3
|
Detailed explanation-1: -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".
Detailed explanation-2: -In this case we will let A = Actual Price and B = Budget Price, so our formula will be: A/B-1. This formula will be entered in cell D2. To execute the formula all we need to do is press Enter.
Detailed explanation-3: -Add numbers using cell references Type a number, such as 5, in cell C1. Then type another number, such as 3, in D1. In cell E1, type an equal sign (=) to start the formula. After the equal sign, type C1+D1.
Detailed explanation-4: -A dollar symbol ($) is used before the coordinates to correct them. For instance, $D$2 is an absolute reference to cell D2. The key F4 in Excel is a shortcut to Absolute Reference.