Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started