EXCEL MULTIPLE

EXCEL MULTIPLE

EXCEL MULTIPLE

Choice Questions Excel chapter 5 1. An overcrowded Excel worksheet should be adjusted by adding blank rows and columns. a. True b. False 2. If you delete a worksheet but then decide you want it back, you can use Undo. a. True b. False 3. Formulas using SUM, AVERAGE, and other similar functions will always update automatically when you insert new rows and columns. a. True b. False 4. Excel displays _____ worksheets in a new workbook, but you can put as many in a workbook as the computer’s memory allows. a. two b. three c. four d. five 5. AutoCorrect can be used to _____.a. replace short abbreviations with long phrases b. correct all misspellings c. fix an incorrect formula d. realign cell contents.6. The Find command can be used to search for _____. a. a specific word that repeats in many cells b. a color used in formatting c. a single formula d. All answers shown are correct. 7. Hidden rows and columns do not print when you print the worksheet. a. True b. False 8. When a formula includes a reference to a hidden cell, Excel_____. a. ignores the reference and calculates the wrong result b. displays an error message c. continues to calculate the correct result d. freezes and stops working 9. To apply the vertical alignment setting named Justify,_____. a. select the command from the Ribbon’s Home tab b. select the cell and tap [Ctrl] + [J] c. you must open a dialog box d. select the command from the Ribbon’s Alignment tab 10. When you rotate text, the row height never automatically changes. a. True b. False 11. Excel’s Find command may be used to search _____. a. your entire computer b. the active worksheet or the entire workbook c. only the selected cell d. for anything except a formula. Inserting or deleting cells may cause problems because these commands alter the structure of your entire spreadsheet. a. True b. False 13. When you close the Find and Replace dialog box, Excel automatically clears all options that you set. a. True b. False