Question

Discuss some of the ways that data can be entered into a new Excel workbook. Next explain various ways to customize the appearance of your completed workbook to present the data more professionally.

Answer 1

At First, we should know what is A Workbook?

A workbook is an Excel file that contains one or more worksheets. Each of the workbook's worksheets is in separate tabs on the bottom of the Excel window. By default, a new Excel workbook will contain three worksheets. You can switch between worksheets by clicking on the worksheet's tab on the bottom of the Excel window. In Excel 2010 the number of worksheets in workbooks is limited only by your computer's available memory.

Now coming to the ways using that data can be entered into a Workbook, There is more than one way to enter data into an Excel workbook. Sometimes we stick to typing directly into cells, but there are different ways to enter data which can speed up your work.

1. Type directly into a cell and add your data. You know a cell is active as it is highlighted with a darker border.
2. Use the formula bar. This is located under the ribbon. Type your data directly into the formula bar and press enter. You can navigate around the worksheet by typing the cell number directly into the Name box.
3. Make the most of auto complete. Excel will try to help you speed up your data entry by guessing what you are typing based on what’s in your worksheet. If the autocorrect option is right for you, just press enter. Auto complete is guessing when you type something repeatedly you will just type something matching and press enter and the same full name will be entered there.
4. Copy and paste – you may have cells that you can copy and paste data within the same worksheet – it can save you time formatting a sheet, or you can copy data to another worksheet within the workbook.
5. Let Auto fill do the work. Auto fill options can complete series of data, whether it is text or numbers. This saves lots of data entry when setting up worksheets, or entering data.

Excel workbooks can hold and process lots of data, but when you manage numerous workbooks, it can be hard to remember from a workbook’s title exactly what data is kept in that workbook. Data labels gives information about data in a worksheet, but it’s important to format the labels so that they stand out visually. To make your data labels or any other data stand out, you can change the format of the cells that hold your data. Some ways to customize the appearance of a completed workbook to present the data more professionally could be summarised as follows:

• Format cells
• Define styles
• Apply workbook themes and Excel table styles
• Make numbers easier to read
• Change the appearance of data based on its value
• Change Colour and appearance of Workbook.
• Add Special Page Layout Effect.
• Add Charts, Inserts Clip Art, Column, Pie, Diagrams, Header-footer, etc to show the work more professionally.