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 ,

More MS-Excel Related questions:

When was the IBM XT microcomputer released in the market?
Options: 1970,    1971,    1987,    1986


The area of AI that investigates methods of facilitating communication between people and computers is:
Options: natural language processing,    symbolic processing,    decision support,    robotics

Ans:A ,A

Which command is used to remove a table from the database in SQL?

Ans:B ,B

Insert Date, Format Page Number, and Insert AutoText are buttons on the _____ toolbar.
Options: a. Formatting b. Header and Footer c. Standard d. Edit

Ans:– B,– B

To locate a data item for storage is
Options: Field,    Feed,    Database,    Fetch


Which of the following is a disadvantage of replication?
Options: Reduced network traffic,    If the database fails at one site, a copy can be located at another site.,    Each site must have the same storage capacity.,    Each transaction may proceed without coordination across the network.

Ans:C ,C

. When you open my computer on desktop you see the information of
Options: a. Hard disk b. CD c. Removable disk d. All of the above

Ans:0 – d ,0 – d

. How are data organized in a spreadsheet?
Options: a. Lines and spaces b. Layers and planes c. Rows and columns d. Height and width

Ans:– c,– c

What is the name given to the software which can be legally compiled and often used for free?
Options: Shareware program,    Public domain program,    Firmware program,    Mindware

Ans:B ,B

. Floppy disks which are made from flexible plastic material are also called?
Options: A) Hard disks B) High-density disks C) Diskettes D) Templates


. Which unit is known as nerve center of computer?
Options: A) ALU B) CU C) Memory D) Registers


Two computers that communicate with each other use a simple parity check to detect errors for ASCII transmissions. Which of the following events will always lead to an undeleted error?
Options: one bit or any odd number of bits inverted in a block of data during transmission,    two bits or any even number of bits inverted in a block during transmission,    one bit or any odd number of bits inverted in a byte during transmission,    two bits or any even number of bits inverted in a byte during transmission

Ans:D ,D

. If you need to edit a relationship
Options: a. Right click the relationship line and choose edit relationship b. Double click the relationship line c. Both of above d. None of above

Ans:5 – c ,5 – c

. 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

Where is a hub specified in the OSI model?
Options: Session layer,    Physical layer,    Data Link layer,    Application layer

Ans:B ,B

The latest time that the event can be delayed without delaying the completion of the entire project in PERT chart is:
Options: earliest allowable time,    latest allowable time,    earliest pass,    latest pass

Ans:B ,B

Which of the following is best for quick copy operation?
Options: Copy and Paste B. Windows Clipboard C. Drag and Drop D. Auto Text

Ans:– C ,

A NAND gate has:
Options: LOW inputs and a LOW output,    HIGH inputs and a HIGH output,    LOW inputs and a HIGH output,    None of the these

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

A program that is employed in the development, repair or enhancement of other programs is known as
Options: System software,    Software tool,    Applications program,    Utility program


A problem's _____ will answer the question, "What information will the computer need to know in order to either print or display the output times?"
Options: Input,    Output,    Processing,    Purpose

Ans:A ,A

The code that should be adequate for present and anticipated data processing both for machine and human use is
Options: Conciseness,    Uniqueness,    Operability,    All of the above

Ans:C ,C

. What are the different views to display a table
Options: a. Datasheet view b. Design view c. Pivote table & pivot chart view d. All of above

Ans:6 – d ,6 – d

Filename extensions help identify certain files. What filename extension identifies command files?
Options: COM,    BAT,    EXE,    SYS

Ans:A ,A

. Which of the following concept is best to preventing page faults?
Options: a. Paging b. The working set c. Hit ratios d. Address location resolution

Ans:8 – b ,8 – b

What will be the output of the program in 16 bit platform (Turbo C under DOS) ? #include<stdio.h> int main() { struct value { int bit1:1; int bit3:4; int bit4:4; }bit; printf("%d\n", sizeof(bit)); return 0; }
Options: 1,    2,    4,    9

Ans:B ,B

Information is _____ when it is useful in making a decision.
Options: relevant,    management by exception,    predictive reports,    control

Ans:A ,A

79. Which would you choose to save a document with a new name?
Options: a. Press Ctrl+S b. Click File, Save c. Click Tools, Options, Save d. Click File, Save As

Ans:–  D ,–  D

. Disk copy command in DOS is used to
Options: a. Copy a file b. Copy contents of one floppy disk to another c. Copy contents of CD-ROM to another d. All of the above

Ans:Correct Answer: b ,Correct Answer: b

. Special category of Number tab in Format Cells dialog box can be used to apply formats like
Options: a. Zip Code b. Phone Number c. Both of above d. None of above

Ans:– c,– c

Which field type can store photos?
Options: a. Hyperlink b. OLE c. Both of these can be used d. Access tables can’t store photos

Ans:ndash; b,ndash; b

What does Router do in a network?
Options: Forwards a packet to all outgoing links B. Forwards a packet to the next free outgoing link C. Determines on which outing link a packet is to be forwarded D. Forwards a packet to all outgoing links except the originated link

Ans:– C ,

The packets switching concept was first proposed
Options: in the late 1980s for the Defense Ministry of US.,    in the early 1960s for military communication systems, mainly to handle speech,    in the late 1950s for Defense Ministry of US,    All of the above

Ans:B ,B

What is required when more than one person uses a central computer at the same time?
Options: A) Light pen B) Mouse C) Digitizer D) Terminal


. 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

The library function used to find the last occurrence of a character in a string is
Options: strnstr(),    laststr(),    strrchr(),    strstr()

Ans:C ,C

96. What is the shortcut key for “Font” dialog box?
Options: a. Ctrl + F b. Ctrl + D c. Ctrl + G d. None of the above

Ans:–  B ,–  B

. Which of the following data types automatically generates a consecutive number?
Options: a. Autonumber b. Memo c. Number d. Text

Ans:7 – a ,7 – a

A typical light switch in your home is a:
Options: knife switch,    toggle switch,    rotary switch,    momentary push button switch

Ans:B ,B

A dialog box with a bomb appears oh a Macintosh screen. What type of problem has occurred?
Options: A RAM problem,    A software problem,    A ROM problem,    An ADB problem

Ans:B ,B

The operating system manages
Options: Memory B. Processes C. Disks and I/O devices D. all of the above

Ans:– D ,

. If you hard disk is partitioned into 3 drives, the number of recycle bin for that hard disk is
Options: a. 1 b. 2 c. 3 d. 4

Ans:2 – c ,2 – c

. The other Col# are inactive when you’ve select 3 columns. How will you activate those boxes?
Options: a. double click on spacing box b. double click on inactive Col# c. Remove mark from Line between checkbox d. Remove mark from Equal Column Width check box

Ans:– D,– D

. Commonly network of network is called
Options: a. MS Word b. MS Excel c. Internet d. MS Access

Ans:9 – c ,9 – c

Which of the following are the cheapest memory devices in terms of Cost/Bit?
Options: Semiconductor memories B. Magnetic Disks C. Compact Disks D. Magnetic Tapes

Ans:– C ,

The two classification of inputs are:
Options: energies and maintenance,    products and waste,    maintenance and waste,    maintenance and signal

Ans:D ,D

An attribute is a(n):
Options: column of a table.,    two dimensional table.,    row of a table.,    key of a table.

Ans:A ,A

The system study project includes
Options: system analysis,    system design,    implementation,    both (a) and (b)

Ans:D ,D

Laser Jet printer speeds are measured in pages per minute (ppm) what do we use to measure dot-matrix printers?
Options: lines per inch,    lines per sheet,    characters per inch,    characters per second

Ans:D ,D

Assume integer is 2 bytes wide. What will be the output of the following code? #include<stdio.h> #include<stdlib.h> #define MAXROW 3 #define MAXCOL 4 int main() { int (*p)[MAXCOL]; p = (int (*) [MAXCOL])malloc(MAXROW *sizeof(*p)); printf("%d, %d\n", sizeof(p), sizeof(*p)); return 0; }
Options: 2, 8,    4, 16,    8, 24,    16, 32

Ans:A ,A