Question 1

When you want to copy an object without a data connection to the source file, you should use the ____ integration method.

Accepted Answer

A)  linking 
B)  inline 
C)  pasting 
D)  compacting 
A)  linking 
B)  inline 
C)  pasting 
D)  compacting

Question 2

Match between columns
                        Premises: Identified by the coordinates of the intersecting column and row
Provides a brief description of the active command or task in progress
A selection of two or more cells
A dark rectangle that outlines the cell in which you are working
Displays the active cell address

Accepted Answer

The Answer of cell pointer and status bar and range is...

Question 3

In Excel, the formula ____ will calculate the average of the values in cells B14 through F14.

Accepted Answer

A)  =AVERAGE 
B)  =AVERAGE[B14:F14] 
C)  =AVERAGE{B14:F14} 
D)  =AVERAGE(B14:F14) 
A)  =AVERAGE 
B)  =AVERAGE[B14:F14] 
C)  =AVERAGE{B14:F14} 
D)  =AVERAGE(B14:F14)

Question 4

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.

Accepted Answer

A)  line 
B)  area 
C)  column 
D)  pie 
A)  line 
B)  area 
C)  column 
D)  pie

Question 5

One of the ways to change your view of the worksheet window is by using the VIEW tab on the Ribbon . ______________________

Accepted Answer

A) True 
 B)False

Question 6

In Excel, MAX and AVERAGE are examples of ____.

Accepted Answer

A)  functions 
B)  arguments 
C)  lists 
D)  buttons 
A)  functions 
B)  arguments 
C)  lists 
D)  buttons

Question 7

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. 
   Which of the following is NOT a valid formula for use in cell B13 for finding the average of the test? 
a. =(B4+B5+B6+B7+B8+B9+B10+B11)/8 
b. =SUM(B4:B11)/8 
c. =(B4+B5+B6+B7+B8+B9+B10+B11)/COUNT(B4:B11) 
d. =AVG(B4:B11)

Accepted Answer

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

Question 8

You insert a comment in a worksheet by using a command on the ____ tab on the Ribbon.

Accepted Answer

A)  HOME 
B)  REVIEW 
C)  INSERT 
D)  VIEW 
A)  HOME 
B)  REVIEW 
C)  INSERT 
D)  VIEW

Question 9

You ____________________ an object to a PowerPoint slide when the object's source file is shared on a network or where other users have access to the file and can change it.

Accepted Answer

The answer of You ____________________ an object to a PowerPoint...

Question 10

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

Accepted Answer

A)  formula button 
B)  status bar 
C)  mode indicator 
D)  New sheet button 
A)  formula button 
B)  status bar 
C)  mode indicator 
D)  New sheet button

Question 11

In the accompanying figure, if the value 150  is connected to a value in a source Excel file, the value is called a(n) ____ object.

Accepted Answer

A)  copied 
B)  embedded 
C)  edited 
D)  linked 
A)  copied 
B)  embedded 
C)  edited 
D)  linked

Question 12

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)  20 
C)  10^2 
D)  100 
A)  =A1^A2 
B)  20 
C)  10^2 
D)  100

Question 13

When you import slides into PowerPoint, you need to reset the ____ of the slides to conform to the PowerPoint slide design you have applied.

Accepted Answer

A)  accent 
B)  layout 
C)  motif 
D)  margin 
A)  accent 
B)  layout 
C)  motif 
D)  margin

Question 14

You can apply font styles and alignment options using the ____ tab of the Ribbon.

Accepted Answer

A)  INSERT 
B)  HOME 
C)  PAGE LAYOUT 
D)  VIEW 
A)  INSERT 
B)  HOME 
C)  PAGE LAYOUT 
D)  VIEW

Question 15

Which of the following is a complex formula?

Accepted Answer

A)  =SUM(B4:B8) 
B)  =(B4/B8)*10 
C)  =AVERAGE(C6:D6) 
D)  =MIN(D5:D7) 
A)  =SUM(B4:B8) 
B)  =(B4/B8)*10 
C)  =AVERAGE(C6:D6) 
D)  =MIN(D5:D7)

Question 16

The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

Accepted Answer

A)  (D3 + D2)/D3 
B)  =(D3 + D2)/D3 
C)  (D3-D2)/D3 
D)  =(D3-D2)/D3 
A)  (D3 + D2)/D3 
B)  =(D3 + D2)/D3 
C)  (D3-D2)/D3 
D)  =(D3-D2)/D3

Question 17

You can copy ____ and numbers between Word and Excel.

Accepted Answer

A)  ribbons 
B)  commands 
C)  text 
D)  formula bars 
A)  ribbons 
B)  commands 
C)  text 
D)  formula bars

Question 18

If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object's source file.

Accepted Answer

A)  encrypt 
B)  decrypt 
C)  link 
D)  embed 
A)  encrypt 
B)  decrypt 
C)  link 
D)  embed

Question 19

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

Accepted Answer

A) True 
 B)False

Question 20

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.

Accepted Answer

A)  red 
B)  blue 
C)  green 
D)  yellow 
A)  red 
B)  blue 
C)  green 
D)  yellow

When you want to copy an object without a data connection to the source file, you should use the ____ integration method.

In Excel, the formula ____ will calculate the average of the values in cells B14 through F14.

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.

One of the ways to change your view of the worksheet window is by using the VIEW tab on the Ribbon . ______________________

In Excel, MAX and AVERAGE are examples of ____.

You insert a comment in a worksheet by using a command on the ____ tab on the Ribbon.

You ____________________ an object to a PowerPoint slide when the object's source file is shared on a network or where other users have access to the file and can change it.

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

In the accompanying figure, if the value 150 is connected to a value in a source Excel file, the value is called a(n) ____ object.

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

When you import slides into PowerPoint, you need to reset the ____ of the slides to conform to the PowerPoint slide design you have applied.

You can apply font styles and alignment options using the ____ tab of the Ribbon.

Which of the following is a complex formula?

The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

You can copy ____ and numbers between Word and Excel.

If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object's source file.

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.

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 you want to copy an object without a data connection to the source file, you should use the ____ integration method.

In Excel, the formula ____ will calculate the average of the values in cells B14 through F14.

A(n) ____ chart compares distinct object levels using vertical bars; it is the Excel default.

One of the ways to change your view of the worksheet window is by using the VIEW tab on the Ribbon . ______________________

In Excel, MAX and AVERAGE are examples of ____.

You insert a comment in a worksheet by using a command on the ____ tab on the Ribbon.

You ____________________ an object to a PowerPoint slide when the object's source file is shared on a network or where other users have access to the file and can change it.

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

In the accompanying figure, if the value 150 is connected to a value in a source Excel file, the value is called a(n) ____ object.

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

When you import slides into PowerPoint, you need to reset the ____ of the slides to conform to the PowerPoint slide design you have applied.

You can apply font styles and alignment options using the ____ tab of the Ribbon.

Which of the following is a complex formula?

The proper formula in Excel for calculating the percentage change between cells D3 and D2 is ____.

You can copy ____ and numbers between Word and Excel.

If your presentation requires an object and you want to keep your presentation file size small, you should ____ the object's source file.

Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.

A small, ____ triangle appears in the upper-right corner of a cell containing a comment.

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