Excel: Convert text to upper case

https://www.youtube.com/watch?v=mLcGLdSXEF8

 

=upper(text) converts text to upper case. All the letters in the word are converted to capital letters.

Comments

Post a Comment

Popular posts from this blog

What is Compatibility Testing and common defects

https://www.youtube.com/watch?v=9isF5oZP_hA Desktop application runs on personal computers and work stations, so when you test the desktop application you are focusing on a specific known environment. Since the environment is known compatibility testing for desktop application is fairly easier. In client server application, application is loaded on server machine while the application executes on every client machine. Compatibility testing becomes little bit complex since it needs to be tested at 2 levels. Web application is loaded on the server but location and environment of users is unknown. Since users environment is unknown multiple conditions need to be considered while testing web application which makes it complex. Compatibility is a non- functional testing and goal is  to determine whether your software application or product is efficiently working and stable to run in different browsers ,hardware, screen size, resolution, operating system, mobile devices, users and networks. ...
Read more

Multiply any number by 5 mentally

https://www.youtube.com/watch?v=rqymPFil-So 5=10/2 If we want to multiply any number by 5 then multiply by 10 and divide by 2. This concept makes multiplication of bigger numbers easier. To multiply any number by 10, you put 0 at the end of the number Ex 23 X 10=230 456 X 10=4560 Then divide by 2. Ex 21 X 5 = 21*10/2 =210/2 =105  
Read more

Database Testing

https://www.youtube.com/watch?v=epvNp7xLtg8 1)What is  a Database? Database is an organized collection of data, which provides efficient retrieval of the data. 2) What is DBMS? DBMS: Data base  Management System.  It is system of systematic  way of  Creating, Storing, Retrieving and Managing of data. Ex: File system, XML 3) What is RDBMS? Relational Database Management System: Is a database system based on relational model. Ex: SQL Server, Oracle 4) What is Database testing? Database testing is a process of testing the behavior of the database with reference to front-end web/desktop application. Any changes made in the front end should change backend and vice versa Data Integrity Data Validity Data base performance Testing of functions, procedure and triggers  5) What do we need to check in Database testing ? Constraint check Verification of a field size and type Stored procedures, Triggers Performance based issues 6) How do you test Data Integrity? What do you ...
Read more