Mlcak Microsoft Excel ch 1

Mlcak copied from Quizlet Excel Ch 1

worksheet

An Excel \_____________ allows data easily to be summarized and charted.

Function

Excel's preset list of formulas you can use such as SUM

data

Often \________ is consolidated into a summary when using a spreadsheet.

chart

A visual representation of data and tells a story about its underlying data.

select a cell

What do you need to do if you are asked to make the cell active

active cell

What do you call the cell that is currently selected with a heavy border around it?

both its row heading and column heading change to a shaded color

Without looking at the active cell or the name box

double clicking

To enter data in a cell

name box

In a spreadsheet, the active cell "reference" appears in the _________. This is where can you look for the address to the active cell.

Formula Bar

This shows the data or formula/equation that is typed into the active cell

escape key or click the cancel box in the formula bar

How do you cancel an entire entry before entering it into a cell?

AutoCorrect

What feature will NOT correct the spelling of your name.

Range

What is a series of two or more adjacent cells in a column

Fill Handle

What is the name of the small square located in the lower-right corner of the active cell. This square is used to copy cell contents to adjacent cells.

SUM function

What function will add all of the numbers in a range of cells?

format

To emphasize certain entries and make the worksheet easier to read and understand

Merging

\________ cells involves creating a single cell by combining two or more selected cells.

Splitting

\_______ a merged cell displays the original cells on the worksheet.

Category

Titles in a given range identify the slices of a pie chart

these entries are called the \_______.

Insert

When Overtype mode is on

row

In a spreadsheet, each ______ runs across the screen horizontally.

column

In a spreadsheet, each ______ runs down the screen vertically.

letter

Column titles are labeled with \__________ heading across the top of the worksheet.

number

Row titles are labeled with \__________ heading along the side of the worksheet.

lock or freeze

Absolute cell reference is a cell address that contains a dollar sign ($) and using it will \_____________ the address of the reference.

Insert Function

Use the \_____________________ button to open the dialog box to help you insert the correct formula and arguments for your needs. ( To view the Insert Function dialog box

Select all

This button sits at the upper left of all worksheets

column headings

The letters along the top of the worksheet window that identify the different columns in the worksheet.

row headings

numbers along the left side of the workbook window that identify the different rows of the worksheet

Tab Scrolling

The Sheet Tab Scroll Buttons are another means of navigating between sheets of the workbook other than selecting a tab. The value of this functionality will become more evident with the use of multiple worksheets within a workbook. Used to navigate through hidden tabs.

Flash Fill

When Excel recognizes a pattern based on other information in your workbook

Cell Reference

a cell you point to in a formula to refer to the data in that cell

relative cell reference

cell reference that adjusts to a new location when copied or moved

absolute cell reference

Cell reference that does not adjust to the new cell location when copied or moved. Is is locked or frozen with use of $ in front of the cell reference (example $B$6)

Conditional Formatting

An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed. Allows you to automatically apply formatting such as colors

Number Format

A format that controls how numerical data is displayed