Excel 英文单词笔记

A

worksheet

is

a

single

spreadsheet

that

typically

contains

pointing.

descriptive

labels,

numeric

values,

formulas,

functions,

and

Auto Fill

enables you to copy the contents of a cell/range of cells by

graphical representations of data.

contained within a single file.

Quick Access Toolbar

:Save, Undo, and Redo/Repeat commands

Excel)

Restore Down, and Close

(such as Alignment) on various tabs (such as Home)

worksheet

The intersection of a column and row is a

cell

dragging the

fill handle

over an adjacent cell or range of cells.

using

the

default

font

or

the

number

of

horizontal

pixels;

Row

height

is the vertical measurement of the row.

Column headings

nonadjacent range

contains multiple ranges.

Merge &Center

:Merges selected cells & centers data into one cell;

or values right aligned;

Merge Cells:

Enables you to merge a range

Cells

: Separates a merged cell into multiple cells again.

Horizontal alignment

specifies the position of data between the left

and right cell margins;

Vertical alignment

specifies the position of

data between the top and bottom cell margins.

You can use

wrap text

to make data appear on multiple lines by

adjusting row height to fit the cell contents within the column width.

Indenting

helps others see the hierarchical structure of data.

A

border

is a line that surrounds a cell or a range of cells.

Fillcolor

is a background color that displays behind the data.

Apply number formats based on the type of values in a cell.

The

Numbergroup

on

the

Home

tab

contains

commands

for

applying Accounting Number Format, Percent Style, and Comma

Each cell has a unique

cell address

, identified by first its column

letter and then its row number.

An

input

area

is

a

specific

region

in

the

worksheet

to

store

and

change the variables used in calculations

An

output area

is the region in the worksheet to contain formulas

dependent on the values in the input area

Plan

the

Worksheet

Design

the

purpose

of

the

what

input

values

are

what

outputs are needed to achieve the purpose of the worksheet

Enter and Format the Data

the labels, values, and formulas

in

the

numerical

values

in

the

the descriptive titles and labels so that they stand out

Complete the Workbook

nt the workbook as thoroughly

as and share the completed workbook

Text

is any combination of letters,

numbers, symbols, and spaces

not used in calculations.

AutoComplete

feature searches for and automatically displays any

other label in that column that matched the letters you typed.

Values

are numbers represent a quantity or measurable amount.

Formulas

combine

cell

references,

arithmetic

operations,

values,

and/or functions used in a calculation.

The

order

of

precedence

(order

of

operations)

is

a

rule

that

controls the sequence in which arithmetic operations are performed,

which affects the results of the calculation.

Semi-selection

is a process of selecting a cell or range of cells for

entering

cell

references

as

you

create

formulas.

It

is

often

called

Style numbering formats.

PageLayoutview

is with the insertion point in the center area of the

header.

Normalview

.

A

relativecellreference

indicates a cell’s relative location, such as

five rows up and one column to the left.

An

absolutecellreference

provides

a

permanent

reference

to

a

specific cell.

A

mixedcellreference

combines an absolute cell reference with a

relative cell reference.

If

a

formula

contains

a

direct

or

an

indirect

reference

to

the

cell

containing the formula, a

circularreference

exists.

An

excel

function

is

a

predefined

computation

that

simplifies

creating a formula that performs a complex calculation.

Syntax

is

the

rules

that

dictate

the

structure

and

components

required to perform the necessary calculations.

A function’s

arguments

specify the inputs.

FormulaAutoComplete

displays

a

list

of

functions

and

defined

names that match letters as you type a formula.

Excel displays the function

ScreenTip

, a small pop-up description

that displays the function’s arguments.

Arguments names in

bold

are required, not in bold are optional.

The

SUMfunction

totals

values

in

two

or

more cells and

displays

the

result

in

the

cell

containing

the

function;

The

AVERAGEfunction

calculates the arithmetic mean, or average, for

the

values

in

a

range

of

cells;

The

MEDIANfunction

finds

the

midpoint

value,

which

is

the

value

that

one half

of

the

data

set

is

above

or

below;

The

MINfunction

analyzes

an

argument

list

to

A

workbook

is

a

collection

of

one

or

more

related

worksheets

Column width

is the number of characters that can fit horizontally

Title Ba

r: File name (such as Book1) and software name (such as

A

range

refers

to

a

group

of

adjacent

or

contiguous

cells;

A

Control buttons

:Microsoft Excel Help, Full Screen Mode, Minimize,

Alignment

refers to how data are positioned in cells.

Ribbon

:

Commands

(such

as

Align

Left)

organized

within

groups

Merge Across:

Merges the selected cells but keeps text left aligned

Scroll

bars

:

Tools

to

scroll

vertically

and

horizontally

through

a

of cells on multiple rows as well as in multiple columns;

Unmerge