USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
sum
|
|
|
sumif
|
|
|
count
|
|
|
countif
|
Detailed explanation-1: -Answer. you would use count to calculate your answer!
Detailed explanation-2: -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-3: -For example you have the answers in the cell range “B15:B21”, with the formula of CountIf function, you can count number of “Yes” or ”No” answer as follows. 1. Select a blank cell, copy and paste formula =COUNTIF(B15:B21, "No") into the Formula Bar, and then press Enter key.
Detailed explanation-4: -The COUNT function is generally used to count the number of cells in Excel or array of numbers. Example: To count the numbers between A1 and A20, you may enter the following formula: =COUNT(A1:A20). For example, if the range contains three cells containing numbers, the result is 3.