# Study sets matching "applications business computer excel"

Study sets

Diagrams

Classes

Users

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…

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…

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

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

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

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

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)

Cell in the worksheet in which you can…

Cell reference area located below the r…

Computerized spreadsheet.

Which key do you press to move up one w…

Active cell

Name box

Worksheet

Page up key

Cell in the worksheet in which you can…

Active cell

Cell reference area located below the r…

Name box

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

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

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…