Excel Test 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)