Quiz: Module 6

Worksheet

A computerized spreadsheet in Excel.

Range of Cells

A group of cells is known as a cell range.

Rows

A horizontal line of cells in a table. Rows are identified by numbers (1, 2, 3).

Templates

A partially complete document in a predefined format that provides a defined structure for collecting, organizing, and presenting information and data.

Functions

A prewritten formula that provides a shortcut to common calculations

Formulas

An arithmetical expression used to calculate values

Cell address

Each cell has its own name—or cell address—based on its column and row. In the example below, the selected cell intersects column C and row 5, so the cell address is C5.

Cells

Every worksheet is made up of thousands of rectangles, which are called cells. A cell is the intersection of a row and a column—in other words, where a row and column meet.

Workbook

Excel files are called workbooks. Whenever you start a new project in Excel, you'll need to create a new workbook. There are several ways to start working with a workbook in Excel. You can choose to create a new workbook—either with a blank workbook or a predesigned template—or open an existing workbook.

Autosave feature

If you forget to save your changes or if Excel crashes, you can restore the file using AutoRecover.

Drag and drop cells

Instead of cutting, copying, and pasting, you can drag and drop cells to move their contents.

Arithmetic operators

The symbols +, -, *, /, %, and ^ used to denote addition, subtraction (or negation), multiplication, division, percentage, and exponentiation in an Excel formula.

Backstage view

The view that opens when you click the File tab, containing commands for managing files, setting program options, and printing.

Inserting columns and rows

Used to add columns or rows into a worksheet

Deleting columns and rows

Used to delete columns or rows into a worksheet

Charts

Visual representations of numerical data

file formats and extensions

You can save an Excel file in another file format by clicking the File > Save As. The file formats that are available in the Save As dialog box vary, depending on what type of sheet is active (a worksheet, chart sheet, or other type of sheet).

Columns

information arranged vertically. Columns are identified by letters (A, B, C)

Spreadsheet

that allows you to store, organize, and analyze information.