Principles Module 4
Hardware
Hardware
Four basic components of every computer
What are bus, memory, CPU, and input/output devices?
The heart of the operating system.
What is the kernel?
Provides an interface between a database and other application programs
What is a database management system?
Equations that perform calculations on value
What is a formula?
Chart best used for demonstrating percentages.
What is a pie chart?
Two major groups of general-purpose computers
What is single-user and multiple-user systems?
Two types of software
What is system software and application software?
Programming language for accessing and manipulating data in a relational database
What is Structured English Query Language (SQL)?
A formula that uses a dollar sign ($D$8) to lock cells.
What is an absolute cell reference?
Way to access to properties of a chart
What is the chart elements button?
This type of memory holds data when typing in an Excel worksheet before saving
What is RAM?
Word processing and spreadsheet processing are examples of this.
What is off-the-shelf personal application software?
In a database, an employee number is often used for this.
What is a primary key or a foreign key?
Provides quick access to tools for data analysis, chart creation, and conditional formatting
What is quick analysis tool?
The cell range of the data source
What is a chart data range?
Magnetic Ink Character Recognition (MICR) Devices are an example of this.
What is an input device?
SAP is an example of this type of software
What is Enterprise Application Software?
Eliminates the installation, maintenance, and monitoring of in-house databases
What is a Database as a Service (DAAS)?
This method is often faster than copying and pasting, which requires two distinct actions.
What is AutoFill?
This chart combines two chart types
What is a combination chart?
The number of bits that together represent a single character of data
What is eight bits = one byte?
Most Operating Systems include these three types of functionalities.
What is networking capability, access to system resources and security, and file management
A visual approach to developing database queries or requests
What is Query by Example (QBE)?
=A5:A14*B4:F4 is an example of this
Useful when you only need to convey a general impression of the data without specific details
What are sparklines?