# Study sets matching "applications business computer excel"

Study sets

Diagrams

Classes

Users

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

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…

Advertisement

Filtering

Sorting

Bar Chart (Column Chart

Pie Chart

Removing information from a spreadsheet so you will only have…

Arranging information from high to low, biggest to smallest, a…

Shows the relationship between two mor more items over a perio…

Shows the relationships of a part to a whole

Filtering

Removing information from a spreadsheet so you will only have…

Sorting

Arranging information from high to low, biggest to smallest, a…

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

active cell

formula bar

screentips

refers to the entire excel file, which contains one or more wo…

bold border where selected. it is where your typing will appear

displayed above the column of letters and displays the content…

small boxes that pop up when pointing to a command on the ribb…

workbook

refers to the entire excel file, which contains one or more wo…

active cell

bold border where selected. it is where your typing will appear

Computer

Data

Information

Computer Hardware

A programmable electronic device that can store, retrieve, and…

A collection of raw facts, figures, and symbols given to a com…

Data that is organized, meaningful, and useful

The physical parts and components of a computer

Computer

A programmable electronic device that can store, retrieve, and…

Data

A collection of raw facts, figures, and symbols given to a com…

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)

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…

Application Software

Central Processing Unit (CPU)

File Management

File Type

computer software created to allow the user to perform specifi…

executes commands from a computer's hardware and software; the…

a program on a computer that allows the user to create, edit,…

an extension at the end of a file name, including which applic…

Application Software

computer software created to allow the user to perform specifi…

Central Processing Unit (CPU)

executes commands from a computer's hardware and software; the…

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

Table

Record

Field

Table array

Or database, an organized collection of data

A horizontal group; all fields in it once

A vertical group, parameter; goes through each record

Or lookup table, a function that allows one to assign rankings…

Table

Or database, an organized collection of data

Record

A horizontal group; all fields in it once

Absolute Cell Reference

Adjacent Range

Argument

Ascending Sort

A cell reference that does not change when copied or moved to…

A range where all cells touch each other and form a rectangle

The value the function uses to perform a calculation, includin…

To arrange data with letters in alphabetical order (A to Z), d…

Absolute Cell Reference

A cell reference that does not change when copied or moved to…

Adjacent Range

A range where all cells touch each other and form a rectangle

Active Cell

Cell

Cell reference

Columns

The cell displayed with a bold border. Also called a selected…

The intersection of a row and column

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

Vertical part of the worksheet grid identified by the letters…

Active Cell

The cell displayed with a bold border. Also called a selected…

Cell

The intersection of a row and column

Attribute

Conditional formatting

Format painter

Hyperlink

A formatting characteristic, such as bold, italic, or underlin…

An Excel feature that enables you to specify how cells that me…

A feature found in most Office applications that allows you to…

A shortcut that enables you to navigate to a web page or a loc…

Attribute

A formatting characteristic, such as bold, italic, or underlin…

Conditional formatting

An Excel feature that enables you to specify how cells that me…

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

Comparison operators

SUMIF Function

AVERAGEIF Function

COUNTIF Function

Symbols that evaluate each value to determine if it is the sam…

The function that calculates the total of a range of values wh…

The function that calculates the average of values in a range…

The function that counts the number of cells in a range when a…

Comparison operators

Symbols that evaluate each value to determine if it is the sam…

SUMIF Function

The function that calculates the total of a range of values wh…

Advertisement

dollar sign ($)

2 symbols. Date format

Branded new

NOW function

A symbol that represents an abdolute value

A dash or forward slash are treated identical

Different colors in data

Retrieves the date and time from your computer and inserts it…

dollar sign ($)

A symbol that represents an abdolute value

2 symbols. Date format

A dash or forward slash are treated identical

Quick Analysis Tool

Auto Fill

functions

Maximum

Select the cells that contain the data you want to analyze

To drag the fill handle (+) to copy formulas

built in formulas that do special calculations

Function to find the highest number =MAX(

Quick Analysis Tool

Select the cells that contain the data you want to analyze

Auto Fill

To drag the fill handle (+) to copy formulas

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