DATABASE FUNDAMENTALS
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
=IF(F7>=70, “PASS", “FAILED")
|
|
|
=IF(F7>70, “PASS", “FAILED")
|
|
|
=IF(F7>=70, PASS, FAIL)
|
|
|
=IF(F7=70, “PASS", “FAILED")
|
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.