Chapter 1 - Applying Fundamental Excel Skills and Tools in Problems Solving Flashcards
What are the 2 main types of errors?
Logic and syntax
Which type of error occurs when you don’t get the Excel wording correct?
Syntax error
Which type of error occurs when the Excel formulas are wording correctly, but the formula does not do what you want?
Logic error
Fill in the Blank:
1/0 is an example of a _____ error whereas 50000 / 5 * 12 is an example of a _____ error
- Syntax error
2. Logic error
Which error message is displayed when the cell’s width is too narrow to display the numeric data?
########
Which error message is displayed when there is unrecognizable text in the formula?
NAME?
Which error message is displayed when an answer can’t be found?
N/A
Which error message is displayed when there is an invalid cell reference?
REF!
Which error message is displayed when the wrong argument type is used?
VALUE!
Which error message is displayed when there is an invalid numeric value in the formula?
NUM!
Which error message is displayed when a number is divided by 0?
DIV/0!
List 3 ways that you can modify the column width and row height?
- Double-click the column border to make the column as wide as the longest entry
- Drag the column border to the desired width
- Click the Format button and manually change the column width
List 4 way to correct formatting problems
- Modify the column width and row height
- Check error messages
- Format numbers
- Insert and align the title
List 6 way to correct errors in formulas
- Print the worksheet in two different formats
- Check the accuracy of the simple formulas
- Use formula and cell references instead of values
- Determine the order of precedence (PEMDAS)
- Understand precision vs. the display of cell values
- Check the accuracy in formula updates
What is the first thing that you should do after you add a new worksheet?
Rename it
What is a predefined formula that performs calculations?
A function
What is the structure of a function?
Function name(Argument)
What is a list of inputs in a specific order, separated by commas?
A Argument
Does a function have its own syntax?
Yes
What does a function behave according to?
Its algorithm
What are the rules programmed into the function called?
An algorithm
Which function adds a list of values and/or cell ranges?
SUM
Which function determines the number of values in a list?
COUNT
Which type of cells does the COUNT function ignore?
Blank cells and cells with text
Which function should you use when you want to count cells with text?
COUNTA
Which Excel tool can you use when you want a quick calculation?
AutoSum
What allows the usage of a “general” formula over and over again, but with a different set of numbers?
Relative cell referencing
What can a relative cell reference use to copy formulas?
The fill handle
What indicates that a cell reference should remain unchanged when copying?
Absolute cell referencing
What is the syntax for absolute cell referencing?
$A$1
What is a cell reference that has only one $?
A mixed cell reference
What is commonly used when you need to copy a formula both down a column and across a row at the same time?
A mixed cell reference
