FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

What can you use to show the relationship between formulas and the cells they reference?

A	Trace arrows
B	Cell names
C	=
D	Blank cells

Explanation:

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: -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.

Detailed explanation-4: -Tracer arrows are arrows that can help you to understand the flow of data on a worksheet and can help you to understand formulas that contain lots of cell references. These can be used to help understand and visualise the relationships between cells.

There is 1 question to complete.