Excel & PowerpointCompetency

"AAA" is an example of a ____ in Excel

• cell reference

• column heading

• name box

• row heading

The best formula to calculate Profits for January is:

• =SUBTRACT(B2:B3)

• =B2-B3

• =B4-(B2+B3)

• =A4-(A2+A3)

The best formula to calculate the Average for Profits is:

• =(B4+C4+D4)/3

• =MEAN(B4:E4)

• =AVERAGE(B4:D4)

• =AVERAGE(B4:E4)

Cell D4 contains the formula =C1+C2. What formula will see when you paste this into cell E5?

• =C1+C2

• =$C1+$C2

• =D2+D3

• =E6+E7

Excel will reference the chart’s data source above as:

• A1:B7

• $A1:B7$

• A$1:$B7

• $A$1:$B$7

The words "Pre-sales" and “Conference Attendance” in the image above are called the chart ______:

• accent

• key

• labels

• legend

To determine the number of sales people by region who have 50 or more orders, we use the:

• COUNT

• COUNTA

• COUNTIF

• COUNTIFS

Returns the number of characters you specify from the right side of a string

• CHAR

• LEN

• RIGHT

• RSTRING

The ______ function returns TRUE if any of its arguments evaluate to TRUE, and returns FALSE if all of its arguments evaluate to FALSE

• AND

• OR

• SOME

• LOOKUP

_______ quickly highlight(s) important information in a spreadsheet that match your criteria by applying formatting options, data bars, color scales, or icon sets.

• cell references

• conditional formatting

• Excel tables

• pivot tables