Module 5 and 6 Microsoft Excel Review

Front

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

Back

20

Front

Which of the following options specifies cell B5 as an absolute reference? Options: $B$5, (B5), #B#5, %B%5

Back

$B$5

Front

Consider the worksheet illustration pictured above. 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? Options: =A1+B1, =10+8, =sum(A1:C1), =COUNT(A1:B1)

Back

=A1+B1

Front

In the Function Library, which category will you find the MAX and MIN functions? Options: Math and Trig, Statistical, Financial, Logical

Back

Statistical

Front

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?

Back

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

Front

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

Back

=

Front

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

Back

average

Front

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

Back

Insert function

Front

The COUNT function is used to indicate how many cells contain a numeric value. Empty cells, text values, and the logical values TRUE and FALSE are ignored and are not counted with the COUNT function. True or False?

Back

True

Front

For formulas, a named range enables you to assign meaningful names to cells or groups of cells, which can be used in place of the column and row references. The named range can also be assigned a scope to be used within a specific worksheet or even be referred to from multiple worksheets within the entire workbook. True or False?

Back

True