Question 1

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

Accepted Answer

A) True 
 B)False

Question 2

The path to the Comma Style button is ____.

Accepted Answer

Question 3

A reference to a range that spans two or more sheets in a workbook is called a(n) ____________________ reference.

Accepted Answer

The answer of A reference to a range that spans...

Question 4

Match between columns
                        Premises: A workbook that automatically reads data from linked workbooks.

Accepted Answer

The Answer of dependent workbook and consolidation and circular reference is...

Question 5

Match between columns
                        Premises: Keyboard shortcut to paste the contents and format of source area.

Accepted Answer

The Answer of CTRL+U and CTRL+E and circular reference and is...

Question 6

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

Accepted Answer

Question 7

The ____________________ option is the Paste Gallery command that allows you to copy the contents of the source area but not the formatting for formulas.

Accepted Answer

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

Question 8

A(n) ____ reference is a formula that depends on its own value.

Accepted Answer

A)  explicit 
B)  implicit 
C)  singular 
D)  circular 
A)  explicit 
B)  implicit 
C)  singular 
D)  circular

Question 9

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 10

Modified Multiple Choice Which of the following are true about the ROUND function?

Accepted Answer

A)  If the number of digits argument is equal to 0 (zero), then the number is rounded to the nearest integer. 
B)  If the number of digits argument is not included, then the number is rounded to 10 times the current value. 
A)  If the number of digits argument is equal to 0 (zero), then the number is rounded to the nearest integer. 
B)  If the number of digits argument is not included, then the number is rounded to 10 times the current value.

Question 11

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 12

An organization may keep data from various departments or regions in different worksheets in the same workbook.

Accepted Answer

A) True 
 B)False

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

The path to the Comma Style button is ____.

A reference to a range that spans two or more sheets in a workbook is called a(n) ____________________ reference.

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

The ____________________ option is the Paste Gallery command that allows you to copy the contents of the source area but not the formatting for formulas.

A(n) ____ reference is a formula that depends on its own value.

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

Modified Multiple Choice Which of the following are true about the ROUND function?

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.

An organization may keep data from various departments or regions in different worksheets in the same workbook.

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

Excel's capability of drilling data through worksheets is an inefficient way to enter data that is common among worksheets.

The path to the Comma Style button is ____.

A reference to a range that spans two or more sheets in a workbook is called a(n) ____________________ reference.

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

The ____________________ option is the Paste Gallery command that allows you to copy the contents of the source area but not the formatting for formulas.

A(n) ____ reference is a formula that depends on its own value.

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

Modified Multiple Choice Which of the following are true about the ROUND function?

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.

An organization may keep data from various departments or regions in different worksheets in the same workbook.

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