QUIZ 4 -- MICROSOFT EXCEL
FPrint this page or write answers on a sheet of paper.
1. A worksheet is better than calculations by hand because:
a. The worksheet finds the answers faster.
b. The worksheet is more accurate.
c. The worksheet recalculates the results whenever you change a number in the cell.
d. All of the above
2. The cell where the second column and third row cross has the cell address:
a. B3
b. 3B
c. C2
d. 2C
3. What will happen if you type F5+F6 into a cell without a beginning equal sign?
a. The entry is the same as the formula =F5+F6
b. The cell will display the information cell F5 plus F6
c. The entry will be treated as a text entry and F5+F6 will show in the cell.
4. The Open command:
a. Brings a workbook from a file onto the screen.
b. Brings a workbook from a file onto the screen, then erases the workbook from the file.
c. Saves the workbook on a disk or in a file.
d. Saves the workbook on a disk or in a file, then erases the workbook from the screen.
5. The save command:
a. Brings a workbook from a file onto the screen.
b. Brings a workbook from a file onto the screen, then erases the workbook from the file.
c. Saves the workbook on a disk or in a file.
d. Saves the workbook on a disk or in a file, then erases the workbook from the screen.
6. The entry =(A4+A5+A6)/3:
a. Will not work.
b. Finds the total of cells A4, A5, and A6.
c. Finds the average of cells A4, A5, and A6.
7. If cell A1=10 and cell A2=5, what number will show in a cell with the following formula:
=A1*A2.
a. 15
b. 5
c. 20
d. 50
8. If cell A1=10 and cell A2=5, what number will show in a cell with the following formula:
=A1+A2
a. 15
b. 5
c. 20
d. 2
9. If cell A1=10 and cell B1=10, what number will show in a cell with the following formula:
=(A1+B1)/2
a. 9
b. 12
c. 8
d. 10
10. If cell A1=22 and cell B1=10, what number will show in a cell with the following formula:
=A1-B1
a. 9
b. 10
c. 12
d. 8
11. What type of chart is this?
a. bar
b. column
c. area
d. pie
[Home] [Welcome Page] [Curriculum] [Requirements] [Useful Information] [Dictionary/Thesaurus] [Test Your Knowledge] [Keyboarding Test] [Calendar] [Virus Info] [Links] [Contact]