Modifying a Worksheet (Excel 2016)

Pataasin ang iyong marka sa homework at exams ngayon gamit ang Quizwiz!

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


Kaugnay na mga set ng pag-aaral

Chapter 9 Physical and Chemical control of microbes

View Set

067 - Chapter 67 - Inflation & Adjustment in Economics

View Set

Unit 2: Scanning Electron Microscopes

View Set

Модуль філософія

View Set