EXCEL FORMULAS

Excel Formulas

Function	Formula	Example
To add up the total	=SUM(cell range)	=SUM(B2:B9)
To add individual items	=Value1 + Value 2	=B2+C2
Subtract	=Value1 - Value 2	=B2-C2
Multiply	=Value1 * Value2	=B2*C2
Divide	=Value1 / Value2	=B2/C2
Average	=AVERAGE(cell range)	=AVERAGE(B2:B9)
Percentage		=G4/HG*100
Max	=MAX(cell range)	=MAX(B2:B9)
Min	=MIN(cell range)	=MIN(B2:B9)
Count IF	=COUNTIF(range,value)	=COUNTIF(D5:D11,”red”)
IF		=IF(F2>=90,"A+",IF(F2>=80,"A",IF(F2>=70,"B+",IF(F2>=60,"B",IF(F2>=50,"C","F")))))
Enter Time	Ctrl +Shift :	8:40 AM
Enter Date	Ctrl ;	01/02/2019

Simple formatting tricks

Function	Formula	Example
To change a cell to proper case	=PROPER(cell)	=PROPER(A2)
To change a cell to upper case	=UPPER(cell)	=UPPER(A2)
To change a cell to lower case	=LOWER(cell)	=LOWER(A2)

MS OFFICE AT A GLANCE

Q1. What is Microsoft Office?

Ans. Microsoft Office is a collection of software of Windows based applications. It was designed by Microsoft Corporation keeping in mind the tools required on an office desk.

Q2. What are the components of MS Office?

Ans. The components of MS Office are as follows:

1. MS Outlook
2. MS Word
3. MS Excel
4. MS PowerPoint
5. MS Access
6. MS Publisher

Q3. What are the components of Microsoft Office Window?

Ans. The components of MS Office Windows are:

1. Title Bar
2. Ribbon
3. Office button
4. Office Access Toolbar
5. Status Bar
6. Horizontal Scroll Bar
7. Vertical Scroll Bar
8. Minimize Button
9. Maximize / Restore Down Button
10. Close Button

Q4. Define MS Excel

Ans. MS Excel is a popular spreadsheet program that allows you to work well with numbers. You can store data in Excel in the form of rows and columns that can be organized and processed.

Q5. Define Workbook.

Ans. A file in MS Excel is called workbook. It contains many pages which are called worksheets or sheets.

Q6. Define the following:

Ans.

1. Formula Bar
2. Name box
3. Sheet tabs
4. 4.Charts

1. Formula Bar: this bar is below the Ribbon. It contains the formula entered in cell. The formula in Excel should begin with an equal to (=) sign.

2. Name Box: It contains the cell address of the active cell.

3. Sheet Tabs: These tabs are present below the work book on the lower left -corner.

4. Charts: It is a pictorial representation of data. You can create different types of graph easily from the data in the spreadsheet. Charts once created can easily changed in terms of the charts text, color, size, position, etc.

Q7. Quick Key