Excel Word Scramble
|
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
Question | Answer |
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. |
Created by:
kcoulee
Popular Computers sets