Which of the following formulas will Excel not be able to...
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
Correct answer is A
Excel 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.
What is the default file name of a Microsoft Excel file? ...
Thesaurus tool in MS Word is used for ________ ...
Which of the following database objects holds data in MS Access? ...
In Excel, which symbol is used to specify the fixed columns or rows in the formula? ...
You can auto fit the width of a column in Excel by ...
What is the full form of SQL? ...