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.
Customer Care Executive in a Telecommunications Company
Treasury & Risk Manager at AAA Finance and Investment Company Limited
HR and Administration Officer at CBM Global Disability Inclusion
Storekeeper at Transgeneration Enterprises Limited
Volunteer HR Manager at Sim Impacting Lives Foundation
Partnerships and Network Lead at Adewunmi Desalu Parkinson's Foundation
Account Officer at Bons Industries Limited
Manager - Sales and Trade Development, Lagos Boundary at MTN Nigeria
Permit to Work Coordinator at WTS Energy
Business Development Executive at ARCO Worldwide Services Limited