Question 1

When you paste formula cells using the Paste button in the Clipboard group,which of the following is true?

Accepted Answer

A)  The Paste Options button then lets you paste specific elements of the copied cells. 
B)  The formula is copied with cell references you must adjust to avoid worksheet errors. 
C)  The Auto Fill Options button appears. 
D)  Pointing to the destination cell causes a preview of the cell contents to appear. 
A)  The Paste Options button then lets you paste specific elements of the copied cells. 
B)  The formula is copied with cell references you must adjust to avoid worksheet errors. 
C)  The Auto Fill Options button appears. 
D)  Pointing to the destination cell causes a preview of the cell contents to appear.

Question 2

In the formula =B6*$B$2,which of the following describes $B$2?

Accepted Answer

A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  Average 
A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  Average

Question 3

You need to add another product to your inventory worksheet,which shows product names in row A Which of the following should you add?

Accepted Answer

A)  a row 
B)  a column 
C)  a button 
D)  conditional formatting 
A)  a row 
B)  a column 
C)  a button 
D)  conditional formatting

Question 4

Which of the following is true about inserting cells in a worksheet?

Accepted Answer

A)  Excel automatically adjusts cell references to reflect new formula locations. 
B)  You need to adjust cell references in all formulas that have moved. 
C)  You cannot insert cells in a worksheet. 
D)  Cells below the inserted cells are always moved downward. 
A)  Excel automatically adjusts cell references to reflect new formula locations. 
B)  You need to adjust cell references in all formulas that have moved. 
C)  You cannot insert cells in a worksheet. 
D)  Cells below the inserted cells are always moved downward.

When you paste formula cells using the Paste button in the Clipboard group,which of the following is true?

In the formula =B6*$B$2,which of the following describes $B$2?

You need to add another product to your inventory worksheet,which shows product names in row A Which of the following should you add?

Which of the following is true about inserting cells in a worksheet?

Creating a Worksheet and a Chart

Formulas,functions,and Formatting

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters

Exam 3: Working With Large Worksheets, charting, and What-If Analysis

When you paste formula cells using the Paste button in the Clipboard group,which of the following is true?

In the formula =B6*$B$2,which of the following describes $B$2?

You need to add another product to your inventory worksheet,which shows product names in row A Which of the following should you add?

Which of the following is true about inserting cells in a worksheet?

Creating a Worksheet and a Chart

Formulas,functions,and Formatting

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters