Which is an example of a formula?


Options: =A1+A2 B. =add(A1:A2) C. A1+A2 D. SUM(A1:A2)

Ans:– A ,


Description: mcqquestions

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

Hits Today: 19909 | Level: Moderate


******************************************************

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

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




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




More MS-Excel Related questions:


A reflective marker that indicates the end of the usable tape is
Options: End user,    End-of-tape,    Optical mark reader,    FAX

Ans:B ,B


The ODBC Level 2 API contains which the following functions?
Options: Commit or rollback transactions only,    Connect to data sources with driver-specific information only,    Connect to data sources only,    All of the above are contained in the OBDC Level 2 API

Ans:D ,D


Which of the following is often used as an alternative to the light pen or in association with storage tube displays?
Options: Digitiser,    Track ball,    Mouse,    Tablet

Ans:D ,D


After doing a low-level format, what would be the next step in configuring the hard drive in a system?
Options: Format DOS partition,    Install operating system,    Configure DMA channel and back-up interrupt,    Partition had disk

Ans:A ,A


Fork is
Options: the dispatching of a task,    the creation of a new job,    the creation of a new process,    increasing the priority of a task

Ans:C ,C


A word field may consist of an optional field instruction called a(n) ______
Options: subdocument B. symbol C. signal D. switch

Ans:– D ,


How many tables may be included with a join?
Options: One,    Two,    Three,    All of the above.

Ans:D ,D


. The shortcut keys for the _____ character formatting are ctrl+ shift+ plus sign.
Options: a. case of letters b. underline words, not spaces c. superscript d. all capital letters

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 ,B


Which of the following registers hold the information before it goes to the decoder
Options: control register,    data register,    accumulator,    address register

Ans:B ,B


In order to use a DBMS, it is important to understand
Options: the physical schema,    all sub-schemas that the system supports,    one subschema,    both (a) and (b)

Ans:C ,C


A language based on graphics for use in education is
Options: PROLOG,    LOGO,    COBOL,    BASIC

Ans:B ,B


. WAN is a most used abbreviation in Newtorking, what is its full form?
Options: A) WAP Area Network B) Wide Area Network C) Wide Array of Network D) Wireless Access Network

Ans:B,B


The no of logical records in a physical record is
Options: Group,    Blocking factor,    Sector,    Field

Ans:B ,B


. Which of the following is not the Section Break Option?
Options: a. Next Page b. Previous Page c. Odd Page d. Even Page

Ans:–  B,–  B


What are reasons for creating OSPF in a hierarchical design? To decrease routing overhead To speed up convergence To confine network instability to single areas of the network To make configuring OSPF easier
Options: 1, 2 and 3,    3 only,    3 and 4,    2, 3 nd 4

Ans:A ,A


We can receive data either through our television aerial or down our telephone lines and display this data on our television screen. What is the general name given to this process?
Options: Viewdata,    Teletext,    Telesoftware,    Videotex

Ans:D ,D


. Which colors are used to define a custom color?
Options: a. Red, Blue, Yellow b. Red, Green, Blue c. Blue, Green, Orange d. Green, Orange, Violet

Ans:0 – b ,0 – b


As alternatives are evaluated, the best one is recognized as the one
Options: best enabling the system to meet its objectives,    representing lowest cost,    with the most advantages,    with the least disadvantages

Ans:A ,A


. What value will display if the formula = “$55.00″+5 is entered into a cell?
Options: a. $60 b. 60 c. “$55.00″+5 d. $60.00

Ans:– b,– b


Which of the following is not used for storage purposes with main frame computers?
Options: removable disks,    fixed disks,    mass storage systems,    diskettes

Ans:D ,D


The term PUSH and POP is related to the
Options: a. array b. lists c. stacks d. all of above

Ans: c, c


What is the difference between the kinds of charges for an electron and a proton?
Options: An electron has a positive charge and a proton has no charge,    An electron has a positive charge and a proton has a negative charge,    An electron has a negative charge and a proton has a positive charge,    An electron has a negative charge and a proton has no charge

Ans:C ,C


The ALU and control unit of most of the microcomputers are combined and manufactured on a single silicon chip. What is it called?
Options: Monochip,    Microprocessor,    ALU,    Control Unit

Ans:B,B


A prewritten program that's sold to perform a common task is called an application
Options: System software,    Package,    Utilities,    Program

Ans:B ,B


_____ help prevent power surges.
Options: Surge suppressor,    Spike protector,    UPS system,    High-grade multi-meter

Ans:A ,A


For a memory system, the cycle time is
Options: same as the access time,    longer than the access time,    shorter than the access time,    submultiple of the access time

Ans:B ,B


What does RIPv2 use to prevent routing loops? CIDR Split horizon Authentication Classless masking Holddown timers
Options: 1 and 3,    2, 3 and 5,    2 and 5,    3 and 4

Ans:C ,C


What is the easiest way to place same graphic in same place in all slides
Options: Place graphic in Notes Master B. Place graphic in Slide Master c. Place graphic in Handout Master D. Place graphic manually in all slide

Ans:– B ,


77. To switch between insert mode and overtype mode, _____.
Options: a. click Caption on the Insert menu b. double-click the OVR status indicator on the status bar c. click Text Box on the Insert menu d. double-click the INS status indicator on the status bar

Ans:– B ,– B


The first items defined for a new system are its :
Options: inputs,    outputs,    storage,    processing

Ans:B ,B


. In Access 2007, to make changes in the Trust Center, you need to go to the ____.
Options: a. Microsoft Office button b. Navigation Pane c. Quick Access toolbar d. Database Tools command tab

Ans:1 – a ,1 – a


What is the most significant difference between the USB and IEEE1394 standards?
Options: IEEE 1394 is faster,    USB does not support USB,    USB is plug and play,    IEEE 1394 is hot swappable

Ans:A ,A


Assuming 100% efficiency, what is the power being consumed at the secondary winding of the transformer described in question 91?
Options: 200 W,    1000 W,    20 W,    100 W

Ans:A ,A


. Which Form tool creates a new form that show both a form and datasheet views?
Options: a. Form b. Form Wizard c. Multiple Item Form d. Split Form

Ans:1 – d ,1 – d


What is a motion path?
Options: a. A type of animation entrance effect b. A method of advancing slides c. A method of moving items on a slide d. All of the above

Ans: – C , – C


The complexity of the average case of an algorithm is
Options: a. Much more complicated to analyze than that of worst case b. Much more simpler to analyze than that of worst case c. Sometimes more complicated and some other times simpler than that of worst case d. None or above  

Ans:a,a


What is bytecode?
Options: Machine-specific code,    Java code,    Machine-independent code,    None of the above is correct.

Ans:C ,C


Which component must be vacuumed or replaced during preventative maintenance on a laser printer?
Options: Scanning mirror,    Toner cartridge,    Ozone filter,    All of the above

Ans:C ,C


A computer has a 1024K memory. What does the letter K stand for
Options: Kilometre,    Thousand,    1024,    MB

Ans:C,C


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

Options: A) Duping B) Booting C) Padding D) CPS

Ans:B,B


Which of the following describe router functions?
Options: Packet switching,    Packet filtering,    Internetwork communication,    Path selection

Ans:E ,E


A top-to-bottom relationship among the items in a database is established by a
Options: Hierarchical schema,    Network schema,    Relational schema,    All of the above

Ans:A ,A


We can remove a relationship defined between two tables by
Options: a. From Edit menu choose Delete Relationship b. Select the relationship line and press Delete c. Choose Delete option from Relationship menu d. All of above

Ans:ndash; b,ndash; b


The problem of thrashing is affected significantly by:
Options: program structure,    program size,    primary-storage size,    all of the above

Ans:A ,A


What does Belady’s Anomaly related to?
Options: Page Replacement Algorithm B. Memory Management Algorithm C. Deadlock Prevention Algorithm D. Disk Scheduling Algorithm

Ans:– A ,


Which is not the function of “Edit, Clear” command?
Options: a. Delete contents, B. Delete notes, C. Delete cells, D. Delete formats

Ans:C ,Delete cells


Latches constructed with NOR and NAND gates tend to remain in the latched condition due to which configuration feature?
Options: asynchronous operation,    low input voltages,    gate impedance,    cross coupling

Ans:D ,D


Capacitance is measured in units of:
Options: volts,    amps,    farads,    neutrinos

Ans:C ,C


A computer program that instructs other programs to perform a particular type of operation is
Options: System software,    Application program,    Compiler,    Interpreter

Ans:A ,A

www.000webhost.com