. How to specify cell range from A9 to A99 in Excel?


Options: (A9, A99) B. (A9 to A99) C. (A9 : A99) D. (A9 – A99)

Ans:– C ,






More MS-Excel Related questions:


Which of the following is the oldest spreadsheet package?
Options: a. VisiCalc b. Lotus 1-2-3 c. Excel d. StarCalc

Ans:#8211; a,#8211; a


. Which of the following will not set text in selected cells to italics?
Options: a. Pressing Ctrl + I on the keyboard b. Using the Tools – Wizard – Web Form menu item c. Using the Format – Cells – Font menu item d. None of the above

Ans:– b,– b


Which of the following is considered a broadband communications channel?
Options: coaxial cable,    fiber optic cable,    microwave circuits,    All of the above

Ans:D,All of the above


A byte is comprised of:
Options: One bit,    Four bits,    Eight bits,    Sixteen bits

Ans:C,C


The general range of speed in revolutions per minute (rpm) at which floppy disks rotate is
Options: 2400-4700,    390-600,    150-250,    300-600

Ans:C ,C


Suppose the zener diode has a breakdown voltage of 10 V and zener resistance of 8.5 W, what is the additional voltage when the current is 20 mA?
Options: 0.17 V,    10.17 V,    20 V,    18.8 V

Ans:A ,A


. Primary key is
Options: a. Uniquely identifies each record b. Cannot be repeated c. AutoNumber is example of Primary key d. All of the above

Ans:– d,– d


A language which is close to that used within the computer is
Options: High-level language,    Assembly language,    Low-level language,    All of the above

Ans:C ,C


Computer can not do anything without a
Options: Chip,    Memory,    Output device,    Program

Ans:D ,D


Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Options: Read committed,    Read uncommitted,    Repeatable read,    Serializable

Ans:C ,C


System prototyping helps the designer in
Options: making the programmers understand how the system will function.,    communicating to the user, quickly, how the system, when developed, will look like and get a feedback.,    giving a demo of the software, to the system manager to whom he reports,    both (a) and (b)

Ans:B ,B


When you link data maintained in an excel workbook to a word document
Options: a. The word document cannot be edit b. The word document contains a reference to the original source application c. The word document must contain a hyperlink d. The word document contains a copy of the actual data

Ans:#8211; b,#8211; b


. Which unit converts computer data into human readable form?
Options: A) Input unit B) Output unit C) ALU D) Control Unit

Ans:B,B


. What is the easiest method to run MS Dos in Windows environment?
Options: a. My computer b. Go to Dos from Start menu c. Click on icon on desktop d. Type Command in run dialog box

Ans:4 – d ,4 – d


An unloaded zener regulator has a source voltage of 20 V, a series resistance of 330 W, and a zener voltage of 12 V, What is the Zener current?
Options: 28.4 mA,    24.2 mA,    34.4 mA,    68.4 mA

Ans:B ,B


To center worksheet titles across a range of cells, you must
Options: a. Select the cells containing the title text plus the range over which the title text is to be centered b. Widen the columns c. Select the cells containing the title text plus the range over which the title text is to be enfettered d. Format the cells with the comma style

Ans:#8211; a,#8211; a


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

Ans:B ,B


Which protocol reduces administrative overhead in a switched network by allowing the configuration of a new VLAN to be distributed to all the switches in a domain?
Options: STP,    VTP,    DHCP,    ISL

Ans:B ,B


Which of the following is a serious problem of file management systems?
Options: difficult to update,    lack of data independence,    data redundancy,    program dependence

Ans:E ,E


By default a real number is treated as a
Options: float,    double,    long double,    far double

Ans:B ,B


. Which of the following field properties is an expression that specifies criteria or requirements for entering data?
Options: a. Field Size b. Format c. Input Mask d. Validation Rule

Ans:1 – d ,1 – d


The CCITT Recommendation X.25 specifies three layers of communications:
Options: application, presentation and session,    Session, transport and network,    physical datalink and network,    datalink, network and transport

Ans:C ,C


According to ANSI specifications which is the correct way of declaring main when it receives command-line arguments?
Options: int main(int argc, char *argv[]),    int main(argc, argv) int argc; char *argv; ,    int main() { int argc; char *argv; } ,    None of above

Ans:A ,A


. MSI stands for

Options: A) Medium Scale Integrated Circuits B) Medium System Integrated Circuits C) Medium Scale Intelligent Circuit D) Medium System Intelligent Circuit

Ans:A,A


A proxy server is used for which of the following?
Options: To provide security against unauthorized users,    To process client requests for Web pages,    To process client requests for database access,    To provide TCP/IP

Ans:A ,A


The integrated circuit was invented by Jack Kilby of:
Options: MIT,    Texas Instruments,    Xerox,    All of the above

Ans:B ,B


Which of the following commands is not the vi Input mode command?
Options: rch,    R,    S,    j

Ans:D ,D


The tracks on a disk which can be accessed without repositioning the R/W heads is
Options: Surface,    Cylinder,    Cluster,    All of the above

Ans:B ,B


Data manipulation language (DML)
Options: describes how data are structured in the data base,    specifies for the DBMS what is required; the techniques used to process data,    determine how data must be structured to produce the user's view,    All of the above

Ans:B ,B


Environmental information has greater value on the
Options: top management level,    middle management level,    lower management level,    All of the above

Ans:A ,A


The data model that is produced from reverse engineering is:
Options: a conceptual model.,    an internal model.,    a logical model.,    None of the above is correct.

Ans:D ,D


How can you navigate around virtual consoles?
Options: Alt+Function Key,    Ctrl+Function Key,    Ctrl+Alt+Del,    Alt+a+w+Function Key

Ans:A ,A


. Which of the following is the most powerful computers?
Options: A) Mainframe Computer B) Mini Computers C) Micro Computers D) Super Computers

Ans:7-D,7-D


. You created a query with two tables that have relationship of One-To-Many with referential rules applied. The first table has 3 records and the second has 8. With using a right outer join, how many records will the resulting recordset have?
Options: a. 5 b. 8 c. 24 d. Not enough information to tell

Ans:9 – c ,9 – c


. Outlook express lets you
Options: a. Mail communication b. Internet c. Connects to ISP d. All of above

Ans:4 – a ,4 – a


A list in alphabetical order
Options: is in descending order,    is in ascending order,    is the result of a sort operation,    both (b) and (c)

Ans:D ,D


Column header is refer as
Options: Table B. Relation C. Attributes D. Domain

Ans:– C ,


“Ctrl + Down Arrow” is used to
Options: a. Moves the cursor one paragraph down b. Moves the cursor one line down c. Moves the cursor one page down d. Moves the cursor one screen down

Ans:–  A,–  A


What will be the output of the program ? #include<stdio.h> int main() { int a[5] = {5, 1, 15, 20, 25}; int i, j, m; i = ++a[1]; j = a[1]++; m = a[i++]; printf("%d, %d, %d", i, j, m); return 0; }
Options: 2, 1, 15,    1, 2, 5,    3, 2, 15,    2, 3, 20

Ans:C ,C


How many OSI layers are covered in the X.25 standard?
Options: two,    three,    seven,    six

Ans:B ,B


Which of the following do you need to consider when you make a table in SQL?
Options: Data types,    Primary keys,    Default values,    All of the above.

Ans:D ,D


Which language does MS-Word use to create Macros?
Options: Visual C++ B. Visual Basic C. FoxPro D. Access

Ans:– B ,


An input device that uses switch contacts placed under a plastic pad which may be inscribed with symbols is known as
Options: Punched card,    Touch pad,    Punched paper tape,    Magnetic disk

Ans:B ,B


Error detecting code is
Options: an error-detecting code based on a summation operation performed on the bits to be checked,    a check bit appended to an array of binary digits to make the sum of all the binary digits.,    a code in which each expression conforms to specify rules of construction, so that if certain errors occur in an expression, the resulting expression will not conform to the rules of construction and thus the presence of the error is detected.,    the ratio of the data units in error to the total number of data units

Ans:C ,C


The microcomputer, Intel MCS-80 is based on the widely used Intel
Options: 8080 microprocessor,    8085 microprocessor,    8086 microprocessor,    8082 microprocessor

Ans:A ,A


An error-detecting code inserted as a field in a block of data to be transmitted is known as
Options: Frame check sequence,    Error detecting code,    Checksum,    flow control

Ans:A ,A


How do you insert a row?
Options: a. Right-click the row heading where you want to insert the new row and select Insert from the shortcut menu b. Select the row heading where you want to insert the new row and select Edit >Row from the menu c. Select the row heading where you want to insert the new row and click the Insert Row button on the standard toolbar d. All of the above

Ans:8211; a,8211; a


Modems use _____ transmission.
Options: Synchronous,    Asynchronous,    Timed interval,    PPP

Ans:B ,B


RS-449/442-A/423-A is
Options: a set of physical layer standards developed by EIA and intended to replace RS-232-C.,    a check bit appended to an array of binary digits to make the sum of the all the binary digits,    a code in which each expression conforms to specific rules of construction, so that if certain errors occur in an expression the resulting expression will not conform to the rules of construction and thus the presence of the errors is detected,    the ratio of the number of data units in error to the total number of data units

Ans:A ,A


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

Ans:B ,B

www.000webhost.com