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

1
Q

What are the 2 main types of errors?

A

Logic and syntax

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

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

A

Syntax error

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

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

A

Logic error

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

Fill in the Blank:

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

A
  1. Syntax error

2. Logic error

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

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

A

########

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

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

A

NAME?

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
7
Q

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

A

N/A

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
8
Q

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

A

REF!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
9
Q

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

A

VALUE!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
10
Q

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

A

NUM!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
11
Q

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

A

DIV/0!

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
12
Q

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

A
  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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
13
Q

List 4 way to correct formatting problems

A
  1. Modify the column width and row height
  2. Check error messages
  3. Format numbers
  4. Insert and align the title
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
14
Q

List 6 way to correct errors in formulas

A
  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
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
15
Q

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

A

Rename it

How well did you know this?
1
Not at all
2
3
4
5
Perfectly
16
Q

What is a predefined formula that performs calculations?

A

A function

17
Q

What is the structure of a function?

A

Function name(Argument)

18
Q

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

A

A Argument

19
Q

Does a function have its own syntax?

A

Yes

20
Q

What does a function behave according to?

A

Its algorithm

21
Q

What are the rules programmed into the function called?

A

An algorithm

22
Q

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

A

SUM

23
Q

Which function determines the number of values in a list?

A

COUNT

24
Q

Which type of cells does the COUNT function ignore?

A

Blank cells and cells with text

25
Q

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

A

COUNTA

26
Q

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

A

AutoSum

27
Q

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

A

Relative cell referencing

28
Q

What can a relative cell reference use to copy formulas?

A

The fill handle

29
Q

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

A

Absolute cell referencing

30
Q

What is the syntax for absolute cell referencing?

A

$A$1

31
Q

What is a cell reference that has only one $?

A

A mixed cell reference

32
Q

What is commonly used when you need to copy a formula both down a column and across a row at the same time?

A

A mixed cell reference