MS Excel Vocabulary Review

What is an Active Cell in Microsoft Excel?

• A cell that is currently selected and ready for data entry

• A cell that contains a formula

• A cell that is locked for editing

• A cell that is highlighted in red

What is the function of AutoFill in Microsoft Excel?

• To automatically fill cells with data following a pattern

• To create charts and graphs

• To format cells with different colors

• To sort data in ascending or descending order

The AutoSum function in Microsoft Excel is used to:

• Automatically sum a range of cells

• Sort data in ascending order

• Format cells with currency symbols

• Create a chart from selected data

A Cell in the context of Microsoft Excel is defined as:

• A rectangular box in a worksheet where data can be entered.

• A type of chart used to represent data graphically.

• A function that performs calculations on data.

• A tool for formatting text in a document.

What is a Cell Address in Microsoft Excel?

• A unique identifier for a cell, consisting of a column letter and a row number

• A formula used to calculate values in a spreadsheet

• A type of data format used in Excel

• A tool for creating charts and graphs

What is a Name Box in Microsoft Excel?

• A tool to create charts

• A box to enter formulas

• A box that displays the cell reference or name

• A feature to sort data

A Cell Grid in Microsoft Excel is:

• A collection of cells organized in rows and columns.

• A single cell in a worksheet.

• A tool for creating charts.

• A feature for sorting data.

What is a Column in Microsoft Excel?

• A vertical series of cells in a chart, table, or spreadsheet.

• A horizontal series of cells in a chart, table, or spreadsheet.

• A single cell in a chart, table, or spreadsheet.

• A diagonal series of cells in a chart, table, or spreadsheet.

What does the Drag function do in Microsoft Excel?

• It moves the selected cells to a new location.

• It copies the selected cells to a new location.

• It fills the selected cells with a series of values.

• It deletes the selected cells.

A File in Microsoft Excel is:

• A single cell in a worksheet

• A collection of worksheets

• A type of chart

• A formula used in calculations