PPSC Intelligence Officer Past Papers Special Branch

Which of the following is not a worksheet design criterion?

1. Efficiency
2. Aditibility
3. Description
4. Clarity

To insert Page Break we press:

1. Ctrl + Tab
2. Ctrl + Enter
3. Ctrl + Alt
4. Ctrl + Shift

The parliament of Srilanka is called:

1. Federal Congress
2. People's Congress
3. Parliament
4. National Congress

A feature that displays only the data in column (s) according to specified criteria

1. Filtering
2. Sorting
3. Formula
4. None

What type of chart will you use to compare performance of sales of two products ?

1. Pie Chart
2. Line Chart
3. Column Chart
4. None

Which feature is used to make selected sentence to All Captital Letters or All Small Letters ?

1. Change case
2. Change letter
3. Change sentence
4. Change word

Office 365 is now the most popular cloud application in the world. But when did it debut?

1. 2011
2. 2010
3. 2008
4. None

Which of these key are used to apply outline border to the selected cell in MS Excel?

1. CTRL+SHIFT+ %
2. CTRL+SHIFT+ &
3. CTRL+SHIFT+ ~
4. CTRL+SHIFT+ $

What type of chart is useful for comparing values over categories?

1. Line Chart
2. Column Chart
3. Pie Chart
4. None

The kitchen was infested ___ ants

1. with
2. by
3. to
4. in