- Cells: Each worksheet has a significant number of cells that can be assigned values and various formatting options. …
- Rows and Columns: Cells in a worksheet are organized in rows and columns.
What are the features of workbook?
- Collection of Worksheets: Each workbook maintains a collection of worksheets that allows you to add and delete worksheets. …
- Active Worksheet: The workbook exposes a property that indicates the active worksheet.
What are the features of electronic worksheet?
The electronic spreadsheets have facilities for
Copying, Deleting, Moving, Erasing, and Inserting data
. These facilities are available for all types of data including labels and formula and are similar to those available in word processors.
What are the main features of Excel?
What are the main features of Microsoft Excel? Ans. The main features of MS Excel include
inserting a pivot table, sorting of tabulated data, adding formulas to the sheet, and calculating large data
.
What are the parts or features of a spreadsheet?
- spreadsheet – a table in which you can enter and manipulate data.
- cell – a table entry. …
- row – cells aligned horizontally. …
- column – cells aligned vertically. …
- range – the specification for a series of cells. …
- function – an operation applied to a range of cells, always beginning with an “=” sign.
What is the main purpose of a spreadsheet?
The 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.
What are the advantages of spreadsheet?
- Formulae can be used to instantly recalculate totals. …
- You can carry out “what if?” investigations. …
- The information can be presented in different ways. …
- It is easy to make these changes, save your work and print it out again.
What do you mean by worksheet?
The term Worksheet used in Excel documents is
a collection of cells organized in rows and columns
. It is the working surface you interact with to enter data. Each worksheet contains 1048576 rows and 16384 columns and serves as a giant table that allows you to organize information.
What is called workbook?
A workbook is
a file that contains one or more worksheets to help you organize data
. You can create a new workbook from a blank workbook or a template.
What are three main tasks performed by an Excel workbook?
- ENTER – When done entering data; the active cell will be the next cell down.
- TAB – Enter the text and move to the next cell to the right.
- Arrow key – Enter the text and move to another cell.
- ESC – If you made a mistake and you want to cancel your entry or edit.
What are the 3 features of Excel?
- Add Header and Footer. MS Excel allows us to keep the header and footer in our spreadsheet document.
- Find and Replace Command. …
- Password Protection. …
- Data Filtering. …
- Data Sorting. …
- Built-in formulae. …
- Create different charts (Pivot Table Report) …
- Automatically edits the result.
What are the tools of Excel?
- Flash fill. Excel’s Flash Fill feature makes it easy to fill data in an Excel worksheet based on adjacent data patterns. …
- Filter and calculate with tables. …
- Dropdown lists. …
- Isolate variable data in a data area. …
- Exception reporting with conditional formatting.
What is the most important function in Excel?
SUM
.
The SUM function
. The function will sum up cells that are supplied as multiple arguments. It is the most popular and widely used function in Excel.
What are the two main components of spreadsheet?
- Workbooks and Worksheets. Excel refers to its documents as workbooks. …
- Cells. A worksheet cell exists at the intersection of a row and column, and can contain up to 32,767 characters. …
- Headings. Within an individual Excel file, you can access up to 1,048,576 rows by 16,384 columns. …
- Formula Bar.
What are the three important parts of a worksheet?
- Worksheet – rectangular grid of rows (numbers) and columns (letters)
- Cell – intersection of row and column.
- Cell reference – unique address, coordinates of the intersection of a column and row (B7)
- Gridlines – horizontal and vertical lines.
What are the 4 major parts of Excel?
- Workbooks, Worksheets, Tables and Charts. Four major parts of Excel.
- Home, Insert, Page Layout, Formulas, Data, Review, and View. When you start Excel, the Ribbon displays these seven top-level tabs.
- Shortcut menu. …
- What constitutes a “number” in Excel. …
- Merging cells. …
- Embedded chart. …
- Legend. …
- ECS key.
