FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The data in the following Microsoft Excel table has counted a total of 4 examinees, provided that if the final score is greater than 70 then it is declared Passed. Then the correct formula for calculating cell F7 is____
A
=IF(F7>=70, “PASS", “FAILED")
B
=IF(F7>70, “PASS", “FAILED")
C
=IF(F7>=70, PASS, FAIL)
D
=IF(F7=70, “PASS", “FAILED")
Explanation: 

Detailed explanation-1: -Use the COUNT function to get the number of entries in a number field that is in a range or array of numbers. For example, you can enter the following formula to count the numbers in the range A1:A20: =COUNT(A1:A20). In this example, if five of the cells in the range contain numbers, the result is 5.

Detailed explanation-2: -You can use a simple formula to sum numbers in a range (a group of cells), but the SUM function is easier to use when you’re working with more than a few numbers. For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6.

Detailed explanation-3: -Excel data types are the four different kinds of values in Microsoft Excel. The four types of data are text, number, logical and error.

Detailed explanation-4: -Use the COUNTIF function to count numbers greater than or less than a number. A11 and A12 has formulas where COUNTIF checks for the number of invoices less than 20000 and greater than or equal to 20, 000 in the B2:B7 range. COUNTIF finds 4 values less than 20000 and 2 values greater than and equal to 20000.

There is 1 question to complete.