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 statements accurately describes the default selection for AutoSum?

A	You must first make the selection before clicking AutoSum.
B	By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content.
C	By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
D	AutoSum does not have a default selection.

Explanation:

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

Detailed explanation-2: -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-3: -Max-Calculates the largest number in the range of cells. Min-Calculates the smallest number in the range of cells. Sum-Calculates the total of all the numbers. This is the default.

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

There is 1 question to complete.