. Multiple calculations can be made in a single formula using…..


Options: Standard Formulas B. Array Formula C. Complex Formulas D. Smart Formula

Ans: – B ,


Description: mcqquestions

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

Hits Today: 6203 | 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 _____ Contains fields of data about one entity.
Options: Record,    File,    Fields,    Document

Ans:A ,A


In CRC the quotient at the sender
Options: becomes the dividend at the receiver,    becomes the divisor at the receiver,    is discarded,    is the remainder

Ans:C ,C


. IBM 1401 is the first computer to enter in Nepal. It belonged to
Options: A) First Generation B) Second Generation C) Third Generatio D) Frouth Generation

Ans:B,B


The command to eliminate a table from a database is:
Options: REMOVE TABLE CUSTOMER;,    DROP TABLE CUSTOMER;,    DELETE TABLE CUSTOMER;,    UPDATE TABLE CUSTOMER;

Ans:B ,B


Which of the following statements are correct about 6 used in the program? int num[6]; num[6]=21;
Options: In the first statement 6 specifies a particular element, whereas in the second statement it specifies a type.,    In the first statement 6 specifies a array size, whereas in the second statement it specifies a particular element of array.,    In the first statement 6 specifies a particular element, whereas in the second statement it specifies a array size.,    In both the statement 6 specifies array size.

Ans:B ,B


The highest level in the hierarchy of data organization is called
Options: data bank,    database,    data file,    data record

Ans:B ,B


In which addressing mode the contents of a register specified in the instruction are first decremented, and then these contents are used as the effective address of the operands?
Options: index addressing,    indirect addressing,    auto increment,    auto decrement

Ans:D ,D


.  To assign a macro to an event, users need to open the form in Design View.
Options: a.            event b.            property c.           title d.           macro

Ans:– a,– a


43. When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is:
Options: a. unassigned b. located on the ten-key pad section of your keyboard. c. assigned to another task. d. from the same font family as the symbol.

Ans:– A ,– A


Which of the following file types has the least life
Options: Master file,    Program file,    Transaction file,    Work file

Ans:D ,D


Which DOS command would allow you to redirect a printer?
Options: Type,    Capture,    Mode,    Print

Ans:C ,C


Many large organizations have information _____ where managers can use fourth-generation languages to retrieve the facts they need from online data bases, and where staff experts are available to provide PC hardware/ software guidance.
Options: expert,    centers,    control,    MIS

Ans:B ,B


. The Third Generation Computer was made with ________.
Options: A) Vacuum Tube B) Discrete Components C) IC D) Bio Chips

Ans:C,C


John Napier invented Logarithm in
Options: A) 1614 B) 1617 C) 1620 D) None of above

Ans:-A,-A


RFM analysis uses customers' purchasing patterns to ________ .
Options: record transactions,    analyze and rank customers,    predict future sales using regression techniques,    perform OLAP

Ans:B ,B


A critical region is
Options: a program segment that has not been proved bug-free,    a program segment that often causes unexpected system crashes,    a program segment where shared resources are accessed,    one which is enclosed by a pair of P and V operations on semaphores

Ans:D ,D


What are the main parts of an atom?
Options: Protons only,    Electrons, protons, and ions,    Electrons, ions, and neutrons,    Electrons, protons, and neutrons

Ans:D ,D


Which of the following terms is the most closely related to main memory?
Options: nonvolatile,    permanent,    control unit,    temporary

Ans:D ,D


. In Excel _______ may not contain in Formula
Options: a. Text Constant b. Number Constant c. Circular Reference d. All of them

Ans:– c,– c


If you delete the contents of NVRAM and reboot the router, what mode will you be in?
Options: Privileged mode,    Global mode,    Setup mode,    NVRAM loaded mode

Ans:C ,C


The application layer of a network
Options: establishes, maintains, and terminates virtual circuits,    defines the user's port into the network,    consists of software being run on the computer connected to the network,    All of the above

Ans:C ,C


Which of the following signs is used to back up over typing errors in vi?
Options: @,    #,    $,    !

Ans:B ,B


In wildcard specification ? is used as replacement for
Options: a. one character b. two character c. three character d. none of the above

Ans:8 a.,8 a.


Which one of the following statements is true for the voltage in a parallel RL circuit?
Options: The voltage always has the same amplitude and phase for every part of the circuit,    The total voltage is equal to the sum of the voltages across the resistance and inductance,    The total voltage lags the total current by less than 90,    The total voltages is less than the sum of the voltages across the resistance and inductance

Ans:A ,A


. Gridlines
Options: a. May be turned off for display but turned on for printing b. May be turned on or off for printing c. The be turned off for display and printing d. a, b and c

Ans:– d,– d


An unloaded zener regulator has a source voltage of 20 V, a series resistance of 330 W, and a zener voltage of 12 V, What is the Zener current?
Options: 28.4 mA,    24.2 mA,    34.4 mA,    68.4 mA

Ans:B ,B


Which constraint requires that the binary relationship indicate all combinations that must appear in the ternary relationship?
Options: MUST COVER,    MUST NOT,    Both of the above.,    None of the above is correct.

Ans:A ,A


Numerical control:
Options: is a method for controlling the operation of a machine by means of a set of instructions,    applies only to milling machines,    is a method for producing an exact number of parts per hour,    All of the above

Ans:A ,A


  Which key on the keyboard can be used to view Slide show?
Options: F1 B. F2 C. F5 D. F10

Ans:– C ,


The 34-pin connection on an I/O card is for?
Options: Floppy drive,    SCSI drive,    IDE drive,    Zip drive

Ans:A ,A


The memory address of fifth element of an array can be calculated by the formula
Options: a. LOC(Array[5]=Base(Array)+w(5-lower bound), where w is the number of words per memory cell for the array b. LOC(Array[5])=Base(Array[5])+(5-lower bound), where w is the number of words per memory cell for the array c. LOC(Array[5])=Base(Array[4])+(5-Upper bound), where w is the number of words per memory cell for the array d. None of above

Ans:- a,- a


A transistor has a current gain of 125 and a base current of 30 µA. What is the collector current?
Options: 3.75 mA,    3.2 mA,    0.05 mA,    13 mA

Ans:A ,A


The marketing mix does not include
Options: place,    product,    persuasion,    promotion

Ans:C ,C


Which WLAN IEEE specification allows up to 54Mbps at 2.4GHz?
Options: A,    B,    G,    N

Ans:C ,C


Structured Programming involves
Options: decentralisation of program activity,    functional modularisation,    localisation of errors,    All of the above

Ans:B ,B


You have been contracted to install a windows NT network in an office that is located in a strip mall. The office is located next to the power plant of the building, so a UPS (uninterruptible power supply) has already been installed. What type of cable should you use for the network cabling? Choose the best answer.
Options: TI,    UTP,    Fiber-optic,    PSTN

Ans:E ,E


Which of the following describes the operation of a positive edge-triggered D-type flip-flop?
Options: If both inputs are HIGH, the output will toggle.,    The output will follow the input on the leading edge of the clock.,    When both inputs are LOW, an invalid state exists.,    The input is toggled into the flip-flop on the leading edge of the clock and is passed to the output on the trailing edge of the clock.

Ans:B ,B


A factor which might cause an individual to consider using a computer in criminal activities is:
Options: The computer's access to large sums of money,    The speed with which the crime can be accomplished,    EFTS (Electronic Funds Transfer System),    All the above

Ans:D ,D


The process of converting analog signals into digital signals so they can be processed by a receiving computer is referred to as:
Options: modulation,    demodulation,    synchronizing,    synchronizing

Ans:B ,B


A continuous process is:
Options: used only for simple tasks,    one that never shuts down,    self-contained in that raw materials enter the process and an identifiable products exits the process.,    used only with analog controllers.

Ans:C ,C


A framework in which circuit boards can he mounted is
Options: Switch circuit,    Chip,    Card cage,    Bar code

Ans:C ,C


The examination and changing of single bits or small groups of his within a word is called
Options: Bit,    Byte,    Bit manipulation,    Bit slice

Ans:C,(Canswer


To create queries in Access
Options: a. You can drag and drop fields on query builders b. you can type the SQL command in SQL view c. You can use query wizard or design view d. All of above

Ans:ndash; d,ndash; d


. Which of the following is correct regarding Underline in MS-Word?
Options: a. Color of Underline can be change b. Style of Underline can be change c. Underline can be set using by shortcut key d. All of the above

Ans: –  D , –  D


.   Which types of fonts are best suitable for titles and headlines
Options: a. serif fonts b. sans serif fonts c. text fonts d. picture fonts

Ans:3 – B ,3 – B


.  Power Point can display data from which of the following add-in software of MS Office?
Options: Equation Editor B. Organization Chart C. Photo Album D. All of these

Ans: – D ,


The paperwork that travels with the materials through the production process is called a
Options: shop packet,    weigh bill,    picking ticket,    work order

Ans:A ,A


How many bits are there in the Ethernet address?
Options: 64 bits B. 48 bits C. 32 bits D. 16 bits

Ans:– B ,


Superscript, subscript, outline, emboss, engrave are known as
Options:  A) font styles, B) font effects, C) word art, D) text effects, 

Ans:-B,-B


Which of the following scheduling objectives should be applied to the following: the system should admit jobs to create a mix that will keep most devices busy
Options: to be fair,    to balance resource utilization,    to obey priorities,    to be predictable

Ans:B ,B

www.000webhost.com