Question 1

The column letter and row number of the active cell are shaded in red for easy identification.

Accepted Answer

A) True 
 B)False

Question 2

The ____________________ character puts a comma with the number at the same location it appears in the format code.

Accepted Answer

The answer of The ____________________ character puts a comma with...

Question 3

Formatting tables works best when there are existing background colors.

Accepted Answer

A) True 
 B)False

Question 4

Numbers will sort lowest to highest in descending order.

Accepted Answer

A) True 
 B)False

Question 5

You can choose to have the legend appear as part of the data table rather than having the legend displayed in a separate part of the chart.

Accepted Answer

A) True 
 B)False

Question 6

The Save As Template command is found on the ____ tab.

Accepted Answer

A)  Home 
B)  Design 
C)  Layout 
D)  Format 
A)  Home 
B)  Design 
C)  Layout 
D)  Format

Question 7

Case EX 8-2 Paco wants to change some of the elements in his chart, including the fill and border color. On a separate chart that he is working on, Paco needs to access the Format dialog box for the chart legend. First, he selects the chart he wants to edit. Then, on the ____ tab under Chart Tools on the Ribbon, in the Current Selection group, he clicks the Format Selection button.

Accepted Answer

A)  Layout 
B)  Page Layout 
C)  Data 
D)  Format 
A)  Layout 
B)  Page Layout 
C)  Data 
D)  Format

Question 8

You can create a custom format for your conditional format by clicking the ____ button in the New Formatting Rule dialog box.

Accepted Answer

A)  Customize 
B)  Reveal 
C)  Modify 
D)  Format 
A)  Customize 
B)  Reveal 
C)  Modify 
D)  Format

Question 9

The SUMIF function is another form of the ____________________ function.

Accepted Answer

The answer of The SUMIF function is another form of...

Question 10

Match between columns
                        Premises: Anything that appears on the screen that you can select and work with as a whole.

Accepted Answer

The Answer of Sort and Comment and Conditional formatting and is...

Question 11

To begin recording a macro, click the ____ button in the Code group on the Developer tab.

Accepted Answer

A)  Start Macro 
B)  Record Macro 
C)  New Macro 
D)  Code Macro 
A)  Start Macro 
B)  Record Macro 
C)  New Macro 
D)  Code Macro

Question 12

Match between columns
                        Premises: Functions, such as the square root functions, that manipulate quantitative data in a worksheet.

Accepted Answer

The Answer of Statistical functions and Mathematical functions and Financial is...

Question 13

To freeze panes, on the View tab of the Ribbon, in the Window group, click the Freeze Panes button, and then click Freeze Panes.

Accepted Answer

A) True 
 B)False

Question 14

To insert a row, click the ____ to select the row where you want the new row to appear. Then, click the Insert button in the Cells group on the Home tab.

Accepted Answer

A)  row number 
B)  row letter 
C)  column letter 
D)  column number 
A)  row number 
B)  row letter 
C)  column letter 
D)  column number

Question 15

The contents of the active cell always appear in the Formula Bar.

Accepted Answer

A) True 
 B)False

Question 16

You can change how the values in a PivotTable are displayed and calculated by using the ____ button.

Accepted Answer

A)  Calculations 
B)  Display 
C)  View 
D)  Arrange 
A)  Calculations 
B)  Display 
C)  View 
D)  Arrange

Question 17

The simplest way to adjust page breaks in a worksheet is in ____.

Accepted Answer

A)  Page Break Preview 
B)  Layout View 
C)  Design View 
D)  Controls View 
A)  Page Break Preview 
B)  Layout View 
C)  Design View 
D)  Controls View

Question 18

The #DIV/0! error indicates that either the function is dividing by a(n) ____________________ or that cells used in the function have missing data.

Accepted Answer

The answer of The #DIV/0! error indicates that either the...

Question 19

To access the Clipboard task pane, click the Clipboard Dialog Box Launcher on the ____ tab of the Ribbon. The Clipboard task pane appears in a separate pane along the left side of the worksheet.

Accepted Answer

A)  Format 
B)  Home 
C)  Data 
D)  Edit 
A)  Format 
B)  Home 
C)  Data 
D)  Edit

Question 20

Logical functions can determine the average, standard deviation, or variance of a range of data.

Accepted Answer

A) True 
 B)False

The column letter and row number of the active cell are shaded in red for easy identification.

The ____________________ character puts a comma with the number at the same location it appears in the format code.

Formatting tables works best when there are existing background colors.

Numbers will sort lowest to highest in descending order.

You can choose to have the legend appear as part of the data table rather than having the legend displayed in a separate part of the chart.

The Save As Template command is found on the ____ tab.

You can create a custom format for your conditional format by clicking the ____ button in the New Formatting Rule dialog box.

The SUMIF function is another form of the ____________________ function.

To begin recording a macro, click the ____ button in the Code group on the Developer tab.

To freeze panes, on the View tab of the Ribbon, in the Window group, click the Freeze Panes button, and then click Freeze Panes.

To insert a row, click the ____ to select the row where you want the new row to appear. Then, click the Insert button in the Cells group on the Home tab.

The contents of the active cell always appear in the Formula Bar.

You can change how the values in a PivotTable are displayed and calculated by using the ____ button.

The simplest way to adjust page breaks in a worksheet is in ____.

The #DIV/0! error indicates that either the function is dividing by a(n) ____________________ or that cells used in the function have missing data.

To access the Clipboard task pane, click the Clipboard Dialog Box Launcher on the ____ tab of the Ribbon. The Clipboard task pane appears in a separate pane along the left side of the worksheet.

Logical functions can determine the average, standard deviation, or variance of a range of data.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

The column letter and row number of the active cell are shaded in red for easy identification.

The ____________________ character puts a comma with the number at the same location it appears in the format code.

Formatting tables works best when there are existing background colors.

Numbers will sort lowest to highest in descending order.

You can choose to have the legend appear as part of the data table rather than having the legend displayed in a separate part of the chart.

The Save As Template command is found on the ____ tab.

You can create a custom format for your conditional format by clicking the ____ button in the New Formatting Rule dialog box.

The SUMIF function is another form of the ____________________ function.

To begin recording a macro, click the ____ button in the Code group on the Developer tab.

To freeze panes, on the View tab of the Ribbon, in the Window group, click the Freeze Panes button, and then click Freeze Panes.

To insert a row, click the ____ to select the row where you want the new row to appear. Then, click the Insert button in the Cells group on the Home tab.

The contents of the active cell always appear in the Formula Bar.

You can change how the values in a PivotTable are displayed and calculated by using the ____ button.

The simplest way to adjust page breaks in a worksheet is in ____.

The #DIV/0! error indicates that either the function is dividing by a(n) ____________________ or that cells used in the function have missing data.

To access the Clipboard task pane, click the Clipboard Dialog Box Launcher on the ____ tab of the Ribbon. The Clipboard task pane appears in a separate pane along the left side of the worksheet.

Logical functions can determine the average, standard deviation, or variance of a range of data.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters