click below
click below
Normal Size Small Size show me how
Excel
| 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. |