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

In a worksheet yo can select

Question # 2

Which function will you use to enter current time in a worksheet cell.

Question # 3

When you print preview a worksheet.

Question # 4

Merge cells option can be applied from.

Question # 5

How can you remove borders applied in cells.

Question # 6

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

Question # 7

Each excel file is called a workbook because.

Question # 8

How are data organized in a spread sheet.

Question # 9

What feature enables yo to adjust or back solve the value in a cell to reach a desired outcome in a formula.

Question # 10

You can print only an embedded chart by

Question # 11

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

Question # 12

Excel is a.

Question # 13

The cell reference for a range of cells that starts in cell B1 and goes over to column G and down to row 10 is

Question # 14

You can quickly change the appearance of your work by choosing Auto format from the Menu.

Question # 15

You can add an image to a template by clicking the insert picture from file button on the toolbar

Question # 16

What is the keyboard shortcut for creating a chart from the selected cells.

Question # 17

Which of the following setup options can not be set in the page setup dialog box.

Question # 18

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

Question # 19

Pre-made sheet formats like simple classic accounting colorful can be applied from.

Question # 20

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

Submit

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


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
Sr.# Question Answer
1 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
2 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
3 In a worksheet yo can select
A. The entire worksheet
B. Rows
C. Columns
D. a,b and c
4 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
5 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
6 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
7 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
8 When the formula bar is activated you can see.
A. The Edit formula button
B. The cancel button
C. The Enter button
D. All of above
9 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
10 What is the keyboard shortcut for creating a chart from the selected cells.
A. F3
B. F6
C. F11
D. F7
11 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
12 How can you remove borders applied in cells.
A. Choose none on border tab of format cells.
B. Open the list on border tool in formatting toolbar then choose fist tool
C. Both of above
D. None of above
13 The autofill feature
A. Extends a sequential series of data
B. Automatically adds a range of cell values
C. Applies a boarder around selected cells.
D. None of above
14 What is an expression that tells how the numbers in a determined set of cells are to be calculated.
A. Formula
B. Field
C. Data
D. query
15 To drag a selected range of data to another worksheet in the same workbook use the.
A. Tab key
B. Alt key
C. Shift key
D. Ctrl key
16 The spelling tool is placed on _____________ toobar.
A. Standard
B. Formatting
C. Drawing
D. Reviewing
17 Which of the following setup options can not be set in the page setup dialog box.
A. Printer selection
B. Vertical or horizontal placement
C. Orientation
D. Raw and column titles
18 Which function will you use to enter current time in a worksheet cell.
A. = today()
B. =now()
C. = time()
D. = current time()
19 When you print preview a worksheet.
A. The entire worksheet is displayed
B. The selected range is displayed
C. The active portion of the worksheet is displayed
D. a , b and c
20 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

Test Questions

Is this page helpful?