1. Home

- Online Exam Test Papers | - MCQs[multiple choice questions and answers ] | - Mock Test Papers | - Practice Papers | - Sample Test Papers |

Question:
Pivot Table report data must meet which of the following criteria?

1.It must be in tabular form, have unique column labels, and each row must represent a unique piece of data

2. Any dates should be formatted with the data format and blank rows or columns should be removed

3. It must be in tabular form, have unique column lagels, and all rows must be sorted

4.Both (A) and (B)

Posted Date:-2022-06-28 13:46:48

More MCQS Questions and answers

  1. In access, the best types of queries to use for data analysis are:
  2. How do you filter by selection?
  3. In a relational schema, each tuple is dividedinto fields called
  4. What does the Special Effect button on the formatting toolbar do?
  5. What is the corresponding text for the <#1/1/ 95# validation rule setting?
  6. Which of the following is NOT a type of Microsoft Access database object?
  7. . What are the columns in a Microsoft Access table called?
  8. A command that lets you cange one or morefields in a record is
  9. A logical schema
  10. A subset of characters within a data field is known as
  11. A top to bottom relationship among the items in a database is established by a
  12. Customers, Orders. What’s their best relationship?
  13. If a piece of data is stored in two places in the database, then a
  14. Pivot Table report data must meet which of the following criteria?
  15. The complete picture of data stored in database is known as
  16. The executive responsible for the data processing function in an organization is
  17. The number of logical records in a physical record is
  18. What is a fast way to adjust the width of a column?
  19. What is the name of the Visual Basic Editor utility that allows you to view the Microsoft Access type library’s available objects and members?
  20. What is the purpose of the page field on a pivot table report?
  21. Which control does access use to link data access page components to access data?
  22. Which of the following is a database management system?
  23. Which of the following is not a data type ?
Search