Excel Practice Certification Test | latest 2023/24 with complete solution

Excel Practice Certification Test | latest 2023/24 with complete solution Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet? - Sheet Options Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table? - Delete In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand? - Formatting Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel? - Page Layout Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the wholesale prices column. What option should she choose? - Hide Which term describes the blank portions of a page that fall outside the main body of the printed document? - Margins Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy? - Breaks Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance? - Theme Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet? - Foramt Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change? - Print Titles John would like to remove a worksheet from his workbook. Which option should he choose? - Delete What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls? - Freeze Panes David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task? - Find and Replace What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches? - String How is an exact copy of a worksheet created within the same workbook? - Right-click the sheet tab, then choose Move or Copy from the Shortcut Menu How would you move sheet tabs to a new position in a workbook? - Click and drag the sheet tab to the new location Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose? - Tab Color John would like to change the order of the worksheets in his workbook . Which option would he choose? - Move Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose? - Freeze Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose? - Rename Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select? - Freeze Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting? - Find & Select Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which form