Exam 26: Entering Worksheet Formulas

Worksheet formulas consist of two components: ____________________ and operators.

(Short Answer)

4.8/5

(27)

Question 41

Case EX 4-1 Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers. What should Kayden do to show the default calculations for a range of cells?

(Multiple Choice)

5.0/5

(35)

Question 42

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.9/5

(37)

Question 43

Three types of cell references are used in formulas that do NOT include ____.

(Multiple Choice)

4.9/5

(37)

Question 44

You can change which cells are included in a reference by dragging any corner of the ____ to resize the selected range.

(Multiple Choice)

4.9/5

(35)

Question 45

The equation used to calculate values in a cell is called a command .

(True/False)

4.9/5

(42)

Question 46

Showing 41 - 46 of 46

Exam 26: Entering Worksheet Formulas

Worksheet formulas consist of two components: ____________________ and operators.

Case EX 4-1 Kayden wants to preview calculations in the status bar so she can quickly glance at them and know some of the basics about a particular range of numbers. What should Kayden do to show the default calculations for a range of cells?

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.

Three types of cell references are used in formulas that do NOT include ____.

You can change which cells are included in a reference by dragging any corner of the ____ to resize the selected range.

The equation used to calculate values in a cell is called a command .

Microsoft Access Basics

Creating a Database

Creating Queries

Creating and Modifying Forms

Creating and Modifying Reports

Integrating Access

Enhancing Table Design

Using Advanced Queries

Using Advanced Form Features

Adding Advanced Features to Reports

Creating and Running Macros

Automating Database Processes

Programming in Access

Creating Database Security and Documentation

Microsoft Excel Basics

Using Advanced Chart Features

Improving Data Accuracy

Creating Pivottables and Pivotcharts

Using Powerful Excel Functions

Creating and Using Macros

Working With Auditing and Analysis Tools

Protecting, Tracking, and Sharing Workbooks

Importing and Exporting Data

Changing the Appearance of a Worksheet

Organizing the Worksheet

Using Functions

Enhancing a Worksheet

Working With Multiple Worksheets and Workbooks

Working With Charts

Applying Advanced Formats to Worksheets

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Sharing and Delivering Presentations

Creating Enhancing Powerpoint Presentations

Working With Visual Elements

Expanding on Powerpoint Basics

Editing and Formatting Slide Content

Working With Tables and Charts

Working With Visual and Sound Objects

Customizing Slides

Importing and Exporting Information

Microsoft Word Basics

Working With Templates and Styles

Customizing Tables and Creating Charts

Creating Mail Merge Documents

Sharing Documents

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Working With Long Documents

Creating Indexes and Tables of Contents, Figures, and Authorities

Basic Editing

Helpful Word Features

Formatting Text

Formatting Paragraphs and Documents

Working With Graphics

Working With Documents

Increasing Efficiency Using Word

Enhancing Documents

Filters