Which of the following formulas will Excel not be able to calculate?

=SUM(Sales)-A3
=SUM(A1:A5)*.5
=SUM(A1:A5)/(10-10)
=SUM(A1:A5)-10

LohaHridoy

5 views

2025-01-04 04:42

1 Answers

AhmedNazir

Answer: Option 1

SUM function returns the sum of values supplied. These values can be numbers, cell references, ranges, arrays, and constants, in any combination. Here =SUM(Sales) is incorrect if it is not name of any range.

5 views Answered 2022-09-01 13:21

Related Questions

Directions : Each of the following question consists of a statement followed by two arguments I and II. You have to decide which of the arguments is a STRONG arguments and which is a WEAK Argument. Statement : Should there be a ceiling on the salary of top executives of multinationals in our country Arguments : I. Yes. Otherwise it would lead to unhealthy competition and our own industry would not be able to withstand that. II. No. With the accent on liberalization of economy, any such move would be counter-productive. Once the economy picks up, this disparity will be reduced.?

1 Answers 5 Views

Directions : Each of the following question consists of a statement followed by two arguments I and II. You have to decide which of the arguments is a STRONG arguments and which is a WEAK Argument. Statement : Should import duty on all the electronic goods be dispensed with Arguments : I. No. This will considerably reduce the income of the government and will adversely affect the developmental activities. II. No. The local manufacturers will not be able to compete with the foreign manufacturers who are technologically far superior.?

1 Answers 4 Views

Directions : Following question consists of a statement followed by four arguments I, II, III and IV. You have to decide which of the arguments is a STRONG arguments and which is a WEAK Argument. Statement : Should all the profit making public sector units be sold to private companies Arguments : I. Yes. This will help the government to augment its resources for implementing the development programmes. II. No. The private companies will not be able to run these units effectively. III. Yes. There will be a significant improvement in the quality of services. IV. No. There would not be job security for the employees at all the levels.?

1 Answers 5 Views

Each excel file is a workbook that contains different sheets. Which of the following can not be a sheet in workbook?

1 Answers 5 Views

Which of the following Excel screen components can NOT be turned on or off?

1 Answers 6 Views

Which of the following is not true about Find and Replace in Excel?

1 Answers 4 Views

Which of the following is not a valid data type in Excel?

1 Answers 4 Views

Which area in an Excel window allows entering values and formulas?

1 Answers 4 Views

Which of the following is not a term of MS-Excel?

1 Answers 4 Views

Which of the following formulas is not entered correctly?

1 Answers 4 Views

এক্সাম দিয়ে মেধা যাচাই করুন

Job Preparation (1125)

Admission (754)

এসএসসি (10)

এইচএসসি (5)