Computer Basics
Productivity Programs
Word Processing Basics
Spreadsheet Basics
Database Basics
100
It is a pointing device that is an alternative to a mouse.
What is a trackball.
100
They use the computer to enter and maintain records.
What does an information worker do?
100
• They help store large volumes of data. • They help you organize data in an easy to access format.
What do database programs do?
100
It's a file which contains one or more spreadsheets.
What is a workboook?
100
• Tables - Stores data in rows and columns. • Queries - Retrieve and process data. • Forms - Control data entry and data views. • Reports - Summarize and print data.
What are the 4 main objects that a database contains?
200
• Moniter - It is used to display information in visual form, using text and graphics. • Printer - It is a device that you use to transfer text and images from a computer to a paper. • Speaker/Headphone - It is a device that allows you to hear sounds.
What are some output devices?
200
It is internally represented in the form of 0s and 1s.
What happens after the computer stores data in the memory?
200
Graphical User Interface.
What does GUI stand for?
200
They begin with an equal (=) sign.
What do formulas begin with?
200
It defines the value of a cell.
What is the function of a data type?
300
Their function is to improve the performance of your computer and enhances its features.
What is the function of an expansion card?
300
• LAN - A LAN connects devices within a limited area, such as a home or a small group of offices. • WAN - A WAN is a network that connects devices in geographically separated areas.
What are the 2 types of networks?
300
• Workbook and worksheets. • Rows and Columns • Cell • Status Bar
What are the parts of a spreadsheet program?
300
• Sum - Used to add numbers in a range. • Average - Indicates the average number in a range. • Minimum - Indicates the low value in a range. • Maximum - Indicates the high value in a range.
What are the 4 different types of functions in a spreadsheet program?
300
• Field size • Format • Input mask • Caption
What are the 4 field properties?
400
It controls and manages the hardware connected to your computer. It provides an interface that helps you to interact with the computer.
What is an operating system?
400
It's the brain of the computer and its speed is an important factor that affects the overall performance of the computer.
What is a CPU?
400
When you need to print multiple slides from your presentation on one page.
When do you select the Handouts option on the Print dialog box?
400
It's an object that explains the symbols, colors, or patterns used to differentiate the data.
What is a Legend?
400
1. Plan the structure of the database. 2. Open and save a new database. 3. Create a table. 4. Enter the field names. 5. Enter the data.
What are the 5 steps in creating a database?
500
• Desktop Computers • Laptop Computers • Handheld Computers • Tablet Computers
What are 4 types of computers?
500
• Word-processing and publishing programs • Presentation programs • Spreadsheet programs • Database programs • Graphics programs
What are the 5 types of productivity programs?
500
You use it to store, edit, and format information.
What can you use database programs for?
500
• Parentheses • Exponents • Multipication • Division • Addition • Subtraction
What is the Order of Operations?
500
They should have a seperate table for every major subject, such as employee records and customer orders.
What should all databases have?