Datasheet

Chapter 1



Navigating in Excel and Understanding the Interface

Exam Essentials

Know the terminology. Get familiar with the terms used in Excel so the MOS scenarios

make sense to you. Remember to use tooltips to identify the names of everything onscreen.

Learn the quickest way to do everything. Try all the methods for moving around the work-

sheets and find the ones that work best for you. Get familiar with where everything is located.

The MOS Exam is a timed exam, so know how to use the shortcuts like Go To and Find.

Be sure you understand the difference between deleting content and deleting cells. Under-

stand how to delete content, as well as cells, rows, columns, ranges, and sheets. Also, know

how to insert rows, columns, and cut cells.

Be able to move and copy data, cells, ranges, and sheets. Know the difference between

move (cut and paste) and copy (copy and paste), and understand all the ways to select contig-

uous and noncontiguous data and use the Office Clipboard.

Understand the cell modes and mouse pointers. Be aware of what mode (Ready, Enter, and

Edit) you are in when working in cells, and be sure you know which mouse pointer does what.

Be able to modify row and column formats. Know how to resize rows and columns, using

both the mouse pointer and the Format menu.

Know how use the Save As dialog box. Understand how to create folders in the correct

locations, how to save files into the correct folders, and how to choose the correct file type.

Sample MOS Scenarios

The following scenarios simulate the types of exercises you will encounter while taking your

MOS Exam. Complete these scenarios, which focus on the MOS objectives covered in this

chapter; then check the solutions to see how you did. To complete these exercises, you will

need to extract the file MOS Scenarios Ch 1.xls from the zipped file for this chapter. Open the

file in Excel before you begin the scenario exercises.

MOS Scenario 1: Enter and Edit Cell Content and Manage Columns and Rows

Change the store names in column A, beginning with A4, to Bayberry Shops; Wilson Appli-

ances; The French Corner; Riley & Sons, Inc.; Madison Avenue; The O’Leary Bros.; and Rose-

wood Plaza. Change the dollar amounts for the Madison Avenue row so that they are all

exactly 100 dollars higher. Add a row above The O’Leary Bros. row and enter the shop name

Smithfield Clothiers, with sales for each week that are the same as the sales for Wilson Appli-

ances. Adjust all columns so they fit the longest data in the column.

4002book.fm Page 42 Friday, March 24, 2006 11:36 PM