USING MICROSOFT EXCEL
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: -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-2: -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.
Detailed explanation-3: -In a formula, a % sign designates that a cell in a formula is an absolute.
There is 1 question to complete.