Conditional formatting impacts the appearance of a cell even if the set criteria are not met. True False Which statement is correct regarding the FIFO method? It uses an average costs to determine the cost of goods sold It assumes ending inventory is made up of the largest goods to arrive in the warehouse It assumes ending inventory is made up of the earliest goods to arrive in the warehouse It assumes cost of goods sold is made up of the largest goods to arrive in the warehouse Under the weighted average method, ending inventory is determined by multiplying the weighted average cost by Total units in ending inventory plus total units sold during the period Total units sold during the period Total units in the warehouse during the period Total units in ending inventory Which statement is incorrect regarding PivotTables? They cannot be modified after initial creation They allow for the subtotaling of data groups They allow for the examination o data in multiple ways They can be filtered using multiple methods Which of these is not displayed in a slicer? Clear filter button Multi select button Filtering choices for a single field Pivot chart options Which statement is incorrect regarding PivotCharts? When you change a pivot chart, the associated pivot table updated automatically Pivot charts can be created only after a pivot table has been established A pivot chart can be filtered using the auto filter buttons on the associated pivotable Pixotsharts can display a legend beside the charted data Conditional formatting impacts the appearance of a cell even if the set criteria are not met. True False Which statement is correct regarding the FIFO method? It uses an average costs to determine the cost of goods sold It assumes ending inventory is made up of the largest goods to arrive in the warehouse It assumes ending inventory is made up of the earliest goods to arrive in the warehouse It assumes cost of goods sold is made up of the largest goods to arrive in the warehouse Under the weighted average method, ending inventory is determined by multiplying the weighted average cost by Total units in ending inventory plus total units sold during the period Total units sold during the period Total units in the warehouse during the period Total units in ending inventory Which statement is incorrect regarding PivotTables? They cannot be modified after initial creation They allow for the subtotaling of data groups They allow for the examination o data in multiple ways They can be filtered using multiple methods Which of these is not displayed in a slicer? Clear filter button Multi select button Filtering choices for a single field Pivot chart options Which statement is incorrect regarding PivotCharts? When you change a pivot chart, the associated pivot table updated automatically Pivot charts can be created only after a pivot table has been established A pivot chart can be filtered using the auto filter buttons on the associated pivotable Pixotsharts can display a legend beside the charted data
