Excel Unit A

Created by GeorgeE08 

Upgrade to
remove ads

25 terms · Understanding Spreadsheet software, tour the excel 2007 window understand formulas Enter labels and values and use auto sum edit cell entries Enter and edit a simple formula switch worksheet views choose print options

Electronic Spreadsheet

Computer program that performs calculations and presents numeric data.

Worksheet

The workspace made up of columns and rows where you enter data to create an electronic spreadsheet is called________.

Workbook

File extension xlsx.

What-if-Anaylsis

When you use a worksheet to ask what if you are using_______.

Templates

A predesigned formmated file used to create a worksheet.

Name box

This displays the active cell address.

Formula Bar

Allows you to enter or edit data in a worksheet

Cell

The intersection of a column and a row

Cell Address

The unique location of a cell which is identified by the cordinates of the intersecting columns and rows

Cell Pointer

A dark rectangle that outlines the cell in which you are working is called a _______ ______.

Active cell

The cell you are currently working on is called the _______ ____.

Sheet Tabs

The __________ are located below the worksheet grid, this also allows you to switch from
sheet to sheet in a workbook.

Sheet Tab Scrolling Buttons

Allows you to navigate to additional sheet tabs

Scroll Bars

You can use the _________ _____ to move around in a document that is too large to fit on the screen at once.

Status Bar

Located at the bottom of the screen that displays a description of the active commands, or tasks in progress.

Mode Indicator

In the bottom left corner of the status bar this also provides additional information about certain tasks.

Range

Selection of two or more cells is called ________.

Formulas

Eqatuions in a worksheet are called _________.

Labels

_________ are entries that contatin text an numerical information not used in calculations.

Values

________ are numbers formulas and functions that can be used in calculations.

Function

A ________ is a built in formula.

Arguments

The information necessary to calculate an awnser and other unique information

Edit

The changing of contents of an active cell at any time.

Insertion Point

The blinking vertical line that allows you to enter data.

Formula Prefix

Formulas in an excel worksheet with the = sign followed by cell address, rage names and values along with calculation operators.

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

NEW! Voice Recording

Click the mic to start.

Create Set