A basic knowledge of Microsoft Office applications such as MS Word, MS Excel and MS PowerPoint is often required for most jobs. Practise and prepare for your aptitude test with these frequently asked MS Office questions and answers.
Foreign key
Native key
Composite key
Primary key
Correct answer is A
No explanation has been provided for this answer.
required when a table does not have any unique fields in it
the primary key with AutoNumber as the field type
made up of two or more fields to uniquely identify records
is a foreign key that uniquely identifies records
Correct answer is C
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.