Computer skills terms that deal with spreadsheets
Help!
|
|
||||
|---|---|---|---|---|---|
| show | Spreadsheet
🗑
|
||||
| What computer application program can be used by accountants to keep track of current money available for spending. | show 🗑
|
||||
| show | Active
🗑
|
||||
| The name and location of a cell on a spreadsheet designated by the column letter and row number. | show 🗑
|
||||
| When giving a cell an address, you should always list what first? | show 🗑
|
||||
| The vertical divisions of a spreadsheet which are labeled alphabetically. | show 🗑
|
||||
| show | Column Heading
🗑
|
||||
| The horizontal divisions of a spreadsheet, labeled numerically. | show 🗑
|
||||
| The numbered box at the beginning of a row in a spreadsheet. | show 🗑
|
||||
| show | A1:C1
🗑
|
||||
| What do rows have as headings? | show 🗑
|
||||
| show | Letters
🗑
|
||||
| show | Number
🗑
|
||||
| show | Letter
🗑
|
||||
| show | Value
🗑
|
||||
| Numbers in order are called what? | show 🗑
|
||||
| A page number in the footer of a report is an example of what? | show 🗑
|
||||
| A formula always begins with what? | show 🗑
|
||||
| show | Functions
🗑
|
||||
| show | Minimum
🗑
|
||||
| What function would you use to find the total value of selected cells? | show 🗑
|
||||
| show | *
🗑
|
||||
| show | /
🗑
|
||||
| show | =SUM(B1:B9)
🗑
|
||||
| show | Pie Charts
🗑
|
||||
| What type of chart is best for showing trends over time? | show 🗑
|
||||
| show | Bar Charts
🗑
|
||||
| Information that is given to explain or clarify a chart is called what? | show 🗑
|
||||
| show | Row Headings
🗑
|
||||
| show | Spreadsheet
🗑
|
||||
| C5:C20 is an example of what? | show 🗑
|
||||
| show | Relative Cell Reference
🗑
|
||||
| show | Absolute Cell Reference
🗑
|
||||
| What symbol do you add to a cell address to make it an absolute cell reference? | show 🗑
|
||||
| show | Cell reference error, formula is not correct.
🗑
|
||||
| show | Fill Series
🗑
|
||||
| Which cell type would you choose if you had the following data (1/2/2009) in a column? | show 🗑
|
||||
| Which cell type would you choose if you had the following data(2010)in a column? | show 🗑
|
||||
| show | Cell Protection
🗑
|
||||
| show | Average
🗑
|
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:
eblanchard
Popular Computers sets