Page 71 - PlusGPT_V2.1_C7_Flipbook
P. 71
DATA TYPES IN EXCEL 2016
Excel supports various data types, including:
1. Text/String: Alphanumeric characters.
2. Number: Numeric values for calculations.
3. Date/Time: Dates and times for scheduling and tracking.
4. Boolean: True or False values for logical operations.
5. Error: Indicates a problem with a formula or operation.
6. Array: A range of cells or values.
Each data type has its own formatting and functions for manipulation and analysis within Excel.
Labels: A label is an important entry in Excel. The label is used to define the information on the
spreadsheet, i.e. heading of columns, titles and names. It is any text besides phone numbers, numbers,
formulas, etc. Labels are aligned on the left side of a cell.
Formula: A formula is a mathematical expression used to do simple and complex calculations of the
numeric data inserted in a cell or a range of cells. A formula always begins with an equal to (=) sign
e.g. = A2 + B2.
EDITING IN EXCEL 2016
In the previous chapter, we have learned about different components of Excel 2016 window such as
cell, row, column, formula bar, workbook and worksheet. We have also learnt the process of creating
a workbook, entering data into a worksheet and saving a workbook. In this chapter, we will learn more
about Excel 2016.
Introduction to Excel 2016 69

