Home
News
Colleges
Courses
Admission
Lectures
Online Test
Past Papers
Date Sheets
Results
Study Abroad
Jobs
Tutors
More
Apps
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
How are data organized in a spread sheet.
Question # 2
The name box
Question # 3
You can open the scenario manager dialog box by choosing scenarios from the ..............menu
Question # 4
You can quickly change the appearance of your work by choosing Auto format from the Menu.
Question # 5
When working in the page break preview you can
Question # 6
What is the keyboard shortcut for creating a chart from the selected cells.
Question # 7
When creating a vertical page break.
Question # 8
To hold row and column title sin place so that they do not scroll when you scroll a worksheet click the
Question # 9
Excel is a.
Question # 10
A function inside another function is called a ................ function.
Question # 11
To drag a selected range of data to another worksheet in the same workbook use the.
Question # 12
What is a quick way to extend these numbers to a longer sequence for instance 1 through 20
Question # 13
Hyperlink cannot be
Question # 14
What feature enables yo to adjust or back solve the value in a cell to reach a desired outcome in a formula.
Question # 15
When working in the page break preview you can.
Question # 16
Macros are 'run' or executed from the ...........menu
Question # 17
You can open the Highlight changes dialog box by choosing track changes from the menu.
Question # 18
Charts tips can
Question # 19
Which of the following methods can not be used to enter data in a cell.
Question # 20
What term described a back ground that appears as a grainy non smooth surface.
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 ComputerScience Chapter 4 Important MCQ's
| Sr.# | Question | Answer |
|---|---|---|
| 1 | What is the keyboard shortcut for creating a chart from the selected cells. |
A. F3
B. F6
C. F11
D. F7
|
| 2 | You can check the conditions against ______ when applying conditional formating. |
A. Cell value
B. Formula
C. Both of above
D. None of above
|
| 3 | You can copy data or formulas |
A. With the copy paste and cut commands on the edit menu
B. With commands an a shortcut menu
C. With buttons on the standard toolbar
D. All of the above
|
| 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 | The spelling tool is placed on _____________ toobar. |
A. Standard
B. Formatting
C. Drawing
D. Reviewing
|
| 6 | Merge cells option can be applied from. |
A. Format cells dialog box alignment tab.
B. Formatting toolbar
C. Both of above
D. None of above
|
| 7 | 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
|
| 8 | When creating a vertical page break. |
A. The active cell must be A1
B. The active cell can be anywhere in the worksheet.
C. The active cell must be in row 1
D. The active cell must be in column A
|
| 9 | 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
|
| 10 | You can set page border in Excel from |
A. From border tab in format cells dialog box
B. From Border tool in formatting toolbar
C. From line style tool in Drawing toolbar
D. You can not set page border in Excel
|
Test Questions
