Maplewood Rice Comp Ex Ch 2
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
---|---|---|---|---|---|
function | a pre-written formula built into Excel
🗑
|
||||
formula | a math calculation keyed in by the user
🗑
|
||||
order of operations | the same left-to-right order and hierarchy as in Algebra when solving a formula
🗑
|
||||
asterisk | the multiplication mathematical operator
🗑
|
||||
Point mode | selecting cells with the mouse while building a formula
🗑
|
||||
Smart tags | a cell label that includes certain actions such as dates, symbols, names
🗑
|
||||
Arguments | the values used in a function
🗑
|
||||
AVERAGE function | Sum of the numbers divided by the total of numbers
🗑
|
||||
MIN function | the lowest value in a range
🗑
|
||||
MAX function | the highest value in a range
🗑
|
||||
relative cell references | row or column references are adjusted when filling down or right
🗑
|
||||
Range | a series of two or more adjacent cells
🗑
|
||||
Fill handles | small black square in lower-right corner of active cell
🗑
|
||||
Accounting number format | a dollar to the left, commas every three positions, two decimal places
🗑
|
||||
Fixed dollar sign | the dollar sign is positioned in the far left of the cell
🗑
|
||||
Floating dollar sign | the dollar sign appears immediately to the left of the first digit
🗑
|
||||
Comma style format | a comma is inserted every three positions, two decimal places
🗑
|
||||
condition | made up of two values and relational operator, true or false
🗑
|
||||
conditional formatting | format changes when the value in a cell meets defined criteria
🗑
|
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:
lrice@penncrest.org
Popular Computers sets