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 the total from the adjacent cell through the first non-numeric cell using SUM function in its formula
A
AVERAGE function
B
AutoSum
C
COUNT function
D
MIN 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: -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-4: -If you need to sum a column or row of numbers, let Excel do the math for you. Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers.

Detailed explanation-5: -Which of the following features displays numerical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells? AutoCalculate displays numerical results such as SUM, AVERAGE, and COUNT on the Status bar for selected cells.

There is 1 question to complete.
Previous
Next