Excel Advanced 2013

8 Questions | By Cay1117 | Last updated: Nov 13, 2015 | Total Attempts: 69

Questions

Settings

CLICK HERE to access the videos for this course.

More Advanced Excel Quizzes

Advanced Excel Quiz Questions And Answers Advanced Excel Quiz Questions And Answers

CMP 540 Excel Trivia Questions Quiz CMP 540 Excel Trivia Questions Quiz

Could You Pass The MS Excel Assessment Trivia Quiz? Could You Pass The MS Excel Assessment Trivia Quiz?

Featured Quizzes

Which Celebrity Do You Look Like Quiz? Which Celebrity Do You Look Like Quiz?

Quiz: The Best Pokemon Picker! Quiz: The Best Pokemon Picker!

The Office Trivia Quiz! The Office Trivia Quiz!

Related Topics

Questions and Answers

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