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 formula that calculates (by default) the total from the adjacent cell through the first nonnumeric cell using the SUM function.
A
count function
B
autosum
C
sum function
D
count function
Explanation: 

Detailed explanation-1: -By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.

Detailed explanation-2: -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-3: -The Autosum Excel Function[1] can be accessed by typing ALT + the = sign in a spreadsheet, and it will automatically create a formula to sum all the numbers in a continuous range.

Detailed explanation-4: -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.

There is 1 question to complete.
Previous
Next