Excel Quiz

Question Number 1 In excel you can do everything but... A. Make charts, diagrams B. Use formulas like sum, average C. Make a database D. Use IF statements in the formula bar Question Number 2 You can save any excel document as a web page. A. True B. False Question Number 3 You can have a personalized header and footer for each page that is printed. A. True B. False Question Number 4 You cannot insert comments on each cell. A. True B. False Question Number 5 You can protect a certain worksheet and have the others full access. A. True B. False Question Number 6 What is the correct formula to calculate the total of cell B3 and B4 A. summary(b3+b4) B. =SUM B4+B3 C. =SUMMARY(B3+B4) D. =SUM(B3+B4) E. =TOTAL(B3+B4) Question Number 7 What is the correct forumla to calculate an average between cells B3 and B6? A. SUM(B3+B4+B5+B6)/4 B. =AVE(B3:B6) C. =AVERAGE(B3:B6) D. =AVERAGE(B3+B4+B5+B6)/4 E. =AVE(B3+B4+B5+B6)/4 Question Number 8 =Sheet1!D9+Sheet1!E9 A. This would select D9 and E9 and create an average from sheet2 B. This would select D9 and E9 and add the two together from sheet2 C. This would select D9 and E9 and add the two together from sheet1 D. This forumla doesn't do anything. Question Number 9 You can download content from the net directly into excel. A. True B. False Question Number 10 You can hide an entire worksheet A. True B. False