Excel Module 2

What is the purpose of the "paste special" feature in MS Excel?

• To paste only the contents of a cell

• To paste special attributes of a cell

• To delete the contents of a cell

• To format a cell

What is the maximum number of copied items the Office Clipboard can hold from any Microsoft application?

• 10

• 24

• 50

• 100

Where is the Quick Access Toolbar located by default?

• Below the ribbon

• Above the ribbon

• On the left side of the screen

• On the right side of the screen

Which of the following commands is NOT included in the Quick Access Toolbar by default?

• AutoSave

• Save

• Print

• Undo

What can you do with the Quick Access Toolbar to suit your needs?

• Change its color

• Customize it

• Move it to the bottom of the screen

• Delete it

What does the Quick Access Toolbar button do?

• It opens a new document.

• It displays additional commands you can add to it.

• It saves the current document.

• It closes the application.

What does the "freeze panes" feature do in a worksheet?

• It changes the color of the worksheet.

• It freezes worksheet titles on screen.

• It deletes all data in the worksheet.

• It prints the worksheet.

What is the purpose of the "arrange all" feature?

• To delete all worksheets.

• To change the font of the text.

• To display more than one workbook or worksheet on screen at the same time.

• To save the worksheet automatically.

What is the purpose of the "split" feature in spreadsheets?

• To change the font size

• To split your screen into halves or quarters

• To add color to cells

• To delete rows