1.
Find the odd man out:
Microwaves
2.
To have your macro available to all new documents you create, store it in:
The Normal template
3.
To move to the previous cell in a table inserted in a document, press:
Shift+Tab
4.
To get step-by-step instructions as you go through the Word mail merge process, use:
The Mail Merge Wizard
5.
A ____ is a major database object used to display information in a printable page format:
Report
6.
The percentage increase in the area of a rectangle, if each of its sides is increased by 20% is:
44%
7.
When inserting a graphic into a worksheet, you could go to cell A1 by pressing:
CTRL+HOME
8.
To be compatible with previous versions of Microsoft Word, a Word 2013 document should be saved with this extension:
.doc
9.
Which option displays fill color in alternate rows in an Excel table?
Banded Rows
10.
What function displays row data in a column or column data in a row?
Transpose
11.
When typing character search criteria, Excel matches fields based on:
Alphabetical order
12.
When you insert a picture into a document, the default text wrapping option is:
In Line with Text
13.
What is the sum of this series 1, 2, 3, 4, ... 99?
3000
14.
The most common types of storage devices are:
Magnetic
15.
What category of functions is used in this formula? = PMT(C10/12, C8, C9, 1)
Financial
16.
Which is the largest fraction?
7/8
17.
Each sector on a hard drive stores ____ bytes of data:
512
18.
What does an I-beam facilitate?
Highlighting text
19.
An unauthorized user is a network ____:
Reliability issue
20.
A car left Lahore at 7:12 am and arrived at a certain place, 180 miles distant, at 10:57 am. What was its average speed in miles per hour?
48
21.
Which of the following is not a major reason for an email bounce?
Domain server is down
22.
When you insert a comment in a document, the comment appears in a:
Balloon
23.
Which function automatically totals a column or row of values?
SUM
24.
The information inside your table needs to be sorted alphabetically. To do this, you go to:
Table Tools Layout
25.
What is the missing number? 1 4 9 ? 25
16
26.
Why might you hide worksheets in a workbook?
Some data is private
27.
User developed instructions for Excel are called:
Macros
28.
What term describes a picture that has been resized by a percentage?
Scaled
29.
How can words be separated in a range name?
With a period
30.
A Word template stores common document:
Structure
31.
In which view does a page break appear as a black dashed line on the screen?
Normal
32.
The synonym of "Commence" is:
To Begin
33.
A man is 24 years older than his son. In two years, his age will be twice the age of his son. The present age of his son is:
22 years
34.
Find the odd man out:
Cucumber
35.
If the code for JAVA is LCXC, what is the code for BASIC?
DCUKE
36.
For what can you use Outlook Tasks?
Manage to-do items
37.
What is Do-while?
Exit control loop
38.
What should follow the sheet name in a 3-D formula?
Exclamation point
39.
Excel would evaluate the formula, =20*10/5*8, and return this answer:
320
40.
What do you see if you hover the mouse over a chart object?
ScreenTip
41.
Afzal mixed 40% kerosene solution to 25% kerosene solution, hence obtaining a 30% kerosene solution. In what ratio were both solutions mixed?
1:2
42.
Protecting a worksheet means:
To lock cells in the worksheet so that a user cannot inadvertently change them
43.
A driver drives 8 km South, then 6 km West, and 2 km South again. She then drives 3 km East to avoid a traffic jam before driving 6 km North. How many kilometers is she from her starting point?
5
44.
Which of the following is reliable communication?
TCP
45.
What term describes shaped text?
WordArt
46.
If ADD = 9, BAD = 7, and CAD = 8, what is the value of ADA?
6
47.
Which of the following will determine your choice of systems software for your computer?
Is the applications software you want to use compatible with it?
48.
A drive that can be removed or inserted while the computer is running is said to be ____.
Hot swappable
49.
Before you create labels such as name tags, specify the size by selecting:
Label Options
50.
A man buys an item for Rs. 1400 and sells it at a loss of 15%. What is the selling price of the item?
Rs. 1190
51.
In a Rich Text content control field, the text:
Can be formatted
52.
In the formula, =10 + 5 + 15 + 25/5, Excel computes this first:
25 / 5
53.
Where is the address of the active cell displayed?
Name Box
54.
Find the odd man out:
London
55.
You can evenly adjust spacing in columns and rows by using the Table Tool called:
Snap to Grid
56.
This describes the size, weight, and spacing of a character in a Word document:
Font
57.
When you want to combine cells in any given table row, you:
Merge
58.
There are two different ways to insert content from one application into another: embedding and:
Linking
59.
What term describes a feature that gives Excel enhanced capability?
Add-in
60.
A cube has a volume of 8 cubic meters. If each side is doubled in length, what will its new volume be in cubic meters?
64
61.
The best tool to use to create a hierarchical flow chart in Word is:
SmartArt
62.
Insert the missing number: 3, 7, 6, 5, 9, 3, 12, 1, 15, (__,)
-1
63.
What is the least number by which 294 should be multiplied to make it a perfect square?
6
64.
The average weight of A, B, and C is 45 Kg. If the average weight of A and B is 40 Kg and that of B and C is 43 Kg, then the weight of B is:
31 Kg
65.
A vessel is filled to its capacity with pure milk. Ten liters of milk is withdrawn from it and replaced by water. The procedure is repeated again. The vessel now has 32 liters of milk. Find the capacity of the vessel (in liters):
50
66.
A combination of instructions and keystrokes that are stored and used in documents is called:
A shortcut
67.
What is the name for a webpage address?
URL
68.
To what does the term "page orientation" refer?
Whether a page is laid out vertically or horizontally
69.
A ____ is a data communication system within a building, plant, or campus, or between nearby buildings:
LAN
70.
Which is NOT a method of creating a table in MS Access?
Layout View
71.
When you are working on a document, Word automatically saves your document:
Every 10 minutes
72.
The price of a certain item increased by X% per week over two successive weeks. If at the beginning, 2 kg was available for Rs. 80 and after two weeks they were available for Rs. 105.80, what is the value of X?
15
73.
Which alignment choice spreads the data across the width of the cell?
Distributed
74.
Where does Word insert a table of contents?
Before the document title
75.
When the Reviewing pane is open, the title of that pane is:
Revisions
76.
If \(a - b = 3\) and \(a^2 + b^2 = 29\), find the value of \(ab\):
12
77.
Connections to the Internet using a phone line and a modem are called ___ connections.
Dial-up
78.
Your ____ files store various versions of running programs.
Temp
79.
The rules that dictate how the various parts of a formula are written in a table and else where are called:
Syntax
80.
A sum of money at simple interest amounts to Rs. 815 in 3 years and Rs. 854 in 4 years. The sum is:
Rs. 698
81.
Which one of the following is not a prime number?
91
82.
Which number will come next? 5, 7, 10, 12, 14, 24, 26
28
83.
____ is a technique that is used to send more than one call over a single line?
Multiplexing
84.
What is the background for a chart called?
Chart area
85.
What dialog box allows you to change a field name in a PivotTable?
Field Settings
86.
What is a synonym for Contradict?
To oppose by words
87.
If the hour hand of a clock is turned anticlockwise from 2 pm to 9 am, through how many degrees will it have turned?
150 degrees
88.
A man has some hens and cows. If the number of heads is 48 and the number of feet equals 140, then the number of hens will be:
22
89.
The Sort command of the Data menu provides this capability:
Multiple-column
90.
You want to create a built-in cover page for your report. You go to the:
Insert tab
91.
Which view shows margins and the ruler?
Page Layout
92.
Data that is copied from an application is stored in the ____:
Clipboard
93.
Akram thought of a number, added 7, multiplied by 3, took away 5, and divided by 4 to give an answer of 7. What was the starting number?
4
94.
Data communication requires:
All of these
95.
From what location are the first computer instructions available on boot up?
ROM BIOS
96.
If Excel disables and notifies you about a macro, how can you enable the macro?
Click the option in the security message panel
97.
What is the binary value of 200?
11001000
98.
To open a template in Word, first go to File and:
Click New
99.
A social security number or a telephone number is considered to be this type of entry in a worksheet:
Text
100.
Which of the following functions is a database function?
DPART