Contents contributed and discussions participated by fictionalworlds - Learning Library

shared by fictionalworlds on 15 Jul 13 - Cached

Workbooks are a collection of worksheets.
...

Cancel
Worksheets allow users to enter, calculate, manipulate, and analyze data such as numbers and text. The terms worksheet and spreadsheet are interchangeable.
...

Cancel
Tables Tables organize and store data within worksheets.
...

Cancel
...4 more annotations...
an Excel table can sort the data, search for specific data, and select data that satisfies defined criteria.
...

Cancel
Web Support Web support allows users to save Excel worksheets or parts of a worksheet in HTML format, so a user can view and manipulate the worksheet using a browser.
...

Cancel
Excel Web support also provides access to real-time data,
...

Cancel
using Web queries.
...

Cancel

shared by fictionalworlds on 15 Jul 13 - Cached

A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for the worksheet, such as charting and Web support.
...

Cancel
The recommended methodology for creating worksheets includes: (1) analyze requirements (supplied in a requirements document); (2) design solution; (3) validate design; (4) implement design; (5) test solution; and (6) document solution.
...

Cancel

shared by fictionalworlds on 15 Jul 13 - Cached

Select titles and subtitles for the worksheet.
...

Cancel
The less text in the titles and subtitles, the more impact the titles and subtitles will have.
...

Cancel
Use the fewest words possible to specify the information presented in the worksheet to the intended audience.
...

Cancel
...11 more annotations...
Determine the contents for rows and columns.
...

Cancel
Rows typically contain information that is analogous to items in a list
...

Cancel
Columns typically contain descriptive information about items in rows or contain information that helps to group the data in the worksheet
...

Cancel
Determine the calculations that are needed.
...

Cancel
Determine where to save the workbook.
...

Cancel
Identify how to format various elements of the worksheet.
...

Cancel
Examples of how you can modify the appearance, or format, of text include changing its shape, size, color, and position on the worksheet.
...

Cancel
Decide on the type of chart needed.
...

Cancel
Each chart type relays a different message about the data in the worksheet. Choose a chart type that relays the message that you want to convey.
...

Cancel
Establish where to position and how to format the chart.
...

Cancel
The position and format of the chart should command the attention of the intended audience. If possible, position the chart so that it prints with the worksheet data on a single page.
...

Cancel

shared by fictionalworlds on 15 Jul 13 - Cached

After carefully reviewing the requirements document
...

Cancel
the next step is to design a solution or draw a sketch of the worksheet based on the requirements, including titles, column and row headings, location of data values, and
...

Cancel
chart
...

Cancel
...1 more annotation...
With a good understanding of the requirements document, an understanding of the necessary decisions, and a sketch of the worksheet, the next step is to use Excel to create the worksheet and chart.
...

Cancel

shared by fictionalworlds on 15 Jul 13 - Cached

The workbook
...

Cancel
is like a notebook. Inside the workbook are sheets, each of which is called a worksheet. Excel opens a new workbook with three worksheets.
...

Cancel
If necessary, you can add additional worksheets as long as your computer has enough memory to accommodate them.
...

Cancel
...1 more annotation...
Each worksheet has a sheet name that appears on a sheet tab at the bottom of the workbook.
...

Cancel

shared by fictionalworlds on 15 Jul 13 - Cached

A column letter above the grid, also called the column heading, identifies each column. A row number on the left side of the grid, also called the row heading, identifies each row.
...

Cancel
The intersection of each column and row is a cell. A cell is the basic unit of a worksheet into which you enter data
...

Cancel
A cell is referred to by its unique address, or cell reference, which is the coordinates of the intersection of a column and a row.
...

Cancel
...4 more annotations...
To identify a cell, specify the column letter first, followed by the row number.
...

Cancel
One cell on the worksheet, designated the active cell, is the one into which you can enter data.
...

Cancel
The active cell is identified in three ways. First, a heavy border surrounds the cell; second, the active cell reference shows immediately above column A in the Name box; and third, the column heading A and row heading 1 are highlighted so it is easy to see which cell is active
...

Cancel
The horizontal and vertical lines on the worksheet itself are called gridlines. Gridlines make it easier to see and identify each cell in the worksheet.
...

Cancel

shared by fictionalworlds on 15 Jul 13 - Cached

You view the portion of the worksheet displayed on the screen through a worksheet window
...

Cancel
The default (preset) view is normal view.
...

Cancel
Below and to the right of the worksheet window are scroll bars, scroll arrows, and scroll boxes that you can use to move the worksheet window around to view different parts of the active worksheet
...

Cancel
...1 more annotation...
To the right of the sheet tabs at the bottom of the screen is the tab split box. You can drag the tab split box to increase or decrease the view of the sheet tabs
...

Cancel

shared by fictionalworlds on 15 Jul 13 - Cached

The status bar presents information about the worksheet, the function of the button the mouse pointer is pointing to, or the mode of Excel.
...

Cancel
Mode indicators, such as Enter and Ready, appear on the status bar and specify the current mode of Excel. When the mode is Ready, Excel is ready to accept the next command or data entry. When the mode indicator reads Enter, Excel is in the process of accepting data through the keyboard into the active cell.
...

Cancel
Keyboard indicators, such as Scroll Lock, show which toggle keys are engaged. Keyboard indicators appear to the right of the mode indicator. Toward the right edge of the status bar are buttons and controls you can use to change the view of a document and adjust the size of the displayed document.
...

Cancel