Excel
Quiz yourself by thinking what should be in
each of the black spaces below before clicking
on it to display the answer.
Help!
|
|
||||
|---|---|---|---|---|---|
| How many elements should each cell contain? | Only one element of data.
🗑
|
||||
| Blank rows and columns in the same body of the list should be avoided. | True
🗑
|
||||
| In order to select a range of non-adjacent cells, you should press the button: | Control
🗑
|
||||
| In order to copy cell contents, select the cell and then press: | Copy
🗑
|
||||
| In order to move cell contents, select the cell and then press: | Cut
🗑
|
||||
| #####: | The contents of the cell cannot be displayed correctly as the column is too narrow.
🗑
|
||||
| #REF!: | Indicates that a cell reference is invalid. This is often displayed when we delete cells that are involved in a formula.
🗑
|
||||
| #VALUE!: | Indicates that there is a wrong type of value in a cell to perform the calculation.
🗑
|
||||
| #NAME?: | Excel does not recognize text contained within a formula.
🗑
|
||||
| #DIV/0!: | Indicates that a number tries to be divided by zero
🗑
|
||||
| The SUM function | is used to add the values to the selected cells.
🗑
|
||||
| The AVERAGE function | is used to determine the average value to the selected cells.
🗑
|
||||
| The MIN function | is used to find the minimum value to the selected cells.
🗑
|
||||
| The MAX function | is used to find the maximum value to the selected cells.
🗑
|
||||
| The COUNT function | is used to count the number of cells that contain numbers in a range of selected cells.
🗑
|
||||
| The COUNTA function | is used to count the number of cells that are not empty in a range of selected cells.
🗑
|
||||
| The COUNTBLANK function | is used to count the number of cells that are empty in a range of selected cells.
🗑
|
||||
| The ROUND function | is used to round off numbers to a specific number of decimal numbers.
🗑
|
||||
| The IF Function | checks the truthfulness or negativity of a statement.
🗑
|
||||
| The charts | are used for presenting the data and the results in a graphical format in order to understand them better.
🗑
|
||||
| Header and footer | allow us to insert information at the top and/or bottom of every page, such as chapter headings, page numbers, etc.
🗑
|
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:
kcoulee
Popular Computers sets