Excel 2010 - Chapter 1

Open Excel by clicking on this button at the left side of the Task bar.

A file created in Excel is referred to as a:

A workbook consists of these

Contains buttons for commonly used commands.

Click this tab and the Backstage view displays containing buttons and tabs for working with and managing files

Displays workbook name followed by program name

Contain commands and features organized into groups

Area containing the tabs and commands divided into groups

Displays cell address (also called the cell reference) and includes the column letter & row number

Provides information about active cell; enter and edit formulas in the bar.

Displays toward bottom of screen and identifies current workdsheet

Displays information about worksheet and active cell, view buttons, and Zoom slider bar.

Area containing gridlines

Columns are labelled with these:

Rows are labelled with these:

Scroll through a worksheet using these:

Data you type appears in two spots:

If a number is too long to fit in a cell, Excel changes the display of the number to this:

A workbook file name can contain up to this amount of characters

This button automatically inserts a formula containing the SUM function, which adds the numbers in a range.

This function is a common function in Excel formulas.

This function sums the numbers in a range of cells and then divides the sum by the number of cell entries

These do not display unless they are typed in a cell

This is a general guideline in accounting regarding entering dollar amounts in a spreadsheet