CTD Punjab Police Past Papers MCQs 2018 – 2024

What are the shortcut keys to paste special?

1. ALT + H + V + F
2. ALT + H + V + P
3. ALT + H + V + O
4. ALT + H + V + S

A ____ is like a summary table of the dataset that enables you to create reports and analyze trends.

1. data table
2. pivot table
3. trend table
4. summary
5. report

What is the shortcut keyboard to edit formulas in a cell?

1. F2
2. F4
3. CTRL +1
4. CRTL + F

Which tab of the ribbon should you go to for removing gridlines on a worksheet?

1. Formulates
2. View
3. Review
4. Developer

Which of the following features cannot be found in the data ribbon?

1. What-If Analysis
2. PivotTable
3. Data Validation
4. Text to Columns

A ___ is a single chip with two or more separate processor cores.

1. transistor
2. multi-core processor
3. resistor
4. capacitor
5. processor

suppose you want the headings in your document to appear in bold and in a particular color and font size. Although you can manually set each formatting option individually for each header, it is much easier to use a _______ that applies all of these options at once.

1. format painter
2. paste special
3. style
4. copy-paste

You want to add your favorite command to a quick access bar. 1) when you find a favorite command, right-click it, and then click add to quick access toolbar. 2) goto file>options>quick access toolbar and add selected commands

1. only option I
2. only option II
3. option I and option II
4. Neither option I and option II

To create an index , you mark the index enteries by providing the ____- of the main entry and the ____ in your document, and then you build the index.

1. cross-reference, name
2. name , cross-reference
3. link, cross-reference
4. link, name