Question 1

If a change is made to the PivotTable, the associated PivotChart changes as well.

Accepted Answer

A) True 
 B)False

Question 2

To make changes to an element's fill, border color, border style, shadow, 3-D format, alignment, and so forth, you need to open the Chart Elements dialog box.

Accepted Answer

A) True 
 B)False

Question 3

The Office Clipboard is a temporary storage area for up to ____ selections you copy or cut.

Accepted Answer

A)  10 
B)  12 
C)  24 
D)  30 
A)  10 
B)  12 
C)  24 
D)  30

Question 4

Match between columns
                        Premises: Functions that are used to insert dates and times in a worksheet.

Accepted Answer

The Answer of Mathematical functions and Date and time functions is...

Question 5

A(n) ____________________ mark separates the worksheet range from its cell or range reference.

Accepted Answer

The answer of A(n) ____________________ mark separates the worksheet range...

Question 6

The ____________________ group on the Page Layout tab contains three options for resizing a worksheet.

Accepted Answer

The answer of The ____________________ group on the Page Layout...

Question 7

=ROUND(142.3433,-2) returns 142.34 .

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: A feature that instantly adds a formula that totals the worksheet data to a cell.

Accepted Answer

The Answer of Convert Text to Columns and drop-down list is...

Question 9

____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

Accepted Answer

A)  Columns 
B)  Rows 
C)  Cells 
D)  Headings 
A)  Columns 
B)  Rows 
C)  Cells 
D)  Headings

Question 10

Case EX 13-2 Gregory works for the local public television station. The station has recently held a TV pledge drive and they have received a large number of pledges from viewers and businesses. The data about the pledge drive is stored in a worksheet. The worksheet has six columns: First Name, Last Name, Address, Phone, Pledge, Received. The Received column contains "Yes" or "No" values depending on whether the amount pledged has been received by the station. From only the pledges which have been received, Gregory wants to find out the average amount pledged. He can first filter the data and then use the ____ function.

Accepted Answer

A)  SUMIF 
B)  COUNTA 
C)  COUNT 
D)  Subtotal 
A)  SUMIF 
B)  COUNTA 
C)  COUNT 
D)  Subtotal

Question 11

A bar chart, sometimes called an XY chart, shows the relationship between two categories of data.

Accepted Answer

A) True 
 B)False

Question 12

Match between columns
                        Premises: Puts a dollar sign with the number at the same location it appears in the format code.

Accepted Answer

The Answer of : (colon) and # and $ and is...

Question 13

All images are protected by copyright law.

Accepted Answer

A) True 
 B)False

Question 14

Match between columns
                        Premises: Useful when you want to find out the result of a scenario based on changing data in several cells.

Accepted Answer

The Answer of Goal Seek and Scenario Manager and Trace is...

Question 15

If you change a theme in one worksheet, it does not affect the themes in other worksheets.

Accepted Answer

A) True 
 B)False

Question 16

When a PivotChart is selected, additional ____ appear on the Ribbon.

Accepted Answer

A)  designs 
B)  tabs 
C)  outlines 
D)  clusters 
A)  designs 
B)  tabs 
C)  outlines 
D)  clusters

Question 17

If you want to keep track of the changes made in a workbook, you can enable the ____ feature.

Accepted Answer

A)  Track Changes 
B)  Password 
C)  Encryption 
D)  Decryption 
A)  Track Changes 
B)  Password 
C)  Encryption 
D)  Decryption

Question 18

To change the background color of a cell, select the cell you want to change. On the Home tab of the Ribbon, in the Font group, click the Background Color button arrow.

Accepted Answer

A) True 
 B)False

Question 19

To ____________________ means to combine or unite.

Accepted Answer

The answer of To ____________________ means to combine or unite....

Question 20

The AND function returns the result of ____ if any or all of the arguments are false.

Accepted Answer

A)  TRUE 
B)  FALSE 
C)  ERROR 
D)  none of the above 
A)  TRUE 
B)  FALSE 
C)  ERROR 
D)  none of the above

If a change is made to the PivotTable, the associated PivotChart changes as well.

To make changes to an element's fill, border color, border style, shadow, 3-D format, alignment, and so forth, you need to open the Chart Elements dialog box.

The Office Clipboard is a temporary storage area for up to ____ selections you copy or cut.

A(n) ____________________ mark separates the worksheet range from its cell or range reference.

The ____________________ group on the Page Layout tab contains three options for resizing a worksheet.

=ROUND(142.3433,-2) returns 142.34 .

____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

A bar chart, sometimes called an XY chart, shows the relationship between two categories of data.

All images are protected by copyright law.

If you change a theme in one worksheet, it does not affect the themes in other worksheets.

When a PivotChart is selected, additional ____ appear on the Ribbon.

If you want to keep track of the changes made in a workbook, you can enable the ____ feature.

To change the background color of a cell, select the cell you want to change. On the Home tab of the Ribbon, in the Font group, click the Background Color button arrow.

To ____________________ means to combine or unite.

The AND function returns the result of ____ if any or all of the arguments are false.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

If a change is made to the PivotTable, the associated PivotChart changes as well.

To make changes to an element's fill, border color, border style, shadow, 3-D format, alignment, and so forth, you need to open the Chart Elements dialog box.

The Office Clipboard is a temporary storage area for up to ____ selections you copy or cut.

A(n) ____________________ mark separates the worksheet range from its cell or range reference.

The ____________________ group on the Page Layout tab contains three options for resizing a worksheet.

=ROUND(142.3433,-2) returns 142.34 .

____ of the worksheet appear vertically and are identified by letters at the top of the worksheet window.

A bar chart, sometimes called an XY chart, shows the relationship between two categories of data.

All images are protected by copyright law.

If you change a theme in one worksheet, it does not affect the themes in other worksheets.

When a PivotChart is selected, additional ____ appear on the Ribbon.

If you want to keep track of the changes made in a workbook, you can enable the ____ feature.

To change the background color of a cell, select the cell you want to change. On the Home tab of the Ribbon, in the Font group, click the Background Color button arrow.

To ____________________ means to combine or unite.

The AND function returns the result of ____ if any or all of the arguments are false.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters