Data types and working with multiple worksheets

Data types and working with multiple worksheets

Data Types

  • Data type means the type of data which can be stored in an Excel Cell
  • There are three basic data types in Excel

    • Numeric data
    • Text data
    • Date and Time data (internally stored as numbers)

  • Excel constantly monitors the data you type in Excel Cell and classifies it into above data types.
  • Another type which is not shown in the above list is Excel formula.
  • Excel formulas are not constant data, but used to calculate results from constant data available in different Cells of Excel worksheets.

  • You could select the data type by using the drop down menu in the home tab


Numerical data

  • Numeric data type in Excel is used to store different quantities, which can be later used for mathematical operations using Excel formulas.
  • In Excel (as of 2019), you can store numeric values in an Excel Cell, up to a precision of 15 digits.

  • Try using the currency format
  • How does this change the display?
  • What other options are there that could be helpful?

  • Try using the percentage format
  • How does this change the display?


Date and time data

  • You can format dates and times as you type.
  • For example, if you type 2/2 in a cell, Excel automatically interprets this as a date and displays 2-Feb in the cell.
  • If this isn’t what you want—for example, if you would rather show February 2, 2009 or 2/2/09 in the cell—you can choose a different date format in the Format Cells dialog box
  • Similarly, if you type 9:30 a or 9:30 p in a cell, Excel will interpret this as a time and display 9:30 AM or 9:30 PM.
  • You can customize the way the time appears in the Format Cells dialog box.

  • On the Home tab, in the Number group, click the Dialog Box Launcher next to Number.
  • In the Category list, click Date or Time.
  • In the Type list, click the date or time format that you want to use.


Text data

  • Text data consists of a combination of alphabet characters, numeric characters or special characters.
  • Text data is also called as string data.
  • Text data is aligned to the left-side of the Cell and numeric data is aligned to the right-side of the Cell.
  • Even if an Excel Cell contains numeric characters along with alphabet characters, Excel treats that data as text.

  • The text data inside that Cell cannot be used for any mathematical formulas.
  • If you try to perform any mathematical operation with text data in an Excel Cell, you may get #VALUE! error as the result.
  • If the text data in an Excel Cell is wider than the Cell width, the text data will spill-over the right-side Cells, if the right-side Cells are empty.
  • If any right-side empty Cell is filled later, Excel hide the spilled text before newly filled Cell to reveal its data.


Multiple worksheets

  • Every workbook contains at least one worksheet by default.
  • When working with a large amount of data, you can create multiple worksheets to help organize your workbook and make it easier to find content.
  • You can also group worksheets to quickly add information to multiple worksheets at the same time.

  • Inserting a new worksheet

  • Copying a worksheet
  • Right-click the worksheet you want to copy, then select Move or Copy from the worksheet menu.

  • The Move or Copy dialog box will appear.
  • Choose where the sheet will appear in the Before sheet: field.
  • Check the box next to Create a copy, then click OK.

  • Renaming a worksheet
  • Right-click the worksheet you want to rename, then select Rename from the worksheet menu.

  • Moving a worksheet

  • Changing the tab color

  • Deleting worksheets


Try it out!

  • What are some scenarios that would need multiple worksheets?
  • Try creating multiple worksheets in this scenario with fake data
  • Organize the sheets with ease of navigation/presentation in mind