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

What does the VLOOKUP function do.

Question # 2

To protect a worksheet, you can choose protection and the protect sheet from the menu.

Question # 3

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

Question # 4

When working in the page break preview you can.

Question # 5

Each excel file is called a workbook because.

Question # 6

Gridines

Question # 7

Paper spreadsheets can have all the same advantages as an electronic spread sheet except which of the following.

Question # 8

Excel is a.

Question # 9

Which is following is not an option in the spelling dialog box.

Question # 10

Which function calculates your monthly mortage payment.

Question # 11

To drag a selected range of data to another worksheet in the same workbook use the.

Question # 12

How can you remove borders applied in cells.

Question # 13

Except for the ...............function a formula with a logical function shows the word "TRUE" or "FALSE" as a result.

Question # 14

When Integrating MS-Word and Excel, Word in usually the

Question # 15

Where can you set the shedding color for a range of cells in Excel.

Question # 16

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

Question # 17

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

Question # 18

Merge cells option can be applied from.

Question # 19

What term refers to a specific set of values saved with the workbook.

Question # 20

Which of the following is not a worksheet design criterion.

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
  • S
    Sajawal Javed 03 - Jan - 2022 05 Min 40 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

PPSC Class ComputerScience Chapter 4 Important MCQ's

Sr.# Question Answer
1 When yu use the fill effects in the format data series dialog box you can not.
A. Rotate text on the chart
B. Select a fore ground color
C. Select a pattern
D. Select a background color
2 To create an interactive pivot table for the web you use a Microsoft Office web component called.
A. HTML
B. Pivot Table field list
C. Pivot Table list
D. Pivot Table Report
3 When you insert an excel file into a word document the data are.
A. Hyperlinked
B. Placed in a word table
C. Linked
D. Embedded
4 To copy cell contents using drag and drop press the.
A. End key
B. Shift key
C. Esc key
D. None of above
5 How do you change column width to fit the contents.
A. Single click the boundary to the left to the column heading
B. Double click the boundary to the right of the column heading
C. Press Alt and single click any ware is the column
D. All of above
6 Which of the following is not a valid zoom percentage in Excel.
A. 10
B. 100
C. 500
D. 300
7 Which of the following is not a worksheet design criterion.
A. Efficiency
B. Auditability
C. Description
D. Clarity
8 To center worksheet titles across a range of cell you must.
A. Select the cells containing the title text and use the fill handle to center the text across a range of cells.
B. Widen the columns
C. Select the cells containing the title text and use the fill handle to center the text across a range of cells.
D. Widen the column
9 What does the VLOOKUP function do.
A. Looks up text that contain
B. Checks whether text is the same in one cell as in the next
C. Finds related records
D. All of above
10 What feature enables yo to adjust or back solve the value in a cell to reach a desired outcome in a formula.
A. Goal seek
B. Scenario summary report
C. Forecasting
D. Trend line

Test Questions

Is this page helpful?