**Microsoft Excel**, but other spreadsheet applications exist as well.

What is the most common Arab name?

**arabic names ” boy**.

### Contents

A spreadsheet is a **computer application for organization, analysis, and storage of data in tabular form**. Spreadsheets were developed as computerized analogs of paper accounting worksheets. The program operates on data entered in cells of a table.

**To enter, calculate, manipulate, and analyze numbers**.

**SUM functions**. Probably the most frequently used function in Excel (or any other spreadsheet program), =SUM does just that: It sums a column, row, or range of numbers—but it doesn’t just sum.

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.

- Google Sheets – (online and free).
- iWork Numbers – Apple Office Suite.
- LibreOffice -> Calc (free).
- Lotus 1-2-3 (discontinued).
- Lotus Symphony – Spreadsheets.
- Microsoft Excel.
- OpenOffice -> Calc (free).
- VisiCalc (discontinued).

Which of the following is a suite of protocols and programs that support low-level network communication?

**Google Sheets** may be the most popular spreadsheet web app, but Zoho Sheet has more features. And it’s also completely free. It’s the best free Excel alternative, if you’re looking for the most powerful solution. Like Excel, Zoho Sheet really packs in the features.

- Business Analysis. The number 1 use of MS Excel in the workplace is to do business analysis. …
- People Management. …
- Managing Operations. …
- Performance Reporting. …
- Office Administration. …
- Strategic Analysis. …
- Project Management. …
- Managing Programs.

- The SUM Function. The sum function is the most used function when it comes to computing data on Excel. …
- The TEXT Function. …
- The VLOOKUP Function. …
- The AVERAGE Function. …
- The CONCATENATE Function.

Excel includes many common functions that can be used to **quickly find the sum, average, count, maximum value, and minimum value for a range of cells**. In order to use functions correctly, you’ll need to understand the different parts of a function and how to create arguments to calculate values and cell references.

- 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.

Spreadsheet programs can **transform data sets** into various types of graphical displays. In Excel, the Charts section provides the ability to present a data set within a chart or graph. This allows users to visualize and communicate their data sets within presentations, for example using pie or bar charts.

The definition of a spreadsheet is a piece of paper or a computer program used for accounting and recording data using rows and columns into which information can be entered. **Microsoft Excel**, a program in which you enter data into columns, is an example of a spreadsheet program.

We can define application software as software that employs the capabilities of a computer to accomplish a dedicated task. … Examples of application software are **Microsoft Word, spreadsheets, VLC media player, Firefox or Google Chrome, accounting applications**, photo editor, mobile apps such as video games, Whatsapp, etc.

- Microsoft Excel. Best for advanced number crunching. …
- Google Sheets. Best for simple and easy collaboration. …
- LibreOffice. Best for single users looking for free spreadsheet software. …
- Zoho Sheet. Best for collaborative power-users. …
- OnlyOffice.

The first spreadsheet program was **VisiCalc**, written for the Apple II computer in 1979.

Many researchers and statisticians agree that Excel **provides enormous capacity to perform statistical analyses of databases with hundreds of thousands of records with user-friendly commands**. Excel is the first spreadsheet to allow users to define the fonts, character attributes or cell appearance in the sheet.

- Data entry.
- Data management.
- Accounting.
- Financial analysis.
- Charting and graphing.
- Programming.
- Time management.
- Task management.

Use of Excel for Students & Teachers: Teachers can make the best use of table styles, charts, shapes, data tools, and various formulas to educate students in the classrooms. Whereas students can **enhance their learning skills to solve basic and logical statistical & mathematical problems in excel**.

VLOOKUP is an **Excel function to look up data in a table organized vertically**. VLOOKUP supports approximate and exact matching, and wildcards (* ?) for partial matches. Lookup values must appear in the first column of the table passed into VLOOKUP. … lookup_value – The value to look for in the first column of a table.

- SUM Function. The ‘SUM’ function is one of the first functions a new user learns. …
- AVERAGE Function. The ‘AVERAGE’ function is one of the basic tasks being done in Excel. …
- COUNT Function. …
- RANDBETWEEN Function. …
- LEN Function. …
- DATE Function.

- Arithmetic functions : offer basic tools to process numerical data.
- Statistical functions: have analysis tools, averaging tools.
- Date functions: process and convert dates.
- Logic functions: process logic data (AND, OR, etc.).
- Financial functions: process monetary data.

Advantage: **Organizing Data** Spreadsheets are frequently the go to tool for collecting and organizing data, which is among the simplest of its uses. Information can easily be placed in neat columns and rows and then sorted by information type.

They are easy to use for simple data analysis and simple calculations. They are a **good tool for visualization of simple tabular data via charts and graphs**. Despite this widespread use and adoption, spreadsheets appropriately address only a small fraction of an organization’s business intelligence (BI) needs.