Which is an example of a formula?


Options: =A1+A2 B. =add(A1:A2) C. A1+A2 D. SUM(A1:A2)

Ans:– A ,






More MS-Excel Related questions:


A technique used by codes to convert an analog signal into a digital bit stream is known as
Options: A) Pulse code modulation B) Pulse stretcher C) Query processing D) Queue management

Ans:-A,-A


An entire path name, consisting of several sub-directory names can contain upto
Options: a. 13 character b. 36 character c. 63 character d. 53 character

Ans:Correct Answer: c ,Correct Answer: c


What is modified when changing the system start-up boot sequence?
Options: BIOS/CMOS,    CONFIG.SYS,    autoexec.bat,    COMMAND.COM

Ans:A ,A


How many tables may be included with a join?
Options: One,    Two,    Three,    All of the above.

Ans:D ,D


. WAN is a most used abbreviation in Newtorking, what is its full form?
Options: A) WAP Area Network B) Wide Area Network C) Wide Array of Network D) Wireless Access Network

Ans:B,B


The word 'linear' in linear programming is used to describe:
Options: relationship among two or more variables in a straight line,    relationship among two or more variable which are directly proportional,    relationship among two or more variables is linear,    all of the above

Ans:B ,B


. A search value can be an exact value or it can be
Options: a. Logical operator b. Relationship c. Wild card character d. Comparison operation

Ans:8 – c ,8 – c


. Which of the following code used in present day computing was developed by IBM Corporation?

Options: A) ASCII B) Hollerith Code C) Baudot Code D) EBCDIC Code

Ans:D,D


A master document contains_________, each of which contains a pointer to a file on a
Options: A. Placeholders B. subdocuments C. bookmarks D. references

Ans:B ,subdocuments


If you want to have a blank line after the title in a worksheet, what is the best thing for you to do?
Options: Re-format the spreadsheet B. Insert a row C. Increase the column width D. Use the spacebar

Ans:– B ,


Who made the statement "if a robot can do a job, a person should not be doing it"?
Options: Prof. F. A. Fisher of Britain,    Ron Albo of Shugart Associates, California,    Prof. Meredith Turing, London University,    John Smith, USA

Ans:B ,B


. What do you mean by one to many relationship between student and class table?
Options: a. One student can have many classes b. One class may have many student c. Many classes may have many students d. Many students may have manu classes

Ans:0 – a ,0 – a


Instructions and memory addresses are represented by
Options: character codes,    binary codes,    binary word,    parity bit

Ans:B ,B


How can you find rows that do not match some specified condition?
Options: EXISTS,    Double use of NOT EXISTS,    NOT EXISTS,    None of the above is correct.

Ans:B ,B


B7:B9 indicates:
Options: Cells B7 and cell B9 only. B. Cells B7 through B9. C. Cell B8 only. D. None of the above.

Ans:– B ,


. ______ shares characteristics with both hardware and software
Options: a. Operating system b. Software c. Data d. None

Ans:4 – a ,4 – a


Properties that describe the characteristics of entities are called:
Options: entities.,    attributes.,    identifiers.,    relationships.

Ans:B ,B


Which of the following communications lines is best suited to interactive processing applications?
Options: narrowband channels,    simplex lines,    full-duplex lines,    mixed band channels

Ans:C ,C


Which bitwise operator is suitable for turning on a particular bit in a number?
Options: && operator,    & operator,    || operator,    | operator

Ans:D ,D


"User friendly" computers have ensured that
Options: management requires no system analysis and design.,    programmers are no longer needed,    structured programming is not needed,    All of the above

Ans:E ,E


. To create queries in access
Options: a. You can drag and drop fields on query builders b. You can type the sql command in sql view c. You can use query wizard or design view d. All of above

Ans:5 – d ,5 – d


A _____ purpose computer is designed for a specific application.
Options: special,    analog,    hybrid,    digital

Ans:A ,A


A design that consists of a hierarchy of modules; each module has a single entry and a single exit subroutine, is known as
Options: hierarchy structure,    top-down design,    Tuple,    Turnaround

Ans:B ,B


Which of the following is not true of a magnetic disk?
Options: It is expensive relative to magnetic tape,    It provides only sequential access to stored data,    Users can easily update records by writing over the old data,    It does not provide an automatic audit trail

Ans:B ,B


. The report footer section is most useful for displaying:
Options: a. grand totals b. Column headings c. subtotals d. page numbers

Ans:– a,– a


Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
Options: Supertype entity,    Subtype entity,    Archetype entity,    Instance entity

Ans:A ,A


. A __________ enables you to view data from a table based on a specific criterion
Options: a. Form b. Query c. Macro d. Report

Ans:0 – b ,0 – b


While working with MS-DOS, which command is used to restore only those files modified since the last backup, from the drive A to the currently logged drive or directory?
Options: RESTORE A: *.*/S,    RESTORE A: *.*/M,    RESTORE A: *.*/N,    RESTORE A: *.*/L

Ans:B ,B


The Strategic Computing Program is a project of the:
Options: Defense Advanced Research Projects Agency,    National Science Foundation,    Jet Propulsion Laboratory,    All of the above

Ans:A ,A


The feedback loop in the general systems model is represented fey
Options: data flow,    decision flow,    information flow,    All of the above

Ans:D ,D


Which command is used with vi editor to search a pattern in the forward direction?
Options: /,    ?,    //,    ??

Ans:A ,A


You set the console password, but when you display the configuration, the password doesn't show up; it looks like this: [output cut] Line console 0 Exec-timeout 1 44 Password 7098C0BQR Login [output cut] What cause the password to be stored like this?
Options: encrypt password,    service password-encryption,    service-password-encryption,    exec-timeout 1 35

Ans:B ,B


58. You can jump to the next column by
Options: a. Clicking with your mouse on the next column b. Press Alt + Down-arrow c. Both of above d. None of Above

Ans:– C ,– C


What is the name of the technique in which the operating system of a computer executes several programs concurrently by switching back and forth between them?
Options: Partitioning,    Multitasking,    Windowing,    Paging

Ans:B ,B


Which of the following file types has the least life
Options: Master file,    Program file,    Transaction file,    Work file

Ans:D ,D


. How to change the order of Slides in Presentation?
Options: a. 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:2 – B ,2 – B


XML is which of the following?
Options: A scripting language that states the rules for tagging elements.,    A programming language that states the rules for tagging elements.,    A programming language that allows the creation of customized tags.,    A scripting language that allows the creation of customized tags.

Ans:D ,D


. Which setting you must modify to print a report using letterhead?
Options: a. Group b. Margin c. Section d. Orientation

Ans:– b,– b


Where do you load the CD Rom drivers?
Options: Autoexec.bat,    Control Panel/Drivers,    Into Upper memory,    Config.sys

Ans:D ,D


Which output device is used for translating information from a computer into pictorial form on paper.
Options: Mouse,    Plotter,    Touch panel,    Card punch

Ans:B ,B


. The _____ on the right side of the menu bar lets users type free-form questions, such as how do I save, or terms, such as copy, and Word responds by displaying a list of topics related to the word or phrase entered.
Options: a. Type a question for help box b. Question Mark button c. What’s this? command d. Index sheet

Ans: – A , – A


41. How many different documents you can open at one time?
Options: a. No more than three b. Only one c. As many as your computer memory will hold d. As many as your taskbar can display

Ans:– C ,– C


What X-based tool is available for configuring the X Window system?
Options: XConfigurator,    XF86Setup,    xf86config,    All of the above

Ans:B ,B


In which area are job openings expected to decline in the future?
Options: computer operator,    data-entry operator,    application programmer,    system programmer

Ans:B ,B


. Which command is used to copy files?
Options: a. Copy b. Diskcopy c. Type d. All of the above

Ans:Correct Answer: a ,Correct Answer: a


As alternatives are evaluated, the best one is recognized as the one
Options: best enabling the system to meet its objectives,    representing lowest cost,    with the most advantages,    with the least disadvantages

Ans:A ,A


In which way(s) a macro processor for assembly language can be implemented:
Options: independent two-pass processor,    independent one-pass processor,    processor incorporated into pass 1 of a standard two-pass assembler,    all of the above

Ans:D ,D


Which of the following holds data and processing instructions temporarily until the CPU needs it?
Options: ROM,    control unit,    main memory,    coprocessor chips

Ans:C,C


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


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