Modifying a Worksheet (Excel 2016)
What is the default setting Excel shows when Insert is clicked? A.) shift cells right B.) shift cells down C.) entire row D.) entire column
B.) shift cells down
Sarah used the Hide command on her Excel worksheet. What would be the most likely reason to use this command? A.) Sarah hid the cells to delete them from the worksheet. B.) Sarah hid the cells to erase the formula they were part of. C.) Sarah hid the cells because the information they contained wasn't relevant to her task. D.) Sarah hid the cells to highlight their importance.
C.) Sarah hid the cells because the information they contained wasn't relevant to her task.
Use the drop-down menus to complete the steps for using the Go To feature. 1. Press the shortcut key of (F1, F4, F2, F5) 2. Type the (range, cell, name, value) in the (Go To:, Special:, Reference:, Cancel:) box. 3. Hit OK or select Special for more options.
F5 cell reference
Use the drop-down menus to complete the steps for inserting a range of cells into a worksheet. 1. Click the first cell to select, and drag to the last cell to select. 2. Click the (Home, Insert, Page Layout, View) tab. 3. In the (ranges, cells, clipboard, insert group) click (range, add, open, insert). 4. Specify whether to shift cells or insert an entire row or column, and click OK.
Home Cells Insert
Use the drop-down menus to complete the steps for using Find and Replace commands. 1. Make sure you have not selected any particular cell. 2. Under the (insert, home, review, formulas) tab, go to the (alignment, cells, editing, styles) command group. 3. Choose the (Go to, Replace, Comments, Formulas) option 4. Type in the information you want to find and what it should be replaced with. To make sure all instances are changed at once, select (Replace, Replace all, Find all, Find next)
Home Cells Replace Replace all
To adjust the height or width to fit the dialog within it, you should use these options. Click all that apply. manually drag the box to adjust the cell double-click the cell to adjust to largest size needed click the File tab and adjust click the View tab and insert size in the Home tab's Cells feature, select cell size
manually drag the box to adjust the cell double-click the cell to adjust to largest size needed in the Home tab's Cells feature, select cell size
Constance wants to run the Spelling feature to check all her worksheet at once. Place the steps in order from first to last (1-3) ___ Click the Review tab ___ Click Spelling ___ Highlight to select the cells
1. Highlight to select the cells 2. Click the Review Tab 3. Click Spelling
Marco is editing a worksheet for Hunter and doesn't understand one of the items on the sheet. What should he do to get more information? A.) Select Explore in the Insights tab. B.) Type a question in the Tell Me bar. C.) Click Find and Select to find out more information. D.) Click the File tab and Browse.
A.) Select Explore in the Insights tab.
What is the shortcut for the Find/Replace command screen? A.) F5 B.) Ctrl + ? C.) Ctrl + F D.) F4
C.) Ctrl + F
Which tab houses the Spelling feature? A.) File tab B.) Home tab C.) View tab D.) Review tab
D.) Review tab
