# FUNDAMENTALS OF COMPUTER

## USING MICROSOFT EXCEL

### HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas?
 A A5 B \$A\$5 C \$A5 D A\$5
Explanation:

Detailed explanation-1: -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-2: -Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently? The formula =B6+B7+B8+B9+B10.

Detailed explanation-3: -Which sequence will add 5 to each number in cells A1, A2, and A3? Enter 5 in cell A4. Select A4, select Ctrl+C, highlight cells A1-A3, select Ctrl+Alt+V, select Add, and then select OK.

Detailed explanation-4: -A relative cell reference in a formula will not change when the formula is copied. By default, when a cell reference is first included in a formula (so that only the column and row reference are included), it is displayed as a relative cell reference.

There is 1 question to complete.