Which of the following are the reasons that are causing the above problem?
You work as an Office Assistant for Tech Perfect Inc. You are working in a spreadsheet. You observe that while trying to look up or match a lookup_value within an array, Excel is not able to recognize the matching value. Which of the following are the reasons that are causing the above problem? Each correct […]
Which of the following steps will you take to accomplish the task?
You work as an Office Assistant for Tech Perfect Inc. You are working in the spreadsheet of the company’s high selling products. You want to find out the matching values in the columns. While doing so, you get an unexpected error that when you attempt to look up or match a lookup_value within an array; […]
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickl
You work as an Office Assistant for Blue Well Inc. The company has a Windows-based network. You want to quickly filter data in a PivotTable report without opening drop-down lists to find the items that you want to filter. For this purpose, you are required to use a slicer. Which of the following are the […]
Rick is creating a project through Microsoft Excel 2010. The project on which he is working has 98 project tas
Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. Rick is creating a project through Microsoft Excel 2010. The project on which he is working has 98 project tasks and 57 team members. Rick wants to check the progress of his project quickly and easily. Which of the […]
Rick wants to display data series, categories, data markers, and axes in the report. Which of the following ac
Rick works as an Office Assistant for Tech Perfect Inc. The company has a Windows-based network. Rick wants to display data series, categories, data markers, and axes in the report. Which of the following actions will Rick take to accomplish the task? A. He will use stand-alone slicers. B. He will create a PivotTable report. […]
What should you do?
Your company has 100 product subcategories and more than 10,000 products. You have a PivotChart that uses Manufacturer as the axis and the sum of SalesAmount as the values. You need to ensure that only the top 10 manufacturers appear in the chart. What should you do? A. Configure the Value Filters B. Summarize the […]
What should you do in the data model?
You have six workbook queries that each extracts a table from a Microsoft Azure SQL database. The tables are loaded to the data model, but the data is not loaded to any worksheets. The data model is shown in the Data Model exhibit. (Click the Exhibit button.) Exhibit: Your company has 100 product subcategories and […]
You need to create a hierarchy in Products that contains ProductCategoryName and ProductName.
There is a relationship between Products and ProductCategory. You need to create a hierarchy in Products that contains ProductCategoryName and ProductName. Solution: You create a measure that uses the ISCROSSFILTERED DAX function Does this meet the goal? A. Yes B. No
You need to create a hierarchy in Products that contains ProductCategoryName and ProductName.
There is a relationship between Products and ProductCategory. You need to create a hierarchy in Products that contains ProductCategoryName and ProductName. Solution: You create a calculated column that uses the RELATED DAX function Does this meet the goal? A. Yes B. No References: https://www.mssqltips.com/sqlservertip/2900/creating-hierarchies-in-powerpivot-for-excel/ https://msdn.microsoft.com/en-us/library/ee634202.aspx
You have a Power Pivot model that contains the following tables.
You have a Power Pivot model that contains the following tables. There is a relationship between Products and ProductCategory. You need to create a hierarchy in Products that contains ProductCategoryName and ProductName. Solution: You create a measure that uses the USERELATIONSHIP DAX function. Does this meet the goal? A. Yes B. No