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

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

Columns

Rows

Relative Cell Reference

Absolute Cell Reference

Go up and down; labeled with letters starting at A from the le…

Go sideways; labeled with numbers starting at 1 from the top

Use when important to preserve relationship to the formula loc…

Use to preserve the exact cell address in the formula; should…

Columns

Go up and down; labeled with letters starting at A from the le…

Rows

Go sideways; labeled with numbers starting at 1 from the top

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 backgroun…

A method of applying conditional formatting based on how cell…

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

Conditional formatting

Variable formatting that changes the formatting applied based…

Data bars

A type of conditional formatting that creates filled backgroun…

Argument

AutoCalculate

Formula AutoComplete

Function

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

A feature that temporarily performs the following calculations…

A feature that speeds up the manual entry of functions.

A predefined formula that performs a specific calculation usin…

Argument

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

AutoCalculate

A feature that temporarily performs the following calculations…

Fixed Dollar Sign

Arugments

Average Function

Comma Style

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

Values used with a function.

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

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

Fixed Dollar Sign

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

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 calculate…

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 usin…

Argument

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

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 t…

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

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

Worksheet

An Excel ____________ allows data easliy to be summarized and…

requirements

The person or persons requesting the worksheet should supply t…

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 a…

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

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 a…

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

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 g…

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 g…

ALT Enter

AVERAGE Function

Conditional format

COUNT

COUNTIF Function

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

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

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

A statistical function that counts the number of cells within…

AVERAGE Function

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

Conditional format

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

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) negati…

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

Function

A pre-written formula that is built into Excel

Formula

A mathematical expression that Excel uses to calculate a result

Print titles

Find and Replace

Excel Table

Statistical Function

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

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

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 repeat…

Find and Replace

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

Accounting format

Cell Style

Comma format

Currency format

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

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

Style that displays numbers with thousands separator

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

Accounting format

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

Cell Style

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

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 usin…

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 out…

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

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

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

Active cell

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

The Backstage view

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

Argument

Function

Function name

Nest

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

A predefined formula that performs a specific calculation usin…

The Name given to one of Excel's predefined formulas.

To use a function as an argument within another function.

Argument

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

Function

A predefined formula that performs a specific calculation usin…

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.

Column specifier

Criterion

Excel table

Filter

The structured reference to a table column, which consists of…

A value, some text, or an expression that defines the type of…

Data arranged in columns and specifically formatted with colum…

Hide nonmatching rows in a table or list of data according to…

Column specifier

The structured reference to a table column, which consists of…

Criterion

A value, some text, or an expression that defines the type of…

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 ce…

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

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

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 ce…

Accounting Number Format

arguments

AVERAGE function

best fit

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

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

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

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

Accounting Number Format

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

arguments

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

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 the…

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 the…

AVERAGE Function

Arguments

Comparison Operators

Conditional format

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

The values that an Excel function uses to perform calculations…

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

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

AVERAGE Function

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

Arguments

The values that an Excel function uses to perform calculations…

AVERAGE Function

Conditional format

COUNT

COUNTIF Function

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

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

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

A statistical function that counts the number of cells within…

AVERAGE Function

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

Conditional format

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