Critical Thinking Questions Case 1-1
You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment.
In the accompanying figure, the formula in cell C7 can be copied to cells C8 and C9. What Excel feature would you use to accomplish this?
A) formula painter
B) formula copier
C) fill handle
D) formula index

Question

Critical Thinking Questions Case 1-1
You have created a simple worksheet like the one in the accompanying figure to help you keep track of your available funds based on your monthly costs for rent, gas, food, and entertainment.
 In the accompanying figure, the formula in cell C7 can be copied to cells C8 and C9. What Excel feature would you use to accomplish this?
A) formula painter 
B) formula copier 
C) fill handle 
D) formula index

Quizplus · Accepted Answer

The fill handle is a feature in Excel that allows you to copy the formula in a cell to adjacent cells. Simply select the cell with the formula, click and hold on the fill handle in the bottom right corner of the cell, and drag it to the adjacent cells where you want to copy the formula. This will automatically adjust the cell references in the formula for the new location. The other options listed (formula painter and formula copier) are not recognized Excel features. Formula index is also not a recognized Excel feature.