Question 1

The following sequence,2,4,6,etc.,is an example of a ____ series.

Accepted Answer

A)  linear 
B)  growth 
C)  fill 
D)  date 
A)  linear 
B)  growth 
C)  fill 
D)  date

Question 2

Judy, an administrative assistant to the sales manager, sends you an e-mail requesting some help on a current project. The sales manager has created three separate workbooks in which she stores sales data. Judy needs to create a new workbook with worksheets that summarize the data from the three workbooks; she asks if there is any way to summarize the data in the three workbooks without spending hours to do it manually.
-You tell Judy that ____.

Accepted Answer

A)  she should copy the data from each worksheet in the three workbooks and paste the data into a single worksheet in a new workbook; then create simple formulas to add all the data 
B)  she can create a new dependent workbook containing a consolidation worksheet; then create 3-D linking formulas to the three source workbooks to summarize the data in the consolidation worksheet 
C)  she should try to export the data in the three workbooks into a database program; then create a summary report using the database report tool 
D)  unfortunately,she will have to manually prepare the summary from data in the three workbooks 
A)  she should copy the data from each worksheet in the three workbooks and paste the data into a single worksheet in a new workbook; then create simple formulas to add all the data 
B)  she can create a new dependent workbook containing a consolidation worksheet; then create 3-D linking formulas to the three source workbooks to summarize the data in the consolidation worksheet 
C)  she should try to export the data in the three workbooks into a database program; then create a summary report using the database report tool 
D)  unfortunately,she will have to manually prepare the summary from data in the three workbooks

Question 3

Which of the following is a method of electronic document distribution?

Accepted Answer

A) posting on SkyDrive 
B) sharing an XPS image of a document 
C) blog posting 
D) posting on a social networking site 
E)  None of the above. 
A) posting on SkyDrive 
B) sharing an XPS image of a document 
C) blog posting 
D) posting on a social networking site 
E)  None of the above.

Question 4

A workbook contains ____ worksheet(s)by default.

Accepted Answer

A)  one 
B)  two 
C)  three 
D)  four 
A)  one 
B)  two 
C)  three 
D)  four

Question 5

You should hold down the ____ key to select the nonadjacent cells.

Accepted Answer

A)  SHIFT 
B)  CTRL 
C)  TAB 
D)  END 
A)  SHIFT 
B)  CTRL 
C)  TAB 
D)  END

Question 6

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

Accepted Answer

The answer of You can click the ____________________ tabs at...

Question 7

When you insert a new worksheet,Excel places the new sheet tab to the left of the active tab.

Accepted Answer

A) True 
 B)False

Question 8

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

Accepted Answer

A) True 
 B)False

Question 9

Excel copies page setup characteristics when one sheet is copied to another.

Accepted Answer

A) True 
 B)False

Question 10

You can switch to Page Layout view by clicking the Page Layout button ____.

Accepted Answer

A)  on the status bar 
B)  (HOME tab | Layout group) 
C)  (VIEW tab | Show group) 
D)  on the FILE tab 
A)  on the status bar 
B)  (HOME tab | Layout group) 
C)  (VIEW tab | Show group) 
D)  on the FILE tab

Question 11

If multiple sheets are selected and you want to select the active sheet,if you are using a touch screen,press and hold and select ____ from the shortcut menu.

Accepted Answer

A)  Select Active Sheet 
B)  Ungroup Sheets 
C)  Quick Select 
D)  Disaggregate Sheets 
A)  Select Active Sheet 
B)  Ungroup Sheets 
C)  Quick Select 
D)  Disaggregate Sheets

Question 12

When you create a new custom format code,Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

Accepted Answer

A) True 
 B)False

Question 13

If multiple sheets are selected and you want to select a sheet that is selected,but not active,tap or click the sheet tab you want to select.

Accepted Answer

A) True 
 B)False

Question 14

When you insert a manual page break,Excel displays a(n)____ line between pages.

Accepted Answer

A)  solid 
B)  orange 
C)  red 
D)  dotted 
A)  solid 
B)  orange 
C)  red 
D)  dotted

Question 15

You can tap or click the ____________________ button (PAGE LAYOUT tab | Themes group)to display the Colors gallery.

Accepted Answer

The answer of You can tap or click the ____________________...

Question 16

The formula =sum(1:1)adds all the values in column A._________________________

Accepted Answer

A) True 
 B)False

Question 17

Which of the following is the path to the Breaks button?

Accepted Answer

Question 18

The following sequence,Jan,Feb,Mar,etc.,is an example of a ____ series.

Accepted Answer

A)  linear 
B)  date 
C)  growth 
D)  fill 
A)  linear 
B)  date 
C)  growth 
D)  fill

Question 19

You can enter a sheet reference in cell by typing it or by clicking the appropriate sheet tab while in ____________________ mode.

Accepted Answer

The answer of You can enter a sheet reference in...

Question 20

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

Accepted Answer

A) positive numbers 
B) negative numbers 
C) zeros 
D) text 
E)  None of the above. 
A) positive numbers 
B) negative numbers 
C) zeros 
D) text 
E)  None of the above.

The following sequence,2,4,6,etc.,is an example of a ____ series.

Which of the following is a method of electronic document distribution?

A workbook contains ____ worksheet(s)by default.

You should hold down the ____ key to select the nonadjacent cells.

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

When you insert a new worksheet,Excel places the new sheet tab to the left of the active tab.

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

Excel copies page setup characteristics when one sheet is copied to another.

You can switch to Page Layout view by clicking the Page Layout button ____.

If multiple sheets are selected and you want to select the active sheet,if you are using a touch screen,press and hold and select ____ from the shortcut menu.

When you create a new custom format code,Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

If multiple sheets are selected and you want to select a sheet that is selected,but not active,tap or click the sheet tab you want to select.

When you insert a manual page break,Excel displays a(n)____ line between pages.

You can tap or click the ____________________ button (PAGE LAYOUT tab | Themes group)to display the Colors gallery.

The formula =sum(1:1)adds all the values in column A._________________________

Which of the following is the path to the Breaks button?

The following sequence,Jan,Feb,Mar,etc.,is an example of a ____ series.

You can enter a sheet reference in cell by typing it or by clicking the appropriate sheet tab while in ____________________ mode.

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters

Exam 5: Working With Multiple Worksheets and Workbooks

The following sequence,2,4,6,etc.,is an example of a ____ series.

Which of the following is a method of electronic document distribution?

A workbook contains ____ worksheet(s)by default.

You should hold down the ____ key to select the nonadjacent cells.

You can click the ____________________ tabs at the bottom of the Excel window to move from worksheet to worksheet in a workbook.

When you insert a new worksheet,Excel places the new sheet tab to the left of the active tab.

You must enter the first three numbers in a series so that Excel can determine the increment amount when using the fill handle to increment a series by two.

Excel copies page setup characteristics when one sheet is copied to another.

You can switch to Page Layout view by clicking the Page Layout button ____.

If multiple sheets are selected and you want to select the active sheet,if you are using a touch screen,press and hold and select ____ from the shortcut menu.

When you create a new custom format code,Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.

If multiple sheets are selected and you want to select a sheet that is selected,but not active,tap or click the sheet tab you want to select.

When you insert a manual page break,Excel displays a(n)____ line between pages.

You can tap or click the ____________________ button (PAGE LAYOUT tab | Themes group)to display the Colors gallery.

The formula =sum(1:1)adds all the values in column A._________________________

Which of the following is the path to the Breaks button?

The following sequence,Jan,Feb,Mar,etc.,is an example of a ____ series.

You can enter a sheet reference in cell by typing it or by clicking the appropriate sheet tab while in ____________________ mode.

You can customize a format code in a cell entry to specify how ____ are displayed in a cell.

Creating a Worksheet and a Chart

Formulas,Functions,and Formatting

Working With Large Worksheets,Charting,and What-If Analysis

Financial Functions,Data Tables,and Amortization Schedules

Creating,sorting,and Querying a Table

Creating Templates,importing Data,and Working With Smartart,Images,and Screen Shots

Office 2013 and Windows 8 Essential Concepts and Skills

Filters