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.
Aptitude Tests
Latest Jobs
Nigerian Army Recruitment 2024 for Trades / Non Tradesmen & Women (87RRI)
Nigerian Agip Exploration (NAE) Limited Post Graduate Scholarship Award Scheme 2024 / 2025
Graduate Trainees at Goonite (NG) Hygiene Products FZE
Production Supervisor at Buckler Land Systems Limited
Training Manager at Buckler Systems
IT Officer / Web Developer at Fadel Minerals Nigeria Limited
Accounts Assistant at Fadel Minerals Nigeria Limited
Associate - Tax Regulatory & Insurance at Pan African Towers Limited
Human Resources Assistant at Fadel Minerals Nigeria Limited
