Excel Lesson 6

Front 1

Ascending sort

Back 1

data with letters is arranged i alphabetical order A-Zdata with numbers is arranged from smallest to largest and data with dates is arranged from earliest to latest.

Front 2

sort

Back 2

rearranges data in more meaningful order.

Front 3

descending sort

Back 3

arranges data with letters from Z to A data with numbers from largest to smallest and data with dates from oldest to newest.

Front 4

filter

Back 4

displays a subset of data that meets certain criteria and temporarily hides the rows that do not meet the specified criteria

Front 5

filte arrow

Back 5

appear in the lower right corners of the cells with column labels

Front 6

conditional formatting

Back 6

changes the appearance of cells that meet a specified condition

Front 7

Shapes

Back 7

can help make a woksheet more informitive.

Front 8

object

Back 8

anything that appears on the screen that can select and work with as a whole

Front 9

Smartart graphics

Back 9

enhance worksheets by providing a visual representation of information and ideas

Front 10

picture

Back 10

is a digital photograph or other image file

Front 11

screenshot

Back 11

a picture of all or part of something you see on your monitor, such as a word document an excel workbook a photograph ar a web page

Front 12

screen clipping

Back 12

the area that you choose to include

Front 13

templates

Back 13

are predesigned workbook files taht you can use as the basis or model for new workbooks

Front 14

Hyperlink

Back 14

is a reference that opens a web page afile a specific location in the current workbook a new document when you click on it.

Front 15

comment

Back 15

is a note attached to a cell that you can use to explain or identify information contained in the cill

Front 16

research task pane

Back 16

provides access to information typically found in references such as dictionaries thesauruses and encyclopedias