menu
Sign up

To Find Anyone Whose Camp Is Either Day Camp,or Overnight

Question 59
Multiple Choice

To find anyone whose Camp is either Day Camp,or Overnight Camp,or Nature Camp,what should he do?  A) Create a text filter using the Contains operator to display all records that have Nature anywhere in the text value.  B) Create a text filter using the Ends With operator to display all records that have Day as the last characters in the text value.  C) Create a text filter using the Begins With operator to display all records that have Overnight as the first characters in the text value.  D) Create a text filter using the Contains operator to display all records that have Camp anywhere in the text value.

Related questions
Q 60
Ted wants to be able to analyze date data in his PivotTable by month.What must he do with the date field in his PivotTable?  A) He must aggregate the data by the date field.  B) He must cluster the data by the date field.  C) He must sort the data by the date field.  D) He must group the data by the date field.
Q 61
If Ted decides that he wants to work with nonnumeric data in his PivotTable,what function must he use to produce summaries?  A) Sum B) Aggregate  C) Total D) Count
Q 62
Ted wants to be able to use his PivotTable to combine items into groups.Which of the following is true?  A) Items that appear as row labels cannot be grouped.  B) Items that appear as column labels can be grouped.  C) If items are dates, they cannot be grouped automatically using the Grouping dialog box.  D) If items are numbers, they cannot be grouped manually using the Ctrl key to select items in a group and then choosing Group from the shortcut menu.
logo
© 2020-2021 Cozyplus FZ LLC. All rights reserved