MIS 3302 Excel Training Exam

You resurrected an old worksheet. It appears to contain most of the information that you need, but not all of it. Which step should you take next?

Check for data you have previously hidden.

Which two keys are commonly used to move or insert data?

Ctrl and Shift

Which shortcuts can you use for Undo and Redo?

Ctrl+Z for Undo and Ctrl+Y for Redo

Which shortcut can you use to rename a worksheet?

Double-click the sheet tab, and then type the new name.

While it might be considered "old-school," which action should you take if you are unsure how a page will print, even after looking at Page Break Preview?

Print the first page.

You have data for Regions, Products, and Customers. Which option on a Pivot Table will you find in the Fields list?

Regions

What is a good rule-of-thumb for using color backgrounds in a worksheet?

Use a light-color fill.

What is the best practice for entering dates and times in Excel?

Use slashes for dates and colons for time.

You created a formula in cell C8. When you copy the formula into cell D8, which action are you taking?

You are changing the content in the formula to the content in cell D8.

Why would you set up a workbook to be shared if you are the only one using the workbook?

You can track changes

Although it is not a term Excel uses, how do most people think of Excel?

as a spreadsheet

Where can you access the format cell's Dialog Box launcher?

from the arrow to the right on Font on the ribbon

Which type of chart is preferable when you are dealing with a timeframe?

line chart

To freeze rows 1 and 2, and columns 1, 2, and 3, which cell should you highlight before selecting Freeze Panes?

row 3, column 4