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

Can you set 0.5 inch left indentation for a cell in Excel.

Question # 2

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

Question # 3

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

Question # 4

What is an expression that tells how the numbers in a determined set of cells are to be calculated.

Question # 5

When you work with large worksheets you may need to

Question # 6

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

Question # 7

Which function calculates your monthly mortage payment.

Question # 8

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

Question # 9

What term described a back ground that appears as a grainy non smooth surface.

Question # 10

You can open the Highlight changes dialog box by choosing track changes from the menu.

Question # 11

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

Question # 12

The autofill feature

Question # 13

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

Question # 14

Got function? No ? you need the insert function dialog box. How do you get it.

Question # 15

What does the VLOOKUP function do.

Question # 16

How can you remove borders applied in cells.

Question # 17

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

Question # 18

What function displays row data in a column or column data in a row.

Question # 19

If you need a text to show vertically in a cell .how will you achieve this.

Question # 20

Macros are 'run' or executed from the ...........menu

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 Which of the following methods can not be used to enter data in a cell.
A. Pressing an arrow key
B. Pressing the tab key
C. Pressing the Esc key
D. Clicking the enter button to the formula bar
2 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
3 Excel is a.
A. Graphic program
B. Word processor
C. A spread sheet
D. None of these
4 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
5 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
6 Which function will you use to enter current time in a worksheet cell.
A. = today()
B. =now()
C. = time()
D. = current time()
7 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
8 What is a quick way to extend these numbers to a longer sequence for instance 1 through 20
A. Select both cells and then drag the fill handle over the range you want for instance 18 more rows.
B. Select the range you want include both cells point to till on the edit menu, and then click down.
C. Copy the second cell click in the cell below it on the standard toolbar click the down arrow on the paste button and than click paste special
D. All above
9 To copy cell contents using drag and drop press the.
A. End key
B. Shift key
C. Esc key
D. None of above
10 Pre-made sheet formats like simple classic accounting colorful can be applied from.
A. From format >> cells
B. From Table >> autoformat
C. From format >> autoformat
D. All of above

Test Questions

Is this page helpful?