Exp - 12 : Excel Functions -> Financial, Logical, Text etc. for COPA Trade

In Excel, I have learned some functions, these are

 Financial Functions:

1) PMT

    Ex: =PMT(10%,3,10000) Returns -402.11

2) Rate

     Ex: = RATE (6, -200, 1000, 0.1)

        = 5%

Logical Functions:

1) And

Ex:    =AND(m>25,m<50) 

    here m value must greater than 25 and less than 50.

2) OR

Ex:    =OR(m>25,x>50)

    here m value greater than 25 or x value greater than 50. 

3) NOT

Ex:    =NOT(x>25)

    here x value is not greater than 25

Text Functions

1) UPPER

Ex:    =UPPER("vesrn")

            Returns VESRN

2) TRIM

   Ex:    =TRIM(" vesrn ")

            Returns vesrn

3) PROPER

    Ex:    =PROPER("vesrn technologies")

            Returns Vesrn Technologies



Popular posts from this blog

Install Windows 7 Operating System - Practical

Image
COPA  Install Windows  -7  Operating System I have learned basically these steps to install windows operating system on Personal Computer(PC) The three basic types of clean installation procedures are as follows: Install on a brand new disk or computer system Erase the disk, format it, and install Install into a new directory I am using  first two methods, be sure my computer can boot from a DVD (most newer computers support booting from a DVD drive). Doing so might require changing the drive boot order in the BIOS or CMOS. The Windows 7 DVD is bootable and should run the Setup program automatically. Clean Install from DVD, Step by Step A typical clean installation (on a blank hard disk) step-by-step procedure is as follows: 1. Insert the Windows 7 DVD into your computer’s DVD-ROM drive, and restart the computer. Windows 7 Setup should start automatically. If Setup does not start automatically, ensure that your computer is configured to boot from the DVD drive. 2. In...
Read more

COPA Bits for Computer Based Test (CBT) by Venugopal Vanjarapu

  Computer Operator and Programming Assistant 1st Semester - Module 1 & 2: Safe Working Practice & Introduction to Computer Components 1 Which is the sequence, in which computer operates?  A Input, output, process  B Input, process, output  C Process, input, output  D Output, process, input  2 Which is the first general purpose programmable electronic computer?  A ENIAC B EDVAC  C EDSAC  D UNIVAC  3 What type of device is computer?   A Electrical device  B Electronic device  C Electro magnetic  D Electro mechanical  4 Who is considered as father of computer?  A Charles Babbage  B John Lickert  C John Mauchy  D M.V Wilkes  5 Who invented Analytical engine?  A Charles Babbage  B John Lickert  C John Mauchy  D M.V Wilkes  6 What is the main electronic component of the first generation computer?  A Integrated circuit  B Microprocess  C Transisto...
Read more

COPA

COPA Computer Operator and Programming Assistant (COPA) Exp No Trade Practical Trade Theory CBT Exam Study Material Video Lesson 1 1 1 Study Material Video Lesson 2 2 2 3 3 3 4 Installing Window Operating System Operating System 5 MS-DOS Commands Operating System 6 Linux Commands Operating System 7 Create new document, open existing document, edit document and save the documents Ms Word 8 Formatting text, inserting objects, tables, hyperlinks, autocorrect features, thesaurus, spelling and grammar Ms Word 9 ...
Read more