Question 1

The equation used to calculate values in a cell is known as a(n) function . ____________________

Accepted Answer

A) True 
 B)False

Question 2

Formulas containing more than one operator are called ____________________ formulas.

Accepted Answer

The answer of Formulas containing more than one operator are...

Question 3

The formula =$A1 contains an absolute reference.

Accepted Answer

A) True 
 B)False

Question 4

Rajit wants to display the data in his worksheet using graphics. Rajit decides to show snapshots of the data for each row in his worksheet. He inserts ____.

Accepted Answer

A)  functions 
B)  sparklines 
C)  charts 
D)  graphics 
A)  functions 
B)  sparklines 
C)  charts 
D)  graphics

Question 5

The accompanying figure shows ____ in column F.

Accepted Answer

A)  sparklines 
B)  embedded charts 
C)  chart sheets 
D)  functions 
A)  sparklines 
B)  embedded charts 
C)  chart sheets 
D)  functions

Question 6

With the AutoComplete feature, the worksheet is scanned and a range of cells to sum is selected. ___________________

Accepted Answer

A) True 
 B)False

Question 7

You can create multiple sparklines within a worksheet at the same time.

Accepted Answer

A) True 
 B)False

Question 8

The = SUM function adds up the number of cells containing values in the specified range. ____________________

Accepted Answer

A) True 
 B)False

Question 9

An error value appears if the cell is not wide enough to show the result.

Accepted Answer

A) True 
 B)False

Question 10

You can change the sequence in which a formula is solved by using hyphens.

Accepted Answer

A) True 
 B)False

Question 11

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 12

The ____________________ reference enables you to access data from three different dimensions in the workbook.

Accepted Answer

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

Question 13

Rajit wants to display the data in his worksheet using graphics. Rajit knows that all of the following are true about charts EXCEPT: ____.

Accepted Answer

A)  You cannot change the type of a chart. 
B)  You can resize a chart by dragging a sizing handle on the canvas. 
C)  To remove a chart element, select it, and then press Delete. 
D)  An embedded chart is useful if you want to view the chart and the data at the same time. 
A)  You cannot change the type of a chart. 
B)  You can resize a chart by dragging a sizing handle on the canvas. 
C)  To remove a chart element, select it, and then press Delete. 
D)  An embedded chart is useful if you want to view the chart and the data at the same time.

Question 14

3D references used in summary worksheets condense and total data from other worksheets.

Accepted Answer

A) True 
 B)False

Question 15

A shortcut to entering cell references is to name a range of cells.

Accepted Answer

A) True 
 B)False

Question 16

Two non-adjacent cells are distinguished in a function using a ____.

Accepted Answer

A)  comma 
B)  colon 
C)  semicolon 
D)  hyphen 
A)  comma 
B)  colon 
C)  semicolon 
D)  hyphen

Question 17

To create a minus sign in a formula, use the hyphen key.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is NOT true about charts?

Accepted Answer

A)  Charts are used to draw or present conclusions about data. 
B)  If a chart is not set up correctly, the representation can be confusing or misleading. 
C)  When creating a chart, the first step is to decide what type of chart you want to create. 
D)  All charts have a horizontal and vertical axis. 
A)  Charts are used to draw or present conclusions about data. 
B)  If a chart is not set up correctly, the representation can be confusing or misleading. 
C)  When creating a chart, the first step is to decide what type of chart you want to create. 
D)  All charts have a horizontal and vertical axis.

Question 19

____ formulas perform calculations that you could perform using a scientific calculator.

Accepted Answer

A)  Complex 
B)  Embedded 
C)  Statistical 
D)  Mathematical 
A)  Complex 
B)  Embedded 
C)  Statistical 
D)  Mathematical

Question 20

Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that ____ is an absolute cell reference.

Accepted Answer

A)  A1 
B)  $A1 
C)  A$1 
D)  $A$1 
A)  A1 
B)  $A1 
C)  A$1 
D)  $A$1

Exam 20: Creating Formulas and Charting Data

The equation used to calculate values in a cell is known as a(n) function . ____________________

Formulas containing more than one operator are called ____________________ formulas.

The formula =$A1 contains an absolute reference.

Rajit wants to display the data in his worksheet using graphics. Rajit decides to show snapshots of the data for each row in his worksheet. He inserts ____.

The accompanying figure shows ____ in column F.

With the AutoComplete feature, the worksheet is scanned and a range of cells to sum is selected. ___________________

You can create multiple sparklines within a worksheet at the same time.

The = SUM function adds up the number of cells containing values in the specified range. ____________________

An error value appears if the cell is not wide enough to show the result.

You can change the sequence in which a formula is solved by using hyphens.

Which of the following is NOT true about creating formulas?

The ____________________ reference enables you to access data from three different dimensions in the workbook.

Rajit wants to display the data in his worksheet using graphics. Rajit knows that all of the following are true about charts EXCEPT: ____.

3D references used in summary worksheets condense and total data from other worksheets.

A shortcut to entering cell references is to name a range of cells.

Two non-adjacent cells are distinguished in a function using a ____.

To create a minus sign in a formula, use the hyphen key.

Which of the following is NOT true about charts?

____ formulas perform calculations that you could perform using a scientific calculator.

Tyler is teaching Eleni how to perform calculations in her Excel worksheet. Tyler tells Eleni that ____ is an absolute cell reference.

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

Using Windows 7

Filters