Home
News
Colleges
Courses
Admission
Lectures
Online Test
Past Papers
Date Sheets
Results
Study Abroad
Jobs
Tutors
More
Apps
.jpg)
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
PPSC Computer Science Topic 4 Microsoft Excel
00:00
Question # 1
When yo see a cell with a red tringle in the top right comer what does this signify.
Question # 2
To drag a selected range of data to another worksheet in the same workbook use the.
Question # 3
Which of the following methods can not be used to enter data in a cell.
Question # 4
How are data organized in a spread sheet.
Question # 5
What Pivot table toolbar button updates the data in a pivot table or pivot chart report if the source data Chas changed.
Question # 6
To hold row and column title sin place so that they do not scroll when you scroll a worksheet click the
Question # 7
You can edit existing Excel data by pressing the
Question # 8
You can use the horizontal and vertical scroll bars to.
Question # 9
The spelling tool is placed on _____________ toobar.
Question # 10
You can activate a cell by
Question # 11
Except for the ...............function a formula with a logical function shows the word "TRUE" or "FALSE" as a result.
Question # 12
If you need a text to show vertically in a cell .how will you achieve this.
Question # 13
A data map is helpful
Question # 14
What do we call a computer program that organizes data in rows and columns of cells? You might use the type of program to keep a record of the money you keep a record of the money you earned moving lawns over the summer.
Question # 15
When working in the page break preview you can
Question # 16
When the formula bar is activated you can see.
Question # 17
When you insert an excel file into a word document the data are.
Question # 18
Which is following is not an option in the spelling dialog box.
Question # 19
You can add an image to a template by clicking the insert picture from file button on the toolbar
Question # 20
A function inside another function is called a ................ function.
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 | When working in the page break preview you can. |
A. View exactly where each page break occurs.
B. Add or remove page breaks
C. Change the print area
D. All of above
|
| 2 | 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
|
| 3 | Which of the following describes how to select all the cells in a single column. |
A. Right click on column and select pick from list
B. Use data text to columns menu item
C. Left click on the gray column title button
D. Pressing Ctrl + A on the keyboard
|
| 4 | Charts tips can |
A. Show the formatting of a data label
B. Show the name of a data series
C. Show the value of data point
D. B and C
|
| 5 | Which of the following format you can decide to apply or not in auto format dialog box. |
A. Number format
B. Border format
C. Font format
D. All of above
|
| 6 | What Pivot table toolbar button updates the data in a pivot table or pivot chart report if the source data Chas changed. |
A. Format Report
B. Pivot table
C. Refresh Data
D. Show detail
|
| 7 | In a worksheet yo can select |
A. The entire worksheet
B. Rows
C. Columns
D. a,b and c
|
| 8 | Which types of charts can excel produce. |
A. Line graphs and pie charts only
B. Only line graphs
C. Bar charts line graphs and pie charts
D. Bar charts and line graphics only
|
| 9 | Except for the ...............function a formula with a logical function shows the word "TRUE" or "FALSE" as a result. |
A. IF
B. AND
C. OR
D. NOT
|
| 10 | Can you set 0.5 inch left indentation for a cell in Excel. |
A. Excel does not have indentation feature
B. You can specify indentation only if you turn the rulers on
C. Indentation can be set from format cells dialog box
D. The indentation can be specified only when printing
|
Test Questions
Share your comments & questions here
No comments yet. Be the first to comment!