#### Study sets matching "applications business computer excel"

#### Study sets matching "applications business computer excel"

Absolute Cell Reference

Active Cell

Alignment

Argument

Cell reference that does not adjust to the new cell location w…

A selected worksheet cell that is ready for data entry.

The position of data within a cell.

Value, cell reference, range, or text that acts as an operand…

Absolute Cell Reference

Cell reference that does not adjust to the new cell location w…

Active Cell

A selected worksheet cell that is ready for data entry.

Ch 13

Spreadsheet

Clipped data

CATEGORY

basic excel

• An array of cells for setting up a list... • The guide lines ar…

Data too long for a cell will appear to flow into the next cel…

When organizing data, each column will represent a CATEGORY, s…

Ch 13

basic excel

Spreadsheet

• An array of cells for setting up a list... • The guide lines ar…

Excel

Spreadsheet

Rows

Columns

Spreadsheet or a worksheet

Grid of rows or columns containing words, numbers, text, and/o…

Run left to right, identified as numbers

Top to bottom, identified as letters

Excel

Spreadsheet or a worksheet

Spreadsheet

Grid of rows or columns containing words, numbers, text, and/o…

Workbook

Worksheet

Cell

Active Cell

An excel file with one or more worksheets

The work area for calculating data made up of columns and rows…

The intersection of a column and a row on a worksheet

The cell that is ready to take data

Workbook

An excel file with one or more worksheets

Worksheet

The work area for calculating data made up of columns and rows…

Active Cell

Cell Reference

Column

Row

The cell displayed with a bold border

The column letter and row number that identify a cell, such as…

Vertical part of the worksheet grid identified by the letters

Horizontal part of the worksheet grid identified by the numbers

Active Cell

The cell displayed with a bold border

Cell Reference

The column letter and row number that identify a cell, such as…

Workbook

Worksheet

Active Cell

Cell Reference

An Excel file that contains one or more worksheets.

The primary document that you use in Excel to store and work w…

The cell surrounded by a green border, ready to receive data o…

The identification of a specific cell by it's intersecting col…

Workbook

An Excel file that contains one or more worksheets.

Worksheet

The primary document that you use in Excel to store and work w…

*Spreadsheet/Worksheet

Workbook

Column

Row

an interactive computer application program for organization,…

A spreadsheet file containing one or many worksheets

A vertical stack of cells in a table or worksheet.

A horizontal group of cells in a worksheet identified by numbe…

*Spreadsheet/Worksheet

an interactive computer application program for organization,…

Workbook

A spreadsheet file containing one or many worksheets

A designation that provides a permanent…

A predefined formula that calculates th…

A predefined formula that tallies the n…

A predefined formula that tallies the n…

Absolute cell reference

AVERAGE function

COUNT function

COUNTA function

A designation that provides a permanent…

Absolute cell reference

A predefined formula that calculates th…

AVERAGE function

Formula prefix

Workbook

Name box

Insert worksheet button

Using formulas in spreadsheets can allow you to quickly make c…

File consisting of one or more worksheet

Part of the Excel program window that displays the active cell…

If you need to add more sheets in Excel, this button provides…

Formula prefix

Using formulas in spreadsheets can allow you to quickly make c…

Workbook

File consisting of one or more worksheet

Dates are automatically treated as what…

What is the definition of a spreadsheet?

What is the main advantage of using a c…

What is the difference between a value…

General

An electronic document in which data is arranged in the rows a…

You can change the data and the formulas are updated.

Labels- text/numbers you type, values- results of calculations

Dates are automatically treated as what…

General

What is the definition of a spreadsheet?

An electronic document in which data is arranged in the rows a…

=A1*B1

sort

$

min

This is the equation I should write in C1 to multiply cells A1…

arrange in order

This sign is the symbol used to represent an anchor.

function to find the smallest value in a range of cells

=A1*B1

This is the equation I should write in C1 to multiply cells A1…

sort

arrange in order

Change Line Spacing

Play slide show from beginning

Press______to advance to slides

To return to slide press

HOME tab- under paragraph group click line and paragraph spaci…

SLIDE SHOW tab- from beginning

Spacebar

Page up function

Change Line Spacing

HOME tab- under paragraph group click line and paragraph spaci…

Play slide show from beginning

SLIDE SHOW tab- from beginning

AVERAGE()

COUNTA ()... (count)

COUNT ()... (numerical count)

MIN ()

averages all the numbers in the selected cell

lists how many of the selected cells contain data

lists how many of the selected cells contain numbers

shows the smallest number in the selected cells

AVERAGE()

averages all the numbers in the selected cell

COUNTA ()... (count)

lists how many of the selected cells contain data

Name box

formula bar

worksheet window

Columns

displays the active cell address

allows you to enter or edit data in the worksheet

contains a grid of columns and rows

labeled alphabetically

Name box

displays the active cell address

formula bar

allows you to enter or edit data in the worksheet

All formulas start with an....... sign

Columns are identified in a worksheet by

Rows are identified in a worksheet by

What do you see in a cell when the colu…

Equal

Letters

Numbers

Number sign (pound sign; #####)

All formulas start with an....... sign

Equal

Columns are identified in a worksheet by

Letters

Order of Operations

Function

absolute reference

Today's Date

determines the order of mathematical operations

premade formulas

used in formulas to repeatedly refer back to a specific cell (…

Control semicolon.Simply put in today's date. Static.

Order of Operations

determines the order of mathematical operations

Function

premade formulas

Excel

spreadsheet

worksheet

workbook

spreadsheet program in the Microsoft Office 2010 software

a grid of rows and columns in which you enter text, numbers, a…

a computerized spreadsheet

collection of related workbooks

Excel

spreadsheet program in the Microsoft Office 2010 software

spreadsheet

a grid of rows and columns in which you enter text, numbers, a…

Workbook

Quick Access Toolbar

Ribbon

Column Heading

The file made in Excel - made up of 3 worksheets

Lets you access quick commands; undo, redo, save... can custom…

Contains commands you need to do common tasks; made up of mult…

Contains 16,000~ __________, named using letter(s)

Workbook

The file made in Excel - made up of 3 worksheets

Quick Access Toolbar

Lets you access quick commands; undo, redo, save... can custom…

You should hold down the ____ key to se…

To hide an entire workbook on an unatte…

Data is in ____ sequence if it is in or…

Excel automatically selects the Left co…

CTRL

(VIEW tab | Window group)

ascending

True

You should hold down the ____ key to se…

CTRL

To hide an entire workbook on an unatte…

(VIEW tab | Window group)

Spreadsheet

Workbook

Cell

Formula Bar

A spreadsheet in a grid of blocks that will keep data organize…

It is the screen you are working on to create your spreadsheet.

A block in Excel where you enter data.

Create or edit your text there.

Spreadsheet

A spreadsheet in a grid of blocks that will keep data organize…

Workbook

It is the screen you are working on to create your spreadsheet.