SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
Search
Test your basic knowledge |
Database And Spreadsheets
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 27 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. A field in a record that holds unique data which identifies that record from all the other records in the file or database.
Relative Reference
Mail Merge
Database Management System
Key Field
2. A program that allows you to use rows and columns of data to manage - predict - and present information.
Relative Reference
Centralized Database
Spreadsheet
Database
3. An operation that segregates items into groups according to a specified criterion
Database
Database Management System
Worksheet
Sort
4. Allows someone to change a cell's appearance; alignment - font - border - patterns - etc. as well as its numerical type; number - text - currency - percentage - etc.
Cell Format
Label
Absolute Reference
Function
5. The process of verifying that a program's input data is within the expected range
Column
Mail Merge
Data Validation
If-Then
6. A numerical quantity measured or assigned or computed
Value
Database Management System
Database
Worksheet
7. A single computer instruction that results in a series of instructions in machine language
Search
Mail Merge
Macro
Worksheet
8. To look through a data structure until a goal object is found.
Search
Mail Merge
Distributed Database
Centralized Database
9. A linear array of numbers one above another
Column
Spreadsheet
Absolute Reference
Database Management System
10. Software that allows the computer to create a database; add - change - and delete data in the database; sort the data; retrieve the data; and create forms and reports using the data in the database.
Spreadsheet
Relative Reference
Database Management System
Query
11. The workspace made up of columns and rows where you enter data to create an electronic spreadsheet
Worksheet
Search
Function
Key Field
12. A linear array of numbers side by side
VLookup
Label
Column
Row
13. Database in which the data can be spread across several smaller databases connected via telecommunications devices
Field
Sort
Database Management System
Distributed Database
14. An identifying or descriptive marker that is attached to an object
Auto-fill/Auto-complete
If-Then
Field
Label
15. A collection of fields that appear as a row in a database or table
Record
Column
Centralized Database
If-Then
16. Cell reference which remains fixed even if the cell in which the reference occurs is moving to a new location
Distributed Database
Absolute Reference
Field
Cell Format
17. Combining a document with information that personalizes it
Distributed Database
Column
Centralized Database
Mail Merge
18. Used to compare a cell value to an array of cells and return a value; used when there are more than two columns in the array (lookup table); searches for matches according to column number
Cell Format
Distributed Database
VLookup
Database
19. A high-level programming language statement that compares two or more sets of data and tests the results. If the results are true - the THEN instructions are taken; if not - the ELSE instructions are taken.
Sort
Field
Auto-fill/Auto-complete
If-Then
20. A predefined formula that performs a specific calculation using the inputs you specify.
Function
Database Management System
Data Validation
Cell
21. Database is stored in one place but used in many places at the same time. This is done to maintain consistency in the data along with many other advantages.
Auto-fill/Auto-complete
Centralized Database
Record
Field
22. A structured way to tell a database to retrieve data from one or more database tables that meet certain criteria
Centralized Database
Row
Query
Field
23. Automatically fills selected cells with data
Cell Format
Row
Auto-fill/Auto-complete
Record
24. Cell reference that adjusts to a new location when copied or moved
Key Field
Relative Reference
Search
Absolute Reference
25. The space formed by the intersection of a row and a column; the basic unit of a worksheet
Column
Centralized Database
Cell Format
Cell
26. A collection of organized data that allows access - retrieval - and use of data
Database
Function
Label
VLookup
27. (computer science) a set of one or more adjacent characters comprising a unit of information
Field
Data Validation
Distributed Database
Worksheet