Discuss how to correct errors after entering data into a cell using in-cell editing.

What will be an ideal response?


If the entry is short, select the cell, retype the entry correctly, and then click the Enter button or press the RETURN key. The new entry will replace the old entry.

If the entry in the cell is long and the errors are minor, using Edit mode may be a better choice than retyping the cell entry. Double-click the cell containing the error to switch Excel to Edit mode. In Edit mode, Excel displays the active cell entry in the formula bar and a flashing insertion point in the active cell.

With Excel in Edit mode, you can edit the contents directly in the cell - a procedure called in-cell editing. Make changes using in-cell editing, as indicated below.
(1) To insert new characters between two characters, place the insertion point between the two characters and begin typing. Excel inserts the new characters at the location of the insertion point.
(2) To delete a character in the cell, move the insertion point to the left of the character you want to delete and then press the FN-DELETE key or place the insertion point to the right of the character you want to delete and then press the DELETE key. You also can use the mouse to drag through the character or adjacent characters you want to delete and then press the DELETE key or click the Cut button in the Standard toolbar.
(3) When you are finished editing an entry, click the Enter button or press the RETURN key.

Computer Science & Information Technology

You might also like to view...

Answer the following questions true (T) or false (F)

1. Loop counter variables are usually of type double. 2. The body of a for statement might not be executed at all. 3. Tables are always displayed using counter-controlled while loops.

Computer Science & Information Technology

Which statement about free vs. paid apps is false?

a) Paid apps represent the vast majority of mobile apps. b) Paid WP8 apps range in price from $1.49 (which is higher than the $0.99 starting price for apps in Google Play and Appleā€™s App Store) to $999.99. c) The average price for mobile apps is generally between $1.50 and $3, depending on the platform. d) For Windows Phone apps, Microsoft retains 30% of the purchase price and distributes 70% to the app authors.

Computer Science & Information Technology

This is a set of communication protocols that are used to enable two electronic devices to communicate. A typical device is a smartphone.

What will be an ideal response?

Computer Science & Information Technology

When you select a specific paint color at a paint store, a recipe that contains the ____________________ values is used to create the color.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology