title
questions

1. Which function is used to find the largest number in a range of cells?

large
sum
max
none of the above

2. The ROUND function

rounds a number to the nearest hundred
rounds a number up, away from zero
rounds a number down, toward zero
rounds a number to a specified number of digits

3. Which menu does the sort function belong to?

file
format
data
edit

4. What is the cell range for column C, row 4 to Column F, row 8

F5:C4
C4:F8
F8:C4
B5:C8

5. A simple formula to add the values in cell B2 and B3 is:

B2+B3
B3+B4
=B3+B4
none of the above

6. Which of the following is an example of absolute reference to a cell?

B7-C10
B2
B$2$
$B$2

7. Can data from the world wide web be copy and pasted straight into the spreadsheet?

true
false

8. Is Tab-delimited Data a guideline type when importing data into excel?

true
false

9. Data/lists can not be converted by a word processor?

true
false