General Computer Test - 76

 

1. Which operation is not performed by computer

(a)    Inputting

(b)    Processing

(c)     Controlling

(d)    Understanding

(e)    Thinking

Ans : (d)

2. The computer that process both analog and digital is called

(a)    Analog computer

(b)    Digital computer

(c)     Hybrid computer

(d)    Mainframe computer

(e)    Super computer

Ans : (c)

3. A right click on the desktop itself will ……………..

(a)    open the Display Properties dialog box

(b)    show a context-sensitive menu

(c)     open the Control Panel

(d)    minimize all open applications

(e)    None of these

Ans : (a)

4. The window which shows icons for things like the mouse, sound, and display is…….

(a)    My Computer or computer

(b)    Explorer

(c)     Control Panel

(d)    Taskbar

(e)    programs

Ans : (c)

5. ……….refers to a computer’s ability to configure and use a device without human interaction.

(a)    CPU

(b)    Plug and Play

(c)     Cache

(d)    ALU

(e)    Format

Ans : (b)

6. When was the first windows operating system launched?

(a)    1984

(b)    1985

(c)     1988

(d)    1989

(e)    1990

Ans : (b)

7. Today’s computer giant IBM was earlier known by different name which was changes in 1924. What was that name?

(a)    Tabulator Machine Co.

(b)    Computing Tabulating Recording Co.

(c)     The Tabulator Ltd.

(d)    International Computer Ltd.

(e)    None of these

Ans : (b)

8. The process of starting a or restarting a computer system by loading instructions from a secondary storage device into the computer memory is called

(a)    Duping

(b)    Booting

(c)     Padding

(d)    CPS

(e)    None of these

Ans : (b)

9. What does the disk drive of a computer do?

(a)    Rotate the disk

(b)    Read the disk

(c)     Load a program from the disk into the memory

(d)    Both (b) and (c)

(e)    All (a), (b) & (c)

Ans : (d)

10. IMB launched its first personal computer called IBM-PC in 1981. It had chips from Intel, disk drives from Tandon, operating system from Microsoft, the printer from Epson and the application software from everywhere. Can you name the country which contributed the video display?

(a)    India

(b)    China

(c)     Germany

(d)    Taiwan

(e)    Japan

Ans : (d)

11. In H2O the figure 2 is appeared lowered. Which effect has been applied?

(a)    Superscript

(b)    Lowered

(c)     Subscript

(d)    Laid down

(e)    None

Ans : (c)

12. A Laptop or Notebook marked 802.11n in its feature, it means device support

(a)    Bluetooth

(b)    WiMAX

(c)     USB

(d)    Wi-Fi LAN

(e)    3G

Ans : (d)

13. You Tube service of streaming videos online in provided by

(a)    Google

(b)    Microsoft

(c)     IBM

(d)    Apple

(e)    Sony

Ans : (a)

14. When using characters in Windows, what code does Windows use?

(a)    ASCII

(b)    UNICODE

(c)     MORSE

(d)    IDBC

(e)    WESTRN

Ans : (b)

15. Which is the latest type of printer interface?

(a)    Serial

(b)    DVI

(c)     Parallel

(d)    USB

(e)    none

Ans : (d)

16. To produce a high-quality graphics (hardcopy) in color, you would want to use a

(a)    Virtual Printer

(b)    Laser Printer

(c)     Ink-Jet Printer

(d)    Plotter

(e)    RGB Monitor

Ans : (d)

17. What is Mail-Merge?

(a)    a web based e-mail service with no spam

(b)    a name of Yahoo! MINDSET search feature

(c)     a new virus-hoax which can delete data from mail-inbox

(d)    a feature of MS-Word used to create multiple documents like letters, mailing labels, name tags etc.

(e)    None of these

Ans : (d)

18. The process of checking the validity of information held in a transaction file is

(a)    Verification

(b)    Test data

(c)     Validation

(d)    Updating

(e)    None of these

Ans : (c)

19. A shares hardware, software, and data among authorized users.

(a)    network

(b)    protocol

(c)     hyperlink

(d)    transmitter

(e)    None of these

Ans : (a)

20. Which of the following is not a function of the control unit?

(a)    Read instructions

(b)    Execute instructions

(c)     Interpret instructions

(d)    Direct operations

(e)    None of these

Ans : (d)

21. Software for organizing storage and retrieval of information is a(n)………

(a)    operating system

(b)    database

(c)     database program

(d)    data warehouse

(e)    None of these

Ans : (c)

22. Which of the following is not true about RAM?

(a)    RAM is a temporary storage area

(b)    RAM is the same as hard disk storage

(c)     RAM is volatile

(d)    Information stored in RAM is gone when you turn the computer off

(e)    None of these

Ans : (b)

23. The main directory of  a  disk  is  called  the directory.

(a)    root

(b)    sub

(c)     folder

(d)    network

(e)    None of these

Ans : (a)

24. SUM (B1:B8) is an example of a………..

(a)    function

(b)    formula

(c)     cell address

(d)    value

(e)    None of these

Ans : (b)

25. The most common input devices include ………&………..

(a)    Monitor and keyboard

(b)    Monitor and mouse

(c)     Mouse and keyboard

(d)    Printer and mouse

(e)    None of these

Ans : (c)

General Computer Test - 75

 

1. Each excel file is called a workbook because :

(a)    It can contain text and data

(b)    It can be modified

(c)     It can contain many sheets including worksheets and chart sheets

(d)    You have to work hard to create it

(e)    None of these

Ans : (c)

2. Which types of charts can excel produce?

(a)    Line graphs and pie charts only

(b)    Only line graphs

(c)     Bar charts, line graphs and pie charts

(d)    Bar charts and line graphs only

(e)    None of these

Ans : (c)

3. How are data organized in a spreadsheet?

(a)    Lines and spaces

(b)    Layers and planes

(c)     Rows and Columns

(d)    Height and width

(e)    None of these

Ans : (c)

4. What does the VLOOKUP function do?

(a)    Looks up text that contain ‘v’

(b)    Checks whether text is the same in one cell as in the next

(c)     Finds related records

(d)    All of these

(e)    None of these

Ans : (c)

5. Gridlines :

(a)    May be turned off for display but turned on for printing

(b)    May be turned on or off or printing

(c)     The be turned off for display and printing

(d)    All of these

(e)    None of these

Ans : (d)

6. You can print only an embedded chart by

(a)    Moving the chart to a chart sheet before you print.

(b)    Formatting the chart before you print

(c)     Selecting the chart before you print

(d)    Both (a) and (c)

(e)    None of these

Ans : (d)

7. Which of the following is a correct order of precedence in a formula calculation?

(a)    Multiplication and division, exponential positive and negative value

(b)    Multiplication and division, positive and negative values, addition and subtraction

(c)     Addition and subtraction, positive and negative values, exponentiation

(d)    All of these

(e)    None of these

Ans : (e)

8. A function inside another function is called a function

(a)    Nested

(b)    Round

(c)     Sum

(d)    Text

(e)    None of these

Ans : (a)

9. How should you print a selected area of a worksheet, if you’ll want to print a different area next time?

(a)    On the file menu, point to print area, and then click set print area.

(b)    On the file menu, click print, and then click selection under print what

(c)     On the view menu, click custom views, then click add

(d)    All of these

(e)    None of these

Ans : (b)

10. Your German supplier still invoices for parts in deutsche marks.

(a)    On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign.

(b)    On the tools menu, click Add-Ins, and select the Euro Currency Tools check box

(c)     Apply a selected background color

(d)    All of these

(e)    None of these

Ans : (b)

11. Which function calculates your monthly mortgage payment?

(a)    PMT (payments)

(b)    NPER (number of periods)

(c)     PV (present value)

(d)    All of these

(e)    None of these

Ans : (a)

12. If you are working in English (US), Chinese or Japanese, Excel 2002 can speak data as you enter it, to help you verify accuracy. How do you activate this feature?

(a)    Point to speech on the tools menu, and then click show text to speech toolbar.

(b)    Click validation on the data menu

(c)     Point to speech on the tools menu, and then click speech recognition

(d)    All of these

(e)    None of these

Ans : (a)

13. Which of the following methods cannot 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

(e)    None of these         

Ans : (c)

14. Which of the following will not set text in selected cells to italics?

(a)    Pressing Ctrl + I on the keyboard

(b)    Using the Tools – Wizard – Web Form menu item

(c)     Using the Format – Cells – Font menu item

(d)    All of these

(e)    None of these

Ans : (b)

15. Which of the following methods cannot be used to edit the content of cell?

(a)    Pressing the Alt key

(b)    Clicking the formula bar

(c)     Pressing F2

(d)    Double clicking the cell

(e)    None of these

Ans : (a)

16. To insert three columns between columns D and E you would :

(a)    Select column D

(b)    Select column E

(c)     Select columns E, F and G

(d)    Select columns D, E, and F

(e)    None of these

Ans : (b)

17. To enter worksheet titles across a range of cell, you must :

(a)    Select the cells containing the title text and use the fill handle to center the text across a range of cells

(b)    Widen the columns

(c)     Select the cells containing the title text and use the fill handle to center the text across a range of cells

(d)    Widen the column

(e)    None of these

Ans : (a)

18. When integrating MS-Word and Excel, Word is usually the :

(a)    Server

(b)    Source

(c)     Client

(d)    All of these

(e)    None of these

Ans : (c)

19. 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)    Both (b) and (c)

(e)    None of these

Ans : (b)

20. The Name box :

(a)    Shows the location of the previously active cell

(b)    Appears the left of the formula bar

(c)     Appears below the status bar

(d)    Appears below the menu bar

(e)    None of these

Ans : (b)

21. How do you change column width to fit the contents?

(a)    Single-click the boundary to the left to the column heading

(b)    Double click the boundary to the right of the column heading

(c)     Press Alt and single click anywhere in the column

(d)    All of these

(e)    None of these

Ans : (b)

22. When you work with large worksheets, you may need to :

(a)    size the worksheet to fit on the specific number of pages

(b)    add and remove page breaks

(c)     specify only certain print areas

(d)    all of these

(e)    None of these

Ans : (d)

23. Hyperlinks cannot be :

(a)    Special shapes like stars and banners

(b)    Drawing objects like rectangles ovals

(c)     Pictures

(d)    All can be hyperlinks

(e)    None of these

Ans : (d)

24. You can use the horizontal and vertical scroll bars to :

(a)    Split a worksheet into two panes

(b)    View different rows and columns

(c)     Edit the contents of a cell

(d)    View different worksheets

(e)    None of these

Ans : (b)

25. What do we call a computer program that organizes data in rows and columns of cells? You might use this type of program to keep a record of the money you earned moving lawns over the summer.

(a)    Spreadsheet program

(b)    Database program

(c)     Word processor program

(d)    Desktop publisher program

(e)    None of these

Ans : (a)