Excel Lesson 1 Vocab
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| WORKBOOK | AN EXCEL FILE WITH ONE OF MORE WORKSHEET.
🗑
|
||||
| WORKSHEET | THE WORK AREA FOR ENTERING AND CALCULATING DATA MADE UP OF COLUMNS AND ROWS SEPARATED BY GRIDLINES (LIGHT GRAY LINES). ALSO CALLED SPREADSHEET.
🗑
|
||||
| CELL | THE INTERSECTION OF A COLUMN AND A ROW ON A WORKSHEET. YOU ENTER DATA INTO THESE TO CREATE A WORKSHEET.
🗑
|
||||
| ACTIVE CELL | THE ACTIVE CELL CONTAINS THE CELL POINTER. THERE IS A DARK OUTLINE AROUND THE ACTIVE CELL.
🗑
|
||||
| FORMULA BAR | AS YOU ENTER DATA INTO A CELL, IT SIMULTANEOUSLY APPEARS IN THE FORMULA BAR, WHICH IS LOCATED ABOVE THE WORKSHEET.
🗑
|
||||
| CELL REFERENCE | THE LOCATION OF A CELL IN A WORKSHEET AS IDENTIFIED BY ITS COLUMN LETTER AND ROW NUMBER. ALSO KNOWN AS THE CELL'S ADDRESS.
🗑
|
||||
| SCROLL | A WAY TO VIEW LOCATIONS ON THE WORKSHEET WITHOUT CHANGING THE ACTIVE CELL.
🗑
|
||||
| SHEET TABS | TABS THAT APPEAR AT THE BOTTOM OF THE WORKBOOK WINDOW, WHICH DISPLAY THE NAME OF EACH WORKSHEET.
🗑
|
||||
| TAB SCROLLING BUTTONS | BUTTONS THAT APPEAR JUST TO THE LEFT OF THE SHEET TABS, WHICH ALLOW YOU TO SCROLL HIDDEN TABS INTO VIEW.
🗑
|
||||
| BLANK WORKBOOK | A NEW EMPTY WORKBOOK CONTAINS THREE WORKSHEETS.
🗑
|
||||
| TEMPLATE | A WORKBOOK WITH CERTAIN LABELS, FORMULAS, AND FORMATTING PRESET, SAVING YOU TIME IN CREATING COMMONLY USED WORKSHEEETS, SUCH AS MONTHLY INVOICES OR BALANCE SHEETS.
🗑
|
||||
| LABEL | TEXT IN THE FIRST ROW OR COLUMN OF A WORKSHEET THAT IDENTIFIES THE TYPE OF DATA CONTAINED THERE.
🗑
|
||||
| DEFAULTS | THE STANDARD SETTINGS EXCEL USES IN ITS SOFTWARE, SUCH AS COLUMN WIDTH OR NUMBER OF WORKSHEETS IN A WORKBOOK.
🗑
|
||||
| UNDO | THE COMMAND USED TO REVERSE ONE OF A SERIES OF EDITING ACTIONS.
🗑
|
||||
| REDO | THE COMMAND USED TO REDO AN ACTION YOU HAVE UNDONE.
🗑
|
||||
| AUTOCOMPLETE | A FEATURE USED TO COMPLETE AN ENTRY BASED ON PREVIOUS ENTRIES MADE IN THE COLUMN CONTAINING THE ACTIVE CELL.
🗑
|
||||
| PICK FROM DROP-DOWN LIST | A SHORTCUT USED TO INSERT REPEATED INFORMATION.
🗑
|
||||
| AUTOCORRECT | A FEATURE USED TO AUTOMATE THE CORRECTION OF COMMON TYPING ERRORS.
🗑
|
||||
| SPELLING CHECKER | A TOOL USED TO ASSIST YOU IN FINDING AND CORRECTING TYPOGRAPHICAL OR SPELLING ERRORS.
🗑
|
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