(A) Many to many
(B) One to many
(C) None to many
(D) None to none
(A) Fields that you add to this quadrant will be used as the column labels within the PivotTable.
(B) Fields that you add to this quadrant will be used as the row labels within the PivotTable.
(C) Fields that you add to this quadrant will be used as the name of the PivotTable.
(D) Fields that you add to this quadrant will be the intersecting calculated fields within thePivotTable.
(D) Active Field
(A) Power View allows you to view multiple workbooks within a single view.
(B) Power View is used to create a 3D view that allows you to view multiple worksheets within aworkbook at the same time.
(C) Power View is a data visualization and reporting tool.
(D) Power View is a tool used to manage the data within the data model in a visual environment.
(D) Named Ranges
(A) You should select the cells in the worksheet that you do not wish to protect.
(B) You should lock the cells that you do not want to allow users to change.
(C) You should unlock cells that you want users to be able to change later.
(D) You should select the cells in the worksheet that you wish to protect.
(A) Macros are small programs that allow you to automate repetitive tasks within Excel.
(B) Macros are “add-in” components that will reprogram functions within Excel.
(C) Macros create data portals to allow you to import data from SQL Server into Excel.
(D) Macros are used to apply user restrictions and security on workbooks in Excel.