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

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 Transistors  D Vacuum tubes 7 How does the parallel port transfer a byte?  A Bit by bit  B 2 bits at a time  C 4 bits at a time  D 8 bits at a time 
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

Operating System

Operating System: An operating system (OS) is system software that manages computer hardware, software resources, and provides common services for computer programs. Types of Operating Systems: 1. Single Task & Multi Tasking Systems:      A single-tasking system can only run one program at a time, while a multi tasking  operating system allows more than one program to be running concurrently. Single Task Functions like printing a document, downloading images, etc., can be performed only one at a time. Examples include MS-DOS, Palm OS, etc. Multi Tasking Operating Systems Examples include Microsoft Windows and Macintosh OS. 2. Multiuser/Multitasking OS It is an operating system that permits several users to utilize the programs that are concurrently running on a single network server. The single network server is termed as "Terminal server". "Terminal client" is a software that supports user sessions. Examples include UNIX, MVS, etc. 3. Distributed Operaing Syste
Read more