# Test Bank for Business Analytics, 2/E 2nd Edition James R. Evans

**ISBN-10: 0321997824
ISBN-13: 9780321997821**

*For undergraduate or graduate business students.*

**A balanced and holistic approach to business analytics**

**Business Analytics, Second Edition** teaches the fundamental concepts of the emerging field of business analytics and provides vital tools in understanding how data analysis works in today’s organizations. Students will learn to apply basic business analytics principles, communicate with analytics professionals, and effectively use and interpret analytic models to make better business decisions. Included access to commercial grade analytics software gives students real-world experience and career-focused value. Author James Evans takes a balanced, holistic approach and looks at business analytics from descriptive, and predictive perspectives.

**Top reasons to buy Test Bank for Business Analytics, 2/E 2nd Edition James R. Evans from us:**

**Best Price:**

- Your motto is to go for the least and our policy is to reduce costs as low as possible like Test Bank for Business Analytics, 2/E 2nd Edition James R. Evans

**Fast Access:**

- Test banks are often bought for instant use and reference, may be for an exam that you need to prepare for tonight. Our
**instant access**system ensures immediate delivery as soon as the payment is cleared with absolutely**no waiting time**

**Support:**

- Customer service is always willing to help you, 24 hours a day, seven days a week.

**Extremely safe:**

- Secure connection and payment system ( 256 bit SSL - Secure Socket Layer )
- We never share your information to third party.

All resources are in electronic format and can be downloaded from your account or email – **How to Download**. Payments will be processed instantly after checkout. Please note that all sales are final and non refundable. If you still have questions, find answers on our **FAQ** page or just send us an email at contact@lovetestbank.com, we will respond as soon as possible.

Business Analytics(Evans)

Chapter 2 Analytics on Spreadsheets

1) Which of the following symbols is used to represent exponents in Excel?

A) ^

B) *

C) #

D) !

Answer: A

Diff: 1

Blooms: Remember

Topic: Basic Excel Skills

LO1: Find buttons and menus in the Excel 2010 ribbon.

LO2: Use a modern software tool to perform statistical calculations.

2) Which of the following ways would 10

2

× 5

3

/ 100 – 73 be represented in an Excel

spreadsheet?

A) 10(2) * 5(3) / 100 ^ 73

B) 10(2) ^ 5(3) / 100 – 73

C) 10^2 * 5^3 / 100 – 73

D) 10*2 ^ 5*3 / 100 – 73

Answer: C

Diff: 1

Blooms: Understand

Topic: Basic Excel Skills

LO1: Write correct formulas in an Excel worksheet.

LO2: Use a modern software tool to perform statistical calculations.

3) Which of the following is a difference between relative addressing and absolute addressing

when using cell formulas in Excel?

A) A relative address uses a dollar sign before either the row or column label; an absolute

address uses the ampersand symbol before either the row or column label.

B) A relative address uses a dollar sign before either the row or column label; an absolute

address uses just the row and column label in the cell reference.

C) A relative address uses justthe row and column label in the cell reference; an absolute

address uses a dollar sign before either the row or column label.

D) A relative address uses only the column label in the cell reference; an absolute address uses

the row.

Answer: C

Diff: 2

Blooms: Remember

Topic: Basic Excel Skills

LO1: Apply relative and absoluteaddressing in Excel formulas.

LO2: Use a modern software tool to perform statistical calculations.

Use the data given below to answer the following question(s)

Below is the spreadsheet for demand prediction of a company that sells chocolates.

4) Given that D = a-bP, where D,is demand, “a” and “b,” are linear constants, and P, is price,

from the below spreadsheet, how will the formula in B9 be represented in Excel using relative

addressing?

A) B4-B5*A9

B) C5-C6*A10

C) B4-B5*A10

D) B5-B6*A10

Answer: A

Diff: 2

Blooms: Apply

AACSB: Analytic Skills

Topic: Basic Excel Skills

LO1: Copy formulas from one cell toanother or to a range of cells.

LO2: Use a modern software tool to perform statistical calculations.

5) If a dollar sign is used after the column in B5 (B$5), how will the formula at B8 be

represented in C9 using absolute addressing?

A) C3-B$5*C9

B) C5-C$6*B9

C) C5-C$6*C9

D) C5-C$5*B9

Answer: D

Diff: 2

Blooms: Apply

AACSB: Analytic Skills

Topic: Basic Excel Skills

LO1: Apply relative and absoluteaddressing in Excel formulas.

LO2: Use a modern software tool to perform statistical calculations.

A B C

1

Demand Prediction

Models

2

3 Linear Model

4 A 10,000

5 B 10

6

7 Price Demand

8 $50 9,500

9 $55 9,450

10 $45 9,550

6) If a dollar sign is used before the column label B4 ($B4), how will the formula at B10 be

represented in C11 using absolute addressing?

A) $B5-C6*B11

B) $C5-C6*A10

C) $B4-C5*B11

D) $A5-C6*B11

Answer: A

Diff: 2

Blooms: Apply

AACSB: Analytic Skills

Topic: Basic Excel Skills

LO1: Apply relative and absoluteaddressing in Excel formulas.

LO2: Use a modern software tool to perform statistical calculations.

7) If, in the spreadsheet, cells B9 and B10 were empty, which of the following formulas should

be entered in B8 so that the formula can be dragged to B9 and B10 to obtain their correct values?

A) B4-B5*A8

B) B4-B5*$A8

C) $B4-B5*$A8

D) $B$4-$B$5*$A8

Answer: D

Diff: 2

Blooms: Apply

AACSB: Analytic Skills

Topic: Basic Excel Skills

LO1: Copy formulas from one cell toanother or to a range of cells.

LO2: Use a modern software tool to perform statistical calculations.

8) Using a $ sign before a column label ________.

A) keeps the reference to both the row and column fixed

B) keeps the reference to the row fixed, butallows the column reference to change

C) keeps the reference to column fixed, but allows the row reference to change

D) allows both the row and column references to change

Answer: C

Diff: 1

Blooms: Remember

AACSB: Analytic Skills

Topic: Basic Excel Skills

LO1: Copy formulas from one cell toanother or to a range of cells.

LO2: Use a modern software tool to perform statistical calculations.

### Be the first to review “Test Bank for Business Analytics, 2/E 2nd Edition James R. Evans”

You must be logged in to post a comment.

## Reviews