Question 1

You normally break a link when you need to send a file to another user. _________________________

Accepted Answer

A) True 
 B)False

Question 2

In the accompanying figure, the screen shown represents a ____ in Design view.

Accepted Answer

A)  form 
B)  page 
C)  query 
D)  report 
A)  form 
B)  page 
C)  query 
D)  report

Question 3

When you copy and paste an object, changes that you make to the object in the source file appear in the destination file.

Accepted Answer

A) True 
 B)False

Question 4

The ____________________ heading is the box at the top of each column containing a letter.

Accepted Answer

The answer of The ____________________ heading is the box at...

Question 5

The file extension .xltx indicates what type of Excel file?

Accepted Answer

A)  Excel template 
B)  Excel workbook 
C)  Excel worksheet 
D)  Excel formulas only worksheet 
A)  Excel template 
B)  Excel workbook 
C)  Excel worksheet 
D)  Excel formulas only worksheet

Question 6

When do you apply formatting to a cell or range?

Accepted Answer

You can apply format

Question 7

In the accompanying figure, the entry in cell B5 is a ____.

Accepted Answer

A)  label 
B)  formula 
C)  graphic 
D)  value 
A)  label 
B)  formula 
C)  graphic 
D)  value

Question 8

A ____ is an individual media file, such as art, sound, animation, or a movie.

Accepted Answer

A)  point 
B)  cell style 
C)  clip 
D)  template 
A)  point 
B)  cell style 
C)  clip 
D)  template

Question 9

In the accompanying figure, item 5 represents ____.

Accepted Answer

A)  data markers 
B)  tick marks 
C)  the plot area 
D)  the legend 
A)  data markers 
B)  tick marks 
C)  the plot area 
D)  the legend

Question 10

In the accompanying figure, the entry in cell B4 is a ____.

Accepted Answer

A)  label 
B)  formula 
C)  number 
D)  value 
A)  label 
B)  formula 
C)  number 
D)  value

Question 11

Critical Thinking Questions 
Case 1-1 
You are the manager of the Sales department for a local clothing store that has three locations. You have prepared a worksheet containing data about the sales figures for the company, which also has a chart to illustrate of the data. 
In the chart, you want to change the fill of one of the data series in your worksheet. To do this, what list arrow do you use? 
a. Shape Fill list arrow in the Shape Styles group on the CHART TOOLS FORMAT tab 
b. Series Fill list arrow in the Series group on the CHART TOOLS FORMAT tab 
c. Fill list arrow in the Data group on the CHART TOOLS FORMAT tab 
d. Series Fill list arrow in the Data group on the CHART TOOLS FORMAT tab

Accepted Answer

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

Question 12

You can change the font and font size of any cell or range using the Mini toolbar.

Accepted Answer

A) True 
 B)False

Question 13

On a chart created in Excel, the horizontal axis is also called the ____.

Accepted Answer

A)  x-axis 
B)  y-axis 
C)  data marker 
D)  legend 
A)  x-axis 
B)  y-axis 
C)  data marker 
D)  legend

Question 14

A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

Accepted Answer

A)  mixed 
B)  absolute 
C)  relative 
D)  parameter 
A)  mixed 
B)  absolute 
C)  relative 
D)  parameter

Question 15

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

Accepted Answer

A)  insertion point 
B)  mode indicator 
C)  Enter button 
D)  active cell 
A)  insertion point 
B)  mode indicator 
C)  Enter button 
D)  active cell

Question 16

When a chart is pasted into the destination document, the ________ button is selected by default .

Accepted Answer

A)  Keep Source Formatting & Embed Workbook 
B)  Use Destination Theme & Link Data 
C)  Use Destination Theme & Embed Workbook 
D)  Keep Source Formatting & Link Data 
A)  Keep Source Formatting & Embed Workbook 
B)  Use Destination Theme & Link Data 
C)  Use Destination Theme & Embed Workbook 
D)  Keep Source Formatting & Link Data

Question 17

After updating an Access table, linked values in Excel will update automatically if you wait a few minutes.

Accepted Answer

A) True 
 B)False

Question 18

A(n) mixed reference means that either the column or row reference in the formula is absolute, but not both. _________________________

Accepted Answer

A) True 
 B)False

Question 19

On a chart created in Excel, the vertical axis is also called the ____.

Accepted Answer

A)  x-axis 
B)  y-axis 
C)  data marker 
D)  legend 
A)  x-axis 
B)  y-axis 
C)  data marker 
D)  legend

Question 20

In the accompanying figure, item ____ shows the button that aligns text at the left edge of the cell.

Accepted Answer

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

You normally break a link when you need to send a file to another user. _________________________

In the accompanying figure, the screen shown represents a ____ in Design view.

When you copy and paste an object, changes that you make to the object in the source file appear in the destination file.

The ____________________ heading is the box at the top of each column containing a letter.

The file extension .xltx indicates what type of Excel file?

When do you apply formatting to a cell or range?

In the accompanying figure, the entry in cell B5 is a ____.

A ____ is an individual media file, such as art, sound, animation, or a movie.

In the accompanying figure, item 5 represents ____.

In the accompanying figure, the entry in cell B4 is a ____.

You can change the font and font size of any cell or range using the Mini toolbar.

On a chart created in Excel, the horizontal axis is also called the ____.

A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

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

When a chart is pasted into the destination document, the ________ button is selected by default .

After updating an Access table, linked values in Excel will update automatically if you wait a few minutes.

A(n) mixed reference means that either the column or row reference in the formula is absolute, but not both. _________________________

On a chart created in Excel, the vertical axis is also called the ____.

In the accompanying figure, item ____ shows the button that aligns text at the left edge of the cell.

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

You normally break a link when you need to send a file to another user. _________________________

In the accompanying figure, the screen shown represents a ____ in Design view.

When you copy and paste an object, changes that you make to the object in the source file appear in the destination file.

The ____________________ heading is the box at the top of each column containing a letter.

The file extension .xltx indicates what type of Excel file?

When do you apply formatting to a cell or range?

In the accompanying figure, the entry in cell B5 is a ____.

A ____ is an individual media file, such as art, sound, animation, or a movie.

In the accompanying figure, item 5 represents ____.

In the accompanying figure, the entry in cell B4 is a ____.

You can change the font and font size of any cell or range using the Mini toolbar.

On a chart created in Excel, the horizontal axis is also called the ____.

A(n) ____ cell reference tells Excel to substitute new cell references within the copied formulas as necessary.

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

When a chart is pasted into the destination document, the ________ button is selected by default .

After updating an Access table, linked values in Excel will update automatically if you wait a few minutes.

A(n) mixed reference means that either the column or row reference in the formula is absolute, but not both. _________________________

On a chart created in Excel, the vertical axis is also called the ____.

In the accompanying figure, item ____ shows the button that aligns text at the left edge of the cell.

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