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 formulas will Excel not be able to calculate?

A	=SUM(Sales)-A3
B	=SUM(A1:A5)*0.5
C	=SUM(A1:A5)/(10-10)
D	=SUM(A1:A5)-10

Explanation:

Detailed explanation-1: -Here =SUM(Sales) is incorrect if it is not name of any range.

Detailed explanation-2: -The most common reason for an Excel formula not calculating is that you have inadvertently activated the Show Formulas mode in a worksheet. To get the formula to display the calculated result, just turn off the Show Formulas mode by doing one of the following: Pressing the Ctrl + ‘ shortcut, or.

Detailed explanation-3: -The correct answer is SUBTRACT().

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: -The most likely cause of this issue is the Calculation Option mode, and it’s a critical setting that every Excel user should know about. To check what calculation mode Excel is in, go to the Formulas tab, and click on Calculation Options. This will bring up a menu with three choices.

There is 1 question to complete.