1. When you track changes, what option can you select?

Select an answer:

• List changes in a PivotTable.
• List changes on a new sheet.
• List changes in a new workbook.
• List changes on the sheet where changes have occurred.

1. Filtering offers specific options for all of these data types EXCEPT:

Select an answer:

• Functions
• Numbers
• Dates
• Text

1. After deleting worksheet(s), how many worksheets can you "undelete" using the Undo command?

Select an answer:

• none
• 2
• 1
• unlimited

1. How many scroll bars will appear on the screen if you split the screen both horizontally and vertically?

Select an answer:

• 2
• variable
• 3
• 4

1. After clicking on a chart, how can you create a copy of it?

Select an answer:

• Ctrl + D
• Ctrl + X
• Double-click the chart
• Ctrl + V

6.What does the solid blue line indicate in Page Break Preview mode?

Select an answer:

• the boundary between data that that will and won't print
• the orientation of the page
• the total volume of data in the spreadsheet
• the maximum file size of the dataset

7.To locate and/or replace data, go to this command on the Home tab:

Select an answer:

• Locate & Substitute
• Find & Select
• Find & Replace
• Search & Retrieve

8.What is the keyboard shortcut to call up the Format Cells dialog box?

Select an answer:

• Shift + 1
• Ctrl + F
• Ctrl + 1
• F1 key