Chapter 1 - Applying Fundamental Excel Skills and Tools in Problems Solving Flashcards Preview

Quantitive Analysis with Excel > Chapter 1 - Applying Fundamental Excel Skills and Tools in Problems Solving > Flashcards

Flashcards in Chapter 1 - Applying Fundamental Excel Skills and Tools in Problems Solving Deck (32)
Loading flashcards...
1

What are the 2 main types of errors?

Logic and syntax

2

Which type of error occurs when you don't get the Excel wording correct?

Syntax error

3

Which type of error occurs when the Excel formulas are wording correctly, but the formula does not do what you want?

Logic error

4

Fill in the Blank:

1/0 is an example of a _____ error whereas 50000 / 5 * 12 is an example of a _____ error

1. Syntax error
2. Logic error

5

Which error message is displayed when the cell's width is too narrow to display the numeric data?

########

6

Which error message is displayed when there is unrecognizable text in the formula?

#NAME?

7

Which error message is displayed when an answer can't be found?

#N/A

8

Which error message is displayed when there is an invalid cell reference?

#REF!

9

Which error message is displayed when the wrong argument type is used?

#VALUE!

10

Which error message is displayed when there is an invalid numeric value in the formula?

#NUM!

11

Which error message is displayed when a number is divided by 0?

#DIV/0!

12

List 3 ways that you can modify the column width and row height?

1. Double-click the column border to make the column as wide as the longest entry
2. Drag the column border to the desired width
3. Click the Format button and manually change the column width

13

List 4 way to correct formatting problems

1. Modify the column width and row height
2. Check error messages
3. Format numbers
4. Insert and align the title

14

List 6 way to correct errors in formulas

1. Print the worksheet in two different formats
2. Check the accuracy of the simple formulas
3. Use formula and cell references instead of values
4. Determine the order of precedence (PEMDAS)
5. Understand precision vs. the display of cell values
6. Check the accuracy in formula updates

15

What is the first thing that you should do after you add a new worksheet?

Rename it

16

What is a predefined formula that performs calculations?

A function

17

What is the structure of a function?

Function name(Argument)

18

What is a list of inputs in a specific order, separated by commas?

A Argument

19

Does a function have its own syntax?

Yes

20

What does a function behave according to?

Its algorithm

21

What are the rules programmed into the function called?

An algorithm

22

Which function adds a list of values and/or cell ranges?

SUM

23

Which function determines the number of values in a list?

COUNT

24

Which type of cells does the COUNT function ignore?

Blank cells and cells with text

25

Which function should you use when you want to count cells with text?

COUNTA

26

Which Excel tool can you use when you want a quick calculation?

AutoSum

27

What allows the usage of a “general” formula over and over again, but with a different set of numbers?

Relative cell referencing

28

What can a relative cell reference use to copy formulas?

The fill handle

29

What indicates that a cell reference should remain unchanged when copying?

Absolute cell referencing

30

What is the syntax for absolute cell referencing?

$A$1