The cell reference for cell range of G2 to M12 is_


Options: A. G2.M12, B. G2;M12, C. G2:M12 ,D. G2-M12

Ans:C ,G2:M12


Description: mcqquestions






More MS-Excel Related questions:


Where would you load the mouse driver mouse.sys?
Options: config.sys,    autoexec.bat,    win.ini,    io.sys

Ans:A ,A


A transformer has a primary voltage of 120 V rms and a secondary voltage of 25 V rms. If the secondary current is 1A rms, what is the primary current?
Options: 7.8 mA,    208 mA,    200 mA,    300 mA

Ans:B ,B


Where have the program and data to be located before the ALU and control unit of a computer can operate on it?
Options: Internal memory,    Secondary memory,    Microprocessor,    Magnetic tapes

Ans:A,A


Which of the following is not one of the three primary functions that on-line direct-access systems can serve?
Options: inquiry,    backup,    update,    programming

Ans:B ,B


A half byte is know is
Options: Data,    Bit,    Half byte,    Nibble

Ans:D ,D


A venturi tube:
Options: is extremely difficult to use,    is made only of metal,    measures the presence of a liquid,    can be used to measure gas or liquid flow rates

Ans:D ,D


. Which of the following components has a property sheet that includes settings for the frame and the option group?
Options: a. Option group label b. Option group frame c. Option button d. Option button labels

Ans:– b,– b


Point out the error in the following program. #include<stdio.h> #include<stdarg.h> void display(char *s, ...); void show(char *t, ...); int main() { display("Hello", 4, 12, 13, 14, 44); return 0; } void display(char *s, ...) { show(s, ...); } void show(char *t, ...) { int a; va_list ptr; va_start(ptr, s); a = va_arg(ptr, int); printf("%f", a); }
Options: Error: invalid function display() call,    Error: invalid function show() call,    No error,    Error: Rvalue required for t

Ans:B ,B


Which of the following is used to make a programs run when the computer is switched on.
Options: Autoboot,    Warmboot,    Bubble,    Authentication

Ans:A ,A


. Which is NOT an option of the Picture Size Mode property?
Options: a. Clip b. Fit c. Stretch d. Zoom

Ans:7 – b ,7 – b


. Dial up connection allows you to
Options: a. Connect ISP b. Internet c. Server d. All of above

Ans:1 – a ,1 – a


. An example of a digital device can be
Options: A) Digital clock B) Automobile speed meter C) Clock with a dial and two hands D) All of the above

Ans:A,A


In Decision Tables three are:
Options: tabulated decisions,    decisions,    condition stubs and action stubs,    decision hierarchy

Ans:C ,C


Database redesign is not terribly difficult if the:
Options: database is structured.,    database is well-designed.,    database has no data.,    database is relatively small.

Ans:C ,C


. To create a table in Access
Options: a. Database should be created before create table b. Table can be created using Table Templates c. There must be at least one Primary key in a table d. All of the above

Ans:– d,– d


. Selecting the Rows 5 & 6 then choose Insert->Row. What will happen?
Options: 2 Rows will be inserted after Row 4 B. 2 Rows will be inserted after Row 5 C. 2 Rows will be inserted after Row 6 D. 2 Rows will be inserted after Row 7

Ans:– A ,


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


. Scandisk
Options: a. Checks the disk b. Give information about disk c. Run from DOS mode d. All of the above

Ans:9 – d ,9 – d


. What is the use of Referential Integrity in MS Access?
Options: a. It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table b. It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table c. It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table d. None of above

Ans:– a,– a


. Which of the following statement is true?
Options: a. Foreign key fields don’t allow duplicate values b. In primary key field you can enter duplicate value c. In an indexed field you may or may not enter duplicate value depending upon setting d. All statements are true

Ans:3 – c ,3 – c


. Where will store data first time when you copy
Options: a. Clipboard b. Clipbook c. Hard disk d. CD

Ans:1 – a ,1 – a


A machine that connects to two or more electronic mail systems and transfers mail messages among them is known as
Options: Gateways,    mail gateway,    bridges,    User Agent

Ans:B ,B


Which policy replace a page if it is not in the favoured subset of a process's pages?
Options: FIFO,    LRU,    LFU,    Working set

Ans:D ,D


A distributed network configuration in which all data/information pass through a central computer is
Options: bus network,    star network,    ring network,    Point-to-point network

Ans:B ,B


. Which of the following statement is false?
Options: A) Mechanical analog computers have existed for thousands of years B) There are mechanical analog computers and electronic analog computers. C) All electronic computers are digital computers D) All of above are false

Ans:C,C


.   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


. Digital devices are
Options: A) Digital Clock B) Automobile speed meter C) Clock with a dial and two hands D) All of them

Ans:2-A,2-A


A connection between two end points, either physical or logical, over which data may travel in both directions simultaneously is called _____
Options: Dump point,    Datalink,    Duplex,    Networks

Ans:C ,C


Natural language understanding is used in:
Options: natural language interfaces,    natural language front ends,    text understanding systems,    All of the above

Ans:D ,D


A systems programming language for microcomputers in the Intel family is
Options: PL/C,    PL/CT,    PL/M,    PLA

Ans:C,(Canswer


The concept of a general CAD system was that it should provide:
Options: A system for handling user actions.,    A system for the operation of applications programming.,    A set of basic system functions and utilities.,    All of the above

Ans:D ,D


. Which elements of a worksheet can be protected from accidental modification?
Options: a. Contents b. Objects c. Scenarios d. All of the above

Ans:– d,– d


. Descending Order of a data Hierarchy is
Options: Database – File – Record – Fields – Bytes – Bit B. Database – File – Record – Fields – Bit – Bytes C. Database – Record – File – Fields – Bytes – Bit D. Database – Record – Fields – File – Bytes – Bit

Ans:– A ,


The highest level in the hierarchy of data organization is called
Options: a. data bank b. data base c. data file d. data record

Ans:.b,.b


After coding a document into a digital signal, it can be sent by telephone, telex or satellite to the receiver where the signal is decoded and an exact copy of the original document is made. What is it called?
Options: Telex,    Word processor,    Facsimile,    Electronic mail

Ans:C ,C


. You can use the formula pallette to
Options: a.  format cells containing numbers b.  create and edit formula containing functions c.  enter assumptions data d.  copy a range of cells

Ans:– b,– b


In synchronous transmission data from various users
Options: Require header,    Do not require header,    Sometimes require header,    All of the above

Ans:B ,B


Which of the following data structure is linear data structure?
Options: a. Trees b. Graphs c. Arrays d. None of above  

Ans:c,c


In a _____ a parent record type can be linked to one or more "child" record types, but a child record type can have only one parent.
Options: Network database,    Relational database,    Distributed database,    Hierarchical database

Ans:D ,D


. You can open the Highlight Changes dialog box by choosing Track Changes from the …. Menu.
Options: a. Edit b. Insert c. Format d. Tools

Ans:– d,– d


Which of the following statements is a true statement concerning the open database connectivity standard (ODBC)?
Options: Each vendor desiring to be ODBC-complaint provides an ODBC driver.,    Requires certain criteria to be met in order to establish an ODBC connection.,    Provides a programming interface that provides a common language for application programs to access and process SQL databases independent of the RDBMS accessed.,    All of the above.

Ans:D ,D


What will be the output of the program? #include<stdio.h> #define SQR(x)(x*x) int main() { int a, b=3; a = SQR(b+2); printf("%d\n", a); return 0; }
Options: 25,    11,    Error,    Garbage value

Ans:B ,B


As the temperature increases, the current gain
Options: increases,    decreases,    contant,    can be any of the above

Ans:A ,A


. Which of the cell pointer indicates you that you can make selection?
Options: a.  Doctor’s symbol (Big Plus) b.  small thin plus icon c.  Mouse Pointer with anchor at the tip d.  None of above

Ans:– a,– a


Use of a supertype/subtype relationship is necessary when which of the following exists?
Options: An instance of a subtype participates in a relationship that is unique to that subtype.,    An instance of a subtype participates in a relationship that is the same as the other subtypes.,    Attributes apply to all of the instances of an entity type.,    No attributes apply to any of the instances of an entity type.

Ans:A ,A


Three-tier architecture includes which of the following?
Options: Three server layers,    A client layer and two server layers,    Two client layers and one server layer,    Three client layers

Ans:B ,B


In the following program how long will the for loop get executed? #include<stdio.h> int main() { int i=5; for(;scanf("%s", &i); printf("%d\n", i)); return 0; }
Options: The for loop would not get executed at all,    The for loop would get executed only once,    The for loop would get executed 5 times,    The for loop would get executed infinite times

Ans:D ,D


Which of the following is not a valid data type in Excel?
Options: Number B. Character C. Label D. Date/Time

Ans:– B ,


Which of the following modes are valid when a switch port is used as a VLAN trunk? Blocking Dynamic auto Dynamic desirable Nonegotiate Access Learning
Options: 1, 2 and 6,    2, 3 and 4,    4, 5 and 6,    2, 4, and 5

Ans:B ,B


The black box concept is based on the assumption(s) that;
Options: the suprasystem is stable,    black boxes are dependent or environments,    the relationship between the inputs and output is stable,    All of the above

Ans:C ,C

www.000webhost.com