. In maximum, how many sheets can be set as default while creating new workbook?


Options: 254 B. 255 C. 256 D. No Limit

Ans:– B ,


Description: mcqquestions

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

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


Output hardware is often categorized according to whether it:
Options: is expensive,    requires a large amount of electricity to work,    produces hardcopy or softcopy,    can fit on a desktop

Ans:C ,C


.   What will happen if you release the mouse button before releasing the shift key when you draw a square?
Options: a. The square will not be a perfect square b. The square will not be at the center of the slide c. The square will be smaller d. The square will be larger

Ans:7 – A ,7 – A


A zener regulator has an input voltage from 15 to 20 V and a load current from 5 to 20 mA. If the zener voltage is 6.8 V, what value should the series resistor have?
Options: 310 Ohm,    400 Ohm,    410 Ohm,    550 Ohm

Ans:C ,C


A _____ Contains fields of data about one entity.
Options: Record,    File,    Fields,    Document

Ans:A ,A


hich of the following is not the Section Break Option?
Options: Next Page B. Previous Page C. Odd Page D. Even Page

Ans:– B ,


Which simplifies the process of formatting text if the same formatting is required in more than one location
Options: Auto Text B. Format Painter C. Font dialog box D. None of the above

Ans:– B ,


A network that requires human intervention of route signals is called a
Options: bus network,    ring network,    star network,    T-switched network

Ans:D ,D


Which of the following is not a standard synchronous communication protocol?
Options: SDLC,    SMTP,    SLIP,    PAS

Ans:D ,D


Compared to an open-loop system, a closed-loop control system is:
Options: more accurate,    more complex,    more stable,    All of the above

Ans:D ,D


High density double sided floppy disks could store _____ of data
Options: A) 1.40 MB B) 1.44 GB C) 1.40 GB D) 1.44 MB

Ans:-D,-D


.   to save a presentation you
Options: a. click save on the windows start button b. press Ctrl + F5 c. select File, Save from the menu d. click the saver button on the formatting toolbar

Ans:2 – C ,2 – C


Which of the following commands will configure all the default VTY ports on a router?
Options: Router#line vty 0 4,    Router(config)#line vty 0 4,    Router(config-if)#line console 0,    Router(config)#line vty all

Ans:B ,B


Information is _____ when it is useful in making a decision.
Options: relevant,    management by exception,    predictive reports,    control

Ans:A ,A


. Why ABC computer is called so?
Options: A) Because it was developed by Atanasoff and Berry B) Because it was thought to be the first computer so named with first alphabets of English C) Both of above are the reason to name the computer ABC D) None of above are true

Ans:A,A


When did IBM close the last of its punched card manufacturing plant?
Options: June, 1989,    December, 1984,    March, 1982,    November, 1979

Ans:B,B


An audit trail
Options: a . is used to make backup copies b . is the recorded history of operations performed on a file c . can be used to restore lost information d . none of the aobve

Ans:B, is the recorded history


While working with MS-DOS, which command is used to restore files that were backed up using the BACKUP command?
Options: COPY,    DISKCOPY,    RESTORE,    STORE

Ans:C ,C


Which of the following tool enables you to add text to a slide without using the standard placeholders?
Options: a. Text tool box b. Line tool c. Drawing tool d. Auto shapes tool

Ans: – A , – A


How can you totally protect a PC from damage during an electrical storm?
Options: Disconnect the AC power cable,    Disconnect all external cables and power cords,    Use a surge protector,    Turn off the AC power

Ans:A ,A


. What is an intersection of a row and a column?
Options: a. Form b. Cursor c. Cell d. Record

Ans:– c,– c


In Computer System Scanner is ______ Device?
Options: Input B. Output         C. Both D. None

Ans:– A ,


A section of code to which control is transferred when a processor is interrupted is known as
Options: M,    SVC,    IP,    MDR

Ans:A ,A


The frequency range : 300 kHz to 3 MHz is used for
Options: AM radio transmission,    FM radio transmission,    TV transmission,    microwave communications, satellite and radar

Ans:A ,A


Which of the following is a secondary memory device?
Options: Keyboard,    Disk,    ALU,    All of the above

Ans:B ,B


Structured design produces computer programs that are
Options: easily,    maintained,    easily understood,    both (a) and (b)

Ans:D ,D


To have a file hold a list, it is necessary to
Options: identify the records in the list,    identify the name, width and type of the fields of each record.,    decide which fields will be used as sort or index keys,    All of the above

Ans:D ,D


A database can be best described as
Options: a. Organized collection of data b. Useful presentation of data c. Graphical representation of data d. All of above

Ans:ndash; a,ndash; a


How does a host on an Ethernet LAN know when to transmit after a collision has occurred? In a CSMA/CD collision domain, multiple stations can successfully transmit data simultaneously. In a CSMA/CD collision domain, stations must wait until the media is not in use before transmitting. You can improve the CSMA/CD network by adding more hubs. After a collision, the station that detected the collision has first priority to resend the lost data. After a collision, all stations run a random backoff algorithm. When the backoff delay period has expired, all stations have equal priority to transmit data.
Options: 1 and 3,    2 and 4,    1,3 and 4,    2 and 5

Ans:D ,D


Managers who are potential users of the MIS
Options: select the optimum equipment configurations,    evaluate alternate equipment configurations,    describe information needs,    All of the above

Ans:E ,E


In data-flow diagrams, an originator or receiver of the data is usually designated by
Options: a circle,    an arrow,    a square box,    a rectangle

Ans:C ,C


We have done an RFM analysis on our customer data. Mary Jones has a score of "1 1 5". This series means that Mary ________ .
Options: Has ordered recently, orders frequently, and places a large order when she orders.,    Hasn't ordered recently, orders infrequently, but places a large order when she orders.,    Has ordered recently, orders frequently, but doesn't place a large order when she orders,    Hasn't ordered recently, orders infrequently, and doesn't place a large order when she orders.

Ans:C ,C


Continuous line drawing are produced using
Options: Chain printers,    Daisy wheel printers,    Plotters,    Thermal devices

Ans:C ,C


The index consists of
Options: a list of keys,    pointers to the master list,    both (a) and (b),    All of the above

Ans:C ,C


What command is used with vi editor to move forward to the end of a word?
Options: c,    d,    b,    e

Ans:D ,D


Which one of the following statements is true for voltage in a series circuit?
Options: The total voltage is equal to the sum of the individual voltages in a series circuit,    The total voltage in a series circuit is equal to the average value of the individual voltages,    The total voltage of a series circuit is equal to the total current divided by the total resistance,    The total voltage in a series circuit is always less than the value of the smallest voltage

Ans:A ,A


The binary equivalent of 5.375 is
Options: 101.101110111,    101.011,    101011,    None of above

Ans:B ,B


. Slides can have
Options: a. title, text, graphs b. drawn objects, shapes c. clipart, drawn art, visual d. any of the above

Ans:9 – D ,9 – D


For a type 0 system, the steady-state:
Options: error for a step input is always zero,    error for a velocity input is always zero,    input for acceleration input is always non-zero,    (a) and (c)

Ans:C ,C


Queries in Access can be used as
Options: a. view, change and analyze data in different ways b. a source of records for forms and reports c. Only a d. Both a and b

Ans:ndash; d,ndash; d


.   Animation schemes can be applied to ….. in the presentation
Options: a. All slides b. Select slides c. Current slide d. All of the above

Ans:5 – D ,5 – D


What is the name given to the 8-bit unit used for coding data?
Options: block of characters,    byte,    word,    K

Ans:B,B


. The insertion point looks like a(n) ____.
Options: a. H-pointer b. I-pointer c. H-beam d. I-beam

Ans:4 – d ,4 – d


. which of the following is problem oriented language?
Options: A) High level language B) Machine language C) Assembly language D) Low level language

Ans:A,A


. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find relationship command
Options: a. File menu b. View menu c. Database menu d. Tools menu

Ans:8 – d ,8 – d


Doubling the operating frequency of a purely capacitive circuit:
Options: has no effect on the total circuit current,    doubles the amount of total current,    cuts the total current by one-half,    thrice the amount of total current

Ans:B ,B


Using the SQL GROUP BY phrase with a SELECT statement can help detect which of the following problems?
Options: The multivalue, multicolumn problem,    The inconsistent values problem,    The missing values problem,    The general-purpose remarks column problem

Ans:B ,B


. Which tab in Font dialog box contain options to apply font effects?
Options: a. Font tab b. Character Spacing c. Text Effects d. Standard Toolbar

Ans: – A , – A


Doubling the operating frequency of an inductive circuit:
Options: has no effect on the inductive reactance,    doubles the amount of inductive reactance,    multiplies the inductive reactance by 6.28,    cuts the inductive reactance in half

Ans:B ,B


A logic gate is an electronic circuit which
Options: makes logic decisions,    allows electron flow only in one direction,    works on binary algebra,    alternates between 0 and 1 values

Ans:A ,A


The keyword "inverse" is used in which of the following?
Options: Class,    Attribute,    Relationship,    All of the above.

Ans:C ,C

www.000webhost.com