Study Guide for Exam 2

Study Guide for Exam 2 - carries out a different operation....

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Study Guide for Exam 2 Spreadsheet: (36 points) Database: (20 points) Applications: (28 points) Matching: (16 points) Study Questions on Applications: 1. What is a spreadsheet and what does a spreadsheet allow me to do with the data stored in it? 2. What is a database and what does a database allow me to do with the data stored in it? 3. How do databases and spreadsheets differ? 4. What formulas do I use to produce results in a spreadsheet that: a. add (or multiply) two cell entries b. add (or multiply) three cell entries c. add (or multiply) a range of cell entries d. count the number of cells in a range that contain a number e. count the number of non-empty cells in a range f. count the number of empty cells in a range g. count cells in a range satisfying a certain criteria h. test to see if a certain condition in a spreadsheet cell is true or false. If the condition is true, the function carries out a specific operation. If the condition is false, the function
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: carries out a different operation. 5. How do I get $ or % printed in the cells of a spreadsheet? 6. How do I sort data in a spreadsheet ? in a database? 7. What is meant by primary key and secondary key when referring to sorting? 8. How do I determine the average, maximum, minimum of a range of values in a spreadsheet and a database? 9. What is meant by query in a database? What is the result of a query? 10. How do a create a query? What can I query about? 11. What ScarletApps are available? 12. What types of questions can I include in ScarletApps forms? How do these types differ from each other? 13. When a form is created the responses are displayed in a spreadsheet. What are the advantages of having the answers available in a spreadsheet? Questions on Privacy and Security will be taken from the study sheet for Privacy and Security available in Resources for that lecture topic....
View Full Document

This note was uploaded on 11/29/2011 for the course INTO TO CO 110 taught by Professor Frantrees during the Fall '11 term at Rutgers.

Ask a homework question - tutors are online