USING MICROSOFT EXCEL
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Trace arrows
|
|
|
Cell names
|
|
|
=
|
|
|
Blank cells
|
Detailed explanation-1: -It is easy to show the trace arrows in Excel. There are two trace arrow types, one is Trace Precedents arrow, and the other is Trace Dependents arrow. Select cell you need and click Formulas > Trace Precedents. Select cell you need and click Formulas > Trace Dependents.
Detailed explanation-2: -Excel Precedents Keyboard Shortcuts Trace Precedents: Press “Ctrl” followed by the square bracket “[“. The shortcut takes you to the first cell used by the active cell with the formula.
Detailed explanation-3: -In the Manage Relationships box, click New. In the Create Relationship box, click the arrow for Table, and select a table from the list. In a one-to-many relationship, this table should be on the many side.
Detailed explanation-4: -A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.