FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -button appears next to the cell in which a formula error occurs, and a green triangle appears in the upper-left corner of the cell. When you click the arrow next to the button, a list of options for error checking appears. For more information, see Detect errors in formulas.

Detailed explanation-2: -If a cell contains a formula that breaks a rule that Excel uses to check for problems, a triangle appears in the top-left corner of the cell. You can prevent these indicators from displaying. On the Excel menu, click Preferences., and then clear the Enable background error checking check box.

Detailed explanation-3: -Any comments that were created in spreadsheets before today are still available and saved as “Notes”. These are shown in your spreadsheet using a black triangle in the corner of the cell to differentiate them from the new discussion-style comments.

Detailed explanation-4: -The mark is used to resize the table comprising the data, though resizing automatically occurs when data are added to a cell immediately below or to the right of the table. Before making changes to eliminate the mark, you might want to consider any advantages a table offers.

Detailed explanation-5: -A cell reference is the set of coordinates that a cell occupies on a worksheet. It identifies the location of a cell in the spreadsheet. A cell reference is always the column letter followed by the row number. For example, the first cell in the top left-hand corner of a worksheet is cell A1.