FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -Spreadsheet specialists usually format a worksheet before they enter any data. Spreadsheet specialists often assign names to a cell or range of cells so that they can select them quickly. An alternative to a one-input data table is a three-input data table.

Detailed explanation-2: -The data that you enter can be numbers, text, dates, or times. You can format the data in a variety of ways. And, there are several settings that you can adjust to make data entry easier for you. This topic does not explain how to use a data form to enter data in worksheet.

Detailed explanation-3: -A workbook contains one or more worksheets. A worksheet (also known as a spreadsheet) consists of cells in which you can enter and calculate data. The cells are organized into columns and rows. A worksheet is always stored in a workbook.

Detailed explanation-4: -You should create worksheets as if you are going to use them only once. A cell name often is created from column and row titles. You cannot use column and row titles within formulas when you want to refer to the related data by name. Assigning names to a cell or range of cells allows you to select them quickly.