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 the total adjacent cell through the first nonnumeric cell using the SUM function
A
AutoSum
B
MAXfunction
C
SUMfunction
D
COUNTfunction
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: -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-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.
Previous
Next