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.
Sales Marketer at Shulifang Biotechnology FZE
Chief Information Security Officer at Standard Chartered Bank
Research Officer at TEDxMaitama Official
Knowledge Management and Learning Senior Advisor at WaterAid
Environment Health and Safety (EHS) Operations Manager at British American Tobacco
Solar Installer at VGL Energy and Power Technology
Sales Representative at VGL Energy and Power Technology
Administrative Assistant at VGL Energy and Power Technology
Sanitation and Hygiene Coordinator at WaterAid Nigeria