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.
What symbol is used before a number to make it a label in Excel?
” ( quote )
= ( equal )
_ ( underscore )
‘ ( apostrophe )
Correct answer is D
An apostrophe before a cell value forces Excel to interpret the value as label. This is mostly useful for values that look like a number or date.
Which of the following is an absolute cell reference in Excel?
!A!1
$A$1
#a#1
A1
Correct answer is B
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.
Right clicking something in Excel
Deletes the object
Nothing. The right mouse button is there for left handed people
Opens a shortcut menu listing everything you can do to the object
Selects the object
Correct answer is C
No explanation has been provided for this answer.
Store Manager at Xpedient Services
Assistant Accountant at Qatar Charity Organization
Civil Engineer at Emmaking Construction Limited
Financial Analyst at Fosad Consulting Limited
Logistics Supervisor at Médecins Sans Frontieres (MSF)
Research Program Manager at Rekrut Consulting
Graphics Designer / Digital Marketer at Meritabode Nigeria Limited
Chinese Translator at Lifemate Nigeria Limited
Social Media Specialist at Globe Medical International Limited