Cada pergunta deste Quiz é cronometrada.
1. If you wished to limit what you would see on an Excel worksheet, what data function would you use?
Sort
Filter
Conditional format
Data analysis
None of these
2. If you wished to highlight, not hide, some information in a worksheet because it met some criteria, what Excel tool would you use?
Table
Format
Conditional Format
3. What Excel tool allows you to create quickly and automatically summary data from a large data set?
Conditional formatting
Sorting
Pivot tables
Field lists
4. When creating a custom filer in Excel, which of the following would not be considered a Boolean operator?
If
And
Or
Not
5. What database key uniquely identifies a record within a table?
Primary key
Foreign key
Secondary key
Relational key
6. What database key links one table to another?
7. What do you create when you need to pose a question to the database?
Inquiry
Rule
Question
Query
8. Debugging tools are there to debug errors in
printers
keyboards
programs
language
9. It converts accepted instructions into machine language:
input unit
output unit
processing unit
memory unit
10. An operation in which data is moved to a different location is referred as
Block move
Street move
Delete
All of the above