Excel Unit 5

Which of the following symbols specifies an absolute reference?

$

Which of the following options specifies cell B5 as an absolute reference?

$B$5

What is the answer to the following calculation: 5+2*(20-10)/2?

15

If sales are larger than $5,000 the salesperson receives a bonus of 10 percent of total sales; otherwise, the salesperson receives a 2 percent bonus of sales. Which of the following formulas reflect this logical statement?

=IF(sales>5000,sales*10%,sales*2%)

Consider the following worksheet illustration. In cell C1, you need to input a formula to total cells A1 and B1. You need to ensure that if you change the numbers, the total automatically updates. Which of the following formulas meet your requirements?

=SUM(A1:B1) AND A1+B1

Which of the following is the best example of a mixed cell reference?

A$2

The _________________________function adds a range of cells and then divides by the number of cell entries.

Average

Which keyboard shortcut can you use to toggle relative, absolute, and mixed references?

F4

The ___________ command helps you search for a specific function and then assists in building the formula.

Insert Function

In the Function Library, which of the following categories will you find the MAX and MIN functions?

Statistical

Review the following formula: =Sales!C10+A7. This formula uses which of the following reference types?

Worksheet

The ____________________ sign is used to start a formula in Excel.

equal