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