How many worksheets can a workbook have?


Options: 3 B. 8 C. 255 D. none of above

Ans:– D ,


Description: mcqquestions

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

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


How many non-overlapping channels are available with 802.11h?
Options: 3,    12,    23,    40

Ans:C ,C


.   The Microsoft clip gallery allows you to
Options: a. Add word art images to a slide b. Spell check your presentation c. Add clip art images to a slide or slides d. Add slides to a presentation

Ans:3 – C ,3 – C


What will be the output of the program? #include<stdio.h> #include<string.h> int main() { char *s; char *fun(); s = fun(); printf("%s\n", s); return 0; } char *fun() { char buffer[30]; strcpy(buffer, "RAM"); return (buffer); }
Options: 0xffff,    Garbage value,    0xffee,    Error

Ans:B ,B


. Word length of a Personal Computer is ___
Options: A) 4 bits B) 8 bits C) 16 bits D) 64 bits

Ans:B,B


Which of the following is(are) true concerning information-system careers?
Options: the primary reason for this increase is the declining cost of hardware,    the number of information-system specialists recruited is expected to be greater than any other profession in the 1990s.,    an information-system career is one of the few area that is recession-proof,    both (a) and (b)

Ans:D ,D


What do the following declaration signify? char **argv;
Options: argv is a pointer to pointer.,    argv is a pointer to a char pointer.,    argv is a function pointer.,    argv is a member of function pointer.

Ans:B ,B


.  In a module, a(n) _______ is a series of commands and properties that perform a specific task.
Options: a.            event b.           property c.           procedure d.            macro

Ans:– c,– c


Which of the following is an essential file of a MS-DOS boot disk?
Options: COMMAND.COM B. START.COM C. TREE.COM D. VER.COM

Ans: A ,COMMAND.COM


What command is used to remove the directory?
Options: rdir,    remove,    rd,    rmdir

Ans:D ,D


. Which of the following is default location of saving and opening file?
Options: a. Desktop b. My computer c. My documents d. All of above

Ans:6 – c ,6 – c


Which of the following is not the Networking Devices?
Options: Gateways B. Linux             C. Routers D. Firewalls

Ans:– B ,


A Database Management System (DBMS) is
Options: Collection of interrelated data B. Collection of programs to access data C. Collection of data describing one particular enterprise D. All of the above

Ans:– D ,


In DOS, which of the following keys will bypass the CONFIG.SYS and AUTOEXEC.BAT files?
Options: F8,    F5,    F4,    Fl

Ans:B ,B


What is the smallest number of polarities required for current flow?
Options: One - a negative terminal,    Two - a negative terminal and a positive terminal,    Three - negative, positive and neutral terminals,    Four - two negative and two positive

Ans:B ,B


What is the shortcut key to “Center Align ” the selected text?
Options: Ctrl + C B. Ctrl + E C. Ctrl + F D. None of above

Ans:– B ,


. Which type of command requires additional files to perform specific operations?
Options: a. Internal commands b. External commands c. Valuable commands d. Primary commands

Ans: b, b


The location for subdirectories for local programs and executables for user and administrative commands, is:
Options: /usr,    /tmp,    /opt,    /mnt

Ans:A ,A


What will be the output of the program? #include<stdio.h> #define PRINT(i) printf("%d,",i) int main() { int x=2, y=3, z=4; PRINT(x); PRINT(y); PRINT(z); return 0; }
Options: 2, 3, 4,,    2, 2, 2,,    3, 3, 3,,    4, 4, 4,

Ans:A ,A


In LISP, the function assigns the symbol x to y is
Options: (setq y x),    (set y = 'x'),    (setq y = 'x'),    (setq y 'x')

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


What is the language used by most of the DBMSs for helping their users to access data?
Options: a. High level language b. SQL c. Query Language d. 4GL

Ans:. c ,. c


Which of the following is not a restriction for a table to be a relation?
Options: The cells of the table must contain a single value.,    All of the entries in any column must be of the same kind.,    The columns must be ordered.,    No two rows in a table may be identical.

Ans:C ,C


“Ctrl + PageDown” is used to
Options: a. Moves the cursor one Paragraph Down b. Moves the cursor one Page Down c. Moves the cursor one Line Down d. Moves the cursor one Screen Down

Ans:–  B,–  B


An error-detecting code inserted as a field in a block of data to be transmitted is known as
Options: Frame check sequence,    Error detecting code,    Checksum,    flow control

Ans:A ,A


If a robot can alter its own trajectory in response to external conditions, it is considered to be:
Options: intelligent,    mobile,    open loop,    non-servo

Ans:A ,A


. Who used punched cards practically for the first time in the history of computers?
Options: A) Charles Babbage B) Dr. Herman Hollerith C) Howard Aikin D) Joseph Jacquard

Ans:5-B,5-B


Which one of the following statements most accurately applies to the frequency of a waveform?
Options: The actual frequency of a sine waveform is 1.41 times the working frequency,    Unless specified otherwise, the frequency of a waveform is assumed to be 60 Hz,    The higher the amplitude of a waveform, the higher its frequency,    The longer the period of a waveform, the lower its frequency

Ans:A ,A


UDP is:
Options: Not a part of the TCP/IP suite,    Connection oriented and unreliable,    Connection orientated and reliable,    Connectionless and unreliable

Ans:D ,D


. Which of the following is NOT possible when printing Forms?
Options: a. Print page 1, 3, and 5 b. Print pages 1 through 5 c. Print selected records d. Print only the third record

Ans:5 – a ,5 – a


The bubbles in a bubble memory pack are created with the help of?
Options: Laser beam,    Magnetic field,    Electric field,    X-ray

Ans:B ,B


Which of the following statements in correct?
Options: most analysts agree on the structure and organization of MIS.,    operational planning reports are a primary informational tool for middle management.,    an MIS focuses on managing information generated with a computer system,    the cross reference of data items is an integral feature of the simple structure used in database organization.

Ans:C ,C


A memory that holds micro programs is
Options: Core memory,    ROM,    RAM,    Control memory

Ans:B ,B


In DOS, what key would you press to step through the Config.sys and Autoexec.bat?
Options: F1,    F3,    F5,    F8

Ans:D ,D


Which of the following frequency ranges is used for AM radio transmission?
Options: Very Low Frequency : 3 kHz to 30 kHz,    Medium Frequency : 300 kHz to 3 MHz,    High Frequency : 3 MHz to 30 MHz,    Very High Frequency : 30 MHz to 300 MHz

Ans:B ,B


. A group of magnetic tapes, videos or terminals usually under the control of one master is
Options: A) Cylinder B) Surface C) Track D) Cluster

Ans:D,D


. What was the first computer to perform all calculation using electronics rather than wheels, ratchets, or mechanical switches?
Options: A) Mark I B) ABC C) Z3 D) None of above

Ans:B,B


. You can open the consolidate dialog box byt choosing Consolidate from the ….. menu.
Options: a. Insert b. Format c. Tools d. Data

Ans:– d,– d


. Which area in an Excel window allows entering values and formulas?
Options: a. Title Bar b. Menu Bar c. Formula Bar d. Standard Tool Bar

Ans:– c,– c


How to restrict to run a macro automatically when starting Microsoft Excel?
Options: Hold down the SHIFT key during startup B. Hold down the CTRL key during startup C. Hold down the ESC key during startup D. Hold down the ALT key during startup

Ans:– A ,


  Slide sorter of PowerPoint is available on _____ menu.
Options: Insert B. File C. View D. Edit

Ans:– C ,


A compiler for a high-level language that runs on one machine and produces code for a different machine is called
Options: optimizing compiler,    one pass compiler,    cross compiler,    multipass compiler

Ans:C ,C


Which of following commands is used for an automatic reminder service?
Options: write,    mesg,    calendar,    mail

Ans:C ,C


. How to restrict the values of a cell so that only whole numbers between 9 and 99 can be entered in a cell.
Options: a. The Settings tab under the menu Format -> Cells b. The Settings tab under the menu Data -> Validation c. The Settings tab under the menu Data -> Filter -> Advanced Filter d. the Settings tab under the menu Format -> Conditional Formatting

Ans:– b,– b


To get the Norton current, you have to
Options: Short the load resistor,    Open the load resistor,    Short the voltage source,    Open the voltage source

Ans:C ,C


. Which of the following is first generation of computer
Options: A) EDSAC B) IBM-1401 C) CDC-1604 D) ICL-2900

Ans:9-A,9-A


Which one of the following equations most directly determines the power dissipation of a resistance when you know the power dissipation of a resistance when you know the voltage drop and current?
Options: P = IE,    P = E2/R,    P = I2R,    I = P/E

Ans:A ,A


Which file executes commands in DOS?
Options: MS-DOS.SYS,    CONFIG.SYS,    COMMAND.COM,    SYSTEM.INI

Ans:C ,C


Which of the following statement is false?
Options: a. Arrays are dense lists and static data structure b. data elements in linked list need not be stored in adjecent space in memory c. pointers store the next data element of a list d. linked lists are collection of the nodes that contain information part and next pointer  

Ans:c,c


In latest generation computers, the instructions are executed
Options: Parallely only,    Sequentially only,    Both sequentially an parallely,    All of the above

Ans:C ,C


The control unit of a microprocessor
Options: stores data in the memory,    accepts input data from a keyboard,    Performs arithmetic / logic / functions,    none of the above

Ans:D,None of the above

www.000webhost.com