Excel Basics
What program is commonly used to create spreadsheets?
Microsoft Excel
Which function adds a range of numbers?
SUM
What feature changes the appearance of text in a worksheet?
Formatting
What is a collection of related data called?
A Database
What Access object stores data?
Table
What is the intersection of a row and a column called?
A Cell
Which function finds the average of a range?
AVERAGE
Which chart is commonly used to show parts of a whole?
Pie Chart
In a database table, what is a row called?
A Record
What Access object is used to enter and view data?
Form
What symbol must every formula begin with in Excel?
= (equals sign)
Which function returns the highest value in a range?
MAX
Which chart is useful for comparing categories?
Bar Chart or Column Chart
In a database table, what is a column called?
A Field
What Access object retrieves specific information from a database?
Query
What is the default name of the first worksheet in a new workbook?
Sheet1
Which function counts cells containing numbers?
COUNT
What feature automatically changes a cell's appearance based on its value?
Conditional Formatting
What field uniquely identifies each record in a table?
Primary Key
What Access object produces printable output?
Report
What do you call a collection of worksheets saved in one file?
A Workbook
What is the formula to multiply the values in cells A1 and B1?
=A1*B1
What tool combines and centers text across selected cells?
Merge and Center
What is the process of organizing data to reduce duplication called?
Normalization
What type of relationship allows one record in one table to relate to many records in another table?
One-to-Many Relationship