Title: Spreadsheets
Course: Technology Applications

Q: A spreadsheet program displays data in a special document, called a _____.
- data column (Incorrect)
- work table (Incorrect)
- worksheet (Correct)
- master table (Incorrect)
A: worksheet

Q: Before you format a cell, you should do this to it.
- enter data in it (Incorrect)
- select it (Correct)
- delete it (Incorrect)
- none of the above (Incorrect)
A: select it

Q: How do you select an entire column of cells in a worksheet?
- click any cell in the column one time (Incorrect)
- click the column's heading one time (Correct)
A: click the column's heading one time

Q: This term refers to the typeface used for data in worksheet cells.
- point (Incorrect)
- style (Incorrect)
- font (Correct)
- text (Incorrect)
A: font

Q: To show this type of number in a worksheet, you should enter it inside parentheses so the data appears correctly.
- currency (Incorrect)
- percentage (Incorrect)
- decimal (Incorrect)
- negative (Correct)
A: negative

Q: Which of the following is easily formatted with background colors or a border?
- cell (Correct)
- text (Incorrect)
- currency (Incorrect)
- font (Incorrect)
A: cell

Q: To change a column's width, you can drag this.
- its heading's right edge (Correct)
- its border line (Incorrect)
A: its heading's right edge

Q: To change a worksheet's name, double-click this.
- tab (Correct)
- frame (Incorrect)
- heading (Incorrect)
- none of the above (Incorrect)
A: tab

Q: The automatic summing feature is usually controlled by an icon with this symbol.
- y (Incorrect)
- P (Incorrect)
- $ (Incorrect)
- å (Correct)
A: å

Q: This type of chart shows changes over time emphasizing fixed points in time.
- column (Correct)
- bar (Incorrect)
- line (Correct)
- pie (Incorrect)
A: column; line

Q: This type of chart shows different parts in relation to the whole.
- column (Incorrect)
- bar (Incorrect)
- line (Incorrect)
- pie (Correct)
A: pie

Q: Which of the following is a commonly used function in Microsoft® Excel?
- AVERAGE (Incorrect)
- COUNT (Incorrect)
- SUM (Incorrect)
- all of the above (Correct)
A: all of the above

Q: This term refers to the rules of wording, which govern which tell how a spreadsheet function/formula must be written.
- syntax (Correct)
- argument (Incorrect)
- keyword (Incorrect)
A: syntax

Q: In a function, a symbol such as the equal sign = means “the beginning of a formula”. The name or term for this is the function's _____.
- name (Incorrect)
- identifier (Correct)
- keyword (Incorrect)
- argument (Incorrect)
A: identifier

Q: In a spreadsheet program, a group of cells is called a _____.
- series (Incorrect)
- reference (Incorrect)
- range (Correct)
- chart (Incorrect)
A: range

Q: This term describes a cell reference that changes when it is copied or moved.
- absolute (Incorrect)
- relative (Correct)
A: relative

Q: This type of cell reference does not change when you copy or move it.
- absolute (Correct)
- relative (Incorrect)
A: absolute

Q: This is a question you ask a database in order to get the information or data you need.
- query (Correct)
- form (Incorrect)
- filter (Incorrect)
- option (Incorrect)
A: query

Q: Match each word or phrase with the correct definition.
- bold or italic | type style
- a group of cells | range
- a spreadsheet table | worksheet
- a program | spreadsheet
- the first step in formatting | select the data

Q: Match each word or phrase with the correct definition.
- position | alignment
- typeface | font
- bold or italic | style
- type size | point
- appearance | format

Q: Match each word or phrase with the correct definition.
- spreadsheets do this automatically | chart
- shows different amounts of the same item | bar chart
- shows different parts in relation to the whole | pie chart
- shows changes over time emphasizing fixed points in time | column chart
- shows changes over time on an ongoing basis | line chart

Q: Match each word or phrase with the correct definition.
- rules for writing functions | syntax
- data used by a function | argument
- a function\'s name | keyword
- a built-in formula | function
- could be @ or = | identifier