What makes a computer fast? Your answer: Microprocessor(CPU) speed Bus line size RAM speed Availability of cache All of the Above

In cell D2, a student's average grade is written. If this grade is less than 50, what is the formula that says FAILED, otherwise PASSED? Your answer.

=IF (D2>50,"PASS", "FAIL") =IF(D2<50, "FAILED", "PASSED") =IF(D2<=50, "FAILED", "PASSED") =IF(D2<49, "FAILED", "PASSED") =IF(D2>=49, "PASSED", "FAILED")

Which of the following functions gives the number of grades 50 and above in a grade list in excel Your answer:

COUNT

COUNTBLANK

COUNTIF

IF

MAX

Which one of the following statements about formulas in Microsoft Excel is FALSE? Your answer: Formulas can contain numbers or cell references Formulas contain mathematical operators

Formulas can begin with any character or value

Formulas can contain functions

The result of the formula is displayed in the cell in which you have entered the formula

The device which modulates outgoing digital signals from a computer to analog signals for a telephone line and demodulates the incoming analog signal and converts it to a digital signal for the computer is called Your answer.

ethernet card CD-ROM diskette modem Windows

Which of the following function counts blank cells in exce

MIN COUNT COUNTA ISBLANK COUNTBLANK

The computer peripheral that captures images from photographic prints, posters, magazine pages, and similar sources for computer editing and display is called an) Your answer: webcam keyboard printer scanner joystick

You want to add a mathematical symbol in your word document. How can you do this? Your answer:

On menu bar click => Insert => Object => Microsoft Maths

On menu bar click => Insert => Symbol => Maths

On menu bar click => Insert => Equation

On menu bar click => Insert => Symbol

On menu bar click => Home => Maths

In Microsoft Excel, if a range of 5 cells displayed the following, 4, blank, 18, 26, ali, 11 what value would Excel display using the COUNT function? Your answer:

8 6 5 3 4

What is a URL? Your answer: A web, e-mail or ftp address for the browsers O A graphic image on the World Wide Web O A group of keyboard keys O Part of the monitor screen O A function in Microsoft Word

The computer peripheral device for retrieving electronic information on a compact disk is called a(n) Your answer: O mouse O diskette O CD-ROM O printer harddisk

In cell D2, a student's average grade is written. If this grade is less than 50, what is the formula that says FAILED, otherwise PASSED? Your answer.

=IF (D2>50,"PASS", "FAIL") =IF(D2<50, "FAILED", "PASSED") =IF(D2<=50, "FAILED", "PASSED") =IF(D2<49, "FAILED", "PASSED") =IF(D2>=49, "PASSED", "FAILED")

Which of the following functions gives the number of grades 50 and above in a grade list in excel Your answer:

COUNT

COUNTBLANK

COUNTIF

IF

MAX

Each computer connected to the Internet must have a unique number. What is the name of this number? Your answer: e-mail number ID number IP number BIOS number CHIP number

A computer loads an operating system into the computer's main memory or random access memory (RAM) after you switch it on. This process is called as Your answer:

Shut down Booting Warming up Formatting None of them

You write a big word document (it is 50 pages). Then you realize that you have written the word "science" as "sciense". You want to correct your mistake as quick you can. What should you do to overcome this problem? Your answer: Open the document and correct them one by one Use Find and Replace Use Correction toolbar Use Undo button Use Autocorrect

Which one of these is a computer storage unit? Your answer: Soft Disk Hard Disk Keyboard High Resolution Monitor Printer

If the formula =IF (8>10; "large", "small") is written in a cell in Excel, which of the following will be the display in that cell? Your answer:

small large 10 8 NULL

Which of the following formula finds the average of the values in cells B8 and C9? Your answer:

=B8+C9/2 B8+(C9)/2 =B8/C9/2 =(B8+c9)/2 =B8+c9

Which one of the following formulas does not contain a function? Your answer:

=AVERAGE(D6:D20)

=A4+B4+C4+D4+E4

=MAX(A13:E13)

=SUM(A1:A6)

=MIN(A1:A10)

Which one is a temporary storage system in a typical PC? Your answer:

RAM harddisk floppy disk paper BIOS

In Excel, which of the following functions calculates the arithmetic mean of a specific range of cells? Your answer:

TOTAL

MEAN

AVERAGE

MAX

ARITHMETIC AVERAGE

Which one is not one of the Power Point views? Your answer:

Slide show Slide Sorter View Print Preview Outline View Slide View

You write a big word document (it is 50 pages). Then you realize that you have written the word "science" as "sciense". You want to correct your mistake as quick as you can. What should you do to overcome this problem?

Open the document and correct them one by one Use Find and Replace Use Correction toolbar Use Undo button Use Autocorrect

Which of the following function counts blank cells in excel Your answer:

MIN COUNT COUNTA ISBLANK COUNTBLANK

Which of the following is not true? Your answer:

You can open a file with Notepad which have extension ".txt" You can open a file with Word which have extension" doc" You can open a file with Powerpoint which have extension".ppt" You can open a file with Excel which have extension "ex!" Tati can open a file with Acrobat Reader which have extension " pdf*

Text alignment commands in Microsoft Word allow us to control the layout (placement) of our document on the screen and paper. Which one of the following is not a text formatting option in Microsoft Word? Your answer:

Align Left Center justify Align Right Condense

Which one is not an operating system? Your answer: DOS Windows 98 Linux Microsoft Office Mac OS

The network with the largest geographical area is a Your answer:

MAN LAN WAN client/server peer-to-peer

Which one of the following statements about formulas in Microsoft Excel is FALSE? Your answer: Formulas can contain numbers or cell references Formulas contain mathematical operators Formulas can begin with any character or value Formulas can contain functions The result of the formula is displayed in the cell in which you have entered the formula

The equation in cell A8 is =E10 + E7 + 7 + A7. What will the equation in cell A9 be if the equation from cell A8 is copied to cell A9 Your answer:

=E11 + E8 + 8 + A8

=E9 + E6 + 6 + A6

=E9 + E6 + 6 + A8

=E11 + E8 + 7 + A8

Suppose that you want to draw graph of your data set. Which program would you use for that purpose? l Your answer: Word Excel Powerpoint Paint File Maker

You write a big word document (it is 50 pages). Then you realize that you have written the word "science" as "sciense". You want to correct your mistake as quick as you can. What should you do to overcome this problem? Your answer: Open the document and correct them one by one Use Find and Replace Use Correction toolbar Use Undo button Use Autocorrect

If the formula =IF (10>8; "large", "small") is written in a cell in Excel, which of the following will be the display in that cell? Your answer:

smal large 10 8 NULL

What is the purpose of headers and footers in a word document? Your answer: O You can change the case of letters there O It is a good tool to borders your page O You can see on all pages of your document the thing you write in header and footer section O You can see just on first page of your document the thing you write in header and footer section

It is a good tool to change page margins

Which of the following devices has the fastest access time? Your answer: Hard Disk

RAM Cache Floppy Disk CD-ROM

We can change the look of our documents in Microsoft Word by using different font faces. Which one of the following is not a font face avallable in Standard Microsoft Office? Your answer: Times New Roman CArlal Calibri O Handy O Courier

Which feature is not in MS PowerPoint? Your answer:

Zoom

Conditional formatting

Background color

Slide show

Notes

What is a (web) site? Your answer:

a view from the tpp a place on the Internet a key on the keyboard a part of the computer a place in a city where lots of people live

What will happen to data stored only in memory (RAM) when the computer is turned off? Your answer: Data will be saved. Data will be lost. Data will be backed-up. Data will be processed. None of the above

Which one is a temporary storage system in a typical PC? Your answer: RAM harddisk floppy disk paper BIOS

Which one of the following is not a computer peripheral? Your answer: webcam CPU printer scanner joystick