1.Which one is wireless?
keyboard,mouse,touchpad,all of above
- which statement is correct:
(Data on RAM erased after restart:ans) - In which one we can edit,rename,move copy and delete files?
Internet explorer,windows explorer,MS Office,Control panel - How to format a USB?
(ans. using left click and “format”) - How impact printer works? (Ans: by banging a head or needle against ink ribbon to
mark paper) - Disk format command in DOS
- 5 Essential parts of computer
EXCEL: - 2 custom number formats like Q18 of Model paper
- Which one is optional in VLOOKUP syntax?
- COUNT numerical
- Average numerical
- What can be done in a shared workbook?
- How to lock particular cells?
- HOw to Export data to text file
- Shortcut to insert Line Break
- Can different colours be applied in text in a cell?
Scenario Ques on traffic signal icon set condtional formatting
- Which function is correct?(4 IF functions were given)
WORD: - Print shortcut
- How to apply Left Align
- What does CAPTION do?
- Which one is not available in Watermark options?(ans. Vertical)
- a section break once inserted can be removed by?
- In MS Word, Table of Contents is created by:
(a) using the built-in heading styles
(b) applying the font size and style from Font group on the Home tab
(c) using table Style Options in the Table Tools Design tab
(d) both (a) and (b) - Which can be applied simultaneously?(ans. strike through and superscript)
- Use of autofit function
- Short key to centre allign
- Change style dropdown menu can perform
- In which layout watermark is visible
- Maximum levels in table of contents
- Foot note end note
- Styles ribbon
POWERPOINT: - Header
- How to Remove transitions from all the slides?
- Templates in powerpoint helpul in?
- scenario type for using charts,text box;format
- Maximum columns in Table
- How to Autofit Coulmn’s width?
- Which is correct: (ans. two pictures can be added in a single slide)
- Which option is not transition
- Which steps for making graph are correct
- how many ways to edit header
- Convinient way to edit footer
- What options we have in screenshot
- locked drawing shape
- How to edit slides
- Which printer prints on carbon paper
a)dot matrix b)thermal printer c)lesar printer d)inkjet printer - if you add chart on “microsoft word” and then you want to change the chart type
then in which type it can be changed
A)any type you want b)only line type c) only bar type d)it cant be changed - how can you align the paragraph on WORD
a) ctrl+j b) ctrl+a - watermark
- if you merge cells from a1:a7 how it forms
A) centre align and bottom line b) centre align and upperword line - merge and compare work book
- in Microsoft word shortcut key of direct print view
- in excel formula =vlookup () what is optional
- excel if there (j7=6) (k7=5) then =NOT (J7+K7=10)
- you add header and footer in excel then you can edit it by
A) only add photo B)only add text c) you can add both photo and text on header/footer - if you add digital signature on worksheet then
A)it is marked as final b)you can invisible signature c) it can be edit by pressing the edit
anyway d) both - font on excel
- add table on WORD and you can change the columns of it upto
A)63 b)10 c)12 d) - excel a1=2 ,a2=4 ,a3=6 ,a4=2 ,a5=02/11/2014 ,a6=3 then =add (a1:a6,2)
A) 7 B) 21 C) 6 D) - team pAkistan =Proper (a1)
A) TEAM PAKISTAN B) Team Patistan c) team pakistan d) - use of find and selet key on excel ribbon
- if write something on word then how it can be deleted
- custom number formating
- chart is used for ?
- if worksheet is shared then what you can do
A) compare and merge cell b)delete workbook c) edit it anyway - What is RAM
- transitions effect
- table of contents
- how workbook/worksheet can update
A) auto b) manual c) d) - slides
- page break
- conditional formating
- RANK
- RANGE
- presentation
- what can you add on slides
A)audio b)photos c)both
81 Excel -Functions (Subtotal, Count, CountA, CountIf)
-Array
-Charts
-Custom Number Formate - Sacatter Chart is Used for what?
- Values were given and you have to put them in Custom number Formate for
Canadiam Formate. - if you have to count Positve number in cells, which functiom will you use?
- Something about Line Chart.
- PowerPoint
-Transiotions Effects
-Scenarios - You are a Dept head and you were given a work to make a presentation and you have
to provide your employees way that everyone can make it Easily? - How to Update Table?
1st Three Chapters Theory.
-Printers
-Commands - What is Command for Formate Hard disk?
- Which Printer Type by Strikingin page?
- ipconfig is used for what?
EXCEL
-Shortcut key of break line
-To share workseet
-Subtotal function
-Count
-Sumif
-Contional formating in scenario based
-Header & Footer
-Charts
-Shapes on text
-Signature line
-Indeet
-What is Theme?
-ROM & RAM Def : According to correct option
-Import text Data File SAve in ? (Txt) ANS
-Track Changes
WORD
-Maximum heigt of row ?
-Watermark
-Table of content
-Smartart
-Footnote
Word
-Table Of Contents ( Most most Important Topic)
-Paragraph Spacing
If you have done Table of Contents in word then you can easily Attempt Word portion in
yourIT paper.
POWERPOINT
-Slides
-Animations
-Front default
–Insert pics from options ?
-Insert Table
-By Default slide orientation ?
-In slide First placeholder we HAve option ? : Normal , Slide Shorter , Notes master ,(
Slider master : Right )
-Printer Theory
PowerPoint
-Transiotions Effects
-Scenarios
Q) You are a Dept head and you were given a work to make a presentation and you have
to provide your employees way that everyone can make it Easily?
Q) How to Update Table?
Q)
Word
-Table Of Contents ( Most most Important Topic)
-Paragraph Spacing
If you have done Table of Contents in word then you can easily Attempt Word portion in
yourIT paper.
1st Three Chapters Theory.
-Printers
-Commands
Q) What is Command for Formate Hard disk?
Q) Which Printer Type by Strikingin page?
Q) ipconfig is used for what?
Excel
-Functions (Subtotal, Count, CountA, CountIf)
-Array
-Charts
-Custom Number Formate
Q) Sacatter Chart is Used for what?
Q) Values were given and you have to put them in Custom number Formate for
Canadiam Formate.
Q) if you have to count Positve number in cells, which functiom will you use?
Q) Something about Line Chart.