Spreadsheets

All of the following are functions except
1. SUM
2. MAX
3. VALUE
4. MIN
Formulas always begin with this symbol
1. *
2. =
3. /
4. @
The horizontal division of a spreadsheet is called a
1. cell
2. column
3. row
4. formula
The MIN function
1. finds the largest number in a range of cells
2. finds the sum of the numbers in a range of cells
3. finds the average of the numbers in a range of cells
4. finds the smallest number in a range of cells
Which of the following is a valid cell address for the fifth row in the second column.
1. 5-2
2. 5B
3. B5
4. 2-5
The SUM function
1. finds the largest number in a range of cells
2. finds the total of the numbers in a range of cells
3. finds the average of the numbers in a range of cells
4. finds the smallest number in a range of cells
The vertical division of a spreadsheet is called a
1. column
2. row
3. formula
4. cell
The intersection of a row and column is a
1. formula
2. cell
3. function
4. label
To arrange items in order from A to Z, you would
1. Sort descending
2. Filter
3. Sort ascending
4. Query
Which of the following is NOT a type of chart in a spreadsheet
1. Pie
2. Bar
3. Formula
4. Line
A column in a spreadsheet is identified by a
1. letter
2. number
3. value
4. label
The AVG function
1. finds the largest number in a range of cells
2. finds the sum of the numbers in a range of cells
3. finds the average of the numbers in a range of cells
4. finds the smallest number in a range of cells
Which of the following correctly denotes a range of cells
1. =A2*B2
2. (A2:A7)
3. (A2-C5)
4. (A2,A3,A4,A5)
A row in a spreadsheet is identified by a
1. letter
2. value
3. number
4. label
The MAX function
1. finds the largest number in a range of cells
2. finds the sum of the numbers in a range of cells
3. finds the average of the numbers in a range of cells
4. finds the smallest number in a range of cells
A cell address begins with a
1. value
2. number
3. letter
4. label
Which of the following would be a good application for a spreadsheet?
1. Typing a business letter
2. Comparing cell phone plans and their related costs
3. Keeping track of student names and addresses
4. Writing a school report

Spreadsheets

Quiz