Ch. 9

Your page rank:

Total word count: 354
Pages: 1

Calculate the Price

- -
275 words
Looking for Expert Opinion?
Let us have a look at your work and suggest how to improve it!
Get a Consultant

You have a workbook that contains sales data for different regional sales reps of a company. Which task is the least likely to be done while the worksheets are grouped?

Enter specific values for the first sales rep

Your manager sent you a workbook that contains data validation rules. One rule specifies a maximum value of 15% with a warning alert. You try to enter 22% in that cell. What happens?

Excel displays a message box informing you the value is above the maximum value and lets you chose to go ahead and enter that value or a different value

The function = FV(D10, D8,-D5) is entered in cell D12. Which cell is a dependent of cell D8?

D12

If you want to display a portion of all three worksheets in a workbook, what should you do?

Open two new workbook windows, arrange windows, and then click a different worksheet tab in each window

Cell B15 contains the formula =B14+B15. You created a:

Reference Formula

A personal trainer stores how much weight each person can lift in several categories. Each week’s data are stored in a separate worksheet within the same workbook, and each workbook has an identical structure. Assume cell F5 contains the weight the first person can bench press. What function can identify that person’s highest amount bench-pressed in all worksheets?

=MAX(‘Week1:Week4’!F5)

You want to create a hyperlink on the summary worksheet to a cell in the data worksheet within the same workbook. Which type of link do you create?

Existing file or web page

You want to create a situation so that you can monitor the results of cell formulas on a different worksheet as you change data on another worksheet. You should create a:

Watch window

You created several workbooks (Accounting, Finance, Management, and Marketing) in the same folder as the main workbook SchoolOfBusiness. What formula correctly links to cell D20 in the Fall 2018 worksheet within the Finance workbook?

="Finance[Fall 2018]"!D20

You want to restrict data entry to whole numbers greater than 100. What do you create to enforce this data-entry restriction?

Validation criteria

Share This
Flashcard

More flashcards like this

NCLEX 10000 Integumentary Disorders

When assessing a client with partial-thickness burns over 60% of the body, which finding should the nurse report immediately? a) ...

Read more

NCLEX 300-NEURO

A client with amyotrophic lateral sclerosis (ALS) tells the nurse, "Sometimes I feel so frustrated. I can’t do anything without ...

Read more

NASM Flashcards

Which of the following is the process of getting oxygen from the environment to the tissues of the body? Diffusion ...

Read more

Unfinished tasks keep piling up?

Let us complete them for you. Quickly and professionally.

Check Price

Successful message
sending