Question: what are some of the functions in the consolidate dialog box?
Answer: In Excel, you can consolidate data in one workbook using the Consolidate feature. In the Consolidate dialog box, you can select the cells you want to consolidate; or, if you named the ranges, you can enter the range names. You can choose various functions, such as Sum, Average, or Count, just to name a few.