Chapter 5: Exam - Exploring Microsoft Office Excel 2013

As you begin building your workbook, one of the most important skills to master is typing and manipulating data within a worksheet. In this chapter, we will explore the various ways to type and move data in Excel 2013.

To start, let's manually enter some data into our worksheet using the RIGHT ARROW key. Begin by typing 'Unit Sales' and pressing the RIGHT ARROW key. This will enter the word into cell A2 and activate the next cell to the right. You can follow this process to type in the column headings for Row 2.

The skills covered in this section are essential for building a comprehensive workbook, particularly during the early stages of development. In this chapter, you will learn how to move data around your worksheet with ease, delete columns and rows as needed, insert new ones, hide them if necessary, adjust column widths and row heights, and even use the Undo command to correct any mistakes.

One of the most useful features in Excel 2013 is Auto Fill. When entering data, you can use this feature to automatically fill in a series of cells with identical information. For example, if you enter 'Unit Sales' into cell A2 and then click on cell B2, Excel will automatically fill in the same text into cell C2. This saves time and reduces errors.

Another important skill is editing data within your worksheet. You can edit individual cells by simply clicking on them and making changes directly. You can also use the Undo command to correct any mistakes you may make while editing.

Finally, it's essential to understand how to enter data into a worksheet correctly. By following these simple steps, you will be able to create a well-organized and efficient workbook that is easy to navigate and understand.

In this chapter, we have covered the basics of typing and manipulating data in Excel 2013. With these skills under your belt, you are now ready to move on to more advanced topics in future chapters.

Chapter 5 exam exploring microsoft office excel 2013