Answered step by step
Verified Expert Solution
Link Copied!

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Wiley CPAexcel Exam Review 2016 Study Guide January Auditing And Attestation

Authors: O. Ray Whittington

1st Edition

1119119960, 978-1119119968

More Books

Students also viewed these Accounting questions