PPSC Computer Science Topic 4 MCQ's Test Preparation

Microsoft Excel is one of the most popular applications created by Microsoft. Millions of individuals and offices around the globe benefit from the power of Excel to create spreadsheets, perform calculations, draw graphs, and do much more. Understanding how Microsoft Excel works and the benefits one can get by using it is an important part of your PPSC Computer Science exam preparation. You might have been utilizing this software for years, but getting to know how this software works can make you prepared for your upcoming PPSC exam. Start preparing about Microsoft Excel right now by starting your PPSC online test on IlmKiDunya.

Choosing IlmKiDunya for PPSC Preparation

By taking the free PPSC online test on IlmKidunya, you can get better prepared for your PPSC exam. The PPSC online tests on our website are designed specifically to meet the syllabus criteria of PPSC exams. Start taking tests right now and get ready for the PPSC Computer Science exam.

MCQ's Test For PPSC Computer Science Topic 4 Microsoft Excel

Try The MCQ's Test For PPSC Computer Science Topic 4 Microsoft Excel

  • Total Questions20

  • Time Allowed20

Start Test Download PDF

PPSC Computer Science Topic 4 Microsoft Excel

00:00
Question # 1

You can check the conditions against ______ when applying conditional formating.

Question # 2

The name box

Question # 3

What is a quick way to extend these numbers to a longer sequence for instance 1 through 20

Question # 4

When you print preview a worksheet.

Question # 5

To copy cell contents using drag and drop press the.

Question # 6

When you insert an excel file into a word document the data are.

Question # 7

To insert three columns between columns D and E you would.

Question # 8

In a worksheet yo can select

Question # 9

To active the previous cell in a pre selected range press.

Question # 10

When yo see a cell with a red tringle in the top right comer what does this signify.

Question # 11

Which of the following is not a valid zoom percentage in Excel.

Question # 12

What Pivot table toolbar button updates the data in a pivot table or pivot chart report if the source data Chas changed.

Question # 13

Merge cells option can be applied from.

Question # 14

A function inside another function is called a ................ function.

Question # 15

"tr 1,, tr 2,tr 3" is an example of a

Question # 16

If you press ........the cell accepts your typing as the contents.

Question # 17

Hyperlink cannot be

Question # 18

You can open the sort dialog box by choosing sort from the .....menu.

Question # 19

To hold row and column title sin place so that they do not scroll when you scroll a worksheet click the

Question # 20

How do you change column width to fit the contents.

Submit

Prepare Complete Set Wise PPSC Computer Science Topic 4 Microsoft Excel MCQs Online With Answers


Topic Test

00:00
Submit

Top Scorers Of PPSC Computer Science Topic 4 Microsoft Excel MCQ`s Test

  • M
    Muqaddas Ashiq 20 - Jun - 2024 00 Min 41 Sec 20/20
  • M
    Muhammad Afzaal 30 - Mar - 2022 02 Min 33 Sec 20/20
  • A
    Akbar Khan 03 - Feb - 2022 04 Min 32 Sec 19/20
  • T
    Tehniat Saddiq 15 - Jun - 2022 03 Min 07 Sec 17/20
  • Y
    younis masih 30 - May - 2024 03 Min 45 Sec 16/20
  • A
    Arshad Mehmood 13 - Jun - 2024 08 Min 10 Sec 16/20
  • S
    Sara Khan 04 - Aug - 2024 03 Min 21 Sec 15/20
  • H
    hatim 25 - Dec - 2022 03 Min 38 Sec 15/20
  • M
    Muhammad Safwan 11 - Mar - 2023 04 Min 09 Sec 14/20
  • S
    Shamim Goraya 07 - Jan - 2022 06 Min 20 Sec 13/20
  • R
    Ramla Siddiqui 26 - Dec - 2023 08 Min 40 Sec 13/20
  • U
    Usman Bubak 13 - Jan - 2022 11 Min 38 Sec 13/20
  • S
    Shaheer Jutt 09 - Nov - 2022 03 Min 16 Sec 12/20
  • P
    prince sman 14 - Nov - 2024 04 Min 06 Sec 12/20
  • N
    Nimra Ramzan 26 - Sep - 2024 06 Min 12 Sec 12/20

PPSC ComputerScience Chapter 4 Important MCQ's

Sr.# Question Answer
1 Hyperlink cannot be
A. Special shapes like stars and banners
B. Drawing objects like rectangles ovals
C. Pictures
D. All can be hyperlinks
2 To insert three columns between columns D and E you would.
A. Select column D
B. Select column E
C. Select columns E, F and G
D. Select column D , E and F
3 Gridines
A. May be turned off for display but turned on for printing.
B. May be turned on or off for printing
C. The be turned off for display and printing.
D. a, b and c
4 What term refers to a specific set of values saved with the workbook.
A. Range
B. Scenario
C. Trend line
D. What if analysis
5 A data map is helpful
A. When you have too much data to chart
B. To show a geographic distribution of data
C. To compare data points
D. To show changes in data over time
6 Where can you set the shedding color for a range of cells in Excel.
A. Choose required color form patterns tab of format cells dialog box
B. Choose required color on fill color tool in formatting toolbar
C. Choose required color on fill color tool in drawing toolbar
D. All of above
7 Got function? No ? you need the insert function dialog box. How do you get it.
A. Right click a cell and then click insert.
B. Click the insert menu and then click function
C. Type = in a cell
D. As of the above
8 Which function will you use to enter current time in a worksheet cell.
A. = today()
B. =now()
C. = time()
D. = current time()
9 The name box
A. Show the location of the previously active cell
B. Appears the left of the formula bar
C. Appears below the status bar
D. Appears below the menu bar
10 When yo see a cell with a red tringle in the top right comer what does this signify.
A. There is an error in the cell
B. There is a comment associated with the cell
C. The font color for text in the cell is red
D. A formula connot be entered into the cell

Test Questions

Is this page helpful?