Filling-up Part-II Applications And Uploading @ TSLPRB

Filling-up Part-II Applications And Uploading Documents from 29th October to 18th November 2018 @Telangana State Level Police Recruitment Board

All the Candidates participating in PMT / PET as detailed have to fill their PartII Final Application Form by Online logging on into their User Account on the TSLPRB Website www.tslprb.in.

Part-II Applications And Uploading Documents can be sumbited between 10 a m on 29th October 2018, Monday and 12 midnight on 18th November 2018. It may please be noted that Part-II Application has to be filled along with uploading the photocopies of the relevant Certificates or Documents and it will take substantial time to fill-up the Form completely. For the aforementioned purpose, Candidates are advised to keep all the relevant Certificates or Documents readily available for scanning and uploading.

Part-II Online Application can be filled along with uploading of scan documents on all the 21 days starting from 10 a.m. on 29th October (Monday) till midnight on 18th November 2018 (Sunday). Note that the Candidates will not be able to fill up their Part-II Application after 12 midnight on 18th November. Therefore, they are requested to complete the procedure well in advance without delaying it till the last moment. It may please be noted that this deadline will not be extended in any circumstances and only those Candidates who have satisfactorily filled their Part-II Online Application Form will be allowed to participate in Physical Measurement Tests and Physical Efficiency Tests@ visit on Official Website www.tslprb.in .

Read More

Honor 8X | More Specific Features | Honor Smartphone

Honor 8X comes with more specific features:

Honor 8X Smartphone has a large 6.5 inch HD Full View Display with 20 Megapixel Camera, Kirin 710 Octa-Core Processor with 6 GB RAM and 128GB Internal storage Memory. Quality with Its more specific features such as Display, Design, Eye Comfort Mode, Internal Storage 128GB ROM, Triple Card Slot, Face Unlock, Camera features.

Honor 8X

1. Full View Display: 

Seamless FHD+ Full View Screen with advanced chip-on-film technology and featuring an incredible 91% screen to body ratio. The 19.5:9 aspect and enhance visual quality show more details. Covering 85% of NTSC Color gamut, Video enhancement and Split- Screen Mode features Also.

2. Design: 

Second-generation anti-glare film, with 2 visual effects and 15 layers of rich reflective crafts man ship on the same glass back. Complex intertwined and grained texture on the left border. Classic, unique pattern effect of Honor flagship phones on the right border

3. Eye Comfort Mode: 

Reduces blue light radiation to prevent eye fatigue. Sunlight Display Technology: enables a better viewing experience under the bright sunlight.

4. Internal Storage 128GB ROM and Triple Card Slot: 

Honor 8X Triple Card Slot

 

Store more than you can imagine, with up to 128GB ROM. Triple Card Slot has Upto 400GB memory card slot with HD 4G+ VoLTE better coverage Dual SIM slot.

Honor 8X Dual SIM HD 4G+VoLTE Better Coverage

5. Face Unlock: 

Honor 8X Face Unlock Features

 

The smart facial recognition technology allows for faster face unlock in different lighting conditions.

6. Camera: 

20-megapixel + 2-megapixel dual-lens rear-facing camera with Phase Detection Auto Focus (PDAF), 16MP Front Camera, Enabling High Quality Camera Captures with bokeh effect.

Honor 8X specifications:

• Operating System: Android Oreo + Huawei EMUI 8.2

• Processor: Kirin 710, Octa-Core (4 x Cortex-A73 2.2 GHz + 4 x Cortex-A53 1.7 GHz)

• GPU (Graphics Processing Unit) : Mali G51

• RAM: 6 GB / 4 GB

• Phone Internal Storage Memory: 128 GB / 64 GB

• External Storage Memory : microSD card (up to 400 GB)

• Camera : 20-megapixel + 2-megapixel dual-lens rear-facing camera with Phase Detection Auto Focus (PDAF)

• Display: 6.5-inch 2340p x 1080p LTPS display with 16,700,000 colors, 397 PPI

• Battery : 3750 mAh battery

• Sensors : Gravity sensor, Proximity sensor, Ambient light sensor, Gyroscope, Fingerprint sensor

Read More

How To Learn Excel Formulas | Microsoft Excel | General Formulas

How To Learn Excel Formulas?

If you have worked in any office, you will most likely depend on "Microsoft Excel". You want to do any mathematical calculation by own thoughts. If you want a bill receipt or the salary bill, that definitely needs to work with "Microsoft Excel". If you are doing a different application or "Microsoft Word" using a mathematical calculation, most calculation update will be difficult. You can easily work on Microsoft Excel using the formulas. Learn to Microsoft Excel Formulas as follow as below.

SUM function:

It will add of the row or column values. For example, make Student Subjects Marks the following as below:

Steps:
1. Manually Enter Student Names and Subject marks
2. Enter "=sum(values or Locate of Cell values)" i.e. Sum Formula syntax "=sum(B2:G2)" Follow picture as below:

3. Select Cells and Press Ctrl+D Fill down values of sum If need for all students.

4. To see return of the values:

If needed more SUM functions of SUMSQ, SUMX2PY2 and SUMX2MY2 - Given x, y values, sum of square values as follow Formulas:

SUMIF function:

It is using that add of the row or column values in different labels and values are alternatively. For example: Given labels are as "SAI, BALU, CHINNA", and values are alternatively. SUMIF formula is "=sumif(table array, criteria, sum of range)" as follow Formula Syntax.

If criteria value is "CHINNA", then returns

If criteria value is "BALU", then returns

If criteria value is "SAI", then returns

SUMPRODUCT function:

It is sum function but it makes the sum and product of the row array or column array in different values are alternatively. Direct Formula: =SUMPRODUCT(array1,array2,array3….)

For Example:

Then return values:

General Use Direct Formulas and Indirect formulas:

Commonly use Sum, Average, Minimum, Maximum, count, etc... Those are direct formulas. Indirect formulas are depending on different functions. For example: result is not direct formulas. It is used that "IF" & "AND" functions. General use formulas as follow as below:

Mathematical Calculation Formulas:

Addition (+), Subtraction (-), Multiplication (*), Division (/) and Power (^) those are operators. Absolute, GCD, LCM, Product, Factorial, Logarithm, Expansion, PI, Sin, Cos, Power, Square Root, Degrees, Radians, Roman, Integer Calculations of the formulas as follow as below: 

Round, Floor, Ceiling, Roundup, Rounddown, Remainder, Finda Leap Year, Count variation Calculations of the formulas as following picture as below: 

Strings or Text Formulas:

Joint String Operator (&), Concatenate, Text Length, Left characters, Right characters, Middle Characters, Uppercase, Lowercase, Propercase (Titlecase), Repeat Text, Trim character space, ASCII CODE character (CHAR) are used formula as following as below: 

Date Formulas:

Commonly use Today, Now, Year, Month, Day, addition days, subtraction days and Age Calculation Formulas by using methods as following below:

Read More

Microsoft Word Tutorial | Shortcut Keys | Ms Word Tricks

Microsoft Word

You can learn Microsoft's Tool Bars, buttons and their uses easily and with need shortcut keys and tricks.

Windows title bar:

When we open the Microsoft Word, we will open the frame that is opened by Windows. Wherever the name of Windows appears, it is called Windows title bar.

Shortcut Tricks: On the title bar, double click (Mouse Left) on it with the mouse and it will be minimised. Double click on it and it becomes maximised or full screen.

Minimise Button: Click left mouse button with the mouse on the Minimise Button to minimise windows. (If there is a minus sign)

Shortcut Key: Alt + Space + N

Maximise Button: Click left mouse button with the mouse on the Maximise Button to full screen windows. If you click on the full screen then the restore download will be maximised or full screen if you click on Restore Down. (If there is a single box or double box sign)

Shortcut Keys:
Alt + Space + X (Maximise)
Alt + Space + R (Restore Down)
Alt + Space + M (Move) If Restore down Window
Alt + Space + S (Size) If Restore down Window

Close Button: Click left mouse button with the mouse on the Close Button to close the windows. (If there is "X" sign with Red Background colour)

Shortcut Key: Alt + Space + C (or) Alt + F4

Office Button or File Menu:

The file menu or office button is the same as containing control options of the file.

Shortcut Key: Alt + F (File Menu)

Shortcut Tricks: Simply left by clicking the mouse on a button office button, the file menu will open. If double click on Office Button the window will closed.

Ribbon Style:

In addition to the file menu, the Seven Menus are in Microsoft Word. These are home, insert, page layouts, references, mailings, review, and view. Each menu options will resemble a ribbon style.

Ruler:

We use the page measurement. It is on top or left side of the page. We can change the ruler to show inches, centimetres, or other units of measure in top or left side ruler.

Scroll bar:

If need to scroll up and down in page, in Microsoft word window that allows you to move the window viewing area up, down.

Status Bar:

It is a horizontal bar, showing information about a document being edited or a program running.

Quick Access Tool Bar:

A customisation tool bar contains commands that we may want to use. We can also add items to the quick access tool bar. Right click on any item in Menu and click on "Add to Quick access tool bar" to shortcut will be added.

Microsoft Office Word Help Button:

This button is the right side on the menu bar. Click on this and get any help in the Word.

Shortcut Key: F1 (Help)

Read More

Junior Pachayat Secretary Hall ticket 2018 | TSPRI

Junior Pachayat Secretary Hallticket 2018:

Today, Telangana Panchyat Raj Department has been released Hall tickets of Junior Panchayat Secretaries .The Hall ticket can be downloaded on Telangana Panchayat Raj Department Official Website tspri.cgg.gov.in.

Junior Panchayat Secretary Hall tickets 2018

The Hall ticket can be downloaded for direct recruitment for the post of Junior Panchayat Secretaries 2018.Examinations will be hold on 07/10/2018 FN&AN. The Examination will be conducted Objective Type and OMR Based Exam.The Hall Ticket must be presented for verification along with at least one original valid identification card. Preferably, the candidate may carry Aadhar Card. There will be 1/4 negative mark for every wrong answer and without answering, there will be no negative mark for that question.

How to Download Junior Pachayat Secretary Hallticket 2018:

• Goto Official Website tspri.cgg.gov.in
• Click Here to Download Hall Ticket for Junior Panchayat Secretary Post
• Click link to "Click Here to Download Hall Ticket"
• Enter Mubile Number and Date of Birth on new tab
• Take Print out your Hall ticket

Download Junior Pachayat Secretary Hallticket 2018

SYLLABUS:

Paper-I: GENERAL STUDIES AND MENTAL ABILITY Current affairs – Regional, National and International International Relations and Events General Science in everyday life Environmental Issues and Disaster Management Geography and Economy of India and Telangana Indian Constitution: Salient Features Indian Political System and Government Modern Indian History with a focus on Indian National Movement History of Telangana and Telangana Movement Society, Culture, Heritage, Arts and Literature of Telangana Policies of Telangana State Mental Ability (Verbal and non-verbal)

PAPER-II:Telangana Panchayat Raj Act, 2018, Rural Development Programmes Telangana Panchayat Raj Act, 2018 Evolution of Panchayat Raj system in India including Constitutional amendments and reports of Various Committees Roles and responsibilities of Panchayat Secretary Rural Sociology: History and Evolution of schemes catering to upliftment of Rural Poor Flagship Rural Development schemes of Rural Development Department of Government of India and Telangana Rural Economy of Telangana: Agriculture, Small scale Industries, Rural artisans Community Based Organizations and convergence of Welfare Schemes Women Empowerment and Economic development through Self Help Groups Revenue and Expenditure Management of Local Bodies 10. Accounting and administering funds received under various schemes

Read More

TSPSC Group 4 Hall Tickets 2018

TSPSC Group 4 hall ticket 2018:

Telangana state public service commission (TSPSC) has been conducted examinations of Group-IV, JA in RTC, Bill Collector in GHMC and various posts in Beverages Corporation for general recruitments. The hall ticket for the recruitment examination of Group-IV, JA in RTC, Bill Collector in GHMC and various posts in Beverages Corporation for general recruitments was released by Telangana state public service commission on official website tspsc.gov.in.

TSPSC Group 4 Hall Ticket Download

Hall ticket Download for GROUP-IV SERVICES

Hall ticket Download for JUNIOR ASSISTANT IN TELANGANA STATE ROAD TRANSPORT CORPORATION (RTC)

Hall ticket Download for BILL COLLECTOR IN GREATER HYDERABAD MUNICIPAL CORPORATION (GHMC)

Hall ticket Download for Assistant Accounts Officer Grade-II, Assistant Stores Officer Grade-II, Data Processing Assistant Grade-II POSTS IN TELANGANA STATE BEVERAGES CORPORATION LIMITED

The Hall ticket can be downloaded for general recruitment to the posts of Group IV, JA in RTC, Bill Collector in GHMC and Various posts in Beverages Corporation. Group IV, JA in RTC, Bill Collector Examinations will be hold on 07/10/2018 FN&AN. The Examination will be conducted Objective Type and OMR Based Examination.

How to download TSPSC Group 4 hall ticket 2018:

Go to the official website tspsc.gov.in
Click on ‘Hall ticket Download’
Then new tab on Enter TSPSC ID number and date of birth
Hall ticket will be displayed
Take a print out your Hall ticket

Hall Ticket Download

SYLLABUS

Paper-I: GENERAL KNOWLEDGE Current affairs International Relations and Events General Science in everyday life Environmental Issues and Disaster Management Geography and Economy of India and Telangana Indian Constitution: Salient Features Indian Political System and Government Modern Indian History with a focus on Indian National Movement History of Telangana and Telangana Movement Society, Culture, Heritage, Arts and Literature of Telangana Policies of Telangana State

Paper-II: SECRETARIAL ABILITIES Mental Ability (Verbal and non-verbal) Logical Reasoning Comprehension Re-arrangement of sentences with a view to improving analysis of a passage Numerical and Arithmetical abilities

Read More

TELANGANA PC PRELIMINARY KEY 2018 | TSLPRB SCT PC CIVIL

Telangana State Level Police Recruitment Board issued a direct recruitment of 16,925 vacancies for SCT PCs Civil or equivalent Posts. Total Candidates that were to take the Preliminary Written Test were 4,78,567.

Fill OMR for TSLPRB PC POSTS

The Preliminary Written Test for the Recruitment of SCT PCs Civil or equivalent Posts has conducted in 966 Examination Centers located in 40 Places main cities and attended 4,49,584 Candidates attended the Test. Preliminary Key will be given within a few days on the official website: www.tslprb.in

How to submit objections for Preliminary Key:

Candidates can login to Mobile Number, as their Login ID. If any objections on Preliminary Key, It is once again cautioned that every individual question objection, has to be separately submitted. Candidates will giving 3 days time to submit Objections Performa in the Web Template made.

Read More