Home
Arranging Information
Computing With Spreadsheets
Functions
Importing Data
Questions
References
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