. Which of the following syntax is correct regarding to SUM function in Excel?


Options: =SUM (A1, B1) B. =SUM (A1:B9) C. =SUM (A1:A9, B1:B9) D. All of the above

Ans:– D ,






More MS-Excel Related questions:


Which three commands can be used to check LAN connectivity problems on a router? show interfaces show ip route tracert ping dns lookups
Options: 1 ,2 and 4,    2 and 5,    3 and 5,    None of the above

Ans:A ,A


The purpose of an application program is to
Options: Convert program written in high level language to machine language,    Meet specific user needs,    Allow the operating system to control resources better,    Make off-line equpment run better

Ans:B ,B


______ is used in operating system to separate mechanism from policy
Options: Single level implementation B. Two level implementation C. Multi level implementation D. None

Ans:– B ,


A medium access control technique for multiple access transmission media is
Options: Aloha,    Amplitude,    Angle modulation,    Attenuation

Ans:A ,A


  Which PowerPoint feature adds special effects to modify the appearance of the slides and the timing between each slide?
Options: Color Schemes B. Animation C. Transition Settings D. Handouts

Ans:– C ,


When you copy a formula
Options: a. Excel erases the original copy of the formula b. Excel edits cell references in the newly copied formula c. Excel adjusts absolute cell references d. Excel doesn’t adjust relative cell references

Ans:#8211; b,#8211; b


. Which of the following views is used to graphically summarize and analyze data in a recordset?
Options: a. Datasheet b. Form c. PivotChart d. PivotTable

Ans:9 – c ,9 – c


. Which of the following is not a mode in starting Windows?
Options: a. Command Prompt b. Safe Mode c. Normal Mode d. Turbo Mode

Ans:8 – d ,8 – d


The imitation of one device or system by another is
Options: Simulation,    Emulation,    Resilience,    Compaction

Ans:B ,B


What command can you add to the AUTOEXEC.BAT file so that your computer temporarily stops in the execution of the file before continuing?
Options: Pause,    Halt,    Wait x.xx seconds,    Wait until Files="x"

Ans:A ,A


What action will correct patchy, faint, uneven or intermittent print on a dot matrix printer?
Options: Replacing the ribbon,    Replacing the timing belt,    Adjusting the paper feed tension,    Adjusting the tractor feed tension

Ans:A ,A


Cascade update option
Options: a. means do not change the value in the primary key field if that record has related records in another table b. means change all the related records in child tables if the record in parent table is changed c. Both of above d. None of above

Ans:ndash; c,ndash; c


. All of the following are TRUE regarding virtual memory EXCEPT
Options: a. Any amount of RAM can be allocated to virtual memory b. The setting for the amount of hard disk drive space to allocate virtual memory canbe manually change c. This temporary storage is called the swap file or page file d. Virtual memory is the physical space o the hard drive

Ans: a, a


Objects on the slide that hold text are called
Options: a. Placeholders b. Object holders c. Auto layouts d. Text holders

Ans: – A , – A


The bubbles in a bubble memory pack are created with the help of?
Options: Laser beam,    Magnetic field,    Electric field,    X-ray

Ans:B,B


. In table design view, which key can be used to switch between the field names and properties panels?
Options: a. F3 b. F4 c. F5 d. F6

Ans:8 – d ,8 – d


A _____ is an outline of a process that keeps develop successful information systems
Options: System Development Life Cycle,    CASE tool,    Phased Conversion,    Success Factors

Ans:A ,A


A register organized to allow to move left or right operations is called a ____
Options: Counter B. Loader C. Adder D. Shift register

Ans:– D ,


A goal of data mining includes which of the following?
Options: To explain some observed event or condition,    To confirm that data exists,    To analyze data for expected relationships,    To create a new data warehouse

Ans:A ,A


What DOS program can you run to see which serial ports are detected?
Options: comdiag,    MSD,    command.com,    SDET

Ans:B ,B


If safety stock is 6 and the EOQ is 50, average inventory level is
Options: 80,    86,    85,    90

Ans:E ,E


A lockbox service is used for
Options: depositing cash when bank is closed,    paying bank customer bills automatically,    storing papers in a bank vault,    depositing payments to bank customers

Ans:D ,D


The NOT EXISTS keyword will be true if:
Options: any row in the subquery meets the condition.,    all rows in the subquery fail the condition.,    both of these two conditions are met.,    neither of these two conditions is met.

Ans:B ,B


UDP is:
Options: Not a part of the TCP/IP suite,    Connection oriented and unreliable,    Connection orientated and reliable,    Connectionless and unreliable

Ans:D ,D


. The virtual memory is
Options: a. An extremely large main memory b. An extremely large secondary memory c. An illusion of extremely large main memory d. A type of memory used in super computer

Ans:5 – c ,5 – c


What is the process lag?
Options: The time it takes for the sensor to respond to a changed.,    The lag in the error signal when the setpoint is changed.,    The time it takes for the mass of the process to respond to an input change.,    All of the above

Ans:C ,C


In geosynchronous orbit, satellite
Options: remains in a fixed position so that as earth rotates, it can fully cover the earth,    remains in a fixed position related to points on earth,    moves faster than the earth's rotation so that it can cover larger portion of earth.,    moves simultaneously

Ans:A ,A


Logical design of database is called
Options: Database Instance B. Database Snapshot C. Database Schema D. All of the above

Ans:– C ,


. Hyperlinks cannot be
Options: a. Special shapes like stars and banners b. Drawing objects like rectangles ovals c. Pictures d. All can be hyperlinks

Ans:– d,– d


. To select more than one slide in the presentation
Options: a. Just Click on slide b. Ctrl + Click on slide c. Alt + Click on slide d. Shift + Click on slide

Ans:2 – B ,2 – B


How can you make the selected character superscripted?
Options:  A) Ctrl + =, B) Ctrl + Shift + =, C) Alt + Ctrl + Shift + =, D) None of above,

Ans:-B,-B


The LRU algorithm
Options: pages out pages that have been used recently,    pages out pages that have not been used recently,    pages out pages that have been least used recently,    pages out the first page in a given area

Ans:C ,C


. What is the shortcut key to insert new sheet in current workbook?
Options: a. F11 b. Alt + F11 c. Ctrl + F11 d. Shift + F11

Ans:– d,– d


Where have the program and data to be located before the ALU and control unit of a computer can operate on it?
Options: Internal memory,    Secondary memory,    Microprocessor,    Magnetic tapes

Ans:A,A


What Is a process variable?
Options: A manipulated variable,    A controlled variable,    A process parameter that changes value,    All of the above

Ans:D ,D


To define what columns should be displayed in an SQL SELECT statement:
Options: use FROM to name the source table(s) and list the columns to be shown after SELECT.,    use USING to name the source table(s) and list the columns to be shown after SELECT.,    use SELECT to name the source table(s) and list the columns to be shown after USING.,    use USING to name the source table(s) and list the columns to be shown after WHERE.

Ans:A ,A


The first microprocessor built by the Intel Corpn. was called
Options: 8008,    8080,    4004,    8800

Ans:C,C


. Which of the following resources must be protected by the operating system?
Options: a. I/O b. Memory c. CPU d. All of the above

Ans:9 – d ,9 – d


Which one of the following statements is true for the currents in a series RC circuit?
Options: The current always has the same amplitude and phase for every part of the circuit,    The total current is equal to the sum of the currents for the resistance and capacitance,    The total current is greater than the sum of the currents for the resistance and capacitance,    The total current is less than the sum of the currents for the resistance and capacitance

Ans:A ,A


The graph of current gain versus collector current indicates that the current gain
Options: varies enormously,    is contant,    varies slightly,    equals the collector current divided by the base current

Ans:D ,D


What port does squid listen, by default?
Options: 4322,    2314,    7334,    3128

Ans:D ,D


A statement - by - statement description of a procedure is detailed in a;
Options: written narrative,    procedure's log,    systems flowchart,    record layout

Ans:A ,A


. Which of the following properties identifies the type of information stored in a field?
Options: a. Data type b. Field description c. Field name d. Field properties

Ans:5 – a ,5 – a


. What is the shortcut key to insert current date in a cell?
Options: a. CTRL + D b. CTRL + T c. CTRL + ; d. CTRL + /

Ans:– c,– c


What does COUNTA () function do?
Options: counts cells having alphabets B. counts empty cells C. counts cells having number D. counts non-empty cells

Ans:– D ,


Which of are following internal commands is used in mail to forward mail to user in user-list?
Options: r user-list,    m user-list,    d user-list,    e user-list

Ans:B ,B


Comments can be added to cells using …..
Options: Edit -> Comments B. Insert -> Comment     C. File -> Comments D. View –> Comments

Ans:– B ,


Silicon atoms combine into an orderly pattern called a
Options: Crystal,    Covalent bond,    Semiconductor,    Valence orbit

Ans:A ,A


A computer has a 1024K memory. What does the letter K stand for
Options: Kilometre,    Thousand,    1024,    MB

Ans:C,C


Bit map terminal
Options: support displays containing multiple windows,    requires considerable amount of video RAM,    requires tremendous amount of copying and hence low performance,    All of the above

Ans:D ,D

www.000webhost.com