Question 1

Charts are not objects, like clip art images or photos.

Accepted Answer

A) True 
 B)False  False

Question 2

Which of the following is NOT true about the contents of column F in the accompanying figure?

Accepted Answer

A)  They can be used to show a trend. 
B)  You can use built-in formats to apply a color scheme. 
C)  You can customize the graphic to choose a color for high, low, first, and last values. 
D)  All of the above are true. 
A)  They can be used to show a trend. 
B)  You can use built-in formats to apply a color scheme. 
C)  You can customize the graphic to choose a color for high, low, first, and last values. 
D)  All of the above are true. D

Question 3

Match between columns
                        Premises: Effective for emphasizing trends

Accepted Answer

The Answer of Area chart and Line chart and Pie is...

Question 4

The ____ is a value, cell reference, range, or text used in a function.

Accepted Answer

A)  operator 
B)  argument 
C)  operand 
D)  formula 
A)  operator 
B)  argument 
C)  operand 
D)  formula

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

Rajit wants to display the data in his worksheet using graphics. Rajit knows that all of the following is 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, then press Delete. 
D)  An embedded chart is useful if you want to view the chart and 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, then press Delete. 
D)  An embedded chart is useful if you want to view the chart and data at the same time.

Question 7

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

Accepted Answer

A)  comma 
B)  colon 
C)  semi-colon 
D)  hyphen 
A)  comma 
B)  colon 
C)  semi-colon 
D)  hyphen

Question 8

=$A1 is a formula with an absolute reference.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is NOT true about creating a function?

Accepted Answer

A)  Several common functions are available by clicking a button on the Ribbon. 
B)  You can collapse and expand the Function Arguments dialog box. 
C)  You can drag the fill handle to copy a formula across a column. 
D)  All of the above are true. 
A)  Several common functions are available by clicking a button on the Ribbon. 
B)  You can collapse and expand the Function Arguments dialog box. 
C)  You can drag the fill handle to copy a formula across a column. 
D)  All of the above are true.

Question 10

The ____ error occurs when the column is not wide enough or a negative date is entered.

Accepted Answer

A)  #VALUE! 
B)  #N/A 
C)  #### 
D)  #REF! 
A)  #VALUE! 
B)  #N/A 
C)  #### 
D)  #REF!

Question 11

The ____ function multiples values in the specified cells.

Accepted Answer

A)  =PRODUCT 
B)  =SUM 
C)  =COUNT 
D)  =MEDIAN 
A)  =PRODUCT 
B)  =SUM 
C)  =COUNT 
D)  =MEDIAN

Question 12

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

Question 13

When creating formulas, there must be a closing parenthesis for every opening parenthesis.

Accepted Answer

A) True 
 B)False

Question 14

Excel has a(n) AutoComplete feature that automatically checks a formula for common keyboarding mistakes.

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____________________ is a symbol that indicates the mathematical operation to perform.

Accepted Answer

The answer of A(n) ____________________ is a symbol that indicates...

Question 16

The COUNT and SUM functions are interchangeable.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

Match between columns
                        Premises: Illustrates scientific data, specifically uneven intervals

Accepted Answer

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

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

____ formulas perform calculations that describe large quantities of data.

Accepted Answer

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

Exam 20: Creating Formulas and Charting Data

Charts are not objects, like clip art images or photos.

Which of the following is NOT true about the contents of column F in the accompanying figure?

The ____ is a value, cell reference, range, or text used in a function.

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

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

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

=$A1 is a formula with an absolute reference.

Which of the following is NOT true about creating a function?

The ____ error occurs when the column is not wide enough or a negative date is entered.

The ____ function multiples values in the specified cells.

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

When creating formulas, there must be a closing parenthesis for every opening parenthesis.

Excel has a(n) AutoComplete feature that automatically checks a formula for common keyboarding mistakes.

A(n) ____________________ is a symbol that indicates the mathematical operation to perform.

The COUNT and SUM functions are interchangeable.

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

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

____ formulas perform calculations that describe large quantities of data.

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