USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Kenneth would like to analyze large amounts of data in many differentways. Which report could Kenneth use to summarize data by categoriesand subcategories, expand and collapse levels of data to drill down andfilter results, or move rows to columns or columns to rows to examinedifferent summaries of the data?
|
|
PivotTable
|
|
|
PowerChart
|
|
|
Query
|
|
|
Slicer
|
Explanation:
Detailed explanation-1: -Arranging data in a specific order is called Sorting.
Detailed explanation-2: -Which of the following is a benefit that the Power Pivot data model gives Excel users over standard PivotTables? We can define relationships between data tables.
Detailed explanation-3: -The statement that best describes the GETPIVOTDATA function is that it: extracts data stored in a PivotTable.
Detailed explanation-4: -Answer: The statement:-A table is a set of data arranged in rows and columns is TRUE. Explanation: Table : A table in a computer system can be defined as the arrangement of data in rows and columns and maybe in more complex forms or structures.
There is 1 question to complete.