Excel Terms 2 Assessment

____________a letter punctuation mark or symbol

a predefined setting you can accept excel's default option

settings or you can change them.

An arrangement in which data appears alphabetically from

A to Z.

a reference that does not change when a formula is copied

or moved

a component of a function that is enclosed in parenthesis

A feature that allows users to enter and edit data on

several worksheets at the same time or apply formatting

to multiple worksheets.

small badges displaying keyboard shortcuts for specific

tabs and commands on the ribbon and Quick Access

Toolbar

A reference in which one component is absolute and one

is relative.

file designed with formatting and formulas complete with

designs,tools,and specific data types

A tool that allows users to drag a cell or range of cells to a

new location, replacing any existing data in the destination

cells.