#### 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…

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…

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 a…

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

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

Ch 13

basic excel

Spreadsheet

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

Excel

Spreadsheet

Rows

Columns

Spreadsheet or a worksheet

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

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/…

Workbook

Worksheet

Cell

Active Cell

An excel file with one or more worksheets

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

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 row…

Active Cell

Cell Reference

Column

Row

The cell displayed with a bold border

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

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 a…

*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 numb…

*Spreadsheet/Worksheet

an interactive computer application program for organization,…

Workbook

A spreadsheet file containing one or many worksheets

A designation that provides a permanen…

A predefined formula that calculates t…

A predefined formula that tallies the…

A predefined formula that tallies the…

Absolute cell reference

AVERAGE function

COUNT function

COUNTA function

A designation that provides a permanen…

Absolute cell reference

A predefined formula that calculates t…

AVERAGE function

Formula prefix

Workbook

Name box

Insert worksheet button

Using formulas in spreadsheets can allow you to quickly make…

File consisting of one or more worksheet

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

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

Formula prefix

Using formulas in spreadsheets can allow you to quickly make…

Workbook

File consisting of one or more worksheet

Dates are automatically treated as wha…

What is the definition of a spreadsheet?

What is the main advantage of using a…

What is the difference between a value…

General

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

You can change the data and the formulas are updated.

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

Dates are automatically treated as wha…

General

What is the definition of a spreadsheet?

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

=A1*B1

sort

$

min

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

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 A…

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 spac…

SLIDE SHOW tab- from beginning

Spacebar

Page up function

Change Line Spacing

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

Play slide show from beginning

SLIDE SHOW tab- from beginning

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

You should hold down the ____ key to s…

To hide an entire workbook on an unatt…

Data is in ____ sequence if it is in o…

Excel automatically selects the Left c…

CTRL

(VIEW tab | Window group)

ascending

True

You should hold down the ____ key to s…

CTRL

To hide an entire workbook on an unatt…

(VIEW tab | Window group)

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 custo…

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

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 custo…

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 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,…

Spreadsheet

Workbook

Cell

Formula Bar

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

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 organiz…

Workbook

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

t/f: when you use conditional formattu…

when you use format painter, double cl…

what is the process of changing a work…

what are the 12 colors that belong to…

false

turn it off

formatting

theme colors

t/f: when you use conditional formattu…

false

when you use format painter, double cl…

turn it off

information created in excel is saved…

in an excel worksheet, columns are ref…

what part of the excel screen displays…

the portion of the excel screen contai…

workbook

columns-letters/rows-numbers

formula bar

worksheet area

information created in excel is saved…

workbook

in an excel worksheet, columns are ref…

columns-letters/rows-numbers

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…

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

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

Workbook

An Excel file that contains one or more worksheets.

Worksheet

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

Cell Reference

Which key do you press to move right o…

Formula Bar

Range Reference

Formed by combining the cell's column letter and row number

Right arrow key

Appears at the right of the name box and displays a formula w…

A unique identifier for a range - it is the cell in its upper…

Cell Reference

Formed by combining the cell's column letter and row number

Which key do you press to move right o…

Right arrow key

Cell Reference

Which key do you press to move right o…

Formula Bar

Range Reference

Formed by combining the cell's column letter and row number

Right arrow key

Appears at the right of the name box and displays a formula w…

A unique identifier for a range - it is the cell in its upper…

Cell Reference

Formed by combining the cell's column letter and row number

Which key do you press to move right o…

Right arrow key

Cell Reference

Which key do you press to move right o…

Formula Bar

Range Reference

Formed by combining the cell's column letter and row number

Right arrow key

Appears at the right of the name box and displays a formula w…

A unique identifier for a range - it is the cell in its upper…

Cell Reference

Formed by combining the cell's column letter and row number

Which key do you press to move right o…

Right arrow key