FUNDAMENTALS OF COMPUTER

APPLICATION SYSTEM SOFTWARE

APPLICATION SOFTWARE FOR PERSONAL ENTERPRISE WORKGROUP OBJECTIVES

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The function of a spreadsheet is ____
A
To create a visually interesting presentation
B
To organise, analyse, and graph numerical data
C
To organise large amounts of data in a database
D
To create a text based document
Explanation: 

Detailed explanation-1: -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.

Detailed explanation-2: -MS Excel is a commonly used Microsoft Office application. It is a spreadsheet program which is used to save and analyse numerical data.

Detailed explanation-3: -Simply select a cell in a data range > select the Analyze Data button on the Home tab. Analyze Data in Excel will analyze your data, and return interesting visuals about it in a task pane.

Detailed explanation-4: -Excel definition: a software program created by Microsoft that uses spreadsheets to organize numbers and data with formulas and functions. Excel analysis is ubiquitous around the world and used by businesses of all sizes to perform financial analysis.

There is 1 question to complete.