Which of the following function will use to find the highest number in a series of number?


Options: MAX(B1:B3) B. MAXIMUM (B1:B3) C. HIGH (B1:B3) D. HIGHEST(B1:B3)

Ans:– A ,






More MS-Excel Related questions:


What will be the output of the program ? #include<stdio.h> int main() { float arr[] = {12.4, 2.3, 4.5, 6.7}; printf("%d\n", sizeof(arr)/sizeof(arr[0])); return 0; }
Options: 5,    4,    6,    7

Ans:B ,B


A typical modern computer uses
Options: LSI chips,    Vacuum tubes,    Valves,    All the above

Ans:A ,A


The south pole of a magnet is the one:
Options: that would be attracted to the earths north magnetic pole,    that has its molecules arranged in a random pattern,    that would be attracted to the earth's south magnetic pole,    that would be repelled by the north pole of another magnet

Ans:C ,C


Batch processing is appropriate if
Options: a . large computer system is available b . only a small computer system is avilbale c . only a few transactions are involved D . none of the above

Ans:D,none of the above


Which of the following is not an advantage of magnetic disk storage?
Options: The access time of magnetic disk is much less than that of magnetic tape,    Disk storage is longer lasting than magnetic tape,    Disk storage is less expensive than tape storage,   None of the above

Ans:D,None of the above


.   An organization has a president, vice president, managers and supervisors. On what level of an organization chart are the vice presidents
Options: a. Fourth level b. Third level c. Second level d. First level

Ans:0 – C ,0 – C


The command chmod 761 letter is equivalent to
Options: chmod 4=7, g = 6, o = 1 letter,    chmod a = 761 letter,    chmod u = rwx, g = rw, o = x letter,    chmod 167 letter

Ans:C ,C


43. When assigning a shortcut key to a symbol, you should always try to select a key or key combination that is:
Options: a. unassigned b. located on the ten-key pad section of your keyboard. c. assigned to another task. d. from the same font family as the symbol.

Ans:– A ,– A


What is the language used by most of the DBMSs for helping their users to access data?
Options: High level language,    Query language,    SQL,    4GL

Ans:B ,B


Data Definition Language (DDL)
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:A ,A


A single bus structure is primarily found in
Options: Main frames,    Super computers,    High performance machines,    Mini-and micro-computers

Ans:D ,D


12. Swapping
Options: a. Works best with many small partitions b. Allows many programs to use memory simultaneously c. Allows each program in turn to use the memory d. Does not work with overlaying

Ans:Correct Answer: c,Correct Answer: c


. The insertion point looks like a(n) ____.
Options: a. H-pointer b. I-pointer c. H-beam d. I-beam

Ans:4 – d ,4 – d


Which of the following is not true about modifying table columns?
Options: You can drop a column at any time.,    You can add a column at any time as long as it is a NULL column.,    You can increase the number of characters in character columns or the number of digits in numeric columns,    You cannot increase or decrease the number of decimal places.

Ans:D ,D


What will be the output of the program in Turbo C? #include<stdio.h> int main() { char near *near *ptr1; char near *far *ptr2; char near *huge *ptr3; printf("%d, %d, %d\n", sizeof(ptr1), sizeof(ptr2), sizeof(ptr3)); return 0; }
Options: 4, 4, 8,    4, 4, 4,    2, 4, 8,    2, 4, 4

Ans:D ,D


. To record a sequence of keystrokes and mouse actions to play back later we use:
Options: a. Media player b. Sound Recorder c. Calculator d. Macro Recorder

Ans:– d,– d


Which of the following is two way list?
Options: a. grounded header list b. circular header list c. linked list with header and trailer nodes d. List traversed in two directions

Ans:D,List traversed in two directions


. PowerPoint design templates are stored in a file with this extension.
Options: a. .ptt b. .pot c. .ppt d. .dtp

Ans:5 – B ,5 – B


The first generation of computers available was based on the bit micro processors.
Options: 4,    8,    16,    64

Ans:B ,B


A person who has the responsibility for development of a new product (such a instant coffee) in a firm is called a
Options: brand manager,    project manager,    development manager,    market manager

Ans:B ,B


At room temperature an intrinsic silicon crystal acts approximately like
Options: a battery,    a conductor,    an insulator,    a piece of copper wire

Ans:C ,C


. Which of the following is not a video file extension?
Options: a. .avi b. .wav c. .mpeg d. .mov

Ans:1 – b ,1 – b


Sending a file from your personal computer's primary memory or disk to another computer is called
Options: uploading,    downloading,    logging on,    hang on

Ans:A ,A


In a 1:1 relationship, the foreign key is placed in:
Options: either table without specifying parent and child tables.,    the parent table.,    the child table.,    either the parent table or the child table.

Ans:A ,A


How to remove the unwanted action from recorded macro without recording the whole macro again?
Options: By using the Find and Edit Action Option B. By clicking on the Refresh button in the Macro toolbar C. By edit the macro in the Visual Basic Editor D. Macro cannot be edited.

Ans:– C ,


In EXCEL, you can sum a large range of data by simply selecting a tool button called …..?
Options: AutoFill B. Auto correct C. Auto sum D. Auto format

Ans:– C ,


Software that measures, monitors, analyzes, and controls real-world events is called:
Options: system software,    real-time software,    scientific software,    business software

Ans:B ,B


A large number of computers in a wide geographical area can be efficiently connected using
Options: Twisted pair lines,    Coaxial cables,    Communications satellites,    All of the above

Ans:C ,C


What should be add before a fraction to avoid entering it as a date?
Options: // B. FR C. Zero D. Zero Space

Ans:– D ,


. The three parts of an IIF function are separated by _____.
Options: a. dashes b. asterisks c. semicolons d. commas

Ans:8 – d ,8 – d


To view any currently running Terminate Stay Resident (TSR's) programs you could type:
Options: Memory,    MEM,    SYS /M,    Memmaker

Ans:B ,B


What two multicast addresses does OSPFv3 use? FF02::A FF02::9 FF02::5 FF02::6
Options: 2 only,    3 only,    1 and 3,    3 and 4

Ans:D ,D


The "big picture" diagram of a system is the
Options: block diagram,    logic diagram,    system flowchart,    program flowchart

Ans:C ,C


Properly arranged data is called
Options: A) Field B) Words C) Information D) File

Ans:-C,-C


. The command allows you to create logical drive
Options: a. Sort b. Path c. Subst d. Batch

Ans: c, c


An algorithm is best described as
Options: A computer language,    A step by step procedure for solving a problem,    A branch of mathematics,    All of the above

Ans:B ,B


. Which command is used to open the directory?
Options: a. Open b. Chdir c. Move d. All of above

Ans:2 – b ,2 – b


. When you point to a text entry in the Office Clipboard gallery in the Clipboard task pane, _____.
Options: a. the first several characters of text in the item display as a ScreenTip b. the text entry is deleted from the Office Clipboard gallery c. the text entry is pasted into the document at the location of the insertion point d. all of the above

Ans: – A , – A


.   Which of the following are types of sound files?
Options: a. LOG files b. DAT files c. WAV files d. DRV files

Ans:1 – C ,1 – C


Which of the following statements is not true
Options: A structured chart is a sequential representation of program design,    the Real-Time system is a particular case of a on-line-system,    Batch totals are not incorporated while designing real-time applications,    4GLs are used for application proto typing

Ans:A ,A


Which of the following is considered to be an interface between the functional applications and the data base?
Options: management information systems,    data-base management systems,    decision-support systems,    data-processing systems

Ans:B ,B


Which of the following commands is used to view your file 24 lines at a time?
Options: pg,    cat,    lp,    /p

Ans:A ,A


Which of the following is usually a special one-time operation that must be completed over a limited time period?
Options: Batch,    Patch,    Project,    Word

Ans:C ,C


Union officials receive the same type of education as
Options: top level managers,    the rank and file employees,    low level managers,    All of the above

Ans:C ,C


Which of the following is true of parallel transmission?
Options: It involves the simultaneous transmission of eight bits.,    The speed is quoted in bits per second.,    It is slower than serial trans¬mission.,    Most microcomputers commu¬nicate with other computers in this mode.

Ans:A ,A


A decision table facilitates conditions to be related to
Options: actions,    programs,    tables,    operation

Ans:A ,A


. What is the keyboard shortcut (button or buttons to be pressed) for creating a chart from the selected cells?
Options: a. F3 b. F5 c. F7 d. F11

Ans:– d,– d


. Scandisk
Options: a. Checks the disk b. Give information about disk c. Run from DOS mode d. All of the above

Ans:9 – d ,9 – d


How many NAND circuits are contained in a 7400 NAND IC?
Options: 1,    2,    4,    8

Ans:C ,C


. The MS DOS operating system is a
Options: a. Graphical user interface, single tasking operating system b. Graphical user interface, multitasking operating system c. Command driven interface, single tasking operating system d. Command driven interface, multitasking operating system

Ans:9 – c ,9 – c

www.000webhost.com