a. List the different types of data can be entered in Excel sheet ?
b. Explain the process of steps in implementing autosum to enter data automatically.
c. What are the three ways for savcing a Workbook?
Differentiate between a Workbook and a Worksheet?
Answers
Answer:
a)Data – values, usually numbers but can be letters or a combination of both.
Labels – headings and descriptions to make the spreadsheet easier to understand.
Formulas – calculations that update automatically if referenced data changes.
b)Select a cell next to the numbers you want to sum: To sum a column, select the cell immediately below the last value in the column. ...
Click the AutoSum button on either the Home or Formulas tab. ...
Press the Enter key to complete the formula.
c)Click File > Save As.
Under Save As, pick the place where you want to save your workbook. ...
Click Browse to find the location you want in your Documents folder. ...
In the File name box, enter a name for a new workbook. ...
To save your workbook in a different file format (like . ...
Click Save.
Workbook is an excel file containing many worksheets. A worksheet has a single spreadsheet containing data. 2. Workbook cannot be added within the worksheet.