Use of Power and Sqrt Function in Excel Worksheet

Today, we will discuss the use of POWER( ) function and SQRT( ) function in Microsoft Excel Worksheets. We will prepare  a worksheet to practically learn the use of Power () function and Sqrt() function

as shown in the following figure:

Use of POWER( ) function and SQRT( ) function in Microsoft Excel Worksheets

The Use of POWER( ) function in MS Excel Worksheet

POWER function may be used to raise a number to a certain power. For example, to calculate number 2 raise to the power of 3, we will type the power function as:
    =POWER(2,3)
which will return the result 8. If the number is in cell B3, we will type the power function as follows:
  =POWER(B2,3)

Steps To Create an Excel Worksheet To Demonstrate Use of Power() and Sqrt() Function

1. Start Microsoft Excel with a new blank workbook.

2. Type the data as shown below in the first worksheet.

3. Perform formatting in Excel worksheet as shown in the following figure.

4. Type data in Column A and Column B of worksheet.

5. In cell C3 of column C , we will type a formula using Power() function to calculate Square of given number.

6. Type = in cell with reference C3.

7. Type POWER(B3,2) and press Enter.

8. Since we have entered number 4 in B3 cell so Power(B3,2) will return 16 in cell C3.

  

The Use of POWER( ) function in MS Excel Workshee

The Use of SQRT( ) function in MS Excel Worksheet

The Excel function SQRT is used to calculate the square root of any number given as its argument.
For example, if you use wish to calculate square root of 4, you will type SQRT function as follows:
  =SQRT(4)   
which will give 2 as a result.

9.   In cell D3 of column D , we will type a formula using Power() function to calculate Cube of given number.

10. Type = in cell with reference D3.

11. Type POWER(B3,3) and press Enter.

12. Since we have entered number 4 in B3 cell so Power(B3,3) will return 64 in cell D3.

The Use of SQRT( ) function in MS Excel Worksheet

13. In cell with reference E3  , we will type a formula using Sqrt() function to calculate Square root of given number.

14. Type = in cell with reference E3.

15. Type SQRT(B3) and press Enter.

16. Since we have entered number 4 in B3 cell so SQRT(B3) will return 2 in cell E3.

We have completed the task of creating a worksheet in MS Excel using Power function and SQRT() function.

Excel Worksheet Student Absence Fine Calculation Formulas

Today, we will discuss how to create an Excel Worksheet that helps calculate Students Absence Fine Calculation on basis of Total Lectures Delivered and Total Lectures Attended (Presence) of the student.

Excel Worksheet Student Absence Fine Calculation Formulas

Steps To Prepare an Excel Worksheet for Student Absence Fine Calculation

1. Start MS Excel with a blank workbook option.

2. Type sample data in first Excel worksheet as shown in the given image.

3. Type formula for calculation of number of absence of a student.

    Place cursor in Cell with reference E3.

    Type = sign in E3

    Type C3-D3 and press Enter

Steps To Prepare an Excel Worksheet for Student Absence Fine Calculation

4. Copy the formula of cell E3 in all lower level cells with the help of Fill Handle in 

    lower right corner of Cell E3.

5. Type formula for calculation of fine by multiplying cell E3 with 50.

6. Type formula of fine calculation =E3 * 50 and press enter in cell referenced by F3.

7. Copy the fine calculation formula downward in all required cells of column F.

8. Congratulations you have successfully prepared Excel Worksheet for Absence Fine calculation of         students. 

9. Please, do not forget to save file.

How to Create College Admission Inquiry Report in Excel

Today, we will discuss how to prepare an Excel worksheet for Admission Inquiry in a College. Actually the management of the college wishes to monitor the Performance of the marketing and advertising staff. The advertising and publicity staff of the college is responsible for taking steps to better publicize the good reputation of the college and attract new  students for admission in college classes.

Excel Worksheet For College Admission Inquiries Performance Report

The Excel worksheet about Admission inquiries performance report will perform the following tasks:

1. It will record Serial No., Date, Inquiries for ICS, B.Sc.(ACS) and MCS

       Note: ICS stands for Intermediate in Computer Science, ACS stands for Advanced Computer                         studies and MCS stands for Master in Computer Science.

2. It will calculate total inquiries by adding the inquiries of the three classes.
3. It will output a message in Performance column as given below:

• Show a message "Excellent"  for inquiries greter than or equal to 100
• Show a message "Good"  for inquiries greter than or equal to 80
• Show a message "Satidfactory"  for inquiries greter than or equal to 40
• Show a message "Unsatisfactory"  otherwise, that is when inquiries are less than 40 per day.

Steps to create Admission Inquiries of a College Worksheet in Excel

1. Prepare the basic admission inquiries worksheet with proper formatting

Guidelines for Formatting the Admission Inquiries Performance Report Worksheet

Type necessary headings in the worksheet. If you wish to merge cells, perform the steps as shown in the figure below:

Apply Merge and center option in Excel worksheet

You can apply middle align options as shown in the figure below:

Apply middle align option in Excel worksheet

You can increase font size of the text in cells:

You can apply borders option to selected cells in the worksheet as shown in the following picture:

You can insert word art in Excel worksheet as shown in the image below:

You can insert word art in Excel worksheet

2. Enter sample data in worksheet as shown in the figure.

3. Enter necessary formulas and predefined functions
4. First of all, when you start work on the worksheet, save the workbook with a proper name as College Admissions Inquiries Report Worksheet. During your work, press CTRL + S from keyboard to save changes, often.

How To Use Necessary Formulas and Functions

In this worksheet, we will use two functions according to the requirements
     1. SUM function
     2. IF function

Using SUM function to get Total Inquiries

Place cursor in cell referenced by F4.
Type  =
Type name of function that is SUM
Type address of ICS cell referenced by C4
Type a colon :
Type address of cell MCS referenced by address E4
Press enter
The total of inquiries will be shown in cell F4.

Apply Sum function in Excel worksheet

Using Logical IF Function To Show Suitable Message according to Total Inquiries

We will use IF function as following:

=IF(F4>=100,"EXCELLENT",IF(F4>=80,"GOOD",IF(F4>=40,"SATISFACTORY","UNSATISFACTORY")))

Syntax of IF logical function is:

IF(Logical-Test, Value-If-True, Value-If-False)

Example of IF Function is

=IF(F4>=40,"Satisfactory","Unsatisfactory")

It will give Satisfactory if cell F4 contains a number greater than or equal to forty or it will return Unsstisfactory otherwise, when less than forty.

Apply Logical IF function in College Admission Inquiries Report Excel worksheet

House Building Expenses Formulas in Excel

Today we will discuss the Excel Worksheet Formulas for recording Monthly House Construction Expense Management.

Steps To Create Expense Management Excel Worksheet

1. First of all, start MS Excel with a new workbook.
2. Merge required number of cells in first row of worksheet.

       

      3. Insert Word Art and type a suitable title heading in worksheet.

      4. Enter heading row.

      5. Enter data in worksheet.

      6. Apply the formulas and functions in worksheet as explained later.

       

Here is the list of expenses we have considered to be recorded.

Sr. No	Item
1	Cement (Bags)
2	Bricks(Trolly)
3	Sand(Trolly)
4	Gravel(Truck)
5	Iron (Kg)
6	Marble(Square Feet)
7	Electricity Bill
8	Labour
9	Miscelleaneous

You can increase this list of expenses according to your wish. The Excel worksheet formulas are provided for the worksheet as shown in the figure below:

Monthly House Building Expenses Calculator Formulas in Excel

If you change the worksheet, it is not difficult to change the construction management formulas in Excel according to your expense list.

The formulas used in Construction Expense Management Excel Worksheet

The formulas used in Construction Expense Management Excel Worksheet are given as follows:

Excel Formula No. 1:

Amount = C3 * D3

Explanation:

First formula will be used to multiply Rate per Item Column Cell with Quantity Column Cell. We can easily check from the above figure of home expenses worksheet that the related column cells are C3 and D3. We use multiplication operator * to multiply these cell values. Don't forget to place = operator before typing the formula. We will insert formula by typing =C3 * D3 in cell E3. Remember that cell E3 is in the Amount (E) column.

Excel Formula for Calculation of Amount

 = C3 * D3

How To Copy Formula in the Cells Below

• Type the formula in cell E3. 
• Point to the lower right corner of this selected cell E3.

• The cursor will take the Plus sign shape.
• Now keeping the left button pressed, drag the mouse downward selecting the cells you wish to copy formula in.

       

• Release the left button of mouse.
• You will see that formula has been copied and the results of formula appeared in the cells.

Calculate Monthly Building Expenses by Formulas in Excel Worksheet

Excel Formula for Calculating Total Amount of All Expense

Type   = SUM(E3 : E11) in cell E12 and press Enter key. The formula will produce the resultant value. This result gives us the total monthly expense during a given month.

Total Expenses during month by excel formulas

The total monthly expense  is shown below:

Download Free Top Antivirus Program - Avast Antivirus of 2018

Let us discuss Why Avast is Number One Free Antivirus Software Solution of  2018. By downloading and installing Avast Antivirus you can get the best virus free working environment in your PC as well as Android Smart Phone.

Why Avast is Number One Free Antivirus Software of 2018

Main Features of AVAST Free Antivirus are discussed here while describing the Top 10 reasons to select AVAST free Antivirus as Number One in 2018:

1. AVAST in 2018 is More Efficient

   New Avast software is more efficient and lighter because of less consumption of critical system resources.

2. AVAST is More Powerful

Avast is more powerful for detecting and removing a vast range of security threats trying to attach on your PC.

3. AVAST is with Pleasant Look and Feel

AVAST provides easy to use graphical User Interface which is attractive and eye catching as well as easier to use effectively. A layman or new computer users can easily use Avast antivirus software.

4. Avast is Easy To Install

AVAST antivirus comes with an easy to install complete setup program. The installer is completely configurable. You can skip the installation of unnecessary third-party components.

5. AVAST Provides different scan mode Options

AVAST provides a QUICK SCAN mode to perform a quick scan in areas where malware is known to hide. By seleting complete scan mode, you can get searched and analyzed  your entire computer system. AVAST also provides a boot time scan to check autostart processes and services.

6. Efficient AVAST Quarantine System

Suspected infections may be sent to the quarantine for deciding later to keep or eliminate them.

7. Auto Check for Virus Definition Updates

AVAST provides an excellent virus definition updater system when you are connected with internet.

8. Avast comes with Extra security tools

Avast provides the security tools including browser protection and cleanup for top web browsers e.g. Internet Explorer, Google Chrome, Mozilla Firefox. Avast provides a software updater for other programs installed.

9. Avast's Transparent Policy for Private Data Collection

Avast software will tell you whenever it wants to gather anonymized usage data which may be useful for further and better development of the antivirus software. You can disable this data collecting function from privacy settings.

10. AVAST is Totally Free Anti-malware Software

And above all, AVAST is a totally free antivirus protection software for your PC and Android Smart Phones. AVAST provides antivirus solution for Personal Computers as well as for Android Smart Phones.

How To Download and Install Avast Free Antivirus

Sponsored Links

You can download AVAST Free Antivirus from AVAST website link.

How To Create Income Tax Calculation Excel Worksheet

Microsoft Excel may be used to prepare employee pay sheet with Basic pay, medical allowance, conveyance allowance, house rent and income tax entries. Each of the mentioned entries in worksheet will be calculated automatically using functions and custom formulas applied to required cells in worksheet.

Income Tax calculation Formulas Calculate pay of employee using income tax in Excel

After entering the sample data in the worksheet, following formulas will be applied:

Q: Create an MS Excel Worksheet to calculate Net Pay of Employees. Input is EmpID, Name, Job
 and Basic Pay. Fill sample data in it as shown in the figure. Calculate Medical Allowance 10% of basic pay, House Rent 50% of basic Pay and Conveyance Allowance 30% of basic pay. Deduct income tax 5% of basic pay if basic pay is less than 30000 and income tax 10% otherwise.
BASIC FORMULAS:
Medical Allowance = D3 * 10%
House Rent                = D3 * 50%
Conveyance Allowance = D3 * 10%
Income Tax   = IF(D3<30000,D3*5%,D3*10%)
Net Pay  = SUM(D3:G3)-H3

You would like to :

EXPLORE  more Microsoft Excel Formulas for Worksheets and downloads

Electricity Bill Calculator Formulas in Excel 

Microsoft Excel Formulas and Functions Fast and Easy Way -1

Using Simple Formulas in Excel With Arithmetic Operators 2

How Functions are Used in Excel Fast and Easy Way 3

Create Bar Chart in Excel Easily by Example

Employee Pay sheet Formulas in Microsoft Excel 

Students Test Score Grades Result Sheet in Excel

Microsoft Office Word Processing Practicals

Explain Difference Between Compiler and Interpreter

Difference between Compiler and Interpreter

The Compiler and Interpreter are the two main types of Language Translator or Language Processor

Explain some important differences between Compiler and Interpreter

or Differentiate between Interpreter and Compiler

Compiler	Interpreter
1.    Compiler   converts   a   source program   into machine code as a whole.	1.  Interpreter    converts    a    source program    into machine code one statement at a time.
2. Compiler after translating whole source program, creates object code file, that can be executed.	2. Interpreter does not create object code file. It only creates executable code for only one statement currently interpreted, which is executed. Next time second statement is translated and executed and so on. No object file is created.
3. Program execution is fast. Since once program is compiled successfully, an object code file is produced. Now this object code file is executed. No need of re-compilation unless we change the source code.	3. Program execution is slow. Because every time we want to run a program it is interpreted again.
4. Error detection and error removal is comparatively difficult. Because, compiler will show a list of all errors in the whole program. Therefore, sorting out every error individually and removing the cause of error becomes more difficult and time consuming.	4. Error detection and removing error is easy in case of interpreter, because interpreter will show when error at a time and its location in program. So that the programmer can easily catch and remove error.
5. More programming languages use compilers for translating source code to object code.	5. The number of high level programming languages that use Interpreter as an option to translate source code into object code is relatively smaller.
6. In compiled high level programming languages program execution does not require Translator or compiler for every execution. Because after first time of compilation, object code file is available that is used subsequently for onward program executions unless we change the source code. In case of change of source code, we need to re-compile the source code to show changes in the object code also.	6. In interpreted high level programming languages, translator program is needed every time for execution of the source program.

You would also like to read:

Types of Language Processors / Language Translators / Compiler, Interpreter, assembler