0. In Excel _______ may not contain in Formula


Options: Text Constant B. Number Constant C. Circular Reference D. All of them

Ans: – C ,


Description: mcqquestions

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

Hits Today: 18791 | 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:


The unit of hardware an operator uses to monitor computer processing is the:
Options: Card reader,    CPU,    Line printer,    Console

Ans:D ,D


Which is not a data source component?
Options:  A) mail merge toolbar, B) header row, C) data fields, D) data records, 

Ans:A,Mail merge toolbar


Multiprogramming
Options: is a method of memory allocation by which the program is subdivided into equal portions, or pages and core is subdivided into equal portions or blocks.,    consists of those addresses that may be generated by a processor during execution of a computation.,    is a method of allocating processor time.,    allows multiple programs to reside in separate areas of core at the time.

Ans:D ,D


. Disk label name can be up to ….characters
Options: a. 8 b. 9 c. 11 d. 255

Ans:9 – c ,9 – c


. The traditional mechanical mouse uses a __________ to track the pointer position on the screen.
Options: a. light sensor b. wheel c. ball d. ruler

Ans:1 – c ,1 – c


Which fields are contained within an IEEE Ethernet frame header? Source and destination MAC address Source and destination network address Source and destination MAC address and source and destination network address FCS field
Options: 1 and 4,    2 only,    2 and 3 only,    3 only

Ans:A ,A


. Multiprogramming systems:
Options: a. Are easier to develop than single programming systems b. Execute each job faster c. Execute more jobs in the same time period d. Are used only one large mainframe computers.

Ans:5 – c ,5 – c


What is the impedance of a circuit composed of a 100 ohm resistor connected in parallel with a capacitor that has a reactance of 100 ohm?
Options: 60 Ohm,    99.3 Ohm,    250 Ohm,    70.7Ohm

Ans:D ,D


In LISP, the function evaluates <object> and assigns this value to the unevaluated <sconst>.
Options: (constant <sconst> <object>),    (defconstant <sconst> <object>),    (eva <sconst> <object>),    (eva <object> <sconst>)

Ans:B ,B


A master document contains_________, each of which contains a pointer to a file on a
Options: A. Placeholders B. subdocuments C. bookmarks D. references

Ans:B ,subdocuments


Which of the structure is correct? 1 : struct book { char name[10]; float price; int pages; }; 2 : struct aa { char name[10]; float price; int pages; } 3 : struct aa { char name[10]; float price; int pages; }
Options: 1,    2,    3,    All of above

Ans:A ,A


. Which of the following methods CANNOT be used to delete records from a table?
Options: a. Selecting records and pressing [Delete] b. Pressing [Ctrl]+[’] c. Clicking the Delete Record button d. From the ribbon, selecting Delete Record

Ans:4 – b ,4 – b


. In the datasheet formatting dialogue box, which is not an option in the border and line styles dropdown list box?
Options: a. datasheet border b. datasheet underline c. Column Header underline d. vertical gridline

Ans:– c,– c


Which access method is used for obtaining a record from a cassette tape?
Options: Direct,    Sequential,    Random,    All of the above

Ans:B,(Banswer


The data recording area between the blank gaps on magnetic tape is called a/ an:
Options: Record,    Block,    Field,    Database

Ans:B ,B


What does Ctrl + = key effect?
Options:  A) Superscript, B) Subscript, C) All Caps, D) Shadow,

Ans:-B,-B


The geostationary satellite used for communication systems
Options: rotates with the earth,    remains stationary relative to the earth,    is positioned over equator,    All of the above

Ans:D ,D


. A ....is a flash memory storage device that plugins into a USB port
Options: a. USB snapdrive b. USB flashdrive c. USB memory makerdrive d. None of above

Ans: b, b


Which of the following data structure cant store the non-homogeneous data elements?
Options: a. Arrays b. Records c. Pointers d. None  

Ans:a,a


The ALU of a computer normally contains a number of high speed storage elements called
Options: semiconductor memory,    registers,    hard disk,    magnetic disk

Ans:B ,B


Two connected routers are configured with RIP routing. What will be the result when a router receives a routing update that contains a higher-cost path to a network already in its routing table?
Options: The updated information will be added to the existing routing table.,    The update will be ignored and no further action will occur.,    The updated information will replace the existing routing table entry.,    The existing routing table entry will be deleted from the routing table and all routers will exchange routing updates to reach convergence.

Ans:B ,B


In a database table, the category of information is called ____________
Options: a. tuple b. field c. record d. All of above

Ans:dash; b,dash; b


. Borders can be applied to
Options: a. cells b. paragraph c. text d. All of above

Ans: – D , – D


A storage area used to store data to compensate for the difference in speed at which the different units can handle data is
Options: Memory,    Buffer,    Accumulator,    Address

Ans:B ,B


Which of the following are kinds of instructions?
Options: Input,    Arithmetic,    Conditional branching,    All of the above

Ans:D ,D


In which year were chips used inside the computer for the first time?
Options: 1964,    1975,    1977,    1981

Ans:B,B


Properly arranged data is called
Options: A) Field B) Words C) Information D) File

Ans:-C,-C


Which of the following are benefits of VLANs? They increase the size of collision domains. They allow logical grouping of users by function. They can enhance network security. They increase the size of broadcast domains while decreasing the number of collision domains. They simplify switch administration. They increase the number of broadcast domains while decreasing the size of the broadcast domains.
Options: 1 and 5,    2 and 4,    1, 3 and 5,    2, 3 and 6

Ans:D ,D


Which of the following is true of parallel transmission?
Options: It involves the simultaneous transmission of eight bits.,    The speed is quoted in bits per second.,    It is slower than serial trans¬mission.,    Most microcomputers commu¬nicate with other computers in this mode.

Ans:A ,A


The hardware device Jhat acts as both a switching and connecting unit is called a(n):
Options: concentrator,    RS-232C port,    multiplexer,    communications processor

Ans:C ,C


  To draw the Square box in the slide by selecting rectangle tool A.  Holding CTRL & Draw B.  Holding ALT & Draw C.  Holding SHIFT & Draw D.  All of the above
Options:

Ans:– C ,


. Which of the following statement is true?
Options: a. Foreign key fields don’t allow duplicate values b. In primary key field you can enter duplicate value c. In an indexed field you may or may not enter duplicate value depending upon setting d. All statements are true

Ans:3 – c ,3 – c


Decision support programs are designed to help managers make:
Options: budget projections,    visual presentations,    business decisions,    vacation schedules

Ans:C ,C


. What is represented by the small, black square in the lower-right corner of an active cell or range?
Options: a. Copy handle b. Fill handle c. Insert handle d. Border

Ans:– b,– b


Which common bus specification provides the fastest data transfer rate?
Options: VL bus,    ISA,    PCI,    All of the above

Ans:C ,C


Which command can force all buffers to disk?
Options: save,    sync,    edbuff,    flush

Ans:B ,B


. Computer operators
Options: A) writes computer programs for specific problems B) operate the device which input and output data from the computer C) normally require a college degree in computer science D) all of the above

Ans:B,B


. What is defined by Handout Master?
Options: a. Slide Formatting b. Slide Transaction c. Layout of Handout d. Layout of Slide

Ans:6 – C ,6 – C


. Which of the following format you can decide to apply or not in AutoFormat dialog box?
Options: a. Number format b. Border format c. Font format d. All of above

Ans:– d,– d


hat is the shortcut key to display field codes?
Options: Alt + F9 B. Ctrl + F9 C. Shift + F9 D. Space + F9

Ans:– A ,


. Which electronic component was made out of semiconductor material?
Options: A) Vacuum tubes B) Transistors C) Ics D) All of above

Ans:C,C


. A name or number used to identify storage location devices?
Options: A) A byte B) A record C) An address D) All of above

Ans:3-C,3-C


The main electronic component used in first generation computers was
Options: A) Transistors B) Vacuum Tubes and Valves C) Integrated Circuits D) None of above

Ans:-B,-B


. A term associated with the comparison of processing speeds of different computer system is:
Options: A) EFTS B) MPG C) MIPS D) CPS

Ans:C,C


If every non-key attribute is functionally dependent on the primary key, the relation will be in
Options: First Normal Form B. Second Normal Form C. Third Normal Form D. Fourth Formal Form

Ans:– C ,


The model curriculum for information-system education suggested by the _____ has a more theoretical and conceptual basis, whereas the model by the _____ is more practical and applied in nature.
Options: AI, ES,    KBS, AI,    ACM, DPMA,    SISD, MMD

Ans:C ,C


Which values are held in CMOS for the hard drive
Options: size (heads, cylinders, sectors),    IRQ,    Free space,    Virus alert

Ans:A ,A


Information about the items ordered (item description, price, warehouse location, etc.) is provided by the
Options: order entry subsystem,    manufacturing information system,    marketing information system,    billing subsystem

Ans:B ,B


. What determines a table’s sort order?
Options: a. AutoNumber field b. Index field c. Field order d. Primary key

Ans:– b,– b


ESD would cause the most damage to which component?
Options: Power supply,    Expansion board,    Monitor,    Keyboard

Ans:B ,B

www.000webhost.com