Lesson 1 & 2
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
Excel 2010 | The spreadsheet program in Microsoft Office 2010
🗑
|
||||
spreadsheet | A grid of rows and columns in which you enter text, numbers, and the results of calculations
🗑
|
||||
Worksheet | A computerized spreadsheet in Excel
🗑
|
||||
Workbook | The file used to store worksheets; usually a collection of related worksheets
🗑
|
||||
Active Worksheet | The worksheet that is displayed in the work area
🗑
|
||||
Row | The horizontal placement of cells in a table or worksheet
🗑
|
||||
Column | A vertical stack of cells in a table or worksheet
🗑
|
||||
Cell | The intersection of a column and a row in a table or worksheet
🗑
|
||||
Active Cell | The cell in the worksheet in which you can type data
🗑
|
||||
Name Box | The cell reference area located below the Ribbon, which displays the cell reference of the active cell
🗑
|
||||
Cell Reference | A unique identifier for a cell, which is formed by combining the cell’s column letter and row number
🗑
|
||||
Range | A group of selected cells
🗑
|
||||
Range Reference | The unique identifier for a range, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a colon
🗑
|
||||
Formula | An equation that calculates a new value from values currently in a worksheet
🗑
|
||||
Formula Bar | The box to the right of the Name Box that displays a formula when the cell of a worksheet contains a calculated value (or the results of a formula)
🗑
|
||||
Column Heading | column letter displayed at the top of the Excel window
🗑
|
||||
Row Heading | row number displayed at the left of the Excel window
🗑
|
||||
Autofit | determines the best width for a column or the best height for a row, based on its contents
🗑
|
||||
Alignment | specifies where data is lined up within a cell
🗑
|
||||
Indent | changes the space between the cell border and its content, moving text several places to the right or left
🗑
|
||||
Orientation | rotates cell contents to an angle or vertically
🗑
|
||||
Wrap Text | moves data to a new line when the cell is not wide enough to display all the contents
🗑
|
||||
Merge | combines multiple cells into one cell
🗑
|
||||
Merge and Center | combines several cells into one cell and centers the data in the merged cell
🗑
|
||||
Font | the design of text
🗑
|
||||
Font Size | determines the height of characters
🗑
|
||||
Font Styles | features that can add emphasis to text
🗑
|
||||
Font Color | the color of the text
🗑
|
||||
Fill Color | the background cell color behind the text
🗑
|
||||
Cell borders | lines around the edges of a cell
🗑
|
||||
Cell Style | a combination of formatting characteristics which can be applied simultaneously to the contents of a cell, saving you time
🗑
|
||||
Filling | copies a cell’s contents and/or formatting into an adjacent cell or range
🗑
|
||||
Fill Handle | appears in the lower-right corner of the active cell and can be used to fill adjacent cells
🗑
|
||||
Print Area | the portion of the worksheet selected to be printed
🗑
|
||||
Scaling | allows you to resize the worksheet to print on a specific number of pages
🗑
|
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:
manding
Popular Computers sets