Documents

BasicsPractice.xls

Categories
Published
of 26
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Related Documents
Share
Description
This file provides hands-on exercises to accompany the document named A Review of Excel Basics . Naming Ranges Exercise 1 Name a Range (method 1) Exercise 2 Name a Range (method 2) Exercise 3 Name a Range (method 3) Exercise 4 Display Range Names Exercise 5 Add a Cell Comment Formatting Exercise 6 Merge and Center Exercise 7 Apply Formatting Exercise 8 Apply Borders Exercise 9 Create a Text Box Exercise 10 Use the Format Painter Basic Editing Exercise 11 Edit Fill Exerc
Transcript
  This file provides hands-on exercises to accompany the document named A Review of Excel Naming Ranges Exercise 1 Name a Range (method 1)Exercise 2  Name a Range (method 2) Exercise 3 Name a Range (method 3)Exercise 4  Display Range Names Exercise 5 Add a Cell Comment Formatting Exercise 6  Merge and Center Exercise 7  Apply Formatting Exercise 8  Apply Borders Exercise 9  Create a Text Box Exercise 10  Use the Format Painter Basic Editing Exercise 11  Edit Fill Exercise 12  Use Excel Custom Lists Exercise 13  Copy and Paste a Formula Exercise 14  Convert Formulas to Values Exercise 15  Transpose Data Formulas Exercise 16  Relative References Exercise 17  Absolute References Exercise 18  Use Built-in Functions Exercise 19  Using Logical Functions Exercise 20  Using Formula Auditing Tools Data Tables Exercise 21  The One-Input Data Table Exercise 22  The Two-Input Data Table Charting Exercise 23  Generate a Quick Chart Exercise 24  Use the Chart Wizard Exercise 25  Create an XY Chart Excel Basics Practice Paula Ecklund v  2007-8   Basics .  Practice: Naming Ranges Exercise 1-Name a range January30February45March22 April18May10June58 Exercise 2-Name a range January Data354466 Exercise 3-Name a rangeExercise 4-Display range names 1. Select range B6:C11. 2. From Excel's tabs choose Formulas, Create from Selection . 3. In the Create Names dialog, click Left column and then 1. Select range B20:B22. 2. From Excel's tabs choose Formulas, Define Name . 3. In the Define Name dialog, supply a name for the selected range or if Excel has provided a name accept its suggestion. 4. Click OK . 1. Select range B37:C39. 2. Click in the Name Box at the left of Excel's formula bar. 3. In the Name Box type the text Aqua_Range and hit the enter key. 1. Display the range names you've assigned by clicking the drop-down arrow in the Name Box . Range name text typed into the N at the left of Excel's formula Return to Contents  Exercise 5-Add a cell comment 100% . ocumen n e worsee e range names you've assigned by clicking a cell in a blank area of the worksheet and choosing the commands Insert, Name, Paste, Paste List  .  An example of paste listed range 1. Hover the mouse pointer over the red triangle in the cell above to see the associated comment. 2. Enter a value in an empty cell*. With that cell selected, choose Insert, Comment   from Excel's menus. -Or- right click the cell and choose Insert Comment   from the pop-up menu that displays. 3. Enter your comment in the text box provided. * You can also add a comment to an empty cell.
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks