Which of the following is not valid version of Microsoft Office?
Office 2007
Office Vista
Office 2016
Office 365
Correct answer is B
No explanation has been provided for this answer.
Which of the following is Microsoft Office Suite's software program?
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
All of the above
Correct answer is D
No explanation has been provided for this answer.
Which of the following options is not available in Excel Paste Special dialog box?
Add
Subtract
Divide
SQRT
Correct answer is D
To use options from the Paste Special box, click Home > Paste > Paste Special.
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.
Which of the following formulas is not entered correctly?
=10+50
=B7*B1
=B7+14
10+50
Correct answer is D
A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.
Here in option D 10+50 there is no equal sign (=), so it is not correct.
Aptitude Tests