Question 1

In the accompanying figure, use the Paste Options button labeled ____ to paste a picture as a chart that cannot be modified and you want to keep the formatting from the source document.

Accepted Answer

A)  1 
B)  2 
C)  3 
D)  5

Question 2

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

Accepted Answer

A)  =A1/A2 
B)  =10/2 
C)  5 
D)  =5

Question 3

Critical Thinking Questions 
Case 1-1 
Eamon Christopher, the new staff assistant at QST Vancouver, wants to create some new reports utilizing the features of each of the various Microsoft Office programs using OLE technology. 
For one set of numbers, Eamon wants to capture the numbers as they are right now, but he is confident that under no circumstance will he want updated numbers to appear in his Word document. Which option should he use? 
a. linking 
b. embedding 
c. copying and pasting from the Clipboard 
d. connecting

Accepted Answer

The answer of Critical Thinking Questions 
Case 1-1 
Eamon Christopher,...

Question 4

You are in Edit mode any time you are entering or changing the contents of a cell.

Accepted Answer

A) True 
 B)False

Question 5

Critical Thinking Questions 
Case1-1 
Sara is the owner of a specialty goods store. To keep a record of the goods that she has in stock and their prices, she has created a very large worksheet. She is not the best speller in the world, however, so she would like to use the spell checker to ensure that her worksheet does not have any spelling mistakes. Sara is not familiar with this feature of Excel and has asked you for help. 
Sara has a proper name in the worksheet, all instances of which she would like the spell checker to skip over. What option do you tell her to select? 
a. Pass Over 
b. Skip All 
c. Ignore 
d. Ignore All

Accepted Answer

The answer of Critical Thinking Questions 
Case1-1 
Sara is the...

Question 6

You use the term linked object to refer to ____ data.

Accepted Answer

A)  connected 
B)  encrypted 
C)  binary 
D)  variable

Question 7

To switch a chart's columns and rows, click the ____________________ button in the Data group on the CHART TOOLS DESIGN tab.

Accepted Answer

The answer of To switch a chart's columns and rows,...

Question 8

###### in a cell means that the ____.

Accepted Answer

A)  formula contains an error 
B)  value contains an error 
C)  label has a spelling error 
D)  column is too narrow to display the value completely

Question 9

In the accompanying figure, the dialog box illustrates what element of a function?

Accepted Answer

A)  arithmetic operator 
B)  argument 
C)  order of precedence 
D)  range

Question 10

You can apply formatting before or after you enter data in a cell or range.

Accepted Answer

A) True 
 B)False

Question 11

A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________

Accepted Answer

A) True 
 B)False

Question 12

Critical Thinking Questions 
Case 1-1 
Your manager has just asked you to create a PowerPoint slide presentation to be delivered at your company's next sales meeting. She expects you to construct the presentation slide by slide based on data in a Word document. 
You know that you could retype the information from the Word document. However, what is an easier way to get the information from Word into PowerPoint? 
a. importing 
b. baselining 
c. indexing 
d. outlining

Accepted Answer

The answer of Critical Thinking Questions 
Case 1-1 
Your manager...

Question 13

You should link an object to a PowerPoint slide when you are the only user of an object, and you want the object to be a part of your presentation.

Accepted Answer

A) True 
 B)False

Question 14

Cells and ranges in a worksheet can be formatted ____.

Accepted Answer

A)  only before data is entered 
B)  only after data is entered 
C)  before or after data is entered 
D)  at the same time data is entered

Question 15

You can use [ ____ ][Tab] to promote headings in Outline view.

Accepted Answer

A)  Alt 
B)  Shift 
C)  Ctrl 
D)  Fn

Question 16

In a pie chart, you can emphasize one data point by plotting , or pulling that slice away from, the pie chart. _________________________

Accepted Answer

A) True 
 B)False

Question 17

Critical Thinking Questions 
Case 1-2 
You are a 7th grade science teacher. You are in the process of creating a simple worksheet to keep track of the test grades for your class. The accompanying figure is the worksheet that you have created so far. 
  You want to put a formula in cells D4 through D11 for finding the difference between the two test scores for each student. You enter =C4-B4 in cell D4 and then use what feature to copy the formula down the column through cell D11? 
a. formula copier 
b. fill handle 
c. formula painter 
d. formula index

Accepted Answer

The answer of Critical Thinking Questions 
Case 1-2 
You are...

Question 18

A block of text that is formatted with a heading style in Word is not included when it is imported into a PowerPoint presentation.

Accepted Answer

A) True 
 B)False

Question 19

The $ symbol placed before a row or column address indicates a(n) ____________________ cell reference.

Accepted Answer

The answer of The $ symbol placed before a row...

Question 20

The Excel operator for division is ____.

Accepted Answer

A)  / 
B)  \ 
C)  % 
D)  ^

Exam 11: Excel 2013 Getting Started With Excel 2013

In the accompanying figure, use the Paste Options button labeled ____ to paste a picture as a chart that cannot be modified and you want to keep the formatting from the source document.

If cell A1 contained 10, cell A2 contained 2 and cell A3 contained =A1/A2, what would cell A3 show on the worksheet?

You are in Edit mode any time you are entering or changing the contents of a cell.

You use the term linked object to refer to ____ data.

To switch a chart's columns and rows, click the ____________________ button in the Data group on the CHART TOOLS DESIGN tab.

###### in a cell means that the ____.

In the accompanying figure, the dialog box illustrates what element of a function?

You can apply formatting before or after you enter data in a cell or range.

A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________

You should link an object to a PowerPoint slide when you are the only user of an object, and you want the object to be a part of your presentation.

Cells and ranges in a worksheet can be formatted ____.

You can use [ ____ ][Tab] to promote headings in Outline view.

In a pie chart, you can emphasize one data point by plotting , or pulling that slice away from, the pie chart. _________________________

A block of text that is formatted with a heading style in Word is not included when it is imported into a PowerPoint presentation.

The $ symbol placed before a row or column address indicates a(n) ____________________ cell reference.

The Excel operator for division is ____.