FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

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]

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.