II-DataEntryAndEdit

II-DataEntryAndEdit - Data Entry and Edit 1 II. Data Entry...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Data Entry and Edit 1 II. Data Entry & Edit Determining the Enter key order of movement One user-configurable option in Excel is where the next current cell will be located after you hit the enter key. The default after you hit the enter key is for Excel to move down one cell, but you can instead choose to have Excel move one cell up, one cell right, or one cell left instead. Set this option by selecting Tools, Options, Edit and choosing from the drop-down list in “Move selection after Enter, Direction”. Data Entry and Edit 2 The Formula bar Excel’s Formula bar is located directly above the worksheet document window. It does three things: 1. At right, displays the contents of the current cell. For a cell holding a formula, it shows the formula, not the evaluated value the worksheet itself displays. In the example below, Cell D3. 2. At left in the “name box”, displays the cell reference or name of the current cell or range. In the example Cell D3 is named TotalSales. 3. At the time you’re entering a formula displays a red X mark and a green check mark to help you conveniently confirm or cancel the operation. Even if you have several worksheets visible in the Excel workspace at one time, there’s only one Formula bar. It applies to whichever worksheet has the focus. 1 1 You can tell which worksheet has the focus because its title bar is emphasized. Move the focus from one sheet to another by clicking anywhere within the sheet you want to move focus to. Data Entry and Edit 3 Formats and when to apply them The “Format Cells” tabbed dialog includes all Excel’s formatting options. OpenThe “Format Cells” tabbed dialog includes all Excel’s formatting options....
View Full Document

This note was uploaded on 12/20/2011 for the course BUS 101 taught by Professor Ecklund during the Spring '01 term at Duke.

Page1 / 10

II-DataEntryAndEdit - Data Entry and Edit 1 II. Data Entry...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online