Excel Lesson 2 Vocab
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
RANGE | A BLOCK OF CELLS IN AN EXCEL WORKSHEET.
🗑
|
||||
CONTIGUOUS RANGE | A BLOCK OF ADJACENT CELLS IN A WORKSHEET.
🗑
|
||||
NONCONTIGUOUS RANGE | CELLS IN A WORKSHEET THAT ACT AS A BLOCK, BUT ARE NOT NECESSARILY ADJACENT TO EACH OTHER.
🗑
|
||||
FORMAT | TO APPLY ATTRIBUTES TO CELL DATA TO CHANGE THE APPEARANCE OF THE WORKSHEET.
🗑
|
||||
THEME | A COLLECTION OF CORRDINATED FONTS, COLORS, AND EFFECTS FOR GRAPHIC ELEMENTS SUCH AS CHARTS AND IMAGES THAT CAN BE QUICKLY APPLIED TO ALL SHEETS IN A WORKBOOK.
🗑
|
||||
FONT | THE TYPEFACE OR DESIGN OF THE TEXT.
🗑
|
||||
FILL | A COLOR THAT FILLS A CELL, APPEARING BEHIND THE DATA.
🗑
|
||||
CELL STYLES | A COMBINATION OF A FONT, TEXT COLOR, CELL COLOR, AND OTHER FONT ATTRIBUTES APPLIED TO A SINGLE CELL. THEY ARE CALL QUICK STYLES IN OTHER OFFICE PROGRAMS.
🗑
|
||||
FONT SIZE | THE MEASUREMENT OF THE TYPEFACE IN POINTS (ONE POINT EQUALS 1/72 OF AN INCH)
🗑
|
||||
NUMBER FORMAT | A FORMAT THAT CONTROLS HOW NUMERICAL DATA IS DISPLAYED, INCLUDING THE USE OF COMMAS, DOLLAR SIGNS (OR OTHER SYMBOLS), AND THE NUMBER OF DECIMAL PLACES.
🗑
|
||||
ACCOUNTING FORMAT | A STYLE THAT VERTICALLY ALIGNS WITH DOLLAR SIGNS ($), THOUSANDS SEPARATORS (,), AND DECIMAL POINTS.
🗑
|
||||
PERCENT FORMAT | A STYLE THAT DISPLAYS DECIMAL NUMBERS AS A PERCENTAGE.
🗑
|
||||
COMMA FORMAT | A STYLE THAT DISPLAYS NUMBERS WITH A THOUSANDS SEPARATOR (,).
🗑
|
||||
CURRENCY FORMAT | A SYTLE THAT DISPLAYS DOLLAR SIGNS ($) IMMEDIATELY PRECEDING THE NUMBER AND INCLUDES A THOUSANDS SEPARATOR(,).
🗑
|
||||
CLIPBOARD | A FEATURE OF WINDOWS THAT HOLDS DATA OR GRAPHICS THAT YOU HAVE CUT OR COPIED AND ARE READY TO BE PASTED INTO ANY DOCUMENT.
🗑
|
||||
FILL HANDLE | DRAGGING THIS HANDLE, LOCATED IN THE LOWER-RIGHT CORNER OF THE ACTIVE CELL, WILL COPY CELL CONTENTS, FORMATTING, OR A FORMULA TO ADJACENT CELLS.
🗑
|
||||
FORMAT PAINTER | A BUTTON ON THE HOME TAB THAT ALLOWS YOU TO COPY FORMATIING FOR A SELCTED OBJECT OR CELL AND APPLY IT TO ANOTHER OBJECT OR CELL.
🗑
|
||||
RELATIVE CELL REFERENCE | A CELL ADDRESS EXPRESSED IN RELATION TO THE CELL CONTAINING THE FORMULA. FOR EXAMPLE, RATHER THAN ANMING A SPECIFIC CELL IN A FORMULA, A RELATIVE CELL REFERENCE MIGHT IDENTIFY A CELL THREE COLUMNS TO THE LEFT OF THE CELL CONTAINING THE FORMULA.
🗑
|
||||
ABSOLUTE CELL REFERENCE | A CELL ADDRESS, SUCH AS $E$14, REFERENCED IN A FORMULA THAT DOES NOT CHANGE BASED ON THE LOCATION OF THE CELL THAT CONTAINS THE FORMULA.
🗑
|
||||
PRINT PREVIEW | A FEATURE USED TO DISPLAY A DOCUMENT AS IT WILL APPEAR WHEN PRINTED.
🗑
|
||||
CUT | THE COMMAND USED TO REMOVE DATA FROM A CELL OR RANGE OF CELLS AND PLACE IT ON THE CLIPBOARD.
🗑
|
||||
PASTE | THE COMMAND USED TO PLACE DATA FROM THE CLIPBOARD TO A LOCATION ON THE WORKSHEET.
🗑
|
||||
DRAG-AND-DROP FEATURE | A MEHOD USED TO MOVE OR COPY THE CONTENTS OF A RANGE OF CELLS BY DRAGGING THE BORDER OF A SELECTION FROM ONE LOCATION IN A WORKSHEET AND DROPPING IT IN ANOTHER LOCATION.
🗑
|
||||
GROUPING | WORKSHEETS THAT ARE SELCETED AS A UNIT; ANY ACTION PERFORMED ON THIS UNIT WILL AFFECT ALL THE WORKSHEETS IN THE GROUP.
🗑
|
||||
ACTIVE SHEET TAB | THE SELECTED WORKSHEET; THE TAB NAME OF AN ACTIVE SHEET IS BOLD.
🗑
|
Review the information in the table. When you are ready to quiz yourself you can hide individual columns or the entire table. Then you can click on the empty cells to reveal the answer. Try to recall what will be displayed before clicking the empty cell.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
To hide a column, click on the column name.
To hide the entire table, click on the "Hide All" button.
You may also shuffle the rows of the table by clicking on the "Shuffle" button.
Or sort by any of the columns using the down arrow next to any column heading.
If you know all the data on any row, you can temporarily remove it by tapping the trash can to the right of the row.
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
Normal Size Small Size show me how
Created by:
jaebird124
Popular Computers sets