Test your basic knowledge |

Database And Spreadsheets

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 side by side






2. Database in which the data can be spread across several smaller databases connected via telecommunications devices






3. A field in a record that holds unique data which identifies that record from all the other records in the file or database.






4. The process of verifying that a program's input data is within the expected range






5. Combining a document with information that personalizes it






6. (computer science) a set of one or more adjacent characters comprising a unit of information






7. 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.






8. Cell reference which remains fixed even if the cell in which the reference occurs is moving to a new location






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.






10. The space formed by the intersection of a row and a column; the basic unit of a worksheet






11. A single computer instruction that results in a series of instructions in machine language






12. A collection of organized data that allows access - retrieval - and use of data






13. The workspace made up of columns and rows where you enter data to create an electronic spreadsheet






14. Cell reference that adjusts to a new location when copied or moved






15. A program that allows you to use rows and columns of data to manage - predict - and present information.






16. Automatically fills selected cells with data






17. A structured way to tell a database to retrieve data from one or more database tables that meet certain criteria






18. A linear array of numbers one above another






19. To look through a data structure until a goal object is found.






20. An identifying or descriptive marker that is attached to an object






21. Allows someone to change a cell's appearance; alignment - font - border - patterns - etc. as well as its numerical type; number - text - currency - percentage - etc.






22. 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






23. A collection of fields that appear as a row in a database or table






24. A numerical quantity measured or assigned or computed






25. 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.






26. A predefined formula that performs a specific calculation using the inputs you specify.






27. An operation that segregates items into groups according to a specified criterion