91Ó°ÊÓ

Use the spreadsheet below to answer Exercises 12–16. $$\begin{array}{|c|c|c|c|c|c|c|c|c|}\hline { } & {\text { A }} & \text{ B } & \text{ C } & \text{ D } & \text{ E } & {\text { F }} & \text{ G } & \text{ H } \\\ \hline {}&{}&{}&{ \text{April } 25}&{}&{}&{\text{April } 24}&\text{Volume in}&\text{Volume in} \\ 1 & \text { Symbol } & {\text { Stock }} & \text { Last } & \text { Change } & \text { % Change } & \text { Close } & {1,000 \text{s}} & {100 \text{s}} \\ \hline 2 & \text { AAPL } & {\text { Apple Inc }} & {169.73} & { 0.79 } & {} & {168.94} & {35,445} & {} \\ \hline 3 & \text { BBW } & {\text { Build-A-Bear }} & {10.15} & {1.15} & {12.78} \text {%} & {} & {616} & {} \\ {} & {} & {\text { Workshop Inc }} & {} & {} & {} & {} & {} & {} \\ \hline 4 & \text { CTB } & {\text { Cooper Tire & }} & {14.7} & {?1.82} & {} & {16.52} & {2,671} & {} \\ {} & {} & {\text { Rubber Co }} & {} & {} & {} & {} & {} & {} \\ \hline 5 & \text { F } & {\text { Ford Motor Co }} & {7.5} & {?0.9} & {} & {} & {227,269} & {} \\ \hline 6 & \text { INTC } & {\text { Intel Corp }} & {22.56} & {} & {?0.57 \text {%}} & {} & {47,604} & {} \\\ \hline 7 & \text { MSFT } & {\text { Microsoft Corp }} & {29.83} & {} & {?6.19 \text {%}} & {31.80} & {145,194} & {} \\ \hline 8 & \text { NTGR } & {\text { NETGEAR Inc }} & {16.76} & {?3.37} & {?16.74 \text {%}} & {} & {8,085} & {} \\ \hline 9 & \text { YHOO } & {\text { Yahoo! Inc }} & {26.8} & {} & {?1.83 \text {%}} & {} & {50,523} & {} \\ \hline \end{array}$$ Write a formula that will convert the volume given in 1,000s into a volume given in 100s. Use the left side of the equation to indicate in which cell to store the formula. a. Intel Corp \(\quad\) b. Yahoo! Inc

Step by step solution

01

Understand cell reference:

For Intel Corp, we can see from the spreadsheet that it is on row 6 (6th row from the top) and the volume in 1,000s is in column G. Thus, the cell reference for volume for Intel Corp is G6. Similarly, the volume in 1,000s for Yahoo! Inc is in cell G9.

02

Create conversion formula:

To convert a volume from 1,000s to 100s, you can multiply by 10. Therefore, the formula will be current cell value * 10.

03

Intel Corp formula:

Insert the formula in H6 (the corresponding cell for volume in 100s) for Intel Corp. The new value for Intel Corp will be =G6*10.

04

Yahoo! Inc formula:

Same way, in cell H9, insert the formula for Yahoo! Inc which will be =G9*10.

Unlock Step-by-Step Solutions & Ace Your Exams!

• Full Textbook Solutions

  Get detailed explanations and key concepts

• Unlimited Al creation

  Al flashcards, explanations, exams and more...

• Ads-free access

  To over 500 millions flashcards

• Money-back guarantee

  We refund you if you fail your exam.

Over 30 million students worldwide already upgrade their learning with 91Ó°ÊÓ!

Key Concepts

These are the key concepts you need to understand to accurately answer the question.

Spreadsheet Calculations

Spreadsheets are powerful tools widely used in various fields for performing calculations, data analysis, and visualization. In educational environments, they are essential for teaching quantitative reasoning and arithmetic skills. A spreadsheet consists of a grid of cells arranged in rows and columns, where each cell can contain a number, text, or a formula. Spreadsheet calculations involve creating formulas that can perform operations like addition, subtraction, multiplication, or more complex functions, allowing users to automate data processing tasks.

Formulas in a spreadsheet are expressions that calculate the value of a cell based on the contents of other cells. For instance, to calculate the percentage change in a stock price, you could use a formula that divides the price change by the starting price and then multiplies the result by 100 to get the percentage. Spreadsheets can update calculations automatically when the input data changes, making them efficient for tasks like budgeting, forecasting, or data analysis where figures often fluctuate.

Cell Reference in Spreadsheets

Understanding cell referencing is crucial when working with spreadsheets. Cell references allow formulas to use the data contained in different cells of the spreadsheet. There are basically two types of cell references: relative and absolute. A relative cell reference, like A1, changes when a formula is copied to another cell, adjusting the reference to the new cell's location. This implies that if you copy a formula with the reference A1 to the right, it adjusts to B1.

An absolute cell reference, on the other hand, like \(A\)1, does not change when the formula is copied. It's a fixed point of reference. This distinction is essential when replicating formulas across multiple cells. For the exercises given in the problem, the student would be utilizing relative cell references (e.g., G6 and G9 for Intel Corp and Yahoo! Inc, respectively), because the exercise involves referencing the cell that contains the relevant data for the volume in 1,000s to calculate the volume in 100s.

Conversion Formula

A conversion formula in spreadsheets is a mathematical expression that changes data from one unit to another. This is frequently needed when working with different measurement systems or when trying to standardize data. In the example provided, the volume data in the spreadsheet need to be converted from 1,000s (thousands) to 100s (hundreds). To perform this unit conversion, a simple formula that multiplies the cell containing the volume in thousands by 10 is used.

This calculation is straightforward because it's based on the relationship between the units: since 1,000 is ten times 100, multiplying by 10 effectively shifts the volume into the desired unit measure. When writing the formula, it's important to ensure that the formula is placed in the correct cell to reflect the updated values accordingly. For example, if Intel Corp's volume in 1,000s is in cell G6, one would write the formula '=G6*10' in the corresponding cell for volume in 100s.