MS-EXCEL can be used to automate

Options: Financial statements, Business forecasting B. Transaction registers, inventory control C. Accounts receivable, accounts payable D. Any of the above

Ans:– D ,

More MS-Excel Related questions:

Which shell's wild-cards is used to match a single character?
Options: *,    ?,    [ijk],    [!ijk]

Ans:B ,B

. The active cell:
Options: a. is defined by a bold border around the cell. b. Receives the data the user enters. c. It is the formula bar. d. Only A and B.

Ans:– d,– d

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

An instruction that transfers program control to one or more possible paths is known as
Options: Utility program,    System software,    Broadband channel,    Application program


EDP auditors can be acquired from
Options: computer consulting firms,    accounting firms,    general management consulting firms,    All of the above

Ans:D ,D

42. Which of the following is the second step in creating a macro?
Options: a. Start recording b. Using your mouse or keyboard, perform the task you want to automate c. Assign a keyboard shortcut to the macro d. Give the macro a name

Ans:– D ,– D

A laser printer generates a totally black page, what is the cause?
Options: malfunctioning imaging laser,    low level in the toner cartridge,    no power to transfer corona,    no power to the primary corona

Ans:D ,D

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

Ans:B ,B

. What is the full form of SQL?
Options: a. Sophisticated Question List b. Structured Question List c. Structured Query Language d. Small Query Length

Ans:– c,– c

A condition that led to the development of databases was:
Options: the proliferation of data files,    an increase in the amount of data handled by organizations,    a demand for more data to support informational needs,    all the above.

Ans:D ,D

. What is the name of the new color laptop computer which is powered by a 386 processor at 33 MHz and is built by Epson?
Options: A) AX3/33 B) NEC-20 C) Magnum 2000 D) HCL-3000


Which of the following would be a good starting point for troubleshooting if your router is not translating?
Options: Reboot.,    Call Cisco.,    Check your interfaces for the correct configuration.,    Run the debug all command.

Ans:C ,C

. What is the use of Notes in slides?
Options: a. It will be displays at the time of Slide Presentation b. This is just Note about the slide c. This is just for printing purpose only d. Notes cannot be inserted in Slides

Ans:0 – B ,0 – B

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

.  To open the existing presentation, press
Options: Ctrl + L B. Ctrl + N C. Ctrl + A D. Ctrl + O

Ans: – D ,

. A computer program that converts an entire program into machine language at one time is called a/an
Options: A) Interpreter B) CPU C) Compiler D) Simulator


Which of the following protocols uses both TCP and UDP?
Options: FTP,    SMTP,    Telnet,    DNS

Ans:D ,D

Storage capacity of magnetic disk depends on
Options: A) tracks per inch of surface B) bits per inch of tracks C) disk pack in disk surface D) All of above


. Which of the following is not a legitimate section for form objects?
Options: a. Form detail b. Group header c. Form header d. Page footer

Ans:– b,– b

The SQL command to create a table is:

Ans:D ,D

    While working with Ms-Dos which command transfers a specific file from one disk to another?
Options: a.    Copy b.    Diskcopy c.    Time d.    Rename

Ans:.c,Correct Answer: a. Copy

. Operating system, editors, and debuggers comes under?
Options: A) System Software B) Application Software C) Utilities D) None of the above


Which of the following is not likely to occur in the near future?
Options: the presidential election will be done by pushing buttons at home.,    the political issue of establishing an information-assistance program will be raised.,    most workers will choose working at hoe, so the traditional workplace will disappear,    automation will reduce job opportunities, thus resulting in a lower standard of living.

Ans:B ,B

. The lower deck of an abacus is known as
Options: A) heaven B) sky C) earth D) floor


Point out the error in the following program (if it is compiled with Turbo C compiler). #include<stdio.h> int main() { display(); return 0; } void display() { printf(""); }
Options: No error,    display() doesn't get invoked,    display() is called before it is defined,    None of these

Ans:C ,C

Paging is implemented in
Options: Operating System B. Hardware C. Software D. All of them

Ans:– B ,

Which of the following are the best units of data on an external storage device?
Options: Bits B. Bytes C. Hertz D. Clock cycles

Ans:8 – B ,

If a file has read and write permissions for the owner, then the octal representation of the permissions will be
Options: 1,    6,    5,    3

Ans:B ,B

A printed document reader which scans the characters and then encodes them in a computer-compatible code for direct transmission to the computer is called
Options: Optical character reader,    Kurzweil Data Entry Machine (KDEM),    MICR,    Laser scanner


A loadstone is:
Options: a natural magnet,    a temporary magnet,    an artificial magnet,    a paramagnetic alloy

Ans:A ,A

When the time to establish link is large and the size of data is small, the preferred mode of data transfer is
Options: Circuit switching,    Packet switching,    Time division multiplexing,    All of the above

Ans:B ,B

A set of well-defined procedures based on mathematical and geometric formulas for solving a problem in a finite number of steps is called:
Options: a permutation,    an algorithm,    arithmetic logic,    a geometric model

Ans:B ,B

. The column command is located on the _____ tab.
Options: a. Insert b. Home c. View d. Page Layout

Ans: – D , – D

. The selected design template can be applied
Options: a.  To current slide only b.  To all the slides c.  To all the new presentation you create d.  All of above

Ans:5 – D ,5 – D

. Identify the true statement
Options: A) Computers are 100% accurate but it can suffer from GIGO B) Computers are reliable because they use electronic component which have very low failure rate C) Computer is never tired and does not suffer from boredom D) All of above


. What is a portion of a document in which you set certain page formatting options?
Options: a. Page b. Document c. Section d. Page Setup

Ans:– C,– C

Which of the following special shell variables is used to process number of the last background job?
Options: $!,    $#,    $0,    $*

Ans:A ,A

Which language was devised by Dr. Seymour Aubrey Papert?
Options: APL,    COBOL,    LOGO,    FORTRAN

Ans:C ,C

Options: is a method of memory allocation by which the program is subdivided into equal portions, or pages and core is subdivided into equal portions or blocks.,    consists of those addresses that may be generated by a processor during execution of a computation.,    is a method of allocating processor time.,    allows multiple programs to reside in separate areas of core at the time.

Ans:A ,A

Which 8-bit chip was used in many of Tandy's TRS-80 computers?
Options: Z-8000,    Motorola 6809,    Z-8088,    Z-80

Ans:D ,D

. What happens if you edited an image inserted in PowerPoint?
Options: a.  The original file that was inserted is not changed b.  The original file that was inserted is changed c.  The original file is changed when you save presentation d.  None of above

Ans:5 – A ,5 – A

. Networking such as LAN, MAN started from

Options: A) First generation B) Second generation C) Third generation D) Fourth generation


The ODBC Level 1 API contains which of the following functions?
Options: Browse possible connections and data sources only,    Connect to data sources with driver-specific information only,    Process a scrollable cursor only,    Both 1 and 3 above are in the OBDC Level 1 API.

Ans:B ,B

What is the difference between a conductor and an insulator?
Options: A conductor allows current to flow much easier than an insulator does,    An insulator has an excessive number of free electrons, while a conductor has a few free electrons or none at all,    An insulator allows current to flow much easier than a conductor does,    The difference between conductors and insulators depends on how they are used

Ans:A ,A

. In slide layout panel how many layouts are available for text layout by default?
Options: a. 4 b. 7 c. 12 d.  None of above

Ans:9 – A ,9 – A

In LISP, the atom that stands for "true" is
Options: t,    ml,    y,    time

Ans:A ,A

. When you cut or copy the text or picture, it stores temporarily in the
Options: a. File b. Clipboard c. Icon d. All of above

Ans:3 – b ,3 – b

Which area in an Excel window allows entering values and formulas?
Options: Title Bar B. Menu Bar C. Formula Bar D. Standard Tool Bar

Ans:– C ,

. ___ is a compromise mode between Shut Down and Sleep mode because it does not consume power and remembers the current state of your desktop
Options: a. Shut Down b. Restart c. Sleep d. Hibernate

Ans:3 – d ,3 – d

83. Ctrl + O
Options: a. Save Document b. Print Document c. Close Document d. Open Document

Ans:–  D ,–  D