Question 1

An Excel formula must begin with the equal sign (=) .

Accepted Answer

A) True 
 B)False

Question 2

When a cell is active, you can see the formula in the cell .

Accepted Answer

A) True 
 B)False

Question 3

Match between columns
                        Premises: Incorrect data type used in the function or formula.
Cell is not wide enough to display formula results.
A value in the formula is not available in the worksheet.
Formula or function uses a cell reference that is no longer valid.
Formula contains incorrect text.

Accepted Answer

The Answer of #VALUE! and ##### and #REF! and #NAME? is...

Question 4

You can enter a formula by pressing the Enter key or clicking the Enter button on the ____.

Accepted Answer

A)  Formula tab on the Ribbon 
B)  taskbar 
C)  formula bar 
D)  all of the above 
A)  Formula tab on the Ribbon 
B)  taskbar 
C)  formula bar 
D)  all of the above

Question 5

FIGURE EX 3-1   In Figure EX 3-1 above, when the formula in cell B11 is copied to cell C13, ____.

Accepted Answer

A)  the relative column references change and the absolute row references do not 
B)  the relative column references do not change and the absolute row references do 
C)  the absolute column references change and the relative row references do not 
D)  the absolute column references do not change and the relative row references do 
A)  the relative column references change and the absolute row references do not 
B)  the relative column references do not change and the absolute row references do 
C)  the absolute column references change and the relative row references do not 
D)  the absolute column references do not change and the relative row references do

An Excel formula must begin with the equal sign (=) .

When a cell is active, you can see the formula in the cell .

You can enter a formula by pressing the Enter key or clicking the Enter button on the ____.

FIGURE EX 3-1 In Figure EX 3-1 above, when the formula in cell B11 is copied to cell C13, ____.

Access Lesson 1: Understanding Access Fundamentals

Access Lesson 2: Creating Queries, Forms, and Reports

Excel Lesson 1: Understanding Excel Fundamentals

Excel Lesson 2: Formatting and Editing Worksheets

Excel Lesson 4: Working With Charts and Graphics

Getting Started Lesson 1: Working With Microsoft Office 2010

Integration Lesson 1: Understanding Integration Fundamentals

Powerpoint Lesson 1: Understanding Powerpoint Fundamentals

Powerpoint Lesson 2: Formatting and Modifying Presentations

Powerpoint Lesson 3: Enhancing Presentations

Publisher Lesson 1 : Understanding Publisher Fundamentals

Word Lesson 1: Understanding Word Fundamentals

Word Lesson 2: Editing and Formatting Text

Word Lesson 3: Formatting Documents

Word Lesson 4: Working With Graphic Objects

Filters

Exam 5: Excel Lesson 3: Using Formulas and Functions

An Excel formula must begin with the equal sign (=) .

When a cell is active, you can see the formula in the cell .

You can enter a formula by pressing the Enter key or clicking the Enter button on the ____.

FIGURE EX 3-1 In Figure EX 3-1 above, when the formula in cell B11 is copied to cell C13, ____.

Access Lesson 1: Understanding Access Fundamentals

Access Lesson 2: Creating Queries, Forms, and Reports

Excel Lesson 1: Understanding Excel Fundamentals

Excel Lesson 2: Formatting and Editing Worksheets

Excel Lesson 4: Working With Charts and Graphics

Getting Started Lesson 1: Working With Microsoft Office 2010

Integration Lesson 1: Understanding Integration Fundamentals

Powerpoint Lesson 1: Understanding Powerpoint Fundamentals

Powerpoint Lesson 2: Formatting and Modifying Presentations

Powerpoint Lesson 3: Enhancing Presentations

Publisher Lesson 1 : Understanding Publisher Fundamentals

Word Lesson 1: Understanding Word Fundamentals

Word Lesson 2: Editing and Formatting Text

Word Lesson 3: Formatting Documents

Word Lesson 4: Working With Graphic Objects

Filters