Computer Application Lecture 1: Microsoft Excel

Vocabulary practice flashcards covering basic Excel terminology, interface elements, and statistical functions based on Lecture 1.

Microsoft Excel

A spreadsheet application developed by Microsoft that features calculation, statistical analysis, and graphing tools.

Workbook

The name for data files created with Excel, analogous to documents in Word.

Alphanumeric

Data involving both letters and numbers.

Office Button

A button that provides access to workbook-level features and program settings.

Quick Access Toolbar

A collection of buttons that provide one-click access to commonly used commands, such as Save, Undo, and Repeat.

Title bar

A bar that displays the name of the active workbook and the Excel program name.

Ribbon

The main set of commands organized by task into tabs and groups.

Column headings

The letters that appear along the top of the worksheet window to identify different columns.

Workbook window

A window that displays an Excel workbook.

View shortcuts

Buttons used to change how worksheet content is displayed, including Normal, Page Layout, or Page Break Preview view.

Sheet tabs

Tabs that display the names of the worksheets within a workbook.

Row headings

The numbers that appear along the left side of the worksheet window to identify different rows.

Select All button

A button used to select all of the cells in the active worksheet.

Active cell

The cell currently selected in the active worksheet.

Name box

A box that displays the cell reference of the active cell.

Formula bar

A bar that displays the value or formula entered in the active cell.

Cell

The intersection between a column and a row, named for the column letter and row number that intersect.

Formulas

Equations that perform calculations in a spreadsheet, which always begin with an equals sign ($=$).

Functions

Excel-defined formulas that take selected data, perform calculations, and return values.

$$=AVERAGE(first\,cell:last\,cell)$$

A function that calculates the mean of a specified range of cells.

$$=MEDIAN(first\,cell:last\,cell)$$

A function that calculates the median of a specified range of cells.

$$=MODE(first\,cell:last\,cell)$$

A function that calculates the mode of a specified range of cells.

$$=VARP(first\,cell:last\,cell)$$

A function that calculates the variance of a specified range of cells.

$$=STDEVP(first\,cell:last\,cell)$$

A function that calculates the standard deviation of a specified range of cells.

AutoFit

A feature triggered by double-clicking the border of a column or row heading to adjust the width or height to match the cell contents.