. 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






More MS-Excel Related questions:


hat is the use of Document Map?
Options: to quickly format the document B. to quickly print required page C. to quickly navigate the document D. to quickly correct spelling mistakes

Ans:– C ,


Lower-level managers make day-to¬day ______ decisions to schedule and control specific tasks.
Options: operational,    decision,    success,    simulation

Ans:A ,A


A data warehouse is which of the following?
Options: Can be updated by end users.,    Contains numerous naming conventions and formats.,    Organized around important subject areas.,    Contains only current data.

Ans:C ,C


The hardware in which data may be stored for a computer system is called
Options: Registers,    Bus,    Control unit,    Memory

Ans:D ,D


What was the computer invented by Attanasoff and Clifford?
Options: A) Mark I B) ABC C) Z3 D) None of above

Ans:-B,-B


MS-Word automatically moves the text to the next line when it reaches the right edge of the screen and is called?
Options: Carriage Return B. Enter C. Word Wrap D. None of the above

Ans:– C ,


First-in-First-Out (FIFO) scheduling is
Options:  Non Preemptive Scheduling B.  Preemptive Scheduling C.  Fair Share Scheduling D.  Deadline Scheduling

Ans:– A ,


Which of the following systems software does the job of merging the records from two flies into one?
Options: Documentation system,    Utility program,    Networking software,    Security software

Ans:B ,B


Which of the following hardware components is the most important to the operation of a database management system?
Options: high-resolution video display,    printer,    high speed, large-capacity disk,    plotter

Ans:C ,C


. The .... displays the name of every computer user on the computer
Options: a. Wish list screen b. Command screen c.Welcome screen d. None of the above

Ans: c, c


In LISP, the atom that stands for "False" is
Options: t,    nil,    y,    time

Ans:B ,B


Which of the following is true regarding access lists applied to an interface?
Options: You can place as many access lists as you want on any interface until you run out of memory.,    You can apply only one access list on any interface.,    One access list may be configured, per direction, for each layer 3 protocol configured on an interface.,    You can apply two access lists to any interface.

Ans:C ,C


. The shortcut key to open a task manager is:
Options: a. Alt + F1 b. Alt + Ctrl + Delete c. Alt + Tab d. F1

Ans:0 – b ,0 – b


. Most of the inexpensive personal computers do not have any disk or diskette drive. What is the name of such computes?

Options: A) Home computers B) Diskless computers C) Dedicated computers D) General purpose computers

Ans:B,B


SQL query and modification commands make up a(n) ________ .
Options: DDL,    DML,    HTML,    XML

Ans:B ,B


. During the boot process, the …. looks for the system file
Options: a. CD b. BIOS c. CPU d. DVD

Ans:7 – b ,7 – b


What is the name of the computer based EMMS that provides a common forum where users can check in at their convenience, post messages, actively exchange ideas and participate in ongoing discussions?
Options: E-mail,    Bulletin board system (BBS),    Teleconferencing,    Videoconferencing

Ans:B ,B


Which of the following is a valid format for mounting a CD-ROM drive?
Options: mount -t iso9660 /dev/cdrom / mnt/cdrom,    mount /dev/cdrom,    mount /mnt/cdrom,    All of the above

Ans:D ,D


If a relationship has a cascade updates constraint, then if ________ in the parent table is changed, then the same change will automatically be made to any corresponding foreign key value.
Options: the primary key,    any alternate key,    a surrogate key,    a foreign key

Ans:A ,A


A 8-Mbps token ring has a token holding timer value of 10 msec. What is the longest frame (assume header bits are negligible) that can be sent on this ring?
Options: 8000 B frame,    80,000 B frame,    8 x 105 bit frame,    10,000 B frame

Ans:D ,D


. Essential files of DOS are
Options: a. Command.com and IO.Sys b. IO.Sys and DOS.Sys c. DOS.Sys and Command.com d. Autoexec.bat and Config.sys

Ans:2 – b ,2 – b


. Which of the following is an example of fifth generation computer?
Options: A) PIM/m B) ICL 2950 C) IBM 1401 D) None of above

Ans:A,A


. Time during which a job is processed by the computer is
Options: A) Delay times B) Real time C) Execution time D) Down time

Ans:C,C


. A Compiler is ____
Options: A) a combination of computer hardware B) a program which translates from one high-level language to another C) a program which translates from one high-level to a machine level language D) None of these

Ans:0-C,0-C


. When did IBM introduce the 20286 based PC/AT?
Options: A) 1982 B) 1984 C) 1985 D) 1989

Ans:B,B


________ is an interface by which application programs can access and process SQL databases in a DBMS-independent manner.
Options: ODBC,    OLE DB,    JPCD,    ADO

Ans:A ,A


. What is the name of the feature that will allow you to take a step backward if you’ve made a mistake?
Options: a. Redo b. Cancel c. Undo d. Backspace

Ans: – C , – C


94. What is the shortcut key for Spelling Check in document?
Options: a. F7 b. Shift + F7 c. Ctrl + F7 d. Alt + F7

Ans:–  A ,–  A


. Essential files of MS DOS are
Options: a. Command . com b. Io.sys c. Msdos.sys d. All of above

Ans:8 – d ,8 – d


Conversion method in which users, being used to an old system, continue to use the old system, along with the new system, is
Options: Multiprocessing,    Multitasking,    Parallel run,    All of the above

Ans:C ,C


To create a formula, you first:
Options: a. Select the cell you want to place the formula into b. Type the equals sign (=) to tell Excel that you’re about to enter a formula c. Enter the formula using any input values and the appropriate mathematical operators that make up your formula d. Choose the new command from the file menu

Ans:#8211; a,#8211; a


Which of the following in not a function of DBA?
Options: Network Maintenance B. Routine Maintenance C. Schema Definition D. Authorization for data access

Ans:– A ,


The "curse of dimensionality" relates to which problem of using operational data for BI reporting?
Options: Dirty data,    Inconsistent data,    Too much data,    Non-integrated data

Ans:C ,C


A turnkey package includes
Options: software,    hardware,    training,    All of the above

Ans:D ,D


. Which command allows you to show the contents of disk widely in screen?
Options: a. Dir/p b. Dir/b c. Dir/w d. Dir/o:w

Ans:7 – c ,7 – c


Data integrity control
Options: is used to set upper and lower limits on numeric data,    requires the use of passwords to prohibit unauthorized access to the file,    has the data dictionary keep the date and time of last access last back-up, and most recent modification for all files,    All of the above

Ans:C ,C


The systems conversion technique of totally removing the existing system and immediately implementing the new system is called a
Options: pilot conversion,    crash conversion,    phased conversion,    parallel run

Ans:B ,B


. To show/hide the grid lines in Microsoft Excel 2007
Options: a. Page Layout -> Grid lines -> View b. Insert -> Grid lines -> View c. View -> Grid lines -> View d. Edit -> Grid lines -> View

Ans:– a,– a


Which standard library function will you use to find the last occurance of a character in a string in C?
Options: strnchar(),    strchar(),    strrchar(),    strrchr()

Ans:D ,D


A functional dependency between two or more non-key attributes is called
Options: Transitive dependency B. Partial transitive dependency C. Functional dependency D. Partial functional dependency

Ans:– A ,


You must service the laser printer in your office. Which part of the printer shoud you avoid touching because it is hot?
Options: fuser,    printer head,    primary corona,    high-voltage power supply

Ans:A ,A


Automation means:
Options: assisting or replacing humans with machines.,    workers controlling machines.,    increased productivity.,    All of the above

Ans:D ,D


The _____ command allows you to modify the default prompt to provide other information
Options: prompt,    windows,    cursor,    click

Ans:A ,A


A part of database that stores only  one type of data is
Options: a. Report b. Field c. Query d. Record

Ans:ndash; b,ndash; b


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


A modem is connected in between a telephone line and a
Options: network,    computer,    communication adapter,    serial port

Ans:C ,C


What are the three options available in Insert >> Picture menu?
Options: a. Clipart, Pictures, Shapes b. Clipart, From File, Shapes c. Clipart, From Files, AutoShapes d. Clipart, Pictures, AutoShapes

Ans: – C , – C


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

Ans:C ,C


Storage on PC allows you to store files until something erases it, but memory loses its contents whenever its _____ is lost
Options: static,    disk space,    power,    both a and b above

Ans:C,C


The operator used to get value at address stored in a pointer variable is
Options: *,    &,    &&,    ||

Ans:A ,A

www.000webhost.com