You can open the consolidate dialog box byt choosing consolidate from the…….menu.

Related MCQs

• What is the short cut key to open the Open dialog box?
• What is the short cut key to open Font dialog box?
• Which of the following format you can decide to apply or not in AutoFormat dialog box?
• Special category of Number tab in Format cells dialog box can be used to apply formats like :
• Which of the following is not an option of the spelling dialog box?
• To get the ‘Symbol’ dialog box, click on the ………… menu and choose ‘Symbol’.
• This dialog box specifies or modifies the worksheet cell range containing data to be charted………….
• To get to the ‘Symbol’ dialog box, click on the……….menu and choose ‘Symbol’.
• ……….is the key to close a selected drop- down list; cancel a command and close a dialog box.
• If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?