Skip to content Skip to navigation Skip to collection information

OpenStax-CNX

You are here: Home » Content » Engineering Computation with Spreadsheets » Data Input

Navigation

Recently Viewed

This feature requires Javascript to be enabled.
 

Data Input

Module by: Serhat Beyenir. E-mail the author

Summary: Data input methods for Excel.

Data Input

The data that we input into a spreadsheet can be numbers, text, dates, or times and we have several options for entering data in Excel.

Fill Series

  1. 1- Select the first cell in the range that you want to fill.
  2. 2- Type the starting value for the series.
  3. 3- Type a value in the next cell to establish a pattern.
  4. 4- Select the cell or cells that contain the starting values.
  5. 5- Drag the fill handle (the bottom right corner of the cell or range selected) across the range that you want to fill

Note:

To fill in increasing order, drag down or to the right or to fill in decreasing order, drag up or to the left.

Auto Fill

This feature creates a series that produces the same results as dragging the fill handle in "Fill Series" procedure and is useful when we want to enter months, days and dates in general.

Table 1: Auto Fill examples.
Initial selection Extended series (example)
1, 2, 3 4, 5, 6,...
1:00 2:00, 3:00, 4:00,...
Monday Tuesday, Wednesday, Thursday,...
Jan Feb, Mar, Apr,...

Auto Complete

When we enter data in a column, typing the first few letters in a cell will suggest the existing value. Using this technique will eliminate typing errors.

Pick From List

When we enter data in a column, right-clicking the first blank cell will trigger a shortcut menu list. Selecting "Pick from List" option lists existing values and we can choose one of the values. By using this technique we can eliminate typing errors.

Collection Navigation

Content actions

Download:

Collection as:

PDF | EPUB (?)

What is an EPUB file?

EPUB is an electronic book format that can be read on a variety of mobile devices.

Downloading to a reading device

For detailed instructions on how to download this content's EPUB to your specific device, click the "(?)" link.

| More downloads ...

Module as:

PDF | More downloads ...

Add:

Collection to:

My Favorites (?)

'My Favorites' is a special kind of lens which you can use to bookmark modules and collections. 'My Favorites' can only be seen by you, and collections saved in 'My Favorites' can remember the last module you were on. You need an account to use 'My Favorites'.

| A lens I own (?)

Definition of a lens

Lenses

A lens is a custom view of the content in the repository. You can think of it as a fancy kind of list that will let you see content through the eyes of organizations and people you trust.

What is in a lens?

Lens makers point to materials (modules and collections), creating a guide that includes their own comments and descriptive tags about the content.

Who can create a lens?

Any individual member, a community, or a respected organization.

What are tags? tag icon

Tags are descriptors added by lens makers to help label content, attaching a vocabulary that is meaningful in the context of the lens.

| External bookmarks

Module to:

My Favorites (?)

'My Favorites' is a special kind of lens which you can use to bookmark modules and collections. 'My Favorites' can only be seen by you, and collections saved in 'My Favorites' can remember the last module you were on. You need an account to use 'My Favorites'.

| A lens I own (?)

Definition of a lens

Lenses

A lens is a custom view of the content in the repository. You can think of it as a fancy kind of list that will let you see content through the eyes of organizations and people you trust.

What is in a lens?

Lens makers point to materials (modules and collections), creating a guide that includes their own comments and descriptive tags about the content.

Who can create a lens?

Any individual member, a community, or a respected organization.

What are tags? tag icon

Tags are descriptors added by lens makers to help label content, attaching a vocabulary that is meaningful in the context of the lens.

| External bookmarks