Question: 5. To fill a formula down through a range: a. Double-click the upper left corner of the formula cell. b. Double-click the upper right corner

5. To fill a formula down through a range:

a. Double-click the upper left corner of the formula cell. b. Double-click the upper right corner of the formula cell. c. Double-click the lower right corner of the formula cell. d. Double-click the lower left corner of the formula cell.

6. If you want to format a cell red when debits do not equal credits, which Excel feature would be helpful?

a. Hyperlinks. b. Tables. c. Conditional Formatting. d. Data Validation.

7. Which function would add up values in the range A1:A100 but would exclude any SUBTOTAL functions in the range?

a. SUBTOTAL(9,A1:A100). b. SUM(9,A1:A100). c. SUBTOTAL(1,A1:A100). d. SUM(1,A1:A100).

8. In your worksheet, you create a skinny row and then write a formula under the skinny row. The key to using the skinny row is to make sure that the formula:

a. Includes the skinny row. b. Excludes the skinny row. c. Includes row 1 of the worksheet. d. Uses a named range.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!