Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off
Reading...
Front

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key

image

Play button

image

Play button

image

Progress

1/40

Click to flip

40 Cards in this Set

  • Front
  • Back

1. Which of the following is not a benefit of PowerPivot?




A) Import data from multiple sources


B) Create relationships


C) Create web queries


D) Maintain connections

C) Create web queries

2. Which of the following is not true regarding data mining?



A) Analyzes large amounts of data


B) Uses advanced statistical techniques


C) Identifies trends


D) Exports data

D) Exports data

3. What tool is best suited for organizing a spreadsheet of rental cars by category in order to be collapsed or expanded?




A) Grouping


B) PivotTables


C) Slicers


D) Outlines

A) Grouping

4. Which of the following is not one of the rules regarding good table design?




A) Use meaningful column labels


B) Ensure data accuracy


C) Avoid blank rows


D) Insert rows to separate data

D) Insert rows to separate data

5. Once slicersare created additional Slicer Styles can be applied.




A) True


B) False


A) True

6. Which of the following is not true about a PivotChart?




A) They function independently from the PivotTable


B) They can be formatted similar to a regular chart


C) They update as the PivotTable updates


D) They can be placed on a separate worksheet

A) They function independently from the PivotTable

7. Which PivotTable calculation option is best suited for comparing the percentage of sales completed by one sales rep against the entire sales force?




A) % of Column Total


B) % of Row Total


C) Running Total


D) % of Grand Total

D) % of Grand Total

8. You must sort in order to properly execute a subtotal.




A) True


B) False

A) True

9. Which of the following is not a PivotTable Subtotals option?




A) Do Not Show Subtotals


B) Show All Subtotals at Bottom of Group


C) Do Not Include Filtered Items in Totals


D) Include Filtered Items in Totals

C) Do Not Include Filtered Items in Totals

10. What is the name of the tab that appears in the Ribbon when a PivotTable is selected?




A) PivotTable Options


B) PivotTable


C) PivotTable Tools


D) Analysis

C) PivotTable Tools

11. A list of active add-ins can be viewed in the ________.




A) Add-Ins Dialog box


B) Scenario Dialog box


C) Data tab


D) View tab

A) Add-Ins Dialog box

12. Which of the following tools is best suited for comparing the effects of one set of substitution values on a formula?




A) Goal Seek


B) Solver


C) Scenario Manager


D) One-variable data table

D) One-variable data table

13. Which what-if analysis tool is best to determine the optimal amount of shoes to produce in order to maximize profit and use 100% of materials?




A) Goal Seek


B) Solver


C) Scenario Manager


D) Two-variable Data Table

B) Solver

14. Where do scenario summary reports appear?




A) A new worksheet


B) A new workbook


C) The current worksheet


D) A pop up box

A) A new worksheet

15. A substitution value replaces the original input value of a variable in a data table.




A) True


B) False

A) True

16. Which of the following what-if analysis tools has the ability to limit values to whole numbers?




A) Goal Seek


B) Scenario Manager


C) Solver


D) One-variable data table

C) Solver

17. Substitutionvalues can be manually entered.




A) True


B) False


A) True

18. Two reference formulas are required to complete atwo-variable data table.




A) True


B) False


B) False

19. Which what-if analysis tool is best suited to calculate the impact of interest rate changes based on different economic climates?




A) Goal Seek


B) Scenario Manager


C) Solver


D) One-variable data table

B) Scenario Manager

20. Which of the following tools is best suited for comparing the effects of two variables on a formula?




A) Solver


B) Goal Seek


C) Two-variable data table


D) One-variable data table

C) Two-variable data table

1. =INDEX(#REF!,MATCH(MAX(#REF!),#REF!,0),1) is an example of a nested function.




A) True


B) False

A) True

2. PPMT should be used to calculate the specific interest paid on one installment of a loan.




A) True


B) False

B) False

3. When the DAVERAGE function returns #DIV/0:




A) there are no records that fit the criteria.


B) there is a typo in the function.


C) a second criteria is needed.


D) the incorrect function was used

A) there are no records that fit the criteria.

4. The criteria range of a database function must contain at least one column heading and one cell of information.




A) True


B) False

A) True

5. The first argument of the INDEX function is:




A) row_num.


B) array.


C) column_num.


D) match type.

B) array

6. When using Advanced Filtering empty cells in the criteria range will return which of the following?




A) All records


B) No records


C) Select records


D) NA

A) All records

7. Which database function will return the largest value from a dataset based on preset criteria?




A) DCOUNT


B) DSUM


C) DMIN


D) DMAX

D) DMAX

8. The IPMT function should be used to calculate the specific interest paid on one installment of a loan.




A) True


B) False

A) True

9. All database functions require a user defined:




A) set cell.


B) criteria range.


C) target range.


D) filter.

B) criteria range.

10. What is the second argument of the IF function?




A) Value_if_false


B) Value_if_true


C) logical_test


D) lookup_value

B) Value_if_true

11. The Analysis ToolPak appears in the Data tab.




A) True


B) False

A) True

12. The PERCENTRANK.INC function excludes 0 and 1.




A) True


B) False

B) False

13. When using an array of data with the FREQUENCY function, the following keystroke is required.




A) Ctrl+Alt+Delete


B) Ctrl+Shift+Delete


C) Ctrl+Shift+Enter


D) Ctrl+Enter

C) Ctrl+Shift+Enter

14. The SUMIF function could be used to add the total salaries of employees over the age of 25 in a dataset.




A) True


B) False

A) True

15. Which of the following functions will help determine the strength of a relationship between two variables?




A) VARPA


B) STDEV.P


C) CORREL


D) VAR.P

C) CORREL

16. When using text for criteria in conditional logic functions, the text must be surrounded by double quotation marks.



A) True


B) False

A) True

17. When using the CORREL function a value of 1 would indicate:



A) a weak relationship.


B) a mild relationship.


C) a strong relationship.


D) no relationship

C) a strong relationship.

18. When using the CORREL function, a value of .00007 would indicate:




A) a weak relationship.


B) a strong relationship.


C) an inverse relationship.


D) no relationship.

A) a weak relationship.

19. Which of the following functions is best suited to count numbers based on multiple conditions?



A) SUMIF


B) COUNTIF


C) COUNTIFS


D) SUMIFS

C) COUNTIFS

20. Which of the following functions is best suited to calculate the variance of a population including logical values and text?



A) VAR.P


B) VARA


C) VARPA


D) VAR.S

C) VARPA