Exercise 4
Which of the following is not a Microsoft Office applications?
Access
Excel
dBase
Powerpoint
Which of the following extensions is for Rich Text Format?
.xls
.doc
.rtf
.txt
In Access database, which data type would you use for a whole number?
Decimal
Long Integer
Short Integer
Integer
What facility would you use to change a word or phrase within an application?
Search
Look for
Find and Replace
Look see
In Access, which wildcard character would you use to represent any single character?
#
?
*
@
Which of the following applications require you to highlight the data before sorting?
Microsoft Word
Microsoft Access
Microsoft Excel
Microsoft Outlook
Which of the following statements is true of an Access table?
The letter 'A' will be accepted in a Number field
The letter 'A' will be accepted in an AutoNumber field
The number '3' will be accepted in a Text field
The number '3' will be accepted in an AutoNumber field
Which of the following applications can utilise .csv files?
Microsoft Word
Microsoft Excel
Microsoft Access
All of the above
A payroll file contains data on 'Employee No.' , 'National Insurance No.' , 'Date of Birth' , 'Starting Date' , 'Hourly Pay Rate' and 'Hours Worked per Week' - how would the payroll file be sorted to show the longest serving employee at the top?
Date of Birth, Ascending
Date of Birth, Descending
Start Date, Ascending
Start Date, Descending
What could be the search criteria to include £95, £106, £165 and £300 in the results?
>100
>=100
<300
<=300
Hit the Finish Button to see how well you've done!