Question 1

Which of the following is the path to the Switch Windows button?

Accepted Answer

Question 2

The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.

Accepted Answer

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

Question 3

The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.

Accepted Answer

A) True 
 B)False

Question 4

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area for numbers or formulas, but use the format of the destination area for text.

Accepted Answer

Values & N

Question 5

Match between columns
                        Premises: A formula that depends on its own value.

Accepted Answer

The Answer of CTRL+E and drag page break and dependent is...

Question 6

The path to the Sum button is ____.

Accepted Answer

Question 7

Which of the following format symbols displays text along with numbers entered in a cell?

Accepted Answer

A)  _ (underscore) 
B)  0 (zero) 
C)  " " (quotation marks) 
D)  # (number sign) 
A)  _ (underscore) 
B)  0 (zero) 
C)  " " (quotation marks) 
D)  # (number sign)

Question 8

Match between columns
                        Premises: Reposition page break in Page Break Preview.

Accepted Answer

The Answer of drilling an entry and drag page break is...

Question 9

The code ____ instructs Excel to insert the page number in the header or footer section.

Accepted Answer

A)  > 
B)  &[Page] 
C)  [PageNum] 
D)  (LoadPageNum) 
A)  > 
B)  &[Page] 
C)  [PageNum] 
D)  (LoadPageNum)

Question 10

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 11

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

Accepted Answer

A) True 
 B)False

Question 12

Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________ .

Accepted Answer

The answer of Entering a number once and copying it...

Question 13

The Normal style is the format style that Excel initially assigns to all cells in a new workbook.

Accepted Answer

A) True 
 B)False

Question 14

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

Accepted Answer

A) True 
 B)False

Question 15

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area but swap the rows and columns.

Accepted Answer

The answer of The ____________________ option is the Paste Gallery...

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

You can enter formulas that reference cells on other worksheets in the workbook.

Accepted Answer

A) True 
 B)False

Question 18

Among the Paste Gallery commands, the ____________________ option will copy the contents and format of a source area but not any borders.

Accepted Answer

The answer of Among the Paste Gallery commands, the ____________________...

Question 19

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 20

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 ____________________...

Which of the following is the path to the Switch Windows button?

The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.

The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area for numbers or formulas, but use the format of the destination area for text.

The path to the Sum button is ____.

Which of the following format symbols displays text along with numbers entered in a cell?

The code ____ instructs Excel to insert the page number in the header or footer section.

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.

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________ .

The Normal style is the format style that Excel initially assigns to all cells in a new workbook.

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area but swap the rows and columns.

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

You can enter formulas that reference cells on other worksheets in the workbook.

Among the Paste Gallery commands, the ____________________ option will copy the contents and format of a source area but not any borders.

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

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

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Creating, Sorting, and Querying a Table

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters

Exam 6: Excell: Working With Multiple Worksheets and Workbooks

Which of the following is the path to the Switch Windows button?

The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.

The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area for numbers or formulas, but use the format of the destination area for text.

The path to the Sum button is ____.

Which of the following format symbols displays text along with numbers entered in a cell?

The code ____ instructs Excel to insert the page number in the header or footer section.

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.

You can reference an entire column or an entire row in a function argument by listing only the column or only the row.

Entering a number once and copying it through worksheets so that it is entered in the same cell on all the selected worksheets is called ____________________ .

The Normal style is the format style that Excel initially assigns to all cells in a new workbook.

Excel assigns a format code to every format style listed in the Category list on the Number sheet in the Format Cells dialog box.

The ____________________ option is the Paste Gallery command that allows you to copy the contents and format of the source area but swap the rows and columns.

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

You can enter formulas that reference cells on other worksheets in the workbook.

Among the Paste Gallery commands, the ____________________ option will copy the contents and format of a source area but not any borders.

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

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

Access: Creating Reports and Forms

Access: Multiple-Table Forms

Access: Advanced Report Techniques

Access: Advanced Form Techniques

Excell: Financial Functions, Data Tables, and Amortization Schedules Question

Excell: Creating, Sorting, and Querying a Table

Excell: Creating Templates, Importing Data, and Working With Smartart, Images, and Screen Shots

Outlook : Managing Contacts and Personal Contact Information With Outlook

Powerpoint: Creating and Formatting Information Graphics Question

Powerpoint: Collaborating on and Delivering a Presentation Question

Powerpoint: Navigating Presentations Using Hyperlinks and Action Buttons

Powerpoint: Creating a Self-Running Presentation Containing Animation

Word: Using a Template to Create a Resume and Sharing a Finished Document

Word: Generating Form Letters, Mailing Labels, and a Directory

Word: Creating a Newsletter With a Pull-Quote and Graphics

Filters