SUM The SUM function is the first must-know formula in Excel. It usually aggregates values from a selection of columns or rows from your selected range. =SUM(number1, [number2], …)
Example: =SUM(B2:G2)–A simple selection that sums the values of a row. =SUM(A2:A8)–A simple selection that sums the values of a column.
There are numbers of spreadsheet programs but from all of them, Excel is the most widely used. People have been using it for the last 30 years and throughout these years, it has been upgraded with more and more features. • The best part about Excel is, it can be applied to many business tasks, including statistics, finance, data management, forecasting, analysis, inventory, billing, and business intelligence
Design This design tab displays the commands which are grouped as Themes, Document Formatting, and Page Background. a) Themes group A theme is a set of colors, fonts, and effects that determines the overall look of your document. b) Document formatting group Is refers to the way a document is laid out on the page. c) Page background group This group is the last group of design tab, which contains three options (Watermark, Page color, and Page Borders).
Microsoft Office is a private commercial office suite that includes interconnected desktop applications, servers, and services for Microsoft Windows operating systems that was established by Microsoft in 1989. The initial version of Office contained:
Microsoft Word
Microsoft Excel
Microsoft PowerPoint
Security has always been an overriding concern of human kind. For many organization, information plays a very important role in running business. • Therefore, it becomes necessary to safe guard information from reaching the illegal hands. When data takes the shapes of digital form, a different security procedure is required. This branch of security is called computer security.
Software is a group of programs designed to perform a specific function. • A program is a set of instructions that is written to solve a specific problem. • There are two types of software:
1. System Software 2. Application Software
CPU is considered as the brain of the computer • It is responsible for interpreting information, performing logical calculations, controlling all commands and instructions, and communicating them between parts of the computer. • It stores data, intermediate results and instructions. • It is also known as a processor or microprocessor.
Computer components are classified into two types:
1. Hardware 2. Software
Hardware : It consists of every mechanical and electrical component. It is any visible and directly attached component of the computer, and can be divided into four main parts: A. Input units B. Output units C. Storage units D. Central processing unit (CPU)
Computer: An electronic device that stores, retrieves, and processes data, and can be programmed with instructions. • The word account is the root of the word computer. • A computer can exist in a variety of sizes and configurations. • A computer is composed of hardware and software
Probability : Is an action through which specific results (counts, measurements or responses) are obtained. All the probability examples are based on four experiments:
1. Dice or Die
2. Coin
3. Balls box or black box
4. Cards