TEC 81202 ICEBREAKER

The AutoSumfunction adds up numbers in a column or row you specify.

• True

• False

"AAA10" is an example of a ____ in Excel.

• cell reference

• column heading

• name box

• row heading

_______ 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

The best formula to calculate the Average for Profits is for the range that starts from B4 to D4:

• =(B4+C4+D4)/3

• =MEAN(B4:E4)

• =AVERAGE(B4:D4)

• =AVERAGE(B4:E4)

As a general rule, Excel will _____-align numbers.

• right

• left

• top

• bottom

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

When you copy a formula that contains an absolute reference to a new location, the reference ____.

• is updated automatically

• does not change

• becomes bold

• has a dotted outline in its cell

Which of the following is a logical function?

• AVERAGE

• IF

• SUMPRODUCT

• VLOOKUP

The image above shows a:

• Column chart

• Bar graph

• Line Chart

• Pie Chart

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

• A1:B7

• $A1:B7$

• A$1:$B7

• $A$1:$B$7