_____________ is the spreadsheet program that organizes data in rows and columns.
|
The rows in a spreadsheet have numeric names (1, 2, 3 etc) and the columns have alphabetic names (a, b, c etc), thus the names of cells subsequently exist of a letter and a number that conveniently point out their position in the grid. Selection of a columnSelection of a cellWorksheetsA spreadsheet can contain one or several worksheets (tabs). Adding worksheets can be done by clicking the ‘+’ on the right side of the existing worksheet tab(s). In the picture above worksheet 3 is selected. Clicking on the plus-sign will add a new worksheet to the spreadsheet. Why spreadsheets are usedThe most common reason to use spreadsheets is to store and organize data, like revenue, payroll and accounting information. Spreadsheets allow the user to make calculations with this data and to produce graphs and charts. A spreadsheet is a tool that is used to store, manipulate and analyze data. Data in a spreadsheet is organized in a series of rows and columns and can be searched, sorted, calculated and used in a variety of charts and graphs. In order to create an electronic spreadsheet, a specialized spreadsheet application is needed. By far, the most frequently used spreadsheet program is Microsoft Excel, but other spreadsheet applications exist as well. The true power of the spreadsheet is its ability to handle complex mathematical calculations and automatically recalculate totals as the underlying data in the sheet changes. This is especially useful for "What-if" analysis and forecasting. Most spreadsheet applications also allow users to format their sheets with options similar to those that we saw in Word Processing. Other similarities exist in the program as well including spell check and the ability to insert decorative items such as borders and images. The remainder of this lesson will introduce you to a few of the basic concepts and functions of spreadsheet applications and then provide you with links to tutorials which will assist you in expanding your skills using Microsoft Excel, the standard spreadsheet software application at Broome Community College. Spreadsheet Terminology Is a spreadsheet program that organizes data in rows and columns?A spreadsheet is a computer program that can capture, display and manipulate data arranged in rows and columns. Spreadsheets are one of the most popular tools available with personal computers. A spreadsheet is generally designed to hold numerical data and short text strings.
What organizes data in rows and columns?A collection of data arranged in rows and columns is a table.
Which type of data is organized in row column format?Data organization and formatting. Organize tabular data into rows and columns. Each row represents a single record or data point, while columns contain information pertaining to that record.
|
