Chapter 5: Analyzing Data With Excel

 

Results

Previous
Next

#1. Which of the following is not an option in the spelling dialog box?

Previous
Next

#2. We can quickly change the appearance of your work by choosing Auto Format from the _________ Menu.

Previous
Next

#3. To protect a worksheet, we can choose protection and the protect sheet from the __________ menu.

Previous
Next

#4. We can open the highlight changes dialog box by choosing track changes from the ____________ menu.

Previous
Next

#5. To copy cell contents using drag and drop, press the _________

Previous
Next

#6. In excel the column width changes from _________ to ____________

Previous
Next

#7. It is possible to _________ the name of the cell.

Previous
Next

#8. Char(65) will return ___________

Previous
Next

#9. Form option is present in _________ menu.

Previous
Next

#10. Set of Work sheet is called as __________

Previous
Next

#11. Sort the field to use for generating ___________

Previous
Next

#12. ____________ means that excel can pull out specific records for review.

Previous
Next

#13. __________ is a tool in excel that helps you summarize many rows and columns of data into a concise report.

Previous
Next

#14. Completes a cell entry and selects the cell below

Previous
Next

#15. Moves one screen up in a worksheet

Previous
Next

#16. On an excel sheet the active cell in indicated by ?

Previous
Next

#17. You can use the horizontal and vertical scroll bars to

Previous
Next

#18. What term describes explanatory text attached to a cell ?

Previous
Next

#19. To hold row and column titles in places so that they do not scroll when you scroll a worksheet, click the

Previous
Next

#20. A function inside another function is known as ?

Previous
Next

#21. Which function calculates your monthly mortage payment ?

Previous
Next

#22. Got functions? No? You need the insert function dialog box. How do you get it?

Previous
Next

#23. Which of the following is not true regarding Conditional Formatting?

Previous
Next

#24. ?In a worksheet you can select

Previous
Next

#25. Which of the following is not an underline option in the format cells dialog box?

Previous
Finish