FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A function that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function in its formula.
A
sum function
B
countblank function
C
average function
D
min function
Explanation: 

Detailed explanation-1: -Count nonblank cells in a range by using the COUNTA function Use the COUNTA function function to count only cells in a range that contain values.

Detailed explanation-2: -SUM: This function adds all the values of the cells in the argument. AVERAGE: This function determines the average of the values included in the argument. It calculates the sum of the cells and then divides that value by the number of cells in the argument.

Detailed explanation-3: -The SUM function adds values. You can add individual values, cell references or ranges or a mix of all three. For example: =SUM(A2:A10) Adds the values in cells A2:10.

Detailed explanation-4: -In cell O9, type =AVERAGE(B9:M9) and then press Enter.

There is 1 question to complete.
Previous
Next