. What is the shortcut key to insert new sheet in current workbook?


Options: F11 B. Alt + F11 C. Ctrl + F11 D. Shift + F11

Ans:– D ,






More MS-Excel Related questions:


The data communication support should include, but is not restricted to
Options: file transfer and transaction processing,    file and database access,    terminal support, electronic mail and voice grams.,    All of the above

Ans:D ,D


. Who designed the first electronics computer ? ENIAC/
Options: A) Von Neumann B) Joseph M Jacquard C) J. P. Eckert and J. W. Mauchly D) All of above

Ans:C,C


8. …..interface consists of things like program counter, registers, interrupts and terminals
Options: a. Hardware b. Software c. Data d. None

Ans:Correct Answer: a,Correct Answer: a


A Monte Carlo simulation is an example of a(n)
Options: static model,    optimizing model,    both (a) and (b),    neither (a) nor (b)

Ans:D ,D


What command would you type to list all of the files in the current directory?
Options: DIR,    LIST ALL,    SHOW,    SHOW ME

Ans:A ,A


Which of the following is the decimal and hexadecimal equivalents of the binary number 10011101?
Options: 155, 0x9B,    157, 0x9D,    159, 0x9F,    185, 0xB9

Ans:B ,B


What command is used to query for a specific package with RPM?
Options: rpm -q,    rpm -a,    rpm -d,    rpm -1

Ans:A ,A


A processing unit that coordinates networks and data communication is known as
Options: Control unit,    Communications processor,    Register unit,    CPU

Ans:B ,B


. Font folder is located on
Options: a. Program folder b. Ms Word file c. Control Panel folder d. Desktop folder

Ans:0 – c ,0 – c


. “Ctrl + PageUp” is used to
Options: Moves the cursor one Page Up B. Moves the cursor one Paragraph Up C. Moves the cursor one Screen Up D. Moves the cursor one Line Up

Ans:– A ,


. The ….command is used to open windows based application directly from DOS prompt
Options: a. Run b. Start c. Load d. Execute

Ans:9 – b ,9 – b


The basic operations performed by a computer are
Options: Arithmetic operation B. Logical operation C. Storage and relative D. All the above

Ans:– D ,


Logical models form the basis for computing systems that generate information useful in dealing with
Options: dynamic situations,    uncertain situations,    complex situations,    All of the above

Ans:D ,D


The DBMS that is most difficult to use is ________ .
Options: Microsoft's SQL Server,    Microsoft's Access,    IBM's DB2,    Oracle Corporation's Oracle

Ans:D ,D


. What is defined by Handout Master?
Options: a. Slide Formatting b. Slide Transaction c. Layout of Handout d. Layout of Slide

Ans:6 – C ,6 – C


What type of memory is not directly addressable by the CPU and requires special software called EMS (expanded memory specification)?
Options: Extended,    Expanded,    Base,    Conventional

Ans:B ,B


Which EIGRP information is held in RAM and maintained through the use of Hello and update packets? Neighbor table STP table Topology table DUAL table
Options: 2 only,    4 only,    1 and 3,    All of the above

Ans:C ,C


Which of the following typically uses a keyboard for input?
Options: desktop terminal,    point-of-sale terminal,    financial transaction terminal,    All of the above

Ans:D,All of the above


Which of the following is not the Section Break Option?
Options: a. Next Page b. Previous Page c. Odd Page d. Even Page

Ans:–  B,–  B


A benefit of the three-tier architecture is which of the following?
Options: New modules can be built to support specific business needs,    Performance improves for compiled SQL statements,    Results in a thinner client and database server,    All of the above.

Ans:A ,A


The 32-bit internet address 10000000 00001010 00000010 00011110 will be written in dotted decimal notation as
Options: 128.10.2.30,    210.20.2.64,    164.100.9.61,    148.20.2.30

Ans:A ,A


The vice-president of information has primary responsibility for
Options: recognizing information needs,    preparing an MIS study proposal,    setting MIS objectives,    establishing MIS constraints

Ans:B ,B


How is the integral mode implemented using analog methods?
Options: Op amp and resistors,    Op amp and a capacitor,    Op amp and an RC network to place the error voltage across the capacitor,    All of the above

Ans:B ,B


CSMA (Carrier Sense Multiple Access) is
Options: a method of determining which device has access to the transmission medium at any time,    a method access control technique for multiple-access transmission media.,    a very common bit-oriented data link protocol issued by ISO.,    network access standard for connecting stations to a circuit-switched network

Ans:B ,B


Typewriter terminals can print computer-generated data at a rate of
Options: 10 characters per second,    120 characters per second,    120 characters per minute,    1200 characters per minute

Ans:B ,B


. To set an exception to an AutoCorrect rule, click _____ on the menu bar and then click AutoCorrect Options to display the AutoCorrect dialog box.
Options: a. Format b. Edit c. Tools d. View

Ans: – C , – C


In SQL, the CREATE VIEW command is used
Options: to recompile view,    to define a view of one or more tables or views,    to recompile a table,    to create a trigger

Ans:B ,B


13. While working with MS-DOS, which command is used to more file from one directory to another?
Options: a. Rename b. Copy c. Move d. Cp

Ans:Correct Answer: c,Correct Answer: c


An Oracle System Change Number (SCN):
Options: is a value that is incremented whenever a dirty read occurs.,    is incremented whenever a deadlock occurs.,    is a value that keeps track of explicit locks.,    is a value that is incremented whenever database changes are made.

Ans:D ,D


Full adder has
Options: 4 inputs,    8 inputs,    10 inputs,    3 inputs

Ans:D ,D


. An application program that helps the user to change any number and immediately see the result of that change is
Options: A) Desktop publishing program B) Database C) Spreadsheet D) All of above

Ans:2-C,2-C


. The lower deck of an abacus is known as
Options: A) heaven B) sky C) earth D) floor

Ans:C,C


61. In Word you can force a page break
Options: a. By positioning your cursor at the appropriate place and pressing the F1 key b. By using the Insert/Section break on the Insert tab c. By positioning your cursor at the appropriate place and pressing Ctrl+Enter d. By changing the font size of your document

Ans:– C ,– C


A hand-held device which reads marks or characters on paper by detecting photo-sensitivity is known as
Options: Light pen,    Optical-wand,    Plotter,    All of the above

Ans:B ,B


A computer, by definition, is any device that computers. This broad definition includes which of the following?
Options: Calculators,    Cash registers,    Automotive controllers,    Desktop computers

Ans:E ,E


A word field may consist of an optional field instruction called a(n) ______ 
Options: a. subdocument b. symbol c. signal d. switch

Ans:–  D,–  D


Which of the following is a type of systems software used on microcomputers?
Options: MS-DOS,    PC-DOS,    Unix,    All of the above

Ans:D ,D


An entity type is which of the following?
Options: A major category of data about people, place, and things,    The various departments of an organization,    The application software,    The business processes the support the mission of an organization

Ans:A ,A


. What does the VLOOKUP function do?
Options: a. Looks up text that contain ‘v’ b. Checks whether text is the same in one cell as in the next c. Finds related records d. All of above

Ans:– c,– c


. The instructions for starting the computer are house on
Options: A) Random access memory B) CD-Rom C) Read only memory chip D) All of above

Ans:7-C,7-C


Before a disk drive can access any sector record, a computer program has to provide the record's disk address. What information does this address specify?
Options: Track number,    Sector number,    Surface number,    All of the above

Ans:D,D


An _____ system has a stored knowledge base and an inference engine.
Options: expert,    centers,    control,    MIS

Ans:A ,A


What is the loopback address?
Options: 127.0.0.1,    255.0.0.0,    255.255.0.0,    255.255.255.255.0

Ans:A ,A


IBM's Micro Channel Architecture (MCA) specifies which type of the following bit access widths?
Options: 8 bit & 16 bit,    16 bit & 24 bit,    16 bit & 32 bit,    32 bit & 64 bit

Ans:C ,C


. To print documents from Windows
Options: a. File >> Print b. Drag the document icon over your printers icon c. Edit print d. Both a and B

Ans:8 – d ,8 – d


. What is the shortcut key to insert current date in a cell?
Options: a. CTRL + D b. CTRL + T c. CTRL + ; d. CTRL + /

Ans:– c,– c


. When was the company named IBM?
Options: A) 1914 B) 1924 C) 1975 D) None of above

Ans:7-B,7-B


What is the shortcut key for “Subscript ” the selected text?
Options: Ctrl + = B. Ctrl + – C. Ctrl + Shift + = D. Ctrl + Shift + –

Ans: – A ,


A device that converts mechanical pressure to electrical energy is called a:
Options: piezoelectric device,    solar cell,    photodiode,    nicad cell

Ans:A ,A


Which of the following statement is correct prototype of the malloc() function in c ?
Options: int* malloc(int);,    char* malloc(char);,    unsigned int* malloc(unsigned int);,    void* malloc(size_t);

Ans:D ,D

www.000webhost.com