8159136973V/cfi/128!/4/4@0.00:17.4 True False True False True False True False True False True False 1. A function is a prewritten formula built into Excel. 2. The AutoSum button can be used only to create formulas with SUM. 3. CONCATENATE is used to divide a single cell entry across multiple cells. 4. Flash fill provides suggestions for cell entries based on previously entered data. 5. The weighted average inventory method results in inventory costs that fall between those arrived at through the use of LIFO and FIFO. 6. Conditional formatting should be used carefully, as it cannot be removed once applied. 7. A PivotTable is a summary of worksheet data that can be arranged in a variety of ways. 8. Data used to create a PivotTable must be contained within a table. 9. The only way to filter PivotTable data is via a slicer. 10. When a PivotChart is updated, the associated PivotTable is also automatically updated. 11. Although each of these functions can be accessed via the AutoSum menu (under More Functions), which one is NOT listed on the AutoSum menu itself? Average Left Max Min True False True False True False True False