Excel Module 1 & 2

You can create an absolute cell reference by placing a ________ in front of both the column letter and the row number of the cell address

$

Absolute cell reference

$G$6

Mixed cell reference

$G6

Advantages of using Excel

-Enter data quickly and accurately -recalculate data easily -create charts

Values

Numbers, formulas, and functions used in calculations

In Excel, a worksheet is contained in a file called a ____.

workbook

The Undo button allows you to reverse up to ____ previous actions, one at a time.

100

Cell

A box formed by the intersection of a row and column in a worksheet or a table, in which you enter information.

Avg function

A built-in function used to calculate the average of the values in a given fuel or cell range

Workbook

A collection of related worksheets contained within a single file which has the file extension XLSX

Flash fill

A feature that lets you fill a range of text based on samples existing in the current worksheet

Complex formula

A formula that uses more than one arithmetic operator

Formula

A set of instructions used to perform one or more numeric calculations, such as adding, multiplying, or averaging, on values, or cells.

Worksheet

A single sheet within a workbook file;also the entire area within an electronic spreadsheet that contains a grid of columns and rows

Function

A special, predefined formula that provides a shortcut for a commonly used or complex calculation, such as SUM (for calculating a sum) or FV ( for calculating a future value of an investment)

Sheet tab scrolling buttons

Allow you to navigate the additional sheet tabs when available; located to the left of the sheet tab

Quick Analysis tool

An icon that is displayed below and to the right of the range that lets you easily create charts and other elements

Insertion point

Appears on the screen as a flashing vertical bar or flashing underline and indicates where the characters you type will appear on the screen. Also called cursor.

Worksheet window

Area of the program window that displays part of the current worksheet; the worksheet window displays only a small fraction of the worksheet, which can contain a total of 1,048,576 rows and 16,384 columns.

Scroll bars

Bars on the right edge (vertical scroll bar) and bottom edge (horizontal scroll bar) of a window that allows you to move around in a window with information that is too large to fit on the screen at once

Name box

Box to the left of the formula bar that shows the cell reference or name of the active cell

Auto fill options button

Button that appears after using the fill handle to copy cell contents; enables you to choose to fill cells with specific elements (such as formatting) of the copied cell if desired.

In the formula =D1+C1/F3, which calculation will be performed first?

C1/F3

Represent values graphically

Creating charts based on worksheet data

analyze data

Creating data summaries and short lists using PivotTables or AutoFilters

generate reports

Creating workbooks that combine information from multiple worksheets, such as summarized sales information from multiple stores

Labels

Descriptive text or other information that identifies data in rows, columns, or charts, but is not included in calculations.

Allows the user to move or copy data from one cell to another without using the Clipboard.

Drag and drop method

Business Intelligence tools

Excel features for gathering and analyzing data to answer sophisticated business questions

A cell reference that does not change when it is copied is called a(n) relative cell reference

False

According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.

False

True or false? The COUNTA function returns the number of cells in a range that contain numeric data.

False

Auto fill

Feature activated by dragging the fill handle; copies a cell's contents or continues a series of entries into adjacent cells.

Sheet tabs

Identify the sheets in a workbook and let you switch between sheets; located below the worksheet grid.

Absolute cell reference

In a formula, a cell address that refers to a specific cell and does not change when you copy the formula; indicated by a dollar sign before the column letter and/or row number.

Text concatenation operators

In a formula, symbols used to join strings of text in different cells.

Reference operators

In a formula, symbols which enable you to use ranges in calculations.

Range

In excel, a selection of two or more cells, such as B5:B14

Landscape

Page orientation in which the contents of a page span the length of a page rather than its width, make the page wider than it is tall.

Portrait

Page orientation in which the contents of a page span the width of a page, so the page is taller than it is wide.

The Excel feature used to selectively copy formulas, values, etc. by choosing options such as "paste formulas only."

Paste list arrow

Page Layout View

Provides an accurate view of how a worksheet will look when printed, including headers and footers.

Order of precedence

Rules that determine the order in which operations are performed within a formula containing more than one arithmetic operator.

The ____ option helps fit the data on a single page without making changes to individual margins.

Scale to Fit

____ below the worksheet grid let you switch from sheet to sheet in a workbook.

Sheet tabs

To display gridlines on a worksheet, click the Gridlines check box in the __________ group on the View tab.

Show

Provides a brief description of the active command or task in progress

Status bar

Normal view

The Excel, the default worksheet view that shows the worksheet without features such as headers and footers; ideal for creating and editing a worksheet, but may not be detailed enough when formatting a document.

Formula bar

The area above the worksheet grid where you enter or edit data in the active cell.

Status bar

The bar at the bottom of an Office program window that shows information about the document, workbook, database, or presentation, such as its zoom level or the current view.

Active cell

The cell in which you are currently working.

Microsoft Excel

The electronic spreadsheet within the Microsoft Office Suite

Cell address

The location of a cell, expressed by cell coordinates; for example, the cell address of the cell in column A, row 1 is A1.

Print area

The portion of a worksheet that will be printed; can be defined by selecting a range and then using the Print Area button on the Page Layout tab.

Edit

To make a change to the contents of an active cell

True or false? Charts are updated automatically in Excel whenever data changes.

True

True or false? To print the formulas in a worksheet, click the Formulas tab, then click the Show Formula button in the Formula Auditing group

True

create what-if data scenarios

Using variable values to investigate and sample different outcomes, such as changing the interest rate or payment schedule on a loan

In a payroll worksheet, Peter worked 40 hours and actual hours are stored in cell B5. This is a ____.

Value

To move one screen to the left press ____.

[Alt][Page Up]

To quickly jump to the first cell in a worksheet press ____.

[Ctrl][Home]

The Excel operator for exponent is ____.

^

Electronic Spreadsheet

a computer program used to perform calculations and analyze and present numeric data

What-if analysis

a decision making tool in which data is changed and formulas are recalculated, in order to predict various possible outcomes

to perform calculations

adding formulas and functions to worksheet data

Formula AutoComplete

an Excel feature which, after typing an = (equal sign) and the beginning letter or letters of a function name, displays a list of function names that match the typed letter(s)

Mode indicator

an area on the left end of the status bar that indicates the program's status

Formula prefix

an arithmetic symbol, such as the equal sign (=) used to start a formula.

____ operators perform mathematical calculations such as adding and subtracting.

arithmetic

You can use the ____ key(s) on the keyboard to navigate the work sheet

arrow

Identified by the coordinates of the intersecting column and row

cell address

A dark rectangle that outlines the cell in which you are working

cell pointer

Cell pointer

dark rectangle that outlines the cell in which you are working

Page Break Preview

displays a reduced view of each page of the worksheet, along with page break indicators

While you are entering a formula in a cell, the cell references and arithmetic operators appear in the _______.

formula bar

A(n) ____ is a built-in formula that uses arguments to calculate information.

function

In Excel, MAX and AVERAGE are examples of ____.

functions

Relative cell reference

in a formula, a cell address that refers to a cell's location in relation to the cell containing the formula and that automatically changes to reflect the new location when the formula is copied or moved; default type of referencing used in Excel worksheets.

Comparison operators

in a formula, symbols that compare values for the purpose of true/false results

Arithmetic Operators

in a formula, symbols that perform mathematical calculations, such as addition (+), subtraction (-) multiplication (*), division (/) or exponentiation (^)

Arguments

information that a function uses to create the final answer. Multiple arguments are separated by commas. All of the arguments for a function are surrounded by a single set of parentheses.

The name Peter is entered in cell B4. This is a ____.

label

Which method of entering a function requires the user to know the name and initial characters of a function?

manually typing the function

Templates

predesigned, formatted files

An Excel user should use a relative cell reference when it is important to ____.

preserve the relationship to the formula location

The type of cell reference used to preserve the relationship to the formula location

relative

organize data

sorting data in ascending or descending order

Calculation operators

symbols in a formula that indicate what type of calculation to perform on the cells, ranges, or values

Predesigned workbook files that contain labels, values, formulas, and formatting

template

In the formula =ROUND(D4:F4,0), what does the zero indicate?

the number of decimal places in the rounded number

The Excel function that returns the number of cells in a range containing numeric data.

to count