Which of the following is correct?


Options: =AVERAGE(4, 5, 6, 7) B. =AVERAGE(A1, B1, C1)               C. =AVERAGE(A1:A9, B1:B9) D. =All of the above

Ans:– D ,






More MS-Excel Related questions:


In which addressing mode, the effective address of the operand is generated by adding a constant value to the contents of a register?
Options: Absolute mode,    Indirect mode,    Immediate mode,    Index mode

Ans:D ,D


. Which tab in Font dialog box contain options to apply font effects?
Options: a. Font tab b. Character Spacing c. Text Effects d. Standard Toolbar

Ans: – A , – A


Which of the following statements is not true?
Options: a. You can type text directly into a PowerPoint slide but typing in text box is more convenient. b. From Insert menu choose Picture and then File to insert your images into slides. c. You can view a PowerPoint presentation in Normal, Slide Sorter or Slide Show view. d. You can show or hide task pane from View >> Toolbars

Ans:– A ,– A


. We can save and protect the workbook by
Options: Write Reservation Password B. Protection Password C. Read-only Recommended D. Any of the above

Ans: – D ,


The word processing task associated with changing the appearance of a document is
Options: A) Editing B) Writing C) Formatting D) All of above

Ans:-C,-C


MS-Word automatically moves the text to the next line when it reaches the right edge of the screen and is called?
Options: Carriage Return B. Enter C. Word Wrap D. None of the above

Ans:– C ,


You can use drag-and-drop to embed excel worksheet data in a word document
Options: a. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key b. By dragging a range of excel data to the word button on the taskbar while pressing Shift key c. By dragging a range of excel data to the word button on the taskbar while pressing Alt key d. None of above

Ans:#8211; a,#8211; a


Which can be used for quick access to commonly used commands and tools?
Options: Status bar B. Tool bar C. Menu bar D. Title bar

Ans:– B ,


Which of the following is not an output device?
Options:  Scanner B.  Printer C.  Flat Screen D.  Touch Screen

Ans:– A ,


Who coordinates the sequencing of events within the central processor of a computer?
Options: Logic unit,    Arithmetic unit,    Register,    Control unit

Ans:D ,D


Pick the correct choice for the 8088 CPU.
Options: 16 bit word size, 8 bit data path,    8 bit word size, 8 bit data path,    16 bit word size, 16 bit data path,    4 bit word size, 8 bit data path

Ans:A ,A


Which of the following correctly shows the hierarchy of arithmetic operations in C?
Options: / + * -,    * - / +,    + - / *,    / * + -

Ans:D ,D


Which command would you place on interface connected to the Internet?
Options: ip nat inside,    ip nat outside,    ip outside global,    ip inside local

Ans:B ,B


Which of the following is correct regarding Class B Address of IP address
Options: Network bit – 14, Host bit – 16 B. Network bit – 16, Host bit – 14 C. Network bit – 18, Host bit – 16 D. Network bit – 12, Host bit – 14

Ans:– A ,


. which of the following should you use if you want all the slides in the presentation to have the same look?
Options: a. The slid layout option b. The add a slide option c. Outline view d. A presentation design template

Ans:5 – D ,5 – D


. Which among the following are the best tools for fixing the errors?
Options: a. Fdisk b. Scandisk c. CHKDSK d. Fixdisk

Ans:1 – b ,1 – b


The view that displays the slides on a presentation as miniature representations of the slides is called
Options: a. slide show b. slide sorter view c. notes page view d. outline view

Ans: – B , – B


The Average case occur in linear search algorithm
Options: a. When Item is somewhere in the middle of the array b. When Item is not in the array at all c. When Item is the last element in the array d. When Item is the last element in the array or is not there at all  

Ans:a,a


Magnetic tape can serve as :
Options: secondary-storage media,    output media,    input media,    All of the above

Ans:D,D


Which of the following is the fastest?
Options: CPU,    magnetic tapes and disks,    video terminal,    sensors, mechanical controllers

Ans:A ,A


If a table has been normalized so that all determinants are candidate keys, then that table is in:
Options: 1NF.,    2NF.,    3NF.,    BCNF.

Ans:D ,D


. Pick out odd
Options: a. Windows b. Window c. DOS d. Linux

Ans:5 – b ,5 – b


Bubble memory is a
Options: Sequential access device only,    Direct access device only,    Combination of sequential and direct access devices,    All of the above

Ans:C ,C


What programming language(s) or scripting language(s) does Java Server Pages (JSP) support?
Options: VBScript only,    Jscript only,    Java only,    All of the above are supported

Ans:C ,C


In analyzing the compilation of PL/I program, the description "resolving symbolic address (labels) and generating machine language" is associated with
Options: Assembly and output,    Code generation,    Storage assignment,    Syntax analysis

Ans:A ,A


The disadvantages of "Compile and Go" loading scheme is (are):
Options: a portion of memory is wasted because the core occupied by the assembler is unavailable to the object program.,    it is necessary to retranslate the user's program deck every time it is run.,    it is very difficult to handle multiple segments, especially if the source programs are in different languages, and to produce orderly modular programs.,    all of the above

Ans:D ,D


The "end-effector" of a robot:
Options: can be an actual tool,    is the robot "hand",    may have a gripping action,    All of the above

Ans:D ,D


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

Ans:A,(Aanswer


In comparison with static RAM memory, the dynamic RAM memory has
Options: lower bit density and higher power consumption,    higher bit density and higher power consumption,    lower bit density and lower power consumption,    higher bit density and lower power consumption

Ans:D ,D


. An error in computer data is called
Options: A) Chip B) Bug C) CPU D) Storage device

Ans:6-B,6-B


.  Which of the following syntax is correct regarding to SUM function in Excel?
Options: a. =SUM (A1, B1) b. =SUM (A1:B9) c. =SUM (A1:A9, B1:B9) d. All of the above

Ans:– d,– d


______________ is a classical approach to database design?
Options: Left – Right approach B. Right – Left approach C. Top – Down approach D. Bottom – Up approach

Ans:– C ,


An optical input device that interprets pencil marks on paper media is
Options: O.M.R,    Punch card reader,    Optical scanners,    Magnetic tape

Ans:A,(Aanswer


. In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
Options: a. formula b. format c. layout d. record

Ans:3 – d ,3 – d


. An approach that permits the computer to work on several programs instead of one is
Options: A) On-line thesaurus B) Multiprogramming C) Over lapped processing D) Outline processor

Ans:C,C


_____ write computer programs that perform jobs specified by the user.
Options: Programmer,    Data entry operator,    System Analyst,    Computer operator

Ans:A ,A


. Which of the following can be use as slide background?
Options: a. Gradient b. Texture c. Picture d. All of the Above

Ans:7 – D ,7 – D


Which of the following is a read only memory storage device?
Options:  Floppy Disk B.  CD-ROM      C.  Hard Disk D.  None of these

Ans:– B ,


.   The arrangement of elements such as Title and Subtitle text, pictures, tables etis called
Options: a. Layout b. Presentation c. Design d. Scheme

Ans:0 – A ,0 – A


. The default header for a worksheet is
Options: a. Your name b. The date and time c. None d. The sheet tab name

Ans:– c,– c


Which of the following is correct regarding Aggregate functions?
Options: it takes a list of values and return a single values as result B. it takes a list of values and return a list of values as result C. it takes a single value and returns a list of values as result D. it takes a single value and returns a single value as result

Ans:– A ,


A device that converts one type of signal into another is called
Options: Modem,    Transducer,    Punched paper tape,    Punched card

Ans:B ,B


. Which of the following is/are external commands?
Options: a. Edit b. Label c. Sys d. All of above

Ans: d, d


The control unit of a microprocessor
Options: stores data in the memory,    accepts input data from a keyboard,    Performs arithmetic / logic / functions,    All of the above

Ans:E ,E


Database management systems are intended to:
Options: eliminate data redundancy,    establish relationships among records in different files,    manage file access,    maintain data integrity

Ans:E ,E


. An application program that helps the user to change any number and immediately see the result of that change is
Options: A) Desktop publishing program B) Database C) Spreadsheet D) All of above

Ans:2-C,2-C


. Ctrl + D shortcut key in Excel will
Options: a.  Open the font dialog box b.  Apply double underline for the active cell c.  Fill down in the selection d.  None of above

Ans:– c,– c


Condensing output data to exhibit specific information is
Options: Calculating,    Recording,    Merging,    Summarising

Ans:D ,D


Which of the following column properties specifies whether or not cells in a column must contain a data value?
Options: Null status,    Data type,    Default value,    Data constraints

Ans:A ,A


Slide Transaction can be apply to
Options: Current Slide B. Selected Slides C. All Slides D. All of the above

Ans:– D ,

www.000webhost.com