Excel Final Exam Review (Excel Crash Course) Q&A

Excel Final Exam Review (Excel Crash Course) Q&A Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings? - CORRECT ANSWER-B. Show Which of the following notebook- like features organizes the sheets for use in Excel? - CORRECT ANSWER-A. Workbook Which view enables a user to create or modify a worksheet while seeing how it will look in printed format? - CORRECT ANSWER-A. Page Layout Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel? - CORRECT ANSWER-B. Worksheet John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option? - CORRECT ANSWER-B. Split Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet? - CORRECT ANSWER-B. Ctrl + End What occurs when the cursor is moved over a cell and a user clicks? - CORRECT ANSWER-B. The cell is selected Which tab do you use to display the area that contains the print command? - CORRECT ANSWER-D. File Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell? - CORRECT ANSWER-C. Name box Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands? - CORRECT ANSWER-A. Quick Access Toolbar(QAT) Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? - CORRECT ANSWER-B. Open Joan has a table that includes demographic information about her employees. What does all the information about one employee represent? - CORRECT ANSWER-C. Row Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data? - CORRECT ANSWERC. Excel Which view is the default view used in Microsoft Excel? - CORRECT ANSWER-C. Normal Which ribbon option opens a related dialog box? - CORRECT ANSWER-C. Launcher What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility? - CORRECT ANSWER-D. Zoom to Selection