AR CBA Excel Ch 1
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| Excel | spreadsheet program in Microsoft Office 2010 that includes rows,and columns, used primarily for calculations
🗑
|
||||
| Spreadsheet | grid of rows and columns used to enter text, numbers, formulas, results of calculations.
🗑
|
||||
| Worksheet | same as a spreadsheet basically. a computerized spreadsheet in Excel. this is made for a specific thing, a page for a special item, i.e., the 4-H trap shooting events we looked at for an example
🗑
|
||||
| Workbook | a collection of worksheets
🗑
|
||||
| Sheet tab | the name of each worksheet appears in the sheet tab at the left bottom corner of the worksheet
🗑
|
||||
| Coulumns | appear vertically-- go down the page, labeled by A, B, C's
🗑
|
||||
| Rows | appear horizontally and are identified by numbers on the left side of the worksheet
🗑
|
||||
| Cell | an intersection of a row and a column, you can type data in it, looks like boxes
🗑
|
||||
| Cell reference (address) | formed by combining the column letter and the row number, It is the identification of the cell location
🗑
|
||||
| Active cell | the cell on the worksheet where you can enter data
🗑
|
||||
| Name box | located below the ribbon- displays the cell reference of the active cell
🗑
|
||||
| Formula bar | appears to the right of the name box and displays a formula when the cell of a worksheet contains a calculated value
🗑
|
||||
| Formula | an equation that calculates a new value form values currently in the worksheet. You have to type and "=" first in cell before the formula. HAve to use cell addresses not just the number
🗑
|
||||
| Range | a group of selected cells on the spreadsheet
🗑
|
||||
| Range reference | like cell reference identifies what cells are in your range. Starts at left corner goes to bottom right corner as you drag the mouse over the range of cells
🗑
|
||||
| Active worksheet | the worksheet that is displayed on you monitor that you are working on now.
🗑
|
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:
Jamie.HenleyatLonoke
Popular Computers sets