USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The cell is highlighted with a border.
|
|
|
Look at the Comments sheet.
|
|
|
The row or column will be highlighted.
|
|
|
There is a little triangle in the upper right-hand corner of the cell.
|
Detailed explanation-1: -Undo the lines. You have received a worksheet from a coworker who told you there are a number of comments you need to review. How do you first know there are comments in the worksheet? There is a little triangle in the upper right-hand corner of the cell.
Detailed explanation-2: -Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.
Detailed explanation-3: -To display an individual comment, right-click on the cell, and select Show/Hide Comments. To display all comments in the worksheet, go to the Review tab > Show all Comments.
Detailed explanation-4: -Ramesh is entering text into a worksheet, but everything he types is in capital letters. Which indicator in Excel lets him know this? The status bar will read “Caps Lock” in the lower left corner.
Detailed explanation-5: -If you accidentally delete a sheet that you wanted to keep, which action should you take? Retrieve the sheet from a saved version of the file.