. 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: 15866 | 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:


A Turnaround document
Options: is circulated among all the staff of an organization.,    is circulated among all the heads of departments of an organization.,    is output at one point which later comes back as an input,    All of the above

Ans:C ,C


One of the following is not considered a method of input control in a CAD system.
Options: Joystick,    Programmable function box,    Plotter,    Touch terminal

Ans:C ,C


. In the third Generation of computers

Options: A) Distributed data processing first became popular B) An operating system was first developed C) High level procedural language were first used D) Online real time systems first become popular

Ans:B,B


The physical equipment made oi various metals, silicon and plastic components that make up the parts of a computer is called
Options: micro,    peripheral,    hardware,    disk drive

Ans:C ,C


Union officials receive the same type of education as
Options: top level managers,    the rank and file employees,    low level managers,    All of the above

Ans:C ,C


Which command is used with file named 'note' to remove the executable permission from the user and assign read permission to the group and others?
Options: chmod u-x, go+r note,    chmod go+r, u+x note,    chmod g-x, uo+r note,    chmod go+x, u-x note

Ans:A ,A


Special software to create a job queue is called a
Options: Drive,    Spooler,    Interpreter,    Linkage editor

Ans:B ,B


Which of the following is not a component of a data warehouse?
Options: Data extraction/cleaning/preparation programs,    Data warehouse data,    Data metadata,    None of the above are data warehouse components.

Ans:C ,C


The arranging of data in a logical sequence is called:
Options: sorting,    classifying,    reproducing,    summarizing

Ans:A ,A


A functional dependency is a relationship between or among:
Options: tables.,    rows.,    relations.,    attributes.

Ans:D ,D


. The personal computer industry was started by
Options: A) IBM B) Apple C) Compaq D) HCL

Ans:A,A


A compound key
Options: is made up a several pieces of information,    uniquely identifies an item in a list,    both (a) and (b),    is a combination of each unique key

Ans:C ,C


. When you point to a text entry in the Office Clipboard gallery in the Clipboard task pane, _____.
Options: a. the first several characters of text in the item display as a ScreenTip b. the text entry is deleted from the Office Clipboard gallery c. the text entry is pasted into the document at the location of the insertion point d. all of the above

Ans: – A , – A


Which of the following is not one of the stages in the evolution of distributed DBMS?
Options: Unit of work,    Remote unit of work,    Distributed unit of Work,    Distributed request

Ans:A ,A


The CPU is made up of control unit ALU and
Options: Memory,    Input-Output,    Register unit,    All of the above

Ans:A ,A


When used with I/O devices, the term intelligent implies
Options: a color output capability,    speech processing capability,    high speed printing capability,    feature to support offline and online tasks

Ans:D ,D


Data division is the third division of a _____ program.
Options: COBOL,    BASIC,    PASCAL,    FORTH

Ans:A ,A


The "walk-through" method of programming a robot involves:
Options: walking through your suggested procedure with your supervisor prior to programming,    physically moving the robot through all the motions it is to repeat,    moving the robot from one location to another,    All of the above.

Ans:B ,B


What will be the output of the program #include<stdio.h> void fun(int); int main(int argc) { printf("%d ", argc); fun(argc); return 0; } void fun(int i) { if(i!=4) main(++i); }
Options: 1 2 3,    1 2 3 4,    2 3 4,    1

Ans:B ,B


Error detection at the data link level is achieved by?
Options: Bit stuffing,    Hamming codes,    Cyclic Redundancy codes,    Equalization

Ans:C ,C


What command is used with vi editor to delete three words?
Options: 3$d,    3 dw,    3 x,    3 dd

Ans:B ,B


A pricing strategy model would function most effectively as a
Options: transaction processing model,    batch model,    time sharing model,    realtime model

Ans:C ,C


What command do you type to save the configuration stored in RAM to NVRAM?
Options: Router(config)#copy current to starting,    Router#copy starting to running,    Router(config)#copy running-config startup-config,    Router#copy run startup

Ans:D ,D


Which of the following addressing modes, facilitates access to an operand whose location is defined relative to the beginning of the data structure in which it appears?
Options: ascending,    sorting,    index,    indirect

Ans:C ,C


During what phase, the requirement analysis is performed?
Options: system design phase,    system development phase,    system analysis phase,    system investigation phase

Ans:C ,C


A tool that can help designers understand the dependencies of database structures is a:
Options: dependency graph.,    data model.,    graphical display.,    None of the above is correct.

Ans:A ,A


What is the shortcut key to display field codes?
Options: a. Alt + F9 b. Ctrl + F9 c. Shift + F9 d. Space + F9

Ans:–  A,–  A


The time factor when determining the efficiency of algorithm is measured by
Options: a. Counting microseconds b. Counting the number of key operations c. Counting the number of statements d. Counting the kilobytes of algorithm  

Ans:b,b


What is one disadvantage of an S-R flip-flop?
Options: It has no Enable input.,    It has a RACE condition.,    It has no clock input.,    It has only a single output.

Ans:B ,B


What will be the output of the program? #include<stdio.h> #include<stdlib.h> int main() { union test { int i; float f; char c; }; union test *t; t = (union test *)malloc(sizeof(union test)); t->f = 10.10f; printf("%f", t->f); return 0; }
Options: 10,    Garbage value,    10.100000,    Error

Ans:C ,C


The computational technique used to compute the disk storage address of individual records is called:
Options: bubble memory,    key fielding,    dynamic reallocation,    hashing

Ans:D ,D


What is the default left margin in Word 2003 document?
Options:  A) 1", B) 1.25", C) 1.5", D) 2", 

Ans:-B,-B


The distinguishable parts of a record are called
Options: files,    data,    fields,    database

Ans:C ,C


Which of the following is not an example of a value?
Options: a. 350 b. May 10, 2001 c. 0.57 d. Serial Number 50771

Ans:#8211; d,#8211; d


In a _____ topology, if there are n devices in a network, each device has n - 1 ports for cables.
Options: ring,    bus,    star,    mesh

Ans:D ,D


. Which of the following provides a list ofx synonyms?
Options: a. Find command b. Replace Command c. Thesaurus d. Spelling and Grammar

Ans: –  C , –  C


A complete microcomputer system consists of
Options: a . microprocessor b . memory c . peripheral equipment d . all of above

Ans:3.d,3.d


A dielectric material is:
Options: a good conductor,    a good insulator,    a poor conductor of electrostatic fields,    a good conductor of magnetic fields

Ans:B ,B


The intersection of a column and row in a spreadsheet is called a bon or
Options: Key,    Field,    Cell,    Menu

Ans:C ,C


. PowerPoint Application allows you to produce
Options: a. Animated Presentations b. Paper Printouts of Slides c. Notes for the Speaker d. All of the above.

Ans:9 – D ,9 – D


. IMB launched its first personal computer called IBM-PC in 1981. It had chips from Intel, disk drives from Tandon, operating system from Microsoft, the printer from Epson and the application software from everywhere. Can you name the country which contributed
Options: A) India B) China C) Germany D) Taiwan

Ans:D,D


What is a portion of memory that serves as a temporary repository for data as it waits for a given action?
Options: Memory Pool,    Cache,    Processor,    Processor pool

Ans:B ,B


Which is a machine-oriented high-level language for the GEC 4080 series machines.
Options: LOGO,    SNOBOL,    Babbage,    ALGOL

Ans:C ,C


What device prevents power interruptions, resulting in corrupted data?
Options: Battery back-up unit,    Surge protector,    Multiple SIMMs strips,    Data guard system

Ans:A ,A


What will be the output of the program in Turb C (under DOS)? #include<stdio.h> int main() { int arr[5], i=0; while(i<5) arr[i]=++i; for(i=0; i<5; i++) printf("%d, ", arr[i]); return 0; }
Options: 1, 2, 3, 4, 5,,    Garbage value, 1, 2, 3, 4,,    0, 1, 2, 3, 4,,    2, 3, 4, 5, 6,

Ans:B ,B


A type of simulation method using random numbers to determine the evolution of a system is
Options: Model dispersion,    Monte carlo,    Monadic,    Padding

Ans:B ,B


A relocate program form is the one which
Options: cannot be made to execute in any area of storage other than the one designated for it at the time of its coding or translation,    consists of a program and relevant information for its relocation,    can itself perform the relocation of its address-sensitive portions,    All of the above

Ans:B ,B


. To edit data in an embedded Excel worksheet object in a Word document
Options: a. Use the Excel menu bar and toolbars inside the word application b. Edit the hyperlink c. Edit the data in a Excel source application d. Use the Word menu bar and toolbars

Ans:– a,– a


The use of specialized workstations:
Options: provides limited growth potentials for 3-D,    reduces the host computer workload and allows more users,    reduces the host computer workload,    has a high cost-performance tradeoff

Ans:B ,B


While working with MS-DOS, which command is used to undelete a bunch of files with extension DOC that you have just deleted?
Options: UNDELETE,    UNDELETE *.DOC,    UNDELETE/ALL,    UNDELETE/LIST

Ans:B ,B

www.000webhost.com