How do you tell one cell from another?


Options: By numbers B. By letters C. By its address D. by color

Ans:– C ,






More MS-Excel Related questions:


What is the result of segmenting a network with a bridge (switch)? It increases the number of collision domains. It decreases the number of collision domains. It increases the number of broadcast domains. It decreases the number of broadcast domains. It makes smaller collision domains. It makes larger collision domains.
Options: 1 and 5,    2, 3 and 5,    3, 4 and 6,    1, 3 and 6

Ans:A ,A


The library function used to find the last occurrence of a character in a string is
Options: strnstr(),    laststr(),    strrchr(),    strstr()

Ans:C ,C


. Which computers are used as servers for any medium sized organizations?
Options: A) Mainframe Computer B) Mini Computers C) Micro Computers D) Super Computers

Ans:B,B


What layer of OSI determines the interface of the system with the user?
Options: Session,    Data-link,    Application,    Network

Ans:C ,C


. Which of the following is use to get data from user?
Options: a. Query b. Pages c. Form d. Report

Ans:– c,– c


. Line spacing refers to
Options: a. The space between the lines of text b. The height of the line c. The length of the line d. a and c

Ans:6 – A ,6 – A


Which of the following position is not available for fonts on MS Word?
Options:  A) Normal, B) Raised, C) Lowered, D) Centered, 

Ans:-D,-D


What are the types of linkages?
Options: Internal and External,    External, Internal and None,    External and None,    Internal

Ans:B ,B


. ALU is
Options: A) Arithmetic Logic Unit B) Array Logic Unit C) Application Logic Unit D) None of above

Ans:0-A,0-A


What command is used to reset a MODEM when using the
Options: ATR,    ATZ,    DTR,    DCE

Ans:B ,B


. Which of the following database objects extracts information from one or more tables or queries?
Options: a. Forms b. Queries c. Reports d. Tables

Ans:8 – b ,8 – b


By default, Word automatically formats each heading in a table of contents as __________
Options: bookmarks B. cross-references C. hyperlinks D. word-fields

Ans:– C ,


. Which of the following field properties enforces the use of parentheses when keying an area code?
Options: a. Field Size b. Format c. Input Mask d. Validation Rule

Ans:0 – c ,0 – c


. Which of the following require large computers memory?
Options: A) Imaging B) Graphics C) Voice D) All of Above

Ans:D,D


Which one of the following statements is true for the voltage in a parallel RL circuit?
Options: The voltage always has the same amplitude and phase for every part of the circuit,    The total voltage is equal to the sum of the voltages across the resistance and inductance,    The total voltage lags the total current by less than 90,    The total voltages is less than the sum of the voltages across the resistance and inductance

Ans:A ,A


A small film-plate which is used for microfilming the output from a microcomputer screen is called
Options: microfilm,    microfiche,    film card,    COM

Ans:B ,B


. How to change row height in Word 2010?
Options: Edit Table from the Layout ribbon, select Row tab B. Properties from the Layout ribbon, select Row tab C. Edit Height from the Design ribbon, select Row tab D. Row Height from the Table ribbon, select Row tab

Ans:– B ,


The packets switching concept was first proposed
Options: in the late 1980s for the Defense Ministry of US.,    in the early 1960s for military communication systems, mainly to handle speech,    in the late 1950s for Defense Ministry of US,    All of the above

Ans:B ,B


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


If the processor of a computer does not have a direct and unassisted access to data items, these items are said to be
Options: offline,    remote,    disconnected,    detached

Ans:A ,A


What will be the output of the program? #include<stdio.h> int fun(int **ptr); int main() { int i=10; const int *ptr = &i; fun(&ptr); return 0; } int fun(int **ptr) { int j = 223; int *temp = &j; printf("Before changing ptr = %5x\n", *ptr); const *ptr = temp; printf("After changing ptr = %5x\n", *ptr); return 0; }
Options: Address of i Address of j,    10 223,    Error: cannot convert parameter 1 from 'const int **' to 'int **',    Garbage value

Ans:C ,C


An extent is which of the following?
Options: A keyword that indicates that the subclass inherits from a superclass,    A keyword that indicates that the superclass inherits from a subclass,    The set of all instances of a class within a database,    Only one instance of a class within a database

Ans:C ,C


A compiler means
Options: A person who compiles source programs,    The same thing as a programmer,    Keypunch operator,    A program which translates source program into object program

Ans:D,(Danswer


. Getting data from a cell located in a different sheet is called….
Options: a. Accessing b. Referencing c. Updating d. Functioning

Ans:– b,– b


ASCII stands for
Options: American standard code for information interchange,    All purpose scientific code for information interchange,    American security code for information interchange,    American Scientific code for information interchange

Ans:A,(Aanswer


Which command will show you all the translations active on your router?
Options: show ip nat translations,    show ip nat statistics,    debug ip nat,    clear ip nat translations *

Ans:A ,A


. While inserting a diskette into the diskette drive of a PC, the diskette’s label side should face

Options: A) East B) North C) South D) Up

Ans:D,D


Which is not true of a correlated subquery?
Options: EXISTS/NOT EXISTS is a form of a correlated subquery.,    The processing of the SELECT statements is nested.,    They can be used to verify functional dependencies.,    They are very similar to a regular subquery.

Ans:D ,D


. Which is the limitation of high level language?
Options: A) Lower efficiency B) Machine dependence C) machine level coding D) None of above

Ans:A,A


CAE and CAM are linked through:
Options: a common data base and communications system,    NC tape programming and automated design,    parts production and testing,    assembly automation and tool production.

Ans:A ,A


Ctrl + W
Options: a. Save and Print the Document b. Save and Close Word Application c. Save and Close document d. Without Save, Close Document

Ans:–  C,–  C


Computer information systems are most successful in providing information for:
Options: control decisions,    planning decisions,    strategic decisions,    nonprogrammable decisions

Ans:A ,A


Which of the following commands is used to absolutely assign all permissions to the owner, read and write permissions to the group and only executable permission to the others of the file note?
Options: chmod 761 note,    chmod 671 note,    chmod 167 note,    chmod 4=rwx, g=rw note

Ans:A ,A


A vertically aligned set of tracks on a disk pack is known as
Options: Cluster,    Surface,    Cylinder,    Panel

Ans:C ,C


_______ provides a connection-oriented reliable service for sending messages
Options: TCP B. IP C. UDP D. All of the above

Ans:– A ,


The situation when in a linked list START=NULL is
Options: a. underflow b. overflow c. housefull d. saturated

Ans:- a,- a


What will happen if in a C program you assign a value to an array element whose subscript exceeds the size of array?
Options: The element will be set to 0.,    The compiler would report an error.,    The program may crash if some important data gets overwritten.,    The array size would appropriately grow.

Ans:C ,C


. to activate the previous cell in a pre-selected range, press
Options: a. the Alt key b. the Tab key c. the Enter key d. none of above

Ans:– d,– d


A computer program that converts an entire program into machine language at one time is called a/an
Options: interpreter,    simulator,    compiler,    commander

Ans:C ,C


An example of digital, rather than analog, communication is
Options: DDD,    DDS,    WATS,    DDT

Ans:B ,B


. The formats defined by _____ include character formatting, such as the font and font size; paragraph formatting, such as line spacing and text alignment; table formatting; and list formatting.
Options: a. options b. styles c. toolbars d. tabs

Ans: – B , – B


. Multiple calculations can be made in a single formula using…..
Options: Standard Formulas B. Array Formula C. Complex Formulas D. Smart Formula

Ans: – B ,


Which of the following best illustrates the default subnet mask for a class A,B, and C Network?
Options: 0.0.0.0, 0.0.0.1, 0.0.1.1,    255.255.255.0, 255.255.0.0, 255.0.0.0,    255.0.0.0, 255.255.0.0, 255.255.255.0,    255.255.0.0, 255.255.255.0, 255.255.255.255

Ans:C ,C


. Which of the following statements about a tab control in a form is incorrect?
Options: a. It can contain only one object. b. It defines a layered space. c. It is a control object. d. It is created in multipage forms.

Ans:– a,– a


Direct Numerical Control means:
Options: using several computers to control one large machine,    using one computer to control several machines,    complete elimination of a need for a human operator.,    eliminating computers from the manufacturing process

Ans:B ,B


RTS stands for:
Options: ready to start,    ready to switch,    request to send,    request to scan

Ans:C ,C


. The autofill feature
Options: a. Extends a sequential series of data b. Automatically adds a range of cell values c. Applies a boarder around selected cells d. None of above

Ans:– a,– a


How many operations per second can perform by a modern fast mainframe digital computer.
Options: 1000,    100,000,    10,00,000,    1,00,00,00,000

Ans:D ,D


The term used to refer to the checking of outputs of a computer, with the corresponding input documents, is called
Options: auditing around the computer,    auditing through the computer,    process control,    beta-test

Ans:A ,A


Which tab is not available on left panel when you open a presentation?
Options: a. Outline b. Slides c. Notes d. All of above are available

Ans:– C ,– C

www.000webhost.com