Question 1

In the figure above, item 2 is pointing to the ____.

Accepted Answer

A)  data set for the PMT function 
B)  cell references used as a function 
C)  arguments that the PMT function uses as a basis for its calculation 
D)  function that calculates monthly payments 
A)  data set for the PMT function 
B)  cell references used as a function 
C)  arguments that the PMT function uses as a basis for its calculation 
D)  function that calculates monthly payments

Question 2

Most displays have a recommended ____ at which images are clearest and text is crispest.

Accepted Answer

A)  resolution 
B)  picture element 
C)  response time 
D)  viewing angle 
A)  resolution 
B)  picture element 
C)  response time 
D)  viewing angle

Question 3

A formula specifies how to add, subtract, multiply, or divide the numbers in worksheet cells.

Accepted Answer

A) True 
 B)False

Question 4

When using the PMT function to calculate monthly car payments, the arguments include all but the following: ____.

Accepted Answer

A)  date of purchase 
B)  interest rate 
C)  number of payments 
D)  cost of the car 
A)  date of purchase 
B)  interest rate 
C)  number of payments 
D)  cost of the car

Question 5

Case-Based Critical Thinking Questions Case 11-1 Hal is starting a new job that requires him to work with spreadsheet software. He has never used spreadsheet software before. Hal needs to create a formula that multiplies the contents of cell B7 by the contents of cell C1. The correct way for Hal to enter this formula is ____.

Accepted Answer

A)  B*/C1 
B)  B7/C1 
C)  =B7*C1 
D)  =B7/C1 
A)  B*/C1 
B)  B7/C1 
C)  =B7*C1 
D)  =B7/C1

Question 6

A range is a series of cells.

Accepted Answer

A) True 
 B)False

Question 7

The speed at which pixels change color is referred to as ghost time.

Accepted Answer

A) True 
 B)False

Question 8

Spreadsheet software first performs any operations in ____________________, then performs multiplication and division, and finally performs addition and subtraction.

Accepted Answer

The answer of Spreadsheet software first performs any operations in...

Question 9

A formula begins with a(n) equal sign and contains cell references instead of raw numbers for a calculation.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following is NOT a type of graph?

Accepted Answer

A)  bar 
B)  doughnut 
C)  high-low-close 
D)  average 
A)  bar 
B)  doughnut 
C)  high-low-close 
D)  average

Question 11

The range for a graph is also referred to as a ____ or data series.

Accepted Answer

A)  data set 
B)  formula 
C)  cell reference 
D)  data list 
A)  data set 
B)  formula 
C)  cell reference 
D)  data list

Question 12

An LED produces on-screen images by manipulating light within a layer of liquid crystal cells.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not an additional formatting option helping to control the way your numbers are displayed?

Accepted Answer

A)  dollar sign 
B)  decimal place 
C)  comma 
D)  semicolon 
A)  dollar sign 
B)  decimal place 
C)  comma 
D)  semicolon

Question 14

An electronic spreadsheet is often referred to as a(n) ____________________.

Accepted Answer

The answer of An electronic spreadsheet is often referred to...

Question 15

In the figure above, what is the function of the button to which item 1 is referring?

Accepted Answer

A)  It inserts a function into the selected cell. 
B)  It deletes the contents of the selected cell. 
C)  It opens a dialog box that gives you options for creating formulas. 
D)  It calculates the result of a function. 
A)  It inserts a function into the selected cell. 
B)  It deletes the contents of the selected cell. 
C)  It opens a dialog box that gives you options for creating formulas. 
D)  It calculates the result of a function.

Question 16

To use a function, simply select it from the function list, then follow the on-screen instructions to select the ____ that contain arguments for the calculation.

Accepted Answer

A)  columns 
B)  rows 
C)  cells 
D)  references 
A)  columns 
B)  rows 
C)  cells 
D)  references

Question 17

Case-Based Critical Thinking Questions Case 11-1 Hal is starting a new job that requires him to work with spreadsheet software. He has never used spreadsheet software before. Hal is having trouble getting a formula to calculate the correct results. His formula reads =2+10*5. The answer he should be getting is 60 but this formula results in an answer of 52. The correct way to write the formula Hal is looking for is ____.

Accepted Answer

A)  =2+(10*5) 
B)  =(2+10*5) 
C)  =(2)+10*5 
D)  =(2+10)*5 
A)  =2+(10*5) 
B)  =(2+10*5) 
C)  =(2)+10*5 
D)  =(2+10)*5

Question 18

Your worksheet automatically calculates the ____ and displays the results.

Accepted Answer

A)  equations 
B)  cells 
C)  scenarios 
D)  formulas 
A)  equations 
B)  cells 
C)  scenarios 
D)  formulas

Question 19

A formula specifies how to add, subtract, multiply, or divide the numbers in worksheet ____________________.

Accepted Answer

The answer of A formula specifies how to add, subtract,...

Question 20

At lower screen resolutions, text and objects appear larger, but the apparent work area is smaller.

Accepted Answer

A) True 
 B)False

In the figure above, item 2 is pointing to the ____.

Most displays have a recommended ____ at which images are clearest and text is crispest.

A formula specifies how to add, subtract, multiply, or divide the numbers in worksheet cells.

When using the PMT function to calculate monthly car payments, the arguments include all but the following: ____.

A range is a series of cells.

The speed at which pixels change color is referred to as ghost time.

Spreadsheet software first performs any operations in ____________________, then performs multiplication and division, and finally performs addition and subtraction.

A formula begins with a(n) equal sign and contains cell references instead of raw numbers for a calculation.

Which of the following is NOT a type of graph?

The range for a graph is also referred to as a ____ or data series.

An LED produces on-screen images by manipulating light within a layer of liquid crystal cells.

Which of the following is not an additional formatting option helping to control the way your numbers are displayed?

An electronic spreadsheet is often referred to as a(n) ____________________.

In the figure above, what is the function of the button to which item 1 is referring?

To use a function, simply select it from the function list, then follow the on-screen instructions to select the ____ that contain arguments for the calculation.

Your worksheet automatically calculates the ____ and displays the results.

A formula specifies how to add, subtract, multiply, or divide the numbers in worksheet ____________________.

At lower screen resolutions, text and objects appear larger, but the apparent work area is smaller.

Getting Started

Looking at Windows

Installing and Using Software

File Basics

Organizing Files and Folders

Protecting Files

Connecting to the Internet

Browsing and Searching the Web

Sending E-Mail and Attachments

Writing and Printing Documents

Accessing Databases

Making Presentations

Recording and Editing Sound

Working With Graphics

Creating Desktop Video and Animation

Looking Under the Hood

Computing Programming

Filters

Exam 11: Working With Spreadsheets

In the figure above, item 2 is pointing to the ____.

Most displays have a recommended ____ at which images are clearest and text is crispest.

A formula specifies how to add, subtract, multiply, or divide the numbers in worksheet cells.

When using the PMT function to calculate monthly car payments, the arguments include all but the following: ____.

A range is a series of cells.

The speed at which pixels change color is referred to as ghost time.

Spreadsheet software first performs any operations in ____________________, then performs multiplication and division, and finally performs addition and subtraction.

A formula begins with a(n) equal sign and contains cell references instead of raw numbers for a calculation.

Which of the following is NOT a type of graph?

The range for a graph is also referred to as a ____ or data series.

An LED produces on-screen images by manipulating light within a layer of liquid crystal cells.

Which of the following is not an additional formatting option helping to control the way your numbers are displayed?

An electronic spreadsheet is often referred to as a(n) ____________________.

In the figure above, what is the function of the button to which item 1 is referring?

To use a function, simply select it from the function list, then follow the on-screen instructions to select the ____ that contain arguments for the calculation.

Your worksheet automatically calculates the ____ and displays the results.

A formula specifies how to add, subtract, multiply, or divide the numbers in worksheet ____________________.

At lower screen resolutions, text and objects appear larger, but the apparent work area is smaller.

Getting Started

Looking at Windows

Installing and Using Software

File Basics

Organizing Files and Folders

Protecting Files

Connecting to the Internet

Browsing and Searching the Web

Sending E-Mail and Attachments

Writing and Printing Documents

Accessing Databases

Making Presentations

Recording and Editing Sound

Working With Graphics

Creating Desktop Video and Animation

Looking Under the Hood

Computing Programming

Filters