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