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.
The word wrap feature ________ ...
To send a business letter to a group of contacts, you should: ...
Which tool would you use to view the calendars of your entire team at the same time? ...
What happens when dollar signs ($) are entered in a cell address? (e$B$2:$B$10) ...
In Excel, which symbol is used to specify the fixed columns or rows in the formula? ...
Steps to change the text case in a document are – You can change any text by selecting i...
A ________ is a collection of predefined design elements and color schemes. ...