# Study sets matching "business computer excel"

Study sets

Diagrams

Classes

Users

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

Cloud Computing

Data visualisation

Descriptive analytics

Business Intelligence

The delivery of computing as a service rather than a product,…

The visual representation of data, to facilitate the explorati…

Generates results related to past and present performance usin…

Information that results from the processing operation data to…

Cloud Computing

The delivery of computing as a service rather than a product,…

Data visualisation

The visual representation of data, to facilitate the explorati…

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…

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

cell

active cell

workbook

spreadsheet

Individual boxes that make up a spreadsheet.

is where your information will appear when you begin to type

is made up of worksheets all related to the same topic

is made up of individual cells. Also known as worksheet

cell

Individual boxes that make up a spreadsheet.

active cell

is where your information will appear when you begin to type

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…

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.

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

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

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

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

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…