Excel Advanced 2013
CLICK HERE to access the videos for this course.
- 1.From the following list of choices, select the name of the choice that is a possible type of tablerelationship that can be created between two tables within the “Create Relationships” window.
- A.
(A) Many to many
- B.
(B) One to many
- C.
(C) None to many
- D.
(D) None to none
- 2.From the following list of choices, select the choice that BEST describes the function of the “Values”quadrant within a PivotTable in Excel 2010:2007.
- A.
(A) Fields that you add to this quadrant will be used as the column labels within the PivotTable.
- B.
(B) Fields that you add to this quadrant will be used as the row labels within the PivotTable.
- C.
(C) Fields that you add to this quadrant will be used as the name of the PivotTable.
- D.
(D) Fields that you add to this quadrant will be the intersecting calculated fields within thePivotTable.
- 3.From the following list of choices, select the name of the button group within the “PivotTable Tools”contextual tab in the Ribbon that contains the “Field Settings” button in Excel 2010:2007.
- A.
(A) PivotTable
- B.
(B) Actions
- C.
(C) Tools
- D.
(D) Active Field
- 4.From the following list of choices, select the choice that BEST describes the purpose of the PowerView tool within Excel 2013.
- A.
(A) Power View allows you to view multiple workbooks within a single view.
- B.
(B) Power View is used to create a 3D view that allows you to view multiple worksheets within aworkbook at the same time.
- C.
(C) Power View is a data visualization and reporting tool.
- D.
(D) Power View is a tool used to manage the data within the data model in a visual environment.
- 5.From the following list of choices, select the name of the choice that is NOT a type of datavisualization that you can create in Power View.
- A.
(A) Map
- B.
(B) Card
- C.
(C) Matrix
- D.
(D) Coordinate
- 6.From the following list of choices, select the name of the type of object that you CANNOT filter usinga slicer.
- A.
(A) Tables
- B.
(B) PivotTables
- C.
(C) PivotCharts
- D.
(D) Named Ranges
- 7.From the following list, select the step that should be performed BEFORE applying worksheetprotection in Excel.
- A.
(A) You should select the cells in the worksheet that you do not wish to protect.
- B.
(B) You should lock the cells that you do not want to allow users to change.
- C.
(C) You should unlock cells that you want users to be able to change later.
- D.
(D) You should select the cells in the worksheet that you wish to protect.
- 8.From the following list, select the choice that BEST describes the purpose of creating macros withinExcel.
- A.
(A) Macros are small programs that allow you to automate repetitive tasks within Excel.
- B.
(B) Macros are “add-in” components that will reprogram functions within Excel.
- C.
(C) Macros create data portals to allow you to import data from SQL Server into Excel.
- D.
(D) Macros are used to apply user restrictions and security on workbooks in Excel.
Back to top