Question 1

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

Accepted Answer

A) True 
 B)False

Question 2

You use linking when you want the linked information in the destination file to update when you change the ____ file.

Accepted Answer

A)  source 
B)  destination 
C)  binary 
D)  text 
A)  source 
B)  destination 
C)  binary 
D)  text

Question 3

Excel Unit B demonstrated the use of several functions: AVERAGE, MAX, COUNT, and COUNTA. Explain how the COUNT and COUNTA functions work.

Accepted Answer

After the Excel user selects a range of

Question 4

The Paste list arrow in the Insert group allows you to see each of the six Paste Options and to view how the pasted object will appear in the document.

Accepted Answer

A) True 
 B)False

Question 5

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

Accepted Answer

A)  HOME 
B)  DATA 
C)  PAGE LAYOUT 
D)  REVIEW 
A)  HOME 
B)  DATA 
C)  PAGE LAYOUT 
D)  REVIEW

Question 6

In the formula =ROUND(D4:F4,0), what does the zero indicate?

Accepted Answer

A)  The number of decimal places in the rounded number. 
B)  The number of times the formula should be repeated. 
C)  A null value. 
D)  The value for cell F4. 
A)  The number of decimal places in the rounded number. 
B)  The number of times the formula should be repeated. 
C)  A null value. 
D)  The value for cell F4.

Question 7

____ shows you how a fill color will look before you apply it.

Accepted Answer

A)  Sneak Peek 
B)  Live Preview 
C)  Quick Look 
D)  Advance Look 
A)  Sneak Peek 
B)  Live Preview 
C)  Quick Look 
D)  Advance Look

Question 8

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

Accepted Answer

A)  $M$3/4 
B)  (G15-G14)*$M$3 
C)  (G15-G14) 
D)  (G15-G14)/4 
A)  $M$3/4 
B)  (G15-G14)*$M$3 
C)  (G15-G14) 
D)  (G15-G14)/4

Question 9

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 a value that Eamon has in his Profit worksheet, he wants to make sure that even if the formula changes later, the value will still be accurate in his Word document. Which option should he use to connect this data? 
a. linking 
b. embedding 
c. copying and pasting 
d. connecting

Accepted Answer

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

Question 10

In the accompanying figure, which country has the highest quarterly sales?

Accepted Answer

A)  Australia 
B)  Britain 
C)  Japan 
D)  USA 
A)  Australia 
B)  Britain 
C)  Japan 
D)  USA

Question 11

When you place multiple items on the Clipboard, newer items appear at the top of the list.  _________________________

Accepted Answer

A) True 
 B)False

Question 12

You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

Accepted Answer

A) True 
 B)False

Question 13

Describe calculation operators, including the different types of calculation operators.

Accepted Answer

Calculation operators indicate what type

Question 14

Match between columns
                        Premises: Often contains the names of data groups, such as locations, months, or years.
Often contains numerical values that help you interpret the size of chart elements.
An independent element on a worksheet.
Visually represents each data point.
Before creating this, you need to plan the information you want it to show.

Accepted Answer

The Answer of data marker and object and value axis is...

Question 15

Explain what a combination chart is and how you can create one.

Accepted Answer

A combination chart is two charts in one

Question 16

Double-clicking the column line to the right of a column activates the ____ feature for the column.

Accepted Answer

A)  AutoCorrect 
B)  Format 
C)  AutoFit 
D)  Format as Table 
A)  AutoCorrect 
B)  Format 
C)  AutoFit 
D)  Format as Table

Question 17

You use the Copy and Paste tools to create a link between a chart in Excel and the same chart pasted into a document in Word.

Accepted Answer

A) True 
 B)False

Question 18

As shown in the accompanying figure, item ____ points to the Name box.

Accepted Answer

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

Question 19

Match between columns
                        Premises: Used in PowerPoint, Word, and Excel to manage links between files.
Used to format a Word outline you import into PowerPoint.
Tool in Access that enables you to sort the records in a table.
Enables you to store a file with a new filename.
Item added to a file without a link to the source file.

Accepted Answer

The Answer of heading styles and embedded object and Edit is...

Question 20

When a Word object is embedded in an Excel file, you can use the tools from the source program (Word) to edit it.

Accepted Answer

A) True 
 B)False

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

You use linking when you want the linked information in the destination file to update when you change the ____ file.

Excel Unit B demonstrated the use of several functions: AVERAGE, MAX, COUNT, and COUNTA. Explain how the COUNT and COUNTA functions work.

The Paste list arrow in the Insert group allows you to see each of the six Paste Options and to view how the pasted object will appear in the document.

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

In the formula =ROUND(D4:F4,0), what does the zero indicate?

____ shows you how a fill color will look before you apply it.

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

In the accompanying figure, which country has the highest quarterly sales?

When you place multiple items on the Clipboard, newer items appear at the top of the list. _________________________

You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

Describe calculation operators, including the different types of calculation operators.

Explain what a combination chart is and how you can create one.

Double-clicking the column line to the right of a column activates the ____ feature for the column.

You use the Copy and Paste tools to create a link between a chart in Excel and the same chart pasted into a document in Word.

As shown in the accompanying figure, item ____ points to the Name box.

When a Word object is embedded in an Excel file, you can use the tools from the source program (Word) to edit it.

Computer and Internet Basics

Computer Hardware

Computer Software

File Management and Digital Electronics

Windows 8 Getting Started With Windows 8

Word 2013 Creating Documents With Word 2013

Access 2013 Getting Started With Access 2013

Appendix Working in the Cloud

Internet Explorer 10 Getting Started With Internet Explorer 10

Office 2013 Getting Started With Microsoft Office 2013

Filters

Exam 11: Excel 2013 Getting Started With Excel 2013

When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.

You use linking when you want the linked information in the destination file to update when you change the ____ file.

Excel Unit B demonstrated the use of several functions: AVERAGE, MAX, COUNT, and COUNTA. Explain how the COUNT and COUNTA functions work.

The Paste list arrow in the Insert group allows you to see each of the six Paste Options and to view how the pasted object will appear in the document.

A theme can be applied using the Themes button in the Themes group on the ____ tab on the Ribbon.

In the formula =ROUND(D4:F4,0), what does the zero indicate?

____ shows you how a fill color will look before you apply it.

In the formula =(G15-G14)*$M$3/4, which mathematical operation is performed first?

In the accompanying figure, which country has the highest quarterly sales?

When you place multiple items on the Clipboard, newer items appear at the top of the list. _________________________

You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.

Describe calculation operators, including the different types of calculation operators.

Explain what a combination chart is and how you can create one.

Double-clicking the column line to the right of a column activates the ____ feature for the column.

You use the Copy and Paste tools to create a link between a chart in Excel and the same chart pasted into a document in Word.

As shown in the accompanying figure, item ____ points to the Name box.

When a Word object is embedded in an Excel file, you can use the tools from the source program (Word) to edit it.

Computer and Internet Basics

Computer Hardware

Computer Software

File Management and Digital Electronics

Windows 8 Getting Started With Windows 8

Word 2013 Creating Documents With Word 2013

Access 2013 Getting Started With Access 2013

Appendix Working in the Cloud

Internet Explorer 10 Getting Started With Internet Explorer 10

Office 2013 Getting Started With Microsoft Office 2013

Filters