BA 240 Chapter 1

freeze pane

When you want column and row headings display whether you are at the top, bottom, left, or right of the spreadsheet, select:

range

a group of cells is called a

pound sign

appear in any cell, means you column is not wide enough to accommodate the entry

fill pointer

copies cell contents, completes lists and fills patterns of selected data

values and source formatting

copy contents and formatting of source cell(s) without formulas

values and number formatting

copy contents and formatting of source cell(s), but use the format of the destination area for labels

values

copy contents of source cell(s) without formatting or formulas

Wrap Text or use Merge and Center

display multiple lines in a cell using

cell reference

each cell is identified with a (ex. C12)

normal, page layout and page break preview

excel has three main views

.xlsx

excel workbooks are saved as

workbook

file you create and edit

value

is a number that you type in a cell

Format Painter

option allows you to copy formatting attributes and styles from one cell to another cell or group of cells

AutoFit

resizes column width or row height to accommodate the width or height of the largest entry

Clipboard

stores cut or copied data from Excel

label

text in a worksheet that identifies a title and subtitle, row and column heading

destination cell

the cell you paste to is a

fill handle

typing data in a series you can use the

source cell

when you cut, copy and paste, the cell you cut or copy from is a

worksheets

workbook file contains many___(also referred to as a spreadsheet or a sheet)

columns and rows

worksheet is arranged in