Exam 10: Excel Lesson 4: Entering Worksheet Formulas

You can include cell references in a formula more quickly by using the point-and-click method to click each cell, rather than typing cell references.

(True/False)

4.8/5

(68)

Question 41

When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____.

(Multiple Choice)

4.9/5

(71)

Question 42

Case EX 4-2 Ben is copying some formulas and wants to make sure he has the cell references correct. Ben also wants to copy a formula from the bottom of the spreadsheet and put it at the top of the spreadsheet in a summary section. He wants the formula to stay exactly the same and result in the same figure. What type of cell reference should Ben use?

(Multiple Choice)

4.7/5

(87)

Question 43

FIGURE EX 4-1 In Figure EX 4-1 above, number 3 is pointing to the ____ menu.

(Multiple Choice)

4.8/5

(72)

Question 44

COUNT CELLS determine how many entries are included in the range.

(True/False)

4.7/5

(76)

Question 45

Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.

(True/False)

4.8/5

(93)

Question 46

Showing 41 - 46 of 46

You can include cell references in a formula more quickly by using the point-and-click method to click each cell, rather than typing cell references.

When the formula =$A$3+$A$4 in cell A5 is copied to cell B7, the formula is ____.

FIGURE EX 4-1 In Figure EX 4-1 above, number 3 is pointing to the ____ menu.

COUNT CELLS determine how many entries are included in the range.

Although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references.

Access Lesson 1: Microsoft Access Basics

Access Lesson 2: Creating a Database

Access Lesson 3: Creating Queries

Access Lesson 4: Creating and Modifying Forms

Access Lesson 5: Creating and Modifying Reports

Access Lesson 6: Integrating Access

Excel Lesson 1: Microsoft Excel Basics

Excel Lesson 2: Changing the Appearance of a Worksheet

Excel Lesson 3: Organizing the Worksheet

Excel Lesson 5: Using Functions

Excel Lesson 6: Enhancing a Worksheet

Excel Lesson 7: Working With Multiple Worksheets and Workbooks

Excel Lesson 8: Working With Charts

Microsoft Office 2010 Basics and the Internet

Outlook Lesson 1: Outlook Basics and E-Mail

Outlook Lesson 2: Calendar

Outlook Lesson 3: Working With Other Outlook Tools

Powerpoint Lesson 1: Microsoft Powerpoint Basics

Powerpoint Lesson 2: Creating Enhancing Powerpoint Presentations

Powerpoint Lesson 3: Working With Visual Elements

Powerpoint Lesson 4: Expanding on Powerpoint Basics

Publisher Lesson 1: Microsoft Publisher Basics

Publisher Lesson 2: Enhancing Publisher Documents

Introduction Lesson 1: Microsoft Windows 7 Basics

Word Lesson 1: Microsoft Word Basics

Word Lesson 2: Basic Editing

Word Lesson 3: Helpful Word Features

Word Lesson 4: Formatting Text

Word Lesson 5: Formatting Paragraphs and Documents

Word Lesson 6: Working With Graphics

Word Lesson 7: Working With Documents

Word Lesson 8: Increasing Efficiency Using Word

Filters