Question 1

You can change the order of evaluation by using hyphens.

Accepted Answer

A) True 
 B)False

Question 2

Match between columns
                        Premises: Compares the sizes of portions as they relate to a whole unit

Accepted Answer

The Answer of Scatter chart and Pie chart and Column is...

Question 3

Which of the following is NOT true about creating formulas?

Accepted Answer

A)  Multiplication and division are performed before addition and subtraction. 
B)  When entering the cell reference, the column letters must be uppercase. 
C)  Calculations in parentheses are performed first. 
D)  Generally, cell references are used in formulas instead of the actual value. 
A)  Multiplication and division are performed before addition and subtraction. 
B)  When entering the cell reference, the column letters must be uppercase. 
C)  Calculations in parentheses are performed first. 
D)  Generally, cell references are used in formulas instead of the actual value.

Question 4

The ____________________ reference enables you to access data from multiple worksheets.

Accepted Answer

The answer of The ____________________ reference enables you to access...

Question 5

A(n) ____________________ is a graphic representation of your worksheet data.

Accepted Answer

The answer of A(n) ____________________ is a graphic representation of...

Question 6

Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that the * (asterisk) character is used to represent ____.

Accepted Answer

A)  addition 
B)  subtraction 
C)  multiplication 
D)  division 
A)  addition 
B)  subtraction 
C)  multiplication 
D)  division

You can change the order of evaluation by using hyphens.

Which of the following is NOT true about creating formulas?

The ____________________ reference enables you to access data from multiple worksheets.

A(n) ____________________ is a graphic representation of your worksheet data.

Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that the * (asterisk) character is used to represent ____.

Computers and Computer Systems

Input, Output and Processing

Computer Protection

Computer Maintenance

Computer-Related Issues

Software and Hardware Interaction

Software Fundamentals

Operating Systems

Windows Management

Operating System Customization

Exploring Microsoft Office 2010

Getting Started With Word Essentials

Editing and Formatting Documents

Sharing Documents

Working With Tables

Using Templates, Styles, and Building Blocks

Enhancing Documents

Getting Started With Excel Essentials

Organizing and Enhancing Worksheets

Getting Started With Powerpoint Essentials

Enhancing Presentations With Multimedia Effects

Getting Started With Access Essentials

Managing and Reporting Database Information

Networks Fundamentals

Communication Services

Communications and Collaboration

Using the Internet and the World Wide Web

Web Content

Technology and Society

Security, Privacy, and Ethics Online

Filters

Exam 20: Creating Formulas and Charting Data

You can change the order of evaluation by using hyphens.

Which of the following is NOT true about creating formulas?

The ____________________ reference enables you to access data from multiple worksheets.

A(n) ____________________ is a graphic representation of your worksheet data.

Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that the * (asterisk) character is used to represent ____.

Computers and Computer Systems

Input, Output and Processing

Computer Protection

Computer Maintenance

Computer-Related Issues

Software and Hardware Interaction

Software Fundamentals

Operating Systems

Windows Management

Operating System Customization

Exploring Microsoft Office 2010

Getting Started With Word Essentials

Editing and Formatting Documents

Sharing Documents

Working With Tables

Using Templates, Styles, and Building Blocks

Enhancing Documents

Getting Started With Excel Essentials

Organizing and Enhancing Worksheets

Getting Started With Powerpoint Essentials

Enhancing Presentations With Multimedia Effects

Getting Started With Access Essentials

Managing and Reporting Database Information

Networks Fundamentals

Communication Services

Communications and Collaboration

Using the Internet and the World Wide Web

Web Content

Technology and Society

Security, Privacy, and Ethics Online

Filters