DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
What cell reference should you enter if you want to create a formula that refers to cell A3 on the Expenses worksheet?
|
|
Expenses!A3
|
|
|
Exp!A3
|
|
|
ExpensesA3
|
|
|
Expenses!A3!
|
Explanation:
Detailed explanation-1: -By default, a cell reference is a relative reference, which means that the reference is relative to the location of the cell. If, for example, you refer to cell A2 from cell C2, you are actually referring to a cell that is two columns to the left (C minus A)-in the same row (2).
Detailed explanation-2: -A formula always begins with an equal sign (=). Excel for the web interprets the characters that follow the equal sign as a formula.
Detailed explanation-3: -Enter a formula in cell B7 to calculate the average value of cells B2:B6. On the Home tab, in the Editing group, click the AutoSum button arrow and select Average. Press Enter.
There is 1 question to complete.