A Spreadsheet Developer Enters the Formula "=B9*$B$10" into Cell C1

question 27

Multiple Choice

A spreadsheet developer enters the formula "=B9*$B$10" into cell C1. If this formula is copied and then pasted into cell D2, what will the formula in cell D2 be?

• A) =B9*$B$10
• B) =C9*C10
• C) =$C$10*$C$11
• D) =B9*$B$11
• E) =C10*$B$10

---

Definitions:

Big Data

Information collected in massive amounts and at unprecedented speed from both traditional and digital sources that is used in business decision making; complex structured or unstructured sets of information that traditional processing applications are unable to analyze.

Structured

Organized in a predictable, efficient, and systematic manner to facilitate processes, projects, or information management.

Unstructured

Refers to data or information that doesn't have a pre-defined model or organization, making it difficult to process and analyze without specialized tools.

Unicorn

In a business context, a unicorn refers to a privately held startup company valued at over $1 billion.