Getting data from a cell located in a different sheet is called….

Options: Accessing B. Referencing C. Updating D. Functioning

Ans:– B ,

Description: mcqquestions

More MS-Excel Related questions:

. What is the method of handling deadlocks?
Options: a. Use a protocol to ensure that the system will never enter a deadlock state. b. Allow the system to enter the deadlock state and then recover. c. Pretend that deadlocks never occur in the system. d. All of the Above

Ans:5 – d ,5 – d

To hold row and column titles in place so that they do not scroll when you scroll a worksheet click the
Options: a. Unfreeze panes command on the window menu b. Freeze panes command on the window menu c. Hold titles command on the edit menu d. Split command on the window menu

Ans:#8211; b,#8211; b

. Which is the shortcut key to jump to the first slide of the presentation?
Options: a. Home b. Alt + Home c. Ctrl + Home d. Shift + Home

Ans:1 – C ,1 – C

What is the term used when a clip art image changes the direction of faces?
Options: a. Group b. Flip c. Rotate d. All of the above

Ans: – C , – C

Poor response times are caused by
Options: Processor busy,    High I/O rate,    High paging rates,    Any of the above

Ans:D ,D

Seymour Papert of the MIT AI lab created a programming environment for children called:
Options: BASIC,    LOGO,    MYCIN,    FORTRAN

Ans:B ,B

Which of the following is the valid host range for the subnet on which the IP address resides?

Ans:A ,A

A form defined 
Options: a. where data is placed on the screen b. the width of each field c. both a and b d. none of the above


Point out the error in the program. #include<stdio.h> #define MAX 128 int main() { char mybuf[] = "India"; char yourbuf[] = "BIX"; char *const ptr = mybuf; *ptr = 'a'; ptr = yourbuf; return 0; }
Options: Error: unknown pointer conversion,    Error: cannot convert ptr const value,    No error,    None of above

Ans:B ,B

Which is considered a direct entry input device?
Options: Optical scanner,    Mouse,    Light pen,    Digitizer

Ans:E ,E

Strategic Planning factors do not include which of the following?
Options: Organizational goals,    Critical success factors,    Information engineering,    Problem areas

Ans:C ,C

Sales order data is entered by means of
Options: terminal entry,    keypunch,    OCR,    All of the above

Ans:D ,D

In an absolute loading scheme, which loader function is accomplished by loader?
Options: Reallocation,    Allocation,    Linking,    Loading

Ans:D ,D

To duplicate a controls formatting you can use___
Options: a. Manager b. Wizard c. Painter d. Control

Ans:ndash; c,ndash; c

The Process Manager has to keep track of:
Options: the status of each program,    the priority of each program,    the information management support to a programmer using the system,    both (a) and (b)

Ans:D ,D

. In MS-Word, for what does ruler help?
Options: a. to set tabs b. to set indents c. to change page margins d. All of the above

Ans: –  D , –  D

. The computer that process both analog and digital is called
Options: A) Analog computer B) Digital computer C) Hybrid computer D) Mainframe computer


Conversion of an octal number 738 to binary number is
Options: 1101112,    1111002,    1100102,    1110112

Ans:D ,D

The physical system of the firm may be regarded as a flow of
Options: manpower, machines, material, and money,    information only,    manpower, machines, material, money, and information,    manpower, machines, material, money, and data

Ans:A ,A

. Which of the following can be used to divide a web page into areas?
Options: a. frames b. theme c. table of contents d. none of the above

Ans: –  A , –  A

. A small part of taskbar that has icons of background running applications is
Options: a. Start button b. Quick launch c. Task bar d. System tray

Ans: d, d

A compiler is
Options: a program that places programs into memory and prepares them for execution,    a program that automate the translation of assembly language into machine language,    program that accepts a program written in a high level language and produces an object program,    is a program that appears to execute a source program as if it were machine language

Ans:C ,C

Point out the error in the program? #include<stdio.h> int main() { struct emp { char name[25]; int age; float bs; }; struct emp e; = "Suresh"; e.age = 25; printf("%s %d\n",, e.age); return 0; }
Options: Error: Lvalue required/incompatible types in assignment,    Error: invalid constant expression,    Error: Rvalue required,    No error, Output: Suresh 25

Ans:A ,A

What is the i/o address for com2?
Options: 2vb,    2f8,    8f8,    330

Ans:B ,B

An up/down counter used in a TI510PC has three inputs. Which of the following is not one of them?
Options: Count up,    Count out,    Reset.,    Count down

Ans:B ,B

. Format a:/s will do
Options: a. Formats and then transfers system file b. Formats with verification c. Formats and scans the disk d. None of above

Ans:8 – a ,8 – a

End-to-end connectivity is provided from host-to-host in:
Options: Network layer,    Session layer,    Data link layer,    Transport layer

Ans:D ,D

. You can tell when an object is active because
Options: a. The object is highlighted b. Eight small sizing handles appear surrounding the text c. A box frame appears surrounding the text d. b and c

Ans:8 – A ,8 – A

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

Ans:C ,C

A system program that combines the separately compiled modules of a program into a form suitable for execution
Options: assembler,    linking loader,    cross compiler,    load and go

Ans:B ,B

B7:B9 indicates
Options: a. Cells B7 and cell B9 only, b. Cells B7 through B9, c. Cell B8 only, d. None of the above

Ans:b,Cells B7 through B9

PowerPoint presentations are widely used as
Options: a. note outlines for teachers b. project presentations by students c. communication of planning d. All of above

Ans:– D ,– D

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

Ans:C ,C

Which of the following is not process states?
Options: New B. Running C. Ready D. Finished

Ans:– D ,

. Referential integrity means
Options: a. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table b. Do not enter a value in the primary key field of chield table if that value does not exist in the primary key of the parent table c. Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table d. All of above

Ans:1 – a ,1 – a

. _____ formatting is the process of changing the way letters, numbers, punctuation marks, and symbols appear on the screen and in print.
Options: a. Document b. Character c. Paragraph d. Object

Ans:– B,– B

Convert the 080D4E machine language instructions into assembly language, assuming that they were not generated by pseudo-ops:
Options: ASRA,    LOADA h#OD4E, i,    STOREA h#014B, d,    ADDA h#01FE, i

Ans:B ,B

. Which command allows you to show the contents of disk widely in screen?
Options: a. Dir/p b. Dir/b c. Dir/w d. Dir/o:w

Ans:7 – c ,7 – c

. Daisy wheel printer is a type of

Options: A) Matrix printer B) Impact printer C) Laser printer D) Manual printer


. Which of the following helps to reduce spelling error in the document?
Options: a. Auto Format b. Auto Correct c. Smart Tags d. Auto Text

Ans:–  B,–  B

For connecting modem, a computer must be equipped with a port that conforms to the RS-232 standard of the Electronic Industries Association of America. What do the letters 'RS' stand for?
Options: Recognised standard,    Random sequence,    Recommended standard,    Registered source

Ans:C ,C

. Which of the following command is used to switch between the window programs?
Options: a. Alt+Tab b. Alt+F4 c. Ctrl+Tab d. None of the above

Ans:5 – a ,5 – a

The primary interactive method of communication used by humans is:
Options: reading,    writing,    speaking,    All of the above

Ans:C ,C

Which of the following subdirectory(ies) contains the device files?
Options: /dev,    /bin,    /etc,    /home

Ans:A ,A

. 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

. Which of the following bypasses the print dialog box when printing individual slides or an entire presentation?
Options: a. File, Print Preview b. The print button c. File, print d. Ctrl + P

Ans:8 – B ,8 – B

EBCDIC can code up to how many different characters?
Options: 8,    16,    32,    64

Ans:E ,E

Which step should you perform first before discharging a CRT?
Options: Remove the CRT from its housing,    Disconnect the CRT from the computer,    Remove the video assembly,    Turn power off before removing power source

Ans:D ,D

Where can you find the Draw Table tool button?
Options:  A) Standard toolbar, B) Formatting toolbar, C) Drawing toolbar, D) Tables and Formatting toolbar, 


What is the shortcut key to Close Active Document in Microsoft Word?
Options: Ctrl + F4 B. Shift + F4 C. Ctrl + Shift + F4 D. None of above

Ans:– A ,