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
Get step-by-step solutions from verified subject matter experts
