. If particular workbook have to open each time Excel started, where that workbook should be placed?


Options: AUTOEXEC Folder B. AUTOSTART Folder C. EXCELSTART Folder D. XLSTART Folder

Ans:– D ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 10310 | Level: Moderate




Got some suggestion about this question or to make this site better? Please leave your comments below.


Want to see where do you stand among other aspirants in "Computer" Category?

Click Here to take quick 5 mins MCQ test to find out.

More MS-Excel Related questions:


. Background color or effects applied on a document is not visible in
Options: a. Web layout view b. Print Layout view c. Reading View d. Print Preview

Ans:– D,– D


Which statement is true regarding classless routing protocols? The use of discontiguous networks is not allowed. The use of variable length subnet masks is permitted. RIPv1 is a classless routing protocol. IGRP supports classless routing within the same autonomous system. RIPv2 supports classless routing.
Options: 1, 3 and 5,    3 and 4,    2 and 5,    None of the above

Ans:C ,C


. A collection of related tables is called
Options: a. Row b. Record c. Database d. File

Ans:– c,– c


Binary search algorithm can not be applied to
Options: a. sorted linked list b. sorted binary trees c. sorted linear array d. pointer array

Ans:- a,- a


Out of fgets() and gets() which function is safe to use?
Options: gets(),    fgets(),    ,    

Ans:B ,B


. Paste Special allows some operation while you paste to new cell. Which of the following operation is valid?
Options: a.  Square b.  Percentage c.  Goal Seek d.  Divide

Ans:– d,– d


. ASCII and EBCDIC are the popular character coding systems. What does ASCII stand for?
Options: A) American Stable Code for International Interchange B) American Standard Case for Institutional Interchange C) American Standard Code for Information Interchange D) American Standard Code for Interchange Information

Ans:C,C


A type of instruction that can produce several lines of machine language code is a
Options: Mnemonic,    Address,    Macro,    assemble

Ans:C ,C


A factor which would strongly influence a businessperson to adopt a computer is its:
Options: Accuracy,    Reliability,    Speed,    All of the above

Ans:D ,D


. Who built the world’s first electronic calculator using telephone relays, light bulbs and batteries?
Options: A) Claude Shannon B) Konrard Zues C) George Stibits D) Howard H. Aiken

Ans:C,C


The fastest read/write time and most efficient data storage of any disk array type is:
Options: RAID-0.,    RAID-1.,    RAID-2.,    RAID-3.

Ans:A ,A


Which of the following memories contains a thin film of magnetic material sandwitched between two permanent bias magnets?
Options: ROM,    Magnetic disk,    Core memory,    Bubble memory

Ans:C,C


When was punched-card equipment used for the first time to process the British census?
Options: 1910,    1907,    1911,    1914

Ans:C ,C


What command can be used to get information about yourself?
Options: which,    pwd,    i /4,    who am i

Ans:D ,D


Which of the following device is used with an X.25 network to provide service to asynchronous terminals
Options: repeater,    bridges,    gateway,    Packet assembler/disassemble

Ans:D ,D


  How can the slide show be repeated continuously?
Options: loop continuously until ‘Esc’ B. repeat continuously     C. loop more D. none

Ans:– A ,


. When was Apple Macintosh II microcomputer introduced in the market?
Options: A) 1964 B) 1970 C) 1983 D) 1986

Ans:C,C


. From which menu you can access Picture, Test Box, Chart etc?
Options: a.  File b.  Edit c.  Insert d.  View

Ans:5 – C ,5 – C


. How to fit long texts in a single cell with multiple lines?
Options: a. Start typing in the cell and press the Enter key to start another line b. Use the Wrap Text option in the Format -> Alignment menu c. Use the Shrink to Fit option in the Format -> Cells -> Alignment menu d. All of above

Ans:– b,– b


How much should an organisation spend for information can be determined by some type of a:
Options: cost analysis,    benefit analysis,    cost-benefit analysis,    any of the above

Ans:C ,C


. Scandisk analyze and repair damage to which of the following?
Options: a. Physical clusters b. FAT c. Lost clusters d. All of the above

Ans:6 – d ,6 – d


Which of the following, is necessary to work on a computer
Options: Compiler,    Operating system,    Assembly,    Interpreter of the above

Ans:B ,B


. System files allocated at
Options: a. Boot area b. FAT area c. Data area d. Directory

Ans:0 – a ,0 – a


What shell's wild-card is used to match a single character?
Options: [!ijk],    [ijk],    ?,    *

Ans:C ,C


What allows you to print on both sides of the printer?
Options: fuser,    duplexer,    toner cartridge,    paper-swapping unit

Ans:B ,B


Which memory allocation policy allocate the largest hole to the process?
Options: Best-Fit B. Worst-Fit C. First-Fit D. None of them

Ans:– B ,


Who is considered to be the "father" of artificial intelligence?
Options: Fisher Ada,    John McCarthy,    Allen Newell,    Alan Turning

Ans:B ,B


If you begin typing an entry into a cell and then realize that you don’t want your entry placed into a cell, you:
Options: a. Press the Erase key b. Press Esc c. Press the Enter button d. Press the Edit Formula button

Ans:#8211; b,#8211; b


To activate the previous cell in a pre-selected range, press
Options: a. The Alt key b. The Tab key c. The Enter key d. None of the above

Ans:D,None of the above


. Validation Rule in a field will
Options: a. Checks the value entered when user leaves the field b. Displays the value in specified format when user leaves the field c. Defines the appearance for the text d. There is no option of Validation Rule

Ans:– a,– a


A dialog box with a bomb appears oh a Macintosh screen. What type of problem has occurred?
Options: A RAM problem,    A software problem,    A ROM problem,    An ADB problem

Ans:B ,B


The approach used in top-down analysis and and design is
Options: to prepare flowcharts after programming has been completed,    to identify a top level function and then create a hierarchy of lower level modules and components,    to identify the top level functions by combining many smaller components into a single entity.,    All of the above

Ans:B ,B


Procedure development occurs within the
Options: structured design phase,    conversion phase,    system building phase,    maintenance

Ans:C ,C


What is the most likely cause of an "FDD controller Failure" error message?
Options: you did not set the jumper on the floppy drive to drive A,    you forgot to flash CMOS,    you installed the floppy disk drive cable backward,    your computer's floppy drive is defective

Ans:C ,C


The workspace required for a robot:
Options: is less than that of a human performing the same task,    depends upon the robot used,    is not dependent on the application.,    must be enclosed by a fence

Ans:B ,B


Which of the following activities, does not belong to the Implementation phase of the SDLC?
Options: File conversion,    Program testing,    User training,    All of the above

Ans:B ,B


Which of the following isn't a type of computer facility?
Options: decentralized,    centralized,    de-distributed,    distributed

Ans:C ,C


Data link layer retransmits the damaged frames in most networks. If the probability of a frame's being damaged is p, what is the mean number of transmissions required to send a frame if acknowledgements are never lost.
Options: P I (K + 1),    KIK (1 + F),    1/ (1 - F),    K I (K - P)

Ans:C ,C


You save the configuration on a router with the copy running-config startup-config command and reboot the router. The router, however, comes up with a blank configuration. What can the problem be?
Options: You didn't boot the router with the correct command.,    NVRAM is corrupted.,    The configuration register setting is incorrect.,    The newly upgraded IOS is not compatible with the hardware of the router.

Ans:C ,C


What do you mean by a Workspace?
Options: Group of Columns B. Group of Worksheets C. Group of Rows D. Group of Workbooks

Ans:– D ,


The first machine to successfully perform a long series of arithmetic and logical operations was:
Options: ENIAC,    Mark I,    Analytic engine,    UNIVAC-I

Ans:B ,B


What types of installations require a special boot disk?
Options: NFS,    FTP,    PCMCIA,    All of the above

Ans:D ,D


. Which of the following commands should you always use before submitting a document to others?
Options: a. find command b. Replace command c. Spelling and Grammar d. Thesaurus

Ans:–  C,–  C


. Programs are executed on the basis of a priority number in a
Options: A) Batch processing system B) Multiprogramming C) Time sharing D) None of these

Ans:B,B


To select a block of text, click at the beginning of the selection, scroll to the end of the selection, position the mouse pointer at the end of the selection, hold down the _____ key, and then click (or drag through the text).
Options: a. ctrl b. alt c. shift d. tab

Ans:– c,– c


38. What is the shortcut key to split a table?
Options: a. Ctrl + Alt + Enter b. Ctrl + Shift + Enter c. Alt + Shift + Enter d. Alt + Space + Enter

Ans:–  B ,–  B


The rotating coil of wire in an electric motor is called the:
Options: armature,    brush,    commutator,    loop

Ans:A ,A


To test for AC ripple on a PC power supply, you would set the volt/ohm meter for:
Options: DC voltage scale,    AC voltage,    OHM scale,    Farad scale

Ans:B ,B


What was the name of the first commercially available micro¬processor chip?
Options: Intel 8008,    Intel 8080,    Intel 4004,    Motorola 6809

Ans:C ,C


80. You cannot close MS Word application by
Options: a. Choosing File menu then Exit submenu b. Press Alt+F4 c. Click X button on title bar d. From File menu choose Close submenu

Ans:– D ,– D

www.000webhost.com