FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula?

A	AVERAGE
B	AutoSum
C	COUNT
D	MAX

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: -Use the AVERAGE function to calculate the arithmetic mean. Use the MAX and MIN functions to find the highest and lowest values in a range of cells.

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

There is 1 question to complete.