or

or

taken

why

Make sure to remember your password. If you forget it there is no way for StudyStack to send you a reset link. You would need to create a new account.

Don't know
Know
remaining cards
Save
0:01

 Flashcards Matching Hangman Crossword Type In Quiz Test StudyStack Study Table Bug Match Hungry Bug Unscramble Chopped Targets

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

# Excel

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