Question 1

The active workbook has all of the following EXCEPT: ____.

Accepted Answer

A)  an Excel program icon in the upper-left corner 
B)  a blue status bar 
C)  sizing buttons 
D)  scroll bars 
A)  an Excel program icon in the upper-left corner 
B)  a blue status bar 
C)  sizing buttons 
D)  scroll bars

Question 2

You can create custom sorting options in Excel.

Accepted Answer

A) True 
 B)False

Question 3

FIGURE EX 11-1   In Figure EX 11-1 above, click ____ to display the greatest amount of detail.

Accepted Answer

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

Question 4

Case EX 7-2 Ron wants to be able to distinguish one worksheet from another. He plans to rename the worksheets and change the color of the tabs. Ron now wants to change the tab color. He first right-clicks the sheet tab he wants to recolor, points to ____ on the shortcut menu, and then clicks the color he wants for the tab.

Accepted Answer

A)  Tab 
B)  Color 
C)  Tab Color 
D)  New Color 
A)  Tab 
B)  Color 
C)  Tab Color 
D)  New Color

Question 5

You can right-click a cell or selected range, and then click Insert on the shortcut menu to open the Insert dialog box.

Accepted Answer

A) True 
 B)False

Question 6

The sort and filter options are displayed when you click the Column Labels down arrow or the Row Labels down arrow on the PivotChart.

Accepted Answer

A) True 
 B)False

Question 7

The New Formatting Rule dialog box is opened through the ____ group on the Home tab.

Accepted Answer

A)  Alignment 
B)  Editing 
C)  Styles 
D)  Number 
A)  Alignment 
B)  Editing 
C)  Styles 
D)  Number

Question 8

The Trace Error feature is helpful when you are just tracing one cell for an error.

Accepted Answer

A) True 
 B)False

Question 9

A(n) data table displays the data used to create a chart.

Accepted Answer

A) True 
 B)False

Question 10

A ____ simply records a series of steps that you do frequently, such as formatting text.

Accepted Answer

A)  virus 
B)  button 
C)  macro 
D)  tab 
A)  virus 
B)  button 
C)  macro 
D)  tab

Question 11

You use special chart text formatting tools to make changes to the fonts used in the chart.

Accepted Answer

A) True 
 B)False

Question 12

The worksheet cell is the hyperlink, not the contents entered in that cell.

Accepted Answer

A) True 
 B)False

Question 13

A macro is a simple way to automate some of the common, repetitive tasks you perform in Excel.

Accepted Answer

A) True 
 B)False

Question 14

The template includes all the parts of a workbook that constantly change, such as text, labels, formulas, and formatting.

Accepted Answer

A) True 
 B)False

Question 15

The VLOOKUP function is found on the ____________________ list.

Accepted Answer

The answer of The VLOOKUP function is found on the...

Question 16

If Excel incorrectly flags a word that you use frequently as a misspelling, you can add the word to a custom dictionary that resides on your computer by clicking the ____ button.

Accepted Answer

A)  Customize 
B)  Add to Dictionary 
C)  Add to Thesaurus 
D)  Add to Excel 
A)  Customize 
B)  Add to Dictionary 
C)  Add to Thesaurus 
D)  Add to Excel

Question 17

You click the ____ button to select the Encrypt with Password option.

Accepted Answer

A)  Save Options 
B)  Encryption 
C)  Track Changes 
D)  Protect Workbook 
A)  Save Options 
B)  Encryption 
C)  Track Changes 
D)  Protect Workbook

Question 18

To help track down and correct spelling errors in a worksheet, you can use the Find command.

Accepted Answer

A) True 
 B)False

Question 19

In a PivotTable, you can quickly change the format and calculation by redisplaying the ____________________ list and selecting another option.

Accepted Answer

The answer of In a PivotTable, you can quickly change...

Question 20

Match between columns
                        Premises: The character which is a placeholder for a digit in a format code. Nothing will appear if there is not another number available.

Accepted Answer

The Answer of : (colon) and % and 0 and is...

The active workbook has all of the following EXCEPT: ____.

You can create custom sorting options in Excel.

FIGURE EX 11-1 In Figure EX 11-1 above, click ____ to display the greatest amount of detail.

You can right-click a cell or selected range, and then click Insert on the shortcut menu to open the Insert dialog box.

The sort and filter options are displayed when you click the Column Labels down arrow or the Row Labels down arrow on the PivotChart.

The New Formatting Rule dialog box is opened through the ____ group on the Home tab.

The Trace Error feature is helpful when you are just tracing one cell for an error.

A(n) data table displays the data used to create a chart.

A ____ simply records a series of steps that you do frequently, such as formatting text.

You use special chart text formatting tools to make changes to the fonts used in the chart.

The worksheet cell is the hyperlink, not the contents entered in that cell.

A macro is a simple way to automate some of the common, repetitive tasks you perform in Excel.

The template includes all the parts of a workbook that constantly change, such as text, labels, formulas, and formatting.

The VLOOKUP function is found on the ____________________ list.

If Excel incorrectly flags a word that you use frequently as a misspelling, you can add the word to a custom dictionary that resides on your computer by clicking the ____ button.

You click the ____ button to select the Encrypt with Password option.

To help track down and correct spelling errors in a worksheet, you can use the Find command.

In a PivotTable, you can quickly change the format and calculation by redisplaying the ____________________ list and selecting another option.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

The active workbook has all of the following EXCEPT: ____.

You can create custom sorting options in Excel.

FIGURE EX 11-1 In Figure EX 11-1 above, click ____ to display the greatest amount of detail.

You can right-click a cell or selected range, and then click Insert on the shortcut menu to open the Insert dialog box.

The sort and filter options are displayed when you click the Column Labels down arrow or the Row Labels down arrow on the PivotChart.

The New Formatting Rule dialog box is opened through the ____ group on the Home tab.

The Trace Error feature is helpful when you are just tracing one cell for an error.

A(n) data table displays the data used to create a chart.

A ____ simply records a series of steps that you do frequently, such as formatting text.

You use special chart text formatting tools to make changes to the fonts used in the chart.

The worksheet cell is the hyperlink, not the contents entered in that cell.

A macro is a simple way to automate some of the common, repetitive tasks you perform in Excel.

The template includes all the parts of a workbook that constantly change, such as text, labels, formulas, and formatting.

The VLOOKUP function is found on the ____________________ list.

If Excel incorrectly flags a word that you use frequently as a misspelling, you can add the word to a custom dictionary that resides on your computer by clicking the ____ button.

You click the ____ button to select the Encrypt with Password option.

To help track down and correct spelling errors in a worksheet, you can use the Find command.

In a PivotTable, you can quickly change the format and calculation by redisplaying the ____________________ list and selecting another option.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters