Microsoft Excel Vocabulary Test

What is the **active cell** in an Excel worksheet?

• The first cell in the worksheet

• The cell with the bold gridlines that you've selected

• Any cell in the first row

• The cell with the largest number

What is the purpose of the **AutoSum** function?

• To copy the contents of one cell to another

• To sum and display a total for a range of cells

• To sort data alphabetically

• To adjust column widths automatically

What does the **Formula Bar** allow you to do?

• Add formatting to cells

• Enter or edit data, formulas, and numbers

• Insert new worksheets

• Copy cell contents horizontally

Which feature copies information from a cell horizontally into adjacent cells?

• Fill Down

• AutoSum

• Fill Right

• Drag

In an Excel worksheet, **headings** refer to:

• The identifying name of the file

• The letters for columns and numbers for rows

• The bold gridlines on selected cells

• The names of the worksheets

Explain the difference between a **workbook** and a **worksheet** in Excel.

What does a **cell address** represent, and how is it written?

Describe how you would use the **AutoFill** feature in Excel.

What is the purpose of **sheet tabs**, and how can you customize them?

Explain the role of **functions** in Excel. Provide an example.