. 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 ,


Description: mcqquestions

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

Hits Today: 15902






More MS-Excel Related questions:


. Computer Model IBM 1401 is
Options: First Generation Computer B. Second Generation Computer C. Third Generation Computer D. Fourth Generation Computer

Ans:– B ,


. Virtual memory typically located on
Options: a. RAM b. CPU c. Flash card d. Hard drive

Ans:0 – d ,0 – d


A word processor designed for programmers is called
Options: a formatter,    a compiler,    an editor,    a debugger

Ans:C ,C


Which shell's wild-cards is used to match a single character?
Options: *,    ?,    [ijk],    [!ijk]

Ans:B ,B


One of the three most common types of payment systems is the
Options: pinion fund transaction system,    travel expense reimbursement system,    accounts payable system,    All of the above

Ans:D ,D


Determine the resistance value and tolerance of a resistor that has the following color bands; first band is red, second band is red, third band is orange, and the fourth band is gold
Options: 220 Ohm, 5%,    220 Ohm, 10%,    22,000 Ohm, 5%,    22, 000 Ohm, 10%

Ans:C ,C


. Which Form tool creates a new form that show both a form and datasheet views?
Options: a. Form b. Form Wizard c. Multiple Item Form d. Split Form

Ans:1 – d ,1 – d


The first AI programming language was called:
Options: BASIC,    FORTRAN,    IPL,    LISP

Ans:C ,C


Operating system functions may include
Options: input/output control,    virtual storage,    multiprogramming,    All of the above

Ans:D ,D


If the memory slots have 30 pins then the chip is a?
Options: DIMM,    SIMM,    SDRAM,    All of the above

Ans:B ,B


A high quality CAD system uses the following for printing drawing and graphs
Options: Dot matrix printer,    Digital plotter,    Line printer,    All of the above

Ans:B,B


. Which of the following function will use to find the highest number in a series of number?
Options: a. MAX(B1:B3) b. MAXIMUM (B1:B3) c. HIGH (B1:B3) d. HIGHEST(B1:B3)

Ans:– a,– a


  A function inside another function is called _______
Options: Nested function B. Round function C. Sum function D. Text function

Ans:– A ,


Demodulation is a process of
Options: converting analog to digital signals,    converting digital to analog signals,    multiplexing various signals into one high speed line signals,    performing data description.

Ans:A ,A


What is the difference between ‘Open’ and ‘Open Exclusively’?
Options: a. Open statement opens access database files and Open Exclusively opens database files of other program like Oracle b. Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed c. Both Open and Open Exclusively are same d. Open Exclusive command does not exist in MS Access

Ans:ndash; b,ndash; b


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

Ans:D ,D


In order to edit a chart, you can
Options: a. Triple click the chart object b. Click and drag the chart object c. Double click the chart object d. Click the chart object

Ans: – C , – C


. Which operating system does not support long file names?
Options: a. OS/2 b. Windows 98 c. DOS 6.2 d. Windows NT

Ans:3 – c ,3 – c


HIMEM.SYS controls:
Options: DOS=HIGH,    RMDRIVE.SYS,    SMARTDRV.SYS,    Extended Memory

Ans:D ,D


.   To select all the boxes of an organization chart
Options: a. Click edit, select all b. Right click the chart background click select all c. Press and hold the shift key and click each box d. All of the above

Ans:6 – D ,6 – D


What is the output of the program? #include<stdio.h> int main() { union a { int i; char ch[2]; }; union a u; u.ch[0] = 3; u.ch[1] = 2; printf("%d, %d, %d\n", u.ch[0], u.ch[1], u.i); return 0; }
Options: 3, 2, 515,    515, 2, 3,    3, 2, 5,    None of these

Ans:A ,A


What was the name of the first stored program electronic computer which was built in 1949 at Cambridge University in England?
Options: EDVAC,    EDSAC,    UNIVAC,    MARK-I

Ans:B ,B


.The complexity of Binary search algorithm is
Options: A)O(n) b.O(log ) c.O(n2) d.O(n log n)

Ans:B,B


The black-box concept:
Options: is invoked by describing a system in terms of inputs and outputs, leaving the transformation process a black box.,    assumes that the black box is independent,    assumes that inputs and outputs will remain stable,    All of the above

Ans:E ,E


Management's decision to rent a computer system may be based upon
Options: tax advantages,    desire to avoid a large one-time payment,    operational flexibility in changing hardware,    All of the above

Ans:D ,D


. Which command displays only directory?
Options: a. Dir/aa b. Dir/od c. Dir/directory d. Dir/ad

Ans:9 – d ,9 – d


Which of the following commands is used to obtain a list of all files by modification time?
Options: ls -1,    ls -t,    ls -i,    ls -R

Ans:B ,B


. An input /output device at which data enters or leaves a computer system is
Options: A) Keyboard B) Terminal C) Printer D) Plotter

Ans:8-B,8-B


. Which part of the computer is used for calculating and comparing?
Options: A) Disk unit B) Control unit C) ALU D) Modem

Ans:C,C


Which is not a data source component?
Options:  A) mail merge toolbar, B) header row, C) data fields, D) data records, 

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


Comments put in cells are called …..
Options: Smart Tip B. Cell Tip C. Web Tip D. Soft Tip

Ans:– B ,


Which area in an excel window allows entering values and formulas
Options: a. Title bar b. Menu bar c. Formula bar d. Standard toolbar

Ans:#8211; c,#8211; c


The difference between linear array and a record is
Options: a. An array is suitable for homogeneous data but the data items in a record may have different data type b. In a record, there may not be a natural ordering in opposed to linear array. c. A record form a hierarchical structure but a linear array does not d. All of above

Ans: d, d


.   Which command select all object at one time when selecting multiple objects to be deleted?
Options: a. Alt + a b. Ctrl + a c. Shift + Enter d. Edit, Select All

Ans:4 – D ,4 – D


Block caches or buffer caches are used
Options: to improve disk performance,    to handle interrupts,    to increase the capacity of the main memory,    to speed up main memory read operation

Ans:A ,A


Which option will be used with disk free command to include the total amount of disk space in the file system?
Options: -t,    -tt,    -4,    -i

Ans:A ,A


. You should choose Sleep option when
Options: a. The computer is tired after working for the whole day b. You are leaving for a very short time and want to resume you work shortly c. Whencomputer gets hanged frequently. Let it sleep for some time d. You finish working and going to bed

Ans: b, b


Off-line operation is the operation of devices without the control of
Options: Memory,    CPU,    ALU,    Control unit

Ans:B,B


  To insert new slide in the current Presentation, we can choose:
Options: Ctrl+M B. Ctrl+N C. Ctrl+O D. Ctrl+F

Ans:– A ,


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

Ans:C ,C


A computer program that contains expertise in a particular domain is called an:
Options: intelligent planner,    automatic processor,    expert system,    operational symbolizer

Ans:C ,C


. Can you tell what passes into and out from the computer via its ports?
Options: A) Data B) Bytes C) Graphics D) Pictures

Ans:A,A


. Which of the following is the structure of the Database?
Options: a. Table b. Schema c. Relation d. None of these

Ans: – b ,


A system program that sets up an executable program in main memory ready for execution is
Options: assembler,    linker,    loader,    compiler

Ans:C ,C


A general purpose single-user microcomputer designed to be operated by one person at a time is
Options: Special-purpose computer,    KIPS,    M,    PC

Ans:D ,D


A lock that allows concurrent transactions to access different rows of the same table is known as a
Options: Field-level lock B. Row-level lock C. Table-level lock D. Database-level lock

Ans:– A ,


Computer instructions written with the use of English words instead of binary machine code is called
Options: Mnemonics,    Symbolic code,    Gray code,    Op-code

Ans:B,B


Doubling the diameter of the coil in an inductor:
Options: multiplies the value of inductance by two,    reduces the value of inductance by one-half,    reduces the value of inductance by one-fourth,    multiplies the value of inductance by four

Ans:A ,A


An integrated circuit is
Options: A) A complicated circuit B) An integrating device C) Much costlier than a single transistor D) Fabricated on a tiny silicon chip

Ans:-D,-D

www.000webhost.com