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






More MS-Excel Related questions:


Which of the following is Relation-algebra Operation
Options: Select B. Union C. Rename D. All of the above

Ans:– D ,


An extranet is which of the following?
Options: The use of Internet protocols with limited access to company data by the company's customers and suppliers.,    The use of Internet protocols with unlimited access to company data by the company's customers and suppliers.,    The use of Internet protocols with limited access to company data by people within an organization.,    The use of Internet protocols with unlimited access to company data by people within an organization.

Ans:A ,A


Primary storage is _____as compared to secondary storage.
Options: Slow and inexpensive,    Fast and inexpensive,    Fast and expensive,    Slow and expensive

Ans:C ,C


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 ,


Which of the following correctly represents a long double constant?
Options: 6.68,    6.68L,    6.68f,    6.68LF

Ans:B ,B


In order to combat foreign competition, U.S. companies are:
Options: automating,    ignoring the situation,    seeking import tariffs,    decreasing the salaries

Ans:A ,A


On a class C network with a subnet mask of 192, how many subnets are available?
Options: 254,    62,    30,    2

Ans:D,2


Which is used to perform what if analysis?
Options: a. Solver b. Goal seek c. Scenario Manager d. All of above

Ans:#8211; d,#8211; d


.   Which of the following is not a way to cut text ?
Options: a. Select the text and press the delete button b. Select the text and select Edit, Cut from the menu c. Select the text and click the Cut button on the toolbar d. Select the text and press Ctrl + X

Ans:2 – A ,2 – A


Conversion method in which users, being used to an old system, continue to use the old system, alongside the new system, is
Options: multi processing,    multitasking,    parallel run,    All of the above

Ans:C ,C


A prefix for billion which is equal to _____ is called as billi.
Options: 100,    10000,    1000,    10

Ans:D ,D


. Operating system is
Options: a. A collection of software routines b. A collection of hardware components c. A collection of input and output devices d. All of above

Ans:0 – a ,0 – a


Which of the following column properties would be used to specify that cells in a column must be immediately filled with a monetary value of $10,000?
Options: Null status,    Data type,    Default value,    Data constraints

Ans:C ,C


Segmentation of a data stream happens at which layer of the OSI model?
Options: Physical,    Data Link,    Network,    Transport

Ans:D ,D


Which of the following statement is true concerning objects and/or classes?
Options: An object is an instance of a class.,    A class is an instance of an object.,    An object includes encapsulates only data.,    A class includes encapsulates only data.

Ans:A ,A


Which is a semi conductor memory?
Options:  Dynamic B.  Static C.  Bubble D.  Both a & b

Ans:– D ,


Which of the following performs modulation and demodulation?
Options: fiber optic,    satellite,    coaxial cable,    modem

Ans:D ,D


What resistence in ohms should be displayed ehen testing a speaker in a computer?
Options: 0 Ohms,    16 Ohms,    -200 Ohms,    Unlimited Ohms

Ans:B ,B


Which of the following is(are) true concerning information-system careers?
Options: the primary reason for this increase is the declining cost of hardware,    the number of information-system specialists recruited is expected to be greater than any other profession in the 1990s.,    an information-system career is one of the few area that is recession-proof,    both (a) and (b)

Ans:D ,D


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 term is used to describe RAM?
Options: Dynamic RAM (DRAM),    Static RAM (SRAM),    Video RAM (VRAM),    All of the above

Ans:D ,D


Which command will create a dynamic pool named Todd that will provide you with 30 global addresses?
Options: ip nat pool Todd 171.16.10.65 171.16.10.94 net 255.255.255.240,    ip nat pool Todd 171.16.10.65 171.16.10.94 net 255.255.255.224,    ip nat pool todd 171.16.10.65 171.16.10.94 net 255.255.255.224,    ip nat pool Todd 171.16.10.1 171.16.10.254 net 255.255.255.0

Ans:B ,B


Which one of the following properties of a magnetic circuit can be directly compared to current in an electrical circuit?
Options: Number of lines of force,    Flux density,    Reluctance,    Magnetomotive force

Ans:A ,A


The ODBC core API consists of which of the following functions?
Options: Commit or rollback transactions only,    Connect to data sources with driver-specific information only,    Connect to data sources only,    Both 1 and 3 above are in the OBDC core API.

Ans:D ,D


The Microsoft Access wildcards are ____ and ____ .
Options: asterisk (*); percent sign (%),    percent sign (%); underscore (_),    underscore(_); question mark (?),    question mark (?); asterisk (*)

Ans:D ,D


. Which technology is more reliable?
Options: A) Mechanical B) Electro-Mechanical C) Electronic D) For reliability it does not matter. So all of above are reliable

Ans:3-C,3-C


What will be the output of the program? #include<stdio.h> int main() { float a=0.7; if(a < 0.7) printf("C\n"); else printf("C++\n"); return 0; }
Options: C,    C++,    Compiler error,    Non of above

Ans:A ,A


Rapid prototyping proves the quality of a design by
Options: having a program simulate the real system,    having the system analyst present an overview of the design to users, programmers, and consultants,    having a data flow diagram,    both (a) and (b)

Ans:A ,A


Data has to be _____ before it can be converted into information.
Options: transformed,    processed,    changed,    engineered

Ans:B ,B


. Which of the following is default mode for Windows to start?
Options: a. Command Prompt b. Safe Mode c. Normal Mode d. None of above

Ans:9 – c ,9 – c


What form of energy is used to maintain an imbalance of charges between the terminals of a battery?
Options: Electronical energy,    Mechanical energy,    Chemical energy,    Solar energy

Ans:C ,C


.   Which view in PowerPoint can be used to enter speaker comments?
Options: a. Normal b. Slide show c. Slide sorter d. Notes page view

Ans:3 – D ,3 – D


A periodic report can be used to
Options: identify the problem,    evaluate solutions,    identify solutions,    select solutions

Ans:A ,A


. Referential integrity cannot be set for _______________ relationships.
Options: a. One-To-One b. Indeterminate c. One-To-Many d. Many-To-Many

Ans:9 – b ,9 – b


How to change the order of Slides in Presentation?
Options: On Slide Sorter View, click on the Soft Slides B. On Slide Sorter View, click on the slide and drag to required position C. On Slide Thumbnail view, click on the slide and drag to required position D. Slides order cannot be changed once it created

Ans:– B ,


Which of the following is the 1's complement of 10?
Options: 01,    110,    11,    10

Ans:A ,A


. A _____ is a collection of predefined design elements and color schemes.
Options: a. feature b. hyperlink c. palette d. theme

Ans:– D,– D


Which command will show you the IOS version running on your router?
Options: sh IOS,    sh flash,    sh version,    sh running-config

Ans:C ,C


What will be the output of the program? #include<stdio.h> #define FUN(arg) do\ {\ if(arg)\ printf("IndiaBIX...", "\n");\ }while(--i) int main() { int i=2; FUN(i<3); return 0; }
Options: IndiaBIX... IndiaBIX... IndiaBIX,    IndiaBIX... IndiaBIX...,    Error: cannot use control instructions in macro,    No output

Ans:B ,B


. Which of the following is first generation of computer
Options: A) EDSAC B) IBM-1401 C) CDC-1604 D) ICL-2900

Ans:9-A,9-A


GNOME is based on
Options: CORBA toolkit,    COM/DCOM toolkit,    ORE toolkit,    OLE DB toolkit

Ans:A ,A


How many worksheets can a workbook have?
Options: 3 B. 8 C. 255 D. none of above

Ans:– D ,


The heart of automation technology is.
Options: robots,    computers,    control,    sensors

Ans:B ,B


Some advantages of the database approach include all, but:
Options: minimal data redundancy.,    improved data consistency.,    improved data sharing.,    program-data dependency.

Ans:D ,D


. If you will be displaying or printing your document on another computer, you’ll want to make sure and select the _____________ option under the ‘Save’ tab.
Options: a. Embed Fonts b. Embed True Type Fonts c. Save True Type Fonts d. Save Fonts

Ans:– B,– B


A file produced by a spreadsheet
Options: is generally stored on disk in an ASCII text format,    can be used as it by the DBMS,    can be used for graphic,    All of the above

Ans:A ,A


. Which of the following operating system do you choose to implement a client server network?
Options: a. MS DOS b. Windows c. Windows 98 d. Windows 2000

Ans: d, d


Which of the following tool is used to partition your hard drive?
Options: mkfs,    fdisk,    fsck,    mount

Ans:B ,B


The standard IRQ for the floppy drive is?
Options: 9,    6,    10,    All of the above

Ans:B ,B


You telnet into a remote device and type debug ip rip, but no output from the debug command is seen. What could the problem be?
Options: You must type the show ip rip command first.,    IP addressing on the network is incorrect.,    You must use the terminal monitor command.,    Debug output is sent only to the console.

Ans:C ,C

www.000webhost.com