# Study sets matching "business computer excel"

spreadsheet

Concatenate

spreadsheet program

worksheet

an electronic file that contains a grid of columns and rows co…

adds strings of text together with " " separating words

a computer application used to create and modify spreadsheets

a spreadsheet that contains, formulas, functions, values, text…

spreadsheet

an electronic file that contains a grid of columns and rows co…

Concatenate

adds strings of text together with " " separating words

excel

template

slides

a context menu appears

What would be the best program to create a sales chart, includ…

A __________ acts as a guideline in creating a document, works…

Your PowerPoint presentation is divided into __________.

What happens when you hover your mouse pointer over a button?

excel

What would be the best program to create a sales chart, includ…

template

A __________ acts as a guideline in creating a document, works…

5 things in a cell

6 dimensions of a cell

IF function

=IF(C2="Yes",1,2)

(1) formulas/functions... (2) logical values (true/false)... (3) err…

(1) number... (2) alignment... (3) border... (4) font... (5) fill... (6) prot…

=IF(something is true, then do something, otherwise do somethi…

If C2 equals yes, then return a 1, otherwise return a 2

5 things in a cell

(1) formulas/functions... (2) logical values (true/false)... (3) err…

6 dimensions of a cell

(1) number... (2) alignment... (3) border... (4) font... (5) fill... (6) prot…

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…

Microsoft Excel

Electronic Spreadsheet

Manual Spreadsheet

workbook

Is a powerful spreadsheet program that integrates graphics and…

An electronic software spreadsheet

Consist of using pencils, erasers, rulers, ledger paper, and a…

A Microsoft Excel file is called a

Microsoft Excel

Is a powerful spreadsheet program that integrates graphics and…

Electronic Spreadsheet

An electronic software spreadsheet

Active cell

Active worksheet

Adjacent range

cell

The cell in the worksheet in which you can type.

the worksheet that is displayed in the work area.

all cells touch each other and from a different rectangle.

is the intersection of a row and a column.

Active cell

The cell in the worksheet in which you can type.

Active worksheet

the worksheet that is displayed in the work area.

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

Software

Software Includes:

Program

Syntax

receives signals from the CPU and gives the signals actions fo…

Programming Language... Operating System ... General Purpose Applica…

a set of symbols and rules to write codes that can be interpre…

The rules of language

Software

receives signals from the CPU and gives the signals actions fo…

Software Includes:

Programming Language... Operating System ... General Purpose Applica…

what does an equal sign do for functions

Range

IF Function

#DIV/0

starts the function off wouldn't work without it

From point to point number range

Comparison

divided by 0

what does an equal sign do for functions

starts the function off wouldn't work without it

Range

From point to point number range

Row heading

Column heading

Default Format Excel

Cell style

Horizontal group of cells identified by numbers

Vertical group of cells identified by letters

Calibri, 11, general format

Defined formatting characteristics such as font, size, color,…

Row heading

Horizontal group of cells identified by numbers

Column heading

Vertical group of cells identified by letters

Active window- the window in which you…

AutoRecover- a feature in some microsof…

Backstage view- a feature of microsoft…

Byte- a unit used to measure storage ca…

...

a feature in some microsoft office 2010 programs that automati…

a feature of microsoft office 2010 from which you access file…

a unit used to measure storage capacity. one byte equals about…

Active window- the window in which you…

...

AutoRecover- a feature in some microsof…

a feature in some microsoft office 2010 programs that automati…

active cell

cell

cell address or cell reference

formula bar

the active cell contains the cell pointer. there is a dark out…

the intersection of a column and a row on a worksheet. you ent…

the location of a cell in a worksheet as identified by its col…

as you enter data in a cell, it simultaneously appears in the…

active cell

the active cell contains the cell pointer. there is a dark out…

cell

the intersection of a column and a row on a worksheet. you ent…

Active cell

Alignment (cell text)

Autofit

Autosum

A cell ready for data entry

Placement of text: right, left, center & up, down, Middle

Automatically changes the width of a column or height of a row…

A function that adds a column of numbers above or a row of num…

Active cell

A cell ready for data entry

Alignment (cell text)

Placement of text: right, left, center & up, down, Middle

Purpose of Excel

Three advantages to using Excel

Difference between workbook and workshe…

how do you create new worksheets in the…

Organize and process numbers in rows and columns

readymade rows and columns, built in formulas, formulas can be…

A workbook is an excel file. A worksheet contains rows and col…

New sheet button

Purpose of Excel

Organize and process numbers in rows and columns

Three advantages to using Excel

readymade rows and columns, built in formulas, formulas can be…

In Excel, column designations are always

Row designations are always

When you click on the green check mark…

To move from one cell to an other, use…

letters

numbers

The contents are entered into the cell

up down left right tab enter

In Excel, column designations are always

letters

Row designations are always

numbers

Spreadsheet

Row

Cell

Column

A spreadsheet is a document that stores data in a grid of hori…

Horizontal line of cells

A Box that holds data

A vertical line of cells

Spreadsheet

A spreadsheet is a document that stores data in a grid of hori…

Row

Horizontal line of cells

What is the significance of an equals s…

Define the term range in reference to a…

Explain the IF Function in Excel.

Explain the following errors in Excel 1…

a formula must begin with an equals sign

a selection of 2 or more cells

used to make a decision based on a comparison

1. the formula is trying to divide by 0 2. the formula contain…

What is the significance of an equals s…

a formula must begin with an equals sign

Define the term range in reference to a…

a selection of 2 or more cells

Fill handle

Cell address

Cell

Name box

Shows up as a back cross. Allows you to fill cell content eith…

Based on which column and row it intersects ... Example: C5

Each rectangle in a worksheet

A box that shows what your cell address is

Fill handle

Shows up as a back cross. Allows you to fill cell content eith…

Cell address

Based on which column and row it intersects ... Example: C5

Chart

Data point

Data series

Column chart

A visual representation of numerical data

A numeric value that describes a single value on a chart

A group of related data points in a chart

Displays data comparisons vertically in columns

Chart

A visual representation of numerical data

Data point

A numeric value that describes a single value on a chart

Data

Cell Reference

Fill Handle

Formula

information stored in a worksheet. Categorized as either label…

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

The solid square in the lower-right corner of a selected cell…

Mathematical statement used to calculate a value. A formula mu…

Data

information stored in a worksheet. Categorized as either label…

Cell Reference

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

Worksheet identifier that appears at th…

Cell reference area located below the r…

Appears horizontally, identified by num…

Which key do you press to move down one…

Sheet tab

Name box

Row

Down arrow key

Worksheet identifier that appears at th…

Sheet tab

Cell reference area located below the r…

Name box