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. |