LC7 - Microsoft Excel - Davis

In Excel, the name of the bar where information appears as you input data is called?

• File Bar

• Formula Bar

• Help Bar

• Window Bar

Excel refers to files as...

• Presentations

• Databases

• Workbooks

• Documents

The letters in Excel represent the...

• Rows

• Columns

• Cells

• Data

The numbers in Excel represent the...

• Rows

• Columns

• Cells

• Data

To alert Excel that you are entering a formula and not text, type a(n) ____________ preceding the formula.

• &

• =

• #

• *

What function adds all of the numbers in a range of cells?

• Calculate

• Compute

• Sum

• Max

If I want to find an average of cells A1 through A25, which formula would I use?

• =average(A1:A25)

• =avg(A1:A25)

• =average(A1-A25)

• =avg(A1-A25)

The ability to quickly add a formula, set of number, months or day of the week down a column or across a row.

• Autofill

• Copy and Paste

• Drag and Drop

• Typing

The set of data that runs left to right in a spreadsheet

• column

• row

• cell

• active cell

The intersection of a row and column.

• column

• row

• cell

• active cell