#### Study sets matching "computer chapter 2 excel"

#### Study sets matching "computer chapter 2 excel"

Conditional formatting

Data bars

Highlight cells rules

Icon sets

Variable formatting that changes the formatting applied based…

A type of conditional formatting that creates filled backgrou…

A method of applying conditional formatting based on how cell…

A type of conditional formatting that includes one of a set o…

Conditional formatting

Variable formatting that changes the formatting applied based…

Data bars

A type of conditional formatting that creates filled backgrou…

Argument

AutoCalculate

Formula AutoComplete

Function

The values and other inputs that a function uses to calculate…

A feature that temporarily performs the following calculation…

A feature that speeds up the manual entry of functions.

A predefined formula that performs a specific calculation usi…

Argument

The values and other inputs that a function uses to calculate…

AutoCalculate

A feature that temporarily performs the following calculation…

Fixed Dollar Sign

Arugments

Average Function

Comma Style

Dollar sign is as far left of cell with space between the sig…

Values used with a function.

Sum of a range of numbers divided by number of cells in the r…

Inserts a comma every three positions. Rounds to the nearest…

Fixed Dollar Sign

Dollar sign is as far left of cell with space between the sig…

Arugments

Values used with a function.

Function

Formula

Circular Reference

Indirect Circular Reference

prewritten formula built into Excel

series of numbers with operation signs; mathematical equation

formula in a cell that contains a reference back to itself

formula in a cell refers to another cell

Function

prewritten formula built into Excel

Formula

series of numbers with operation signs; mathematical equation

Argument

AutoCalculate

Formula AutoComplete

Function

The values and other inputs that a functions uses to calculat…

A featuare that temporary preforms the fallowing calculations…

A feature that speeds up the manually entry of funtions

A predefined formula that performs a specific calculation usi…

Argument

The values and other inputs that a functions uses to calculat…

AutoCalculate

A featuare that temporary preforms the fallowing calculations…

Worksheet

requirements

understand what is required

cell

An Excel ____________ allows data easliy to be summarized and…

The person or persons requesting the worksheet should supply…

the first step in creating an effective worksheet is to make…

to enter data in the cell, you must first select or activate…

Worksheet

An Excel ____________ allows data easliy to be summarized and…

requirements

The person or persons requesting the worksheet should supply…

True

False

False

True

A requirements document includes a needs statement, source of…

Worksheet titles and subtitles should be as wordy as possible

A thin red border indicates the active cell, as shown in the…

Both the Cancel Box and the Enter Box appear on the formula b…

True

A requirements document includes a needs statement, source of…

False

Worksheet titles and subtitles should be as wordy as possible

True

False

False

True

A requirements document includes a needs statement, source of…

Worksheet titles and subtitles should be as wordy as possible

A thin red border indicates the active cell, as shown in the…

Both the Cancel Box and the Enter Box appear on the formula b…

True

A requirements document includes a needs statement, source of…

False

Worksheet titles and subtitles should be as wordy as possible

Function

How do you make the words in a column…

What does this symbol mean -

what overrides the order of operations?

a prewritten formula that is built into excel

ALT Enter

negation

parenthesis

Function

a prewritten formula that is built into excel

How do you make the words in a column…

ALT Enter

Conditional formatting

Data bars

Highlight cells rules

Icon sets

Variable formatting that changes the formatting applied based…

A type of conditional formatting that creates filled backgrou…

A method of applying conditional formatting based on how cell…

A type of conditional formatting that includes one of a set o…

Conditional formatting

Variable formatting that changes the formatting applied based…

Data bars

A type of conditional formatting that creates filled backgrou…

Conditional formatting

Data bars

Highlight cells rules

Icon sets

Variable formatting that changes the formatting applied based…

A type of conditional formatting that creates filled backgrou…

A method of applying conditional formatting based on how cell…

A type of conditional formatting that includes one of a set o…

Conditional formatting

Variable formatting that changes the formatting applied based…

Data bars

A type of conditional formatting that creates filled backgrou…

AVERAGE Function

Conditional format

COUNT

COUNTIF Function

An Excel function that adds a group of values, and then divid…

A format that changes the appearance of a cell - for example,…

A statistical function that counts the number of cells in a r…

A statistical function that counts the number of cells within…

AVERAGE Function

An Excel function that adds a group of values, and then divid…

Conditional format

A format that changes the appearance of a cell - for example,…

Print titles

Find and Replace

Excel Table

Statistical Function

Command that enables you to specify rows and columns to repea…

Command that searches the cells in a worksheet-or selected ra…

Series of rows and columns that contains related data that is…

Used to analyze a group of measurements

Print titles

Command that enables you to specify rows and columns to repea…

Find and Replace

Command that searches the cells in a worksheet-or selected ra…

Function

Formula

Order of operations

Point mode

A pre-written formula that is built into Excel

A mathematical expression that Excel uses to calculate a result

Formulas are read from left to right in this order: (1) negat…

Allows you to select cells for use in a formula by using the…

Function

A pre-written formula that is built into Excel

Formula

A mathematical expression that Excel uses to calculate a result

Accounting format

Cell Style

Comma format

Currency format

A style that vertically aligns dollar sign ($). Thousands sep…

A combination of a font, text color, cell color, and other fo…

Style that displays numbers with thousands separator

A style that displays dollar sign ($) immediately preceding t…

Accounting format

A style that vertically aligns dollar sign ($). Thousands sep…

Cell Style

A combination of a font, text color, cell color, and other fo…

Argument

Formulas AutoComplete

Functions

Function Name

The values and other inputs that a function uses to calculate…

A Features that speeds up the manual entry of functions

A predefined formula that performs a specific calculation usi…

the name given to one of Excel's predefined formulas

Argument

The values and other inputs that a function uses to calculate…

Formulas AutoComplete

A Features that speeds up the manual entry of functions

Active cell

The Backstage view

Cell

Formula bar

The active cell contains the cell pointer. There is a dark ou…

A feature of Microsoft Office 2013 from which you access file…

______ is the intersection of a column and a row on a workshe…

As you enter data in a cell, it simultaneously appears here,…

Active cell

The active cell contains the cell pointer. There is a dark ou…

The Backstage view

A feature of Microsoft Office 2013 from which you access file…

MIN

MAX

Valid Arithmetic Operators

Point mode

Function that determines the lowest number in a range.

Function that determines the highest number in a range.

- % ^ * / +

When you select cells for use in a formula by using the mouse…

MIN

Function that determines the lowest number in a range.

MAX

Function that determines the highest number in a range.

range name

conditional formating

freeze

filter

an identifying label assigned to a group of cells.... also known…

changes the formatting applied based on the contents of the c…

a method to keep specified rows anf columns- usually ones con…

to display only certain records. ... 1. by form: use a form to e…

range name

an identifying label assigned to a group of cells.... also known…

conditional formating

changes the formatting applied based on the contents of the c…

rows

columns

cells

active cell

a horizontal series of cells in a chart, table, or spreadsheet

a vertical series of cells in a chart, table, or spreadsheet

intersection of a row and a column

selected cell in which data is entered when you begin typing

rows

a horizontal series of cells in a chart, table, or spreadsheet

columns

a vertical series of cells in a chart, table, or spreadsheet

copy

cut

fill handle

formula bar

takes the information from one location and duplicates it

removing data from a worksheet, but it is still located on th…

a small square in the lower-right corner of a selected cell

place between ribbon and worksheet where you can make changes…

copy

takes the information from one location and duplicates it

cut

removing data from a worksheet, but it is still located on th…

Accounting Number Format

arguments

asterisk

AVERAGE function

displays numbers with a dollar sign to the left of the number…

the information necessary to calculate the answer

a star-shaped character * used in printing also used in multi…

sums the numbers in the specified range and then divides the…

Accounting Number Format

displays numbers with a dollar sign to the left of the number…

arguments

the information necessary to calculate the answer

Accounting Number Format

arguments

asterisk

AVERAGE function

displays numbers with a dollar sign to the left of the number…

the information necessary to calculate the answer

a star-shaped character * used in printing

sums the numbers in the specified range and then divides the…

Accounting Number Format

displays numbers with a dollar sign to the left of the number…

arguments

the information necessary to calculate the answer

Accounting Number Format

arguments

asterisk

AVERAGE function

displays numbers with a dollar sign to the left of the number…

the information necessary to calculate the answer

a star-shaped character * used in printing also used in multi…

sums the numbers in the specified range and then divides the…

Accounting Number Format

displays numbers with a dollar sign to the left of the number…

arguments

the information necessary to calculate the answer

1. What do you do to emphasize a parti…

2. This finds the input needed in one…

3. Whole goal of Excel is to do ______…

4. This shape effect caused the edges…

Explode (pull the slice out from the rest of the chart)

Goal Seek

What If Analysis

Bevel

1. What do you do to emphasize a parti…

Explode (pull the slice out from the rest of the chart)

2. This finds the input needed in one…

Goal Seek

Absolute reference

Relative reference

Transpose

Argument

A cell address in a formula that will not change when you cop…

A cell address that can change in a copied formula

A method to rearrange data by switching the positions of colu…

The values and other inputs that a function uses to calculate…

Absolute reference

A cell address in a formula that will not change when you cop…

Relative reference

A cell address that can change in a copied formula

Arguments

Average function

Comparison operators

Conditional format

Values that an excel function uses to perform calculatikns or…

Excel function that adds a group of value and then divides th…

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

Changes appearance of a cell

Arguments

Values that an excel function uses to perform calculatikns or…

Average function

Excel function that adds a group of value and then divides th…

Accounting Number Format

arguments

Auto Fill Options

AVERAGE function

Displays numbers with a dollar sign to the left and inserts a…

The values that are used with a function

Button that gives options for how to fill cells following a f…

Sums numbers in a specified range and then divides by the num…

Accounting Number Format

Displays numbers with a dollar sign to the left and inserts a…

arguments

The values that are used with a function

A set of rules that governs the struct…

Displays the current date.

Indicates a cell's specific location;…

Occurs when a formula directly or indi…

Syntax

TODAY function

Absolute cell reference

Circular reference

A set of rules that governs the struct…

Syntax

Displays the current date.

TODAY function

A ______ is a prewritten formula that…

To start a new line in a cell, press t…

When you enter a two-digit year that i…

A(n) ______ circular reference occurs…

A. Function

C. ALT + Enter

A. 20xx

D. Indirect

A ______ is a prewritten formula that…

A. Function

To start a new line in a cell, press t…

C. ALT + Enter

Accounting Number Format

arguments

asterisk

AVERAGE function

displays numbers with a dollar sign to the left of the number…

the information necessary to calculate the answer

a star-shaped character * used in printing

sums the numbers in the specified range and then divides the…

Accounting Number Format

displays numbers with a dollar sign to the left of the number…

arguments

the information necessary to calculate the answer

Accounting Number Format

arguments

AVERAGE function

best fit

displays numbers with a dollar sign all the way in the left m…

the values within the parentheses that you use with a functio…

sums the numbers in the specified range and then divides the…

means that the width of the column will be increased or decre…

Accounting Number Format

displays numbers with a dollar sign all the way in the left m…

arguments

the values within the parentheses that you use with a functio…

Categories

Chart

Chart sheet

Column chart

In most cases, each column of charted worksheet.

A graphic that compares and contrasts worksheet data in a vis…

A chart that occupies its own worksheet

The default chart type that displays each data point as a ver…

Categories

In most cases, each column of charted worksheet.

Chart

A graphic that compares and contrasts worksheet data in a vis…

flash fill

formula

circular reference

direct circular reference

feature that looks for patterns in the data and automatically…

consists of cell references, numbers, and arithmetic operator…

formula in a cell that contains a reference back to itself

occurs when a formula refers to the same cell in which it is…

flash fill

feature that looks for patterns in the data and automatically…

formula

consists of cell references, numbers, and arithmetic operator…

Function

Formula

Circular Reference

Indirect Circular Reference

A pre-written formula that is built into Excel.

An expression telling the computer what mathematical operatio…

A formula in a cell that contains a reference back to itself.

Occurs when a formula in a cell refers to another cell or cel…

Function

A pre-written formula that is built into Excel.

Formula

An expression telling the computer what mathematical operatio…

Addition

Autofill Options

Average Function

Best Fit

Arithmetic operator that adds contents of cells

Button that gives options for how to fill cells following a f…

Sums numbers then divides by the number of values

The width of the column will increase or decrease so the wide…

Addition

Arithmetic operator that adds contents of cells

Autofill Options

Button that gives options for how to fill cells following a f…

Arithmetic (operators)

Formula

Order of precedence

SUM function

Symbols used in mathematical operations: +, -, *, /

An instruction Excel used to calculate a result.

The order in which Excel performs the mathematical operations…

A built-in calculation used to add a range of values together.

Arithmetic (operators)

Symbols used in mathematical operations: +, -, *, /

Formula

An instruction Excel used to calculate a result.

Accounting Number Format

arguments

asterisk

AVERAGE function

displays numbers with a dollar sign to the left of the number…

the information necessary to calculate the answer

a star-shaped character * used in printing

sums the numbers in the specified range and then divides the…

Accounting Number Format

displays numbers with a dollar sign to the left of the number…

arguments

the information necessary to calculate the answer

A command with which you can display t…

A cell reference that refers to a cell…

Rules that specify the way numbers sho…

The Default value applied to numbers

Text Wrap

Absolute Cell Reference

Number Format

General Format

A command with which you can display t…

Text Wrap

A cell reference that refers to a cell…

Absolute Cell Reference

asterisk

best fit

circular reference

debugging

is a arithmetic operator that directs excel to preform the mu…

that the width of the column will increase or decrease so tha…

a formula in a cell that contains a reference back to itself

is the process of finding and correcting errors in the worksh…

asterisk

is a arithmetic operator that directs excel to preform the mu…

best fit

that the width of the column will increase or decrease so tha…

Auto Fill

AutoComplete

copy

copy pointer

Excel provides Auto Fill options that automatically fill cell…

If the first few characters that you type in a column match a…

Copy takes the information from one location and duplicates it.

When the pointer becomes a copy pointer (arrow with a plus),…

Auto Fill

Excel provides Auto Fill options that automatically fill cell…

AutoComplete

If the first few characters that you type in a column match a…

function

statistical functions

SUM function

arguments

a predefined formula that performs calculations by using spec…

Functions used to describe large quantities of data; average,…

a predefined formula that adds all the numbers in a selected…

the values that an Excel function uses to perform calculation…

function

a predefined formula that performs calculations by using spec…

statistical functions

Functions used to describe large quantities of data; average,…

A relative cell reference

An absolute cell reference

A mixed cell reference

A circular reference

indicates a cells relative location from the cells containing…

indicates a cells specific location and the reference does no…

Contains both an absolute and a relative cell reference

occurs when a formula directly or indirectly refers to the ce…

A relative cell reference

indicates a cells relative location from the cells containing…

An absolute cell reference

indicates a cells specific location and the reference does no…

Auto fill

Auto complete

Copy

Copy pointer

Automatically fill cells with data and or formatting

Feature works only for entries that contain text or à combinâ…

Takes the information from one location and duplicates it

You can drag the cell or range of cells to the new location

Auto fill

Automatically fill cells with data and or formatting

Auto complete

Feature works only for entries that contain text or à combinâ…

default settings

definitive command

document properties

fast command

standard settings installed by an application as presets so t…

a command that closes Backstage view and returns the user to…

document information that identifies who created the document…

a command that provides quick access to common functions and…

default settings

standard settings installed by an application as presets so t…

definitive command

a command that closes Backstage view and returns the user to…

text wrap

absolute cell reference

number format

general format

a command with which you can display text on multiple lines w…

a cell reference that refers to a cell by its fixed position…

rules that specify the way numbers should display

the default format applied to numbers

text wrap

a command with which you can display text on multiple lines w…

absolute cell reference

a cell reference that refers to a cell by its fixed position…

Case

Concatenation

Freeze

Panes

The use of capital and small letters in text.

The linking of elements together in a series.

A method to keep specified rows and columns—usually ones cont…

Sections or areas in a window that enable you to see differen…

Case

The use of capital and small letters in text.

Concatenation

The linking of elements together in a series.

Argument

AutoCalculate

Formula AutoComplete

Functions

The values and other unputs that a function uses to calculate…

A feature that temporarily performs the following calculation…

A feature that speeds up the manual entry of functions.

a predefind formula that performs a specific calculation usin…

Argument

The values and other unputs that a function uses to calculate…

AutoCalculate

A feature that temporarily performs the following calculation…