DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
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: -Right-click the cell and then click Insert Comment (or press Shift+F2). If you’re using Excel for Office 365, right-click the cell and choose New Note. Type your annotation text.
Detailed explanation-5: -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.