USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
if(B1>=5.0, “Go to class”, “Retest”)
|
|
|
if(B1>=5.0, Advance, Retake)
|
|
|
if(B1>=5.0, ‘Go to class’, ‘Exam’)
|
|
|
if(B1>=5.0, ‘Go to class’, “Retest”)
|
Detailed explanation-1: -For example, cells B1, B2, and B3 contain 20, 44, and 67 respectively. The formula “=SUM(B1:B3)” adds the numbers of the cells B1 to B3. It returns 131. The SUM formula automatically updates with the insertion or deletion of a value.
Detailed explanation-2: -Microsoft Excel formulas-the basics After the equal symbol, you enter either a calculation or function. For example, to add up values in cells B1 through B5, you can either: Type the entire equation: =B1+B2+B3+B4+B5.
Detailed explanation-3: -Use the IF function, one of the logical functions, to return one value if a condition is true and another value if it’s false. For example: =IF(A2>B2, "Over Budget", "OK") =IF(A2=B2, B4-A4, "")
Detailed explanation-4: -Division. To perform the division formula in Excel, enter the cells you’re dividing in the format, =A1/B1.