[Solved]-Uale Use Find Go Navigate Workbook Excel S Go Feature Allows User Switch Different Open Wo Q37165428

Are my answers correct?

Uale. Use Find and Go To to Navigate a Workbook Excel’s Go To feature allows the user to switch between different open workbooks. 1. True B. False Excel’s Go To feature will show up to 4 recently used cell locations. 2. A. True B. False Which of the following are available features when using Find in Excel? 3. A. The results show the exact cell location in which the item is found. B. It is possible to search through the entire workbook, rather than just individual worksheets. C. It is possible to search for specific formatting. D. It is possible to search for either formulas or values. E. All of these features are available. Vivica is working on a workbook she’s created to help her track business purchases she makes. The workbook is getting larger and larger, and she’d like to figure out a way to quickly navigate to different parts of the workbook, rather than scrolling or switching around between worksheets. Which of the following methods will provide Vivica with the navigation shortcuts she’s looking for? 4. A. Type the cell reference or cell name into the Name Box. B. Open the Go To dialog box and select the desired cell’s reference or name. C. Open the Find and Replace dialog box and type in a word or words in the desired cell. D. All of these options will work. Create Hyperlinks for Navigation A hyperlink is a piece of text or a graphic that takes the user to another location when clicked. 5. A. True B. False Page 1 of 5 Excel 2016 Which of the following hyperlink types is not an external source type? 6. A. File B. Web page Ils in a Workbook D. Email Address Which of the following statements about hyperlinks is true? 7. A. You may create hyperlinks in Excel worksheets that work just like the ones on web pages. Hyperlinks help others navigate to important data items or to documents outside the workbook. You create links with the Hyperlink command on the Ribbon. All of these statements are true. B. C. D. 8. Eitch these hyperlink types with the examples of their destinations. A. To a cell in another worksheet B. To another file C. To a web page D. To an email address 2 4 1. smith@simp.com 2. Sheet1!B13 3. criminidly.com 4. Family Budget.xlsx Insert Comments 9. A comment is specific to a cell; you cannot assign a comment to a range of cells. A. True B. False 10. Once a comment box is created, it is not possible to resize it. A. True B. False 11. Jimmy is working with a colleague on a spreadsheet. He’d like to use Excel’s collaborative tools as efficiently as possible. When might Jimmy insert a comment? A. To ask a direct question if his colleague is online To document the formula or value in a cell To record a question to be followed up later All of these options B. C. D. : 12. Match the following functions with their commands in the Comments section of the Ribbon’s Review tab. A. Navigate to the previous comment 3 B. Delete the selected comment C. Navigate to the next comment D. Edit the selected comment 2 4 Add Alt Text to Objects 13. Alt text refers to holding the [Alt] key while typing in order to insert a hyperlink. A. True B. False 14. Adding alt text can be done through the Navigation pane. A. True B. False 15. Alt text can be added to which of the following graphic objects in Excel? A. Pictures B. Charts C. Shapes D. Tables E. All of these options Inspect Your Workbook 16. Some content removed through the Document Inspector cannot be restored. A. True B. False 17. When running the Compatibility Checker, you can select which version of Excel to use in the check or just check all versions since 1997. A. True B. False 18. Miranda is finishing up an Excel file she plans to submit to her teacher. However, one of the requirements for the assignment is that a fellow student double-check the material before it is submitted to the teacher. Why is it a good idea for Miranda to run the Inspect Document feature before sending her file to another student? A. It will check for compatibility issues. B. It will check for any sensitive personal information. C. It will check for any accessibility issues. D. All of these options 19. When inspecting a workbook for personal information and hidden data, which of the following will be found in the search? A. Hidden worksheets, rows, and columns B. Comments in cells C. Headers and footers D. All of these options will be found in the search Protect Your Workbook 20. Turning on Protect Workbook Structure will prevent users from making changes to individual cells on a worksheet. A. True B. False 21. A document is marked as final when the Mark as Final icon is displayed on the status bar. A. True B. False 22. Tarig has created a spreadsheet to track the payments he makes on both of his cars. Because the spreadsheet contains sensitive information, he decided to encrypt it with a password. Now he’s forgotten his password and is unable to open the spreadsheet. What can Tariq do to recover the information on this spreadsheet? A. He can hold (Ctrl] while opening the document to bypass the password requirement. B. He can deselect the Protect Worksheet button on the Ribbon. C. He can run a Save As on the document, which will remove the password requirement. D. He cannot recover it. 23. Sophie has completed a worksheet she plans to distribute to her colleagues to make their required daily reports easier to complete. She wants her colleagues to be able to add and format columns and rows, select cells she hasn’t locked, and format cells. She doesn’t want them to be able to do anything else. Which of the following Protect Sheet dialog box options will provide Sophie with what she is looking for? Pretect Sheet A. Pretet Shee B. C. D. Show transcribed image text Uale. Use Find and Go To to Navigate a Workbook Excel’s Go To feature allows the user to switch between different open workbooks. 1. True B. False Excel’s Go To feature will show up to 4 recently used cell locations. 2. A. True B. False Which of the following are available features when using Find in Excel? 3. A. The results show the exact cell location in which the item is found. B. It is possible to search through the entire workbook, rather than just individual worksheets. C. It is possible to search for specific formatting. D. It is possible to search for either formulas or values. E. All of these features are available. Vivica is working on a workbook she’s created to help her track business purchases she makes. The workbook is getting larger and larger, and she’d like to figure out a way to quickly navigate to different parts of the workbook, rather than scrolling or switching around between worksheets. Which of the following methods will provide Vivica with the navigation shortcuts she’s looking for? 4. A. Type the cell reference or cell name into the Name Box. B. Open the Go To dialog box and select the desired cell’s reference or name. C. Open the Find and Replace dialog box and type in a word or words in the desired cell. D. All of these options will work. Create Hyperlinks for Navigation A hyperlink is a piece of text or a graphic that takes the user to another location when clicked. 5. A. True B. False Page 1 of 5 Excel 2016
Which of the following hyperlink types is not an external source type? 6. A. File B. Web page Ils in a Workbook D. Email Address Which of the following statements about hyperlinks is true? 7. A. You may create hyperlinks in Excel worksheets that work just like the ones on web pages. Hyperlinks help others navigate to important data items or to documents outside the workbook. You create links with the Hyperlink command on the Ribbon. All of these statements are true. B. C. D. 8. Eitch these hyperlink types with the examples of their destinations. A. To a cell in another worksheet B. To another file C. To a web page D. To an email address 2 4 1. smith@simp.com 2. Sheet1!B13 3. criminidly.com 4. Family Budget.xlsx Insert Comments 9. A comment is specific to a cell; you cannot assign a comment to a range of cells. A. True B. False 10. Once a comment box is created, it is not possible to resize it. A. True B. False 11. Jimmy is working with a colleague on a spreadsheet. He’d like to use Excel’s collaborative tools as efficiently as possible. When might Jimmy insert a comment? A. To ask a direct question if his colleague is online To document the formula or value in a cell To record a question to be followed up later All of these options B. C. D.
: 12. Match the following functions with their commands in the Comments section of the Ribbon’s Review tab. A. Navigate to the previous comment 3 B. Delete the selected comment C. Navigate to the next comment D. Edit the selected comment 2 4 Add Alt Text to Objects 13. Alt text refers to holding the [Alt] key while typing in order to insert a hyperlink. A. True B. False 14. Adding alt text can be done through the Navigation pane. A. True B. False 15. Alt text can be added to which of the following graphic objects in Excel? A. Pictures B. Charts C. Shapes D. Tables E. All of these options Inspect Your Workbook 16. Some content removed through the Document Inspector cannot be restored. A. True B. False 17. When running the Compatibility Checker, you can select which version of Excel to use in the check or just check all versions since 1997. A. True B. False
18. Miranda is finishing up an Excel file she plans to submit to her teacher. However, one of the requirements for the assignment is that a fellow student double-check the material before it is submitted to the teacher. Why is it a good idea for Miranda to run the Inspect Document feature before sending her file to another student? A. It will check for compatibility issues. B. It will check for any sensitive personal information. C. It will check for any accessibility issues. D. All of these options 19. When inspecting a workbook for personal information and hidden data, which of the following will be found in the search? A. Hidden worksheets, rows, and columns B. Comments in cells C. Headers and footers D. All of these options will be found in the search Protect Your Workbook 20. Turning on Protect Workbook Structure will prevent users from making changes to individual cells on a worksheet. A. True B. False 21. A document is marked as final when the Mark as Final icon is displayed on the status bar. A. True B. False 22. Tarig has created a spreadsheet to track the payments he makes on both of his cars. Because the spreadsheet contains sensitive information, he decided to encrypt it with a password. Now he’s forgotten his password and is unable to open the spreadsheet. What can Tariq do to recover the information on this spreadsheet? A. He can hold (Ctrl] while opening the document to bypass the password requirement. B. He can deselect the Protect Worksheet button on the Ribbon. C. He can run a Save As on the document, which will remove the password requirement. D. He cannot recover it.
23. Sophie has completed a worksheet she plans to distribute to her colleagues to make their required daily reports easier to complete. She wants her colleagues to be able to add and format columns and rows, select cells she hasn’t locked, and format cells. She doesn’t want them to be able to do anything else. Which of the following Protect Sheet dialog box options will provide Sophie with what she is looking for? Pretect Sheet A. Pretet Shee B. C. D.

Expert Answer

---

Answer to Uale. Use Find and Go To to Navigate a Workbook Excel’s Go To feature allows the user to switch between different open w… . . .