Excel vocabs
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
Spreadsheet | Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions.
🗑
|
||||
workbook | A group of adjacent worksheets
🗑
|
||||
worksheet | Sheets in an excel workbook
🗑
|
||||
Workbook Window | is a collection of cells where you keep and manipulate the data. By default, each Excel workbook contains three worksheets.
🗑
|
||||
cell | A cell is the intersection between a row and a column on a spreadsheet that starts with cell A1.
🗑
|
||||
Sheet tab | is the current worksheet that is being displayed.
🗑
|
||||
Active worksheet | is the worksheet that is currently open.
🗑
|
||||
workspace | A workspace in Excel is a file that memorizes the current layout of all open windows and workbooks.
🗑
|
||||
columns | is a vertical series of cells in a chart, table, or spreadsheet.
🗑
|
||||
rows | A row is the range of cells that go across (horizontal) the spreadsheet/worksheet.
🗑
|
||||
headings | is the colored row of letters used to identify each column within the sheet, or workbook.
🗑
|
||||
Cell reference | refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.
🗑
|
||||
Name box | is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet.
🗑
|
||||
Formula bar | A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts.
🗑
|
||||
Formula | Using formulas in spreadsheets can allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet.
🗑
|
||||
Relative reference | When copied across multiple cells, they change based on the relative position of rows and columns.
🗑
|
||||
Absolute reference | remain constant, no matter where they are copied.
🗑
|
||||
Mixed reference | A mixed cell reference is either an absolute column and relative row or absolute row and relative column
🗑
|
||||
Active cell | is the selected cell in which data is entered when you begin typing.
🗑
|
||||
Enter data | When you enter text or numbers in Microsoft excel worksheets.
🗑
|
||||
range | A group of selected cells
🗑
|
||||
Gridlines | A solid lines that marked of the rows and columns in a worksheet
🗑
|
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:
truly_valla
Popular Computers sets