# Study sets matching "applications business computer excel"

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…

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…

Funny, Smart and Cute

Saturday movie

1,000 or more

Sorting

Cole's description of Megan

Cole and Megan's first date

Number of text messages Cole and Megan exchanged in less than…

Removing information from a spreadsheet so you will only have…

Funny, Smart and Cute

Cole's description of Megan

Saturday movie

Cole and Megan's first date

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…

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

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…

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

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

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

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…

Worksheet

Spreadsheet

Cell

Formula

the electronic representation of a spreadsheet. A worksheet is…

computer software program that can be used to manipulate data…

the basic unit of a worksheet in which data are stored. Inters…

an arrangement of numbers and/or cell addresses and arithmetic…

Worksheet

the electronic representation of a spreadsheet. A worksheet is…

Spreadsheet

computer software program that can be used to manipulate data…

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.

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

t/f: when you use conditional formattun…

when you use format painter, double cli…

what is the process of changing a workb…

what are the 12 colors that belong to t…

false

turn it off

formatting

theme colors

t/f: when you use conditional formattun…

false

when you use format painter, double cli…

turn it off

information created in excel is saved i…

in an excel worksheet, columns are refe…

what part of the excel screen displays…

the portion of the excel screen contain…

workbook

columns-letters/rows-numbers

formula bar

worksheet area

information created in excel is saved i…

workbook

in an excel worksheet, columns are refe…

columns-letters/rows-numbers

Cell Reference

Which key do you press to move right on…

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

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

Right arrow key

Workbook

Active cell

Autofill

A series

An excel document is called?

The ______, when outlined in black, indicates it is ready to a…

______ generates and extends a series of values into adjacent…

A group of items that comes one after another in succession

Workbook

An excel document is called?

Active cell

The ______, when outlined in black, indicates it is ready to a…