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

Question 1

What are the 2 main types of errors?

Answer 1

Logic and syntax

Question 2

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

Answer 2

Syntax error

Question 3

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

Answer 3

Logic error

Question 4

Fill in the Blank:

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

Answer 4

1. Syntax error

2. Logic error

Question 5

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

Answer 5

########

Question 6

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

Answer 6

NAME?

Question 7

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

Answer 7

N/A

Question 8

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

Answer 8

REF!

Question 9

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

Answer 9

VALUE!

Question 10

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

Answer 10

NUM!

Question 11

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

Answer 11

DIV/0!

Question 12

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

Answer 12

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

Question 13

List 4 way to correct formatting problems

Answer 13

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

Question 14

List 6 way to correct errors in formulas

Answer 14

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

Question 15

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

Answer 15

Rename it

Question 16

What is a predefined formula that performs calculations?

Answer 16

A function

Question 17

What is the structure of a function?

Answer 17

Function name(Argument)

Question 18

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

Answer 18

A Argument

Question 19

Does a function have its own syntax?

Answer 19

Yes

Question 20

What does a function behave according to?

Answer 20

Its algorithm

Question 21

What are the rules programmed into the function called?

Answer 21

An algorithm

Question 22

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

Answer 22

SUM

Question 23

Which function determines the number of values in a list?

Answer 23

COUNT

Question 24

Which type of cells does the COUNT function ignore?

Answer 24

Blank cells and cells with text

Question 25

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

Answer 25

COUNTA

Question 26

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

Answer 26

AutoSum

Question 27

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

Answer 27

Relative cell referencing

Question 28

What can a relative cell reference use to copy formulas?

Answer 28

The fill handle

Question 29

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

Answer 29

Absolute cell referencing

Question 30

What is the syntax for absolute cell referencing?

Answer 30

$A$1

Question 31

What is a cell reference that has only one $?

Answer 31

A mixed cell reference

Question 32

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

Answer 32

A mixed cell reference