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 linear array of numbers one above another
Sort
Column
Function
Centralized Database
2. A structured way to tell a database to retrieve data from one or more database tables that meet certain criteria
If-Then
Cell
Query
Spreadsheet
3. Combining a document with information that personalizes it
Label
VLookup
Centralized Database
Mail Merge
4. Automatically fills selected cells with data
Auto-fill/Auto-complete
Value
Centralized Database
Spreadsheet
5. A collection of fields that appear as a row in a database or table
Worksheet
Sort
VLookup
Record
6. An operation that segregates items into groups according to a specified criterion
Database
Sort
Field
Cell Format
7. 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
Function
Label
Centralized Database
8. A program that allows you to use rows and columns of data to manage - predict - and present information.
Macro
Row
Function
Spreadsheet
9. Cell reference which remains fixed even if the cell in which the reference occurs is moving to a new location
Auto-fill/Auto-complete
Absolute Reference
Sort
Row
10. A numerical quantity measured or assigned or computed
Label
Value
Auto-fill/Auto-complete
Worksheet
11. 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.
Database Management System
Mail Merge
VLookup
Absolute Reference
12. A field in a record that holds unique data which identifies that record from all the other records in the file or database.
Field
Cell
Key Field
Centralized Database
13. A linear array of numbers side by side
Macro
Auto-fill/Auto-complete
If-Then
Row
14. A predefined formula that performs a specific calculation using the inputs you specify.
Function
Search
Absolute Reference
Distributed Database
15. Database in which the data can be spread across several smaller databases connected via telecommunications devices
Worksheet
Distributed Database
Query
Mail Merge
16. The space formed by the intersection of a row and a column; the basic unit of a worksheet
Worksheet
Cell
Query
Centralized Database
17. The workspace made up of columns and rows where you enter data to create an electronic spreadsheet
Worksheet
Cell Format
Sort
Macro
18. 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.
If-Then
Key Field
Database
Value
19. A single computer instruction that results in a series of instructions in machine language
Macro
Key Field
Sort
Data Validation
20. A collection of organized data that allows access - retrieval - and use of data
Cell Format
Database
Function
Auto-fill/Auto-complete
21. (computer science) a set of one or more adjacent characters comprising a unit of information
If-Then
Mail Merge
Macro
Field
22. To look through a data structure until a goal object is found.
Search
Function
If-Then
Auto-fill/Auto-complete
23. An identifying or descriptive marker that is attached to an object
Macro
Label
Centralized Database
Database Management System
24. Allows someone to change a cell's appearance; alignment - font - border - patterns - etc. as well as its numerical type; number - text - currency - percentage - etc.
Mail Merge
Value
Cell Format
VLookup
25. The process of verifying that a program's input data is within the expected range
Distributed Database
Field
Data Validation
VLookup
26. 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
Value
If-Then
Absolute Reference
VLookup
27. Cell reference that adjusts to a new location when copied or moved
Cell Format
Label
Search
Relative Reference