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

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

Ans:– B ,

More MS-Excel Related questions:

Which of the following commands is used to save the output of the who command in a file named user.lst, as well as display it?
Options: who | tee user.lst,    who > user.lst,    who >> user.lst,    who < user.lste

Ans:A ,A

How can you create a uniform appearance by adding a background image to all slides?
Options: a. Create a template b. Edit the slide master c. Use the autocorrect wizard d. All of the above

Ans: – B , – B

. Clear the contents by pressing “DELETE” key from a keyboard will clear 
Options: a. Text Only b. Format Only c. Contents Only d. Both Contents and Format

Ans:– c,– c

An Information system that responds immediately to the needs of the physical system is called a(n)
Options: inline system,    on line system,    offline system,    realtime system

Ans:D ,D

What was the total number of UNIVAC-I sold eventually and by which company?
Options: A -30 British Tabulating Machine Co. (BTM), B -40 International Business Machines (IBM), C - 48 Remington Rand, D- 40 International Computer Ltd. (ICL)

Ans:C ,48

. The memory which is programmed at the time it is manufactured


Codes consisting of light and dark marks which may be optically read is known as
Options: Mnemonics,    Bar code,    Decoder,    All of the above

Ans:B ,B

A network administrator views the output from the show ip route command. A network that is advertised by both RIP and IGRP appears in the routing table flagged as an IGRP route. Why is the RIP route to this network not used in the routing table?
Options: IGRP has a faster update timer.,    IGRP has a lower administrative distance.,    RIP has a higher metric value for that route.,    The IGRP route has fewer hops.

Ans:B ,B

. Which would you choose to list Synonyms & Antonyms of a selected word?
Options: a. Tools, Spelling & Grammar b. Tools, Language c. Tools, Options d. Insert, Cross-reference

Ans: –  B , –  B

A double sided magnetic disk pack has six disks. Can you tell how many surfaces of this pack are normally used?
Options: 10,    12,    6,    9

Ans:A ,A

To run the old system and the new system at the same time for a specified period, the system implementation approach used is
Options: pilot,    phased,    parallel,    direct

Ans:C ,C

19. Word is preset to use standard 8.5-by-11-inch paper with _____ margins.
Options: a. 1-inch left, right, top, and bottom b. 1.25-inch left, right, top, and bottom c. 1.25-inch left and right margins and 1-inch top and bottom d. 1-inch left and right margins and 1.25-inch top and bottom

Ans:– C ,– C

_____ use standardized symbols to represent an algorithm.
Options: Flowcharts,    Flow diagrams,    IPO charts,    Pseudocharts

Ans:A ,A

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

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

Ans:D ,D

. Which command be used to clear the screen and display the operating system prompt on the first line of the display?
Options: a. Cd b. Md c. Rename d . cls

Ans:Correct Answer: d ,Correct Answer: d

The _____ switch instructs DOS to display the directory list in a wide format.
Options: /W,    /O,    /P,    /B

Ans:A ,A

To have a file hold a list, it is necessary to
Options: identify the records in the list,    identify the name, width and type of the fields of each record.,    decide which fields will be used as sort or index keys,    All of the above

Ans:D ,D

. Which command is used to delete all the files from root directory of drive A?
Options: a. Del a: b. Del *.* c. Del A d. Erase *

Ans:3 – a ,3 – a

. A program in execution is called
Options: a. A Paging b. A Process c. A virtual memory d. A Demand Page

Ans:6 – b ,6 – b

Changes to the data base are made only with
Options: proper departmental security codes,    proper individual passwords,    both (a) and (b),    neither (a) nor (b)

Ans:C ,C

. Start/restart the computer is called
Options: a. Exit b. Run c. Option d. Boot

Ans:7 – d ,7 – d

. What is the AutoComplete feature of Excel?
Options: a. It automatically completes abbreviated words b. It completes text entries that match an existing entry in the same column c. It completes text and numeric entries that match an existing entry in the same column d. It completes text entries that match an existing entry in the same worksheet

Ans:– b,– b

The tracks on a disk which can be accessed without repositioning the R/W heads is
Options: Surface,    Cylinder,    Cluster,    All of the above


Which of the following are benefits of VLANs? They increase the size of collision domains. They allow logical grouping of users by function. They can enhance network security. They increase the size of broadcast domains while decreasing the number of collision domains. They simplify switch administration. They increase the number of broadcast domains while decreasing the size of the broadcast domains.
Options: 1 and 5,    2 and 4,    1, 3 and 5,    2, 3 and 6

Ans:D ,D

35. 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

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

What are lines, curve, freeform, and scribble?
Options: a. Emphasis effects that can be applied to animations b. Types of custom motion paths c. Predefined entrance and exit effects d. All of the above

Ans: – B , – B

.    Which command creates a directory or subdirectory?
Options: a.    Dir b.    Mkdir c.    Md d.    Both b and c

Ans:.a,Correct Answer: d. Both b and c

. 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 is not a worksheet design criterion?
Options: a. Efficiency b. Aditibility c. Description d. Clarity

Ans:#8211; c,#8211; c

The use of specialized workstations:
Options: provides limited growth potentials for 3-D,    reduces the host computer workload and allows more users,    reduces the host computer workload,    has a high cost-performance tradeoff

Ans:B ,B

. what term describes a background that appears as a grainy, non smooth surface
Options: a. gradient b. pattern c. solid d. texture

Ans:– a,– a

Which network is a packet switching network?
Options: Ring network,    LAN,    Star network,    EuroNET


How many pairs of stations can simultaneously communicate on Ethernet LAN?
Options: 1,    2,    3,    multiple

Ans:A ,A

A device that converts thermal energy to electrical energy is called a:
Options: thermocouple,    solar cell,    chemical cell,    piezoelectric devices

Ans:A ,A

In ________ mode, the communication channel is used in both directions at the same time?
Options: Full-duplex B. Simplex C. Half-duplex D. None of the above

Ans:– A ,

A hand-held device for optically reading bar codes on goods, labels & shelves is
Options: Wand,    Touch tablet,    Mouse,    Light pen

Ans:A ,A

. By using RD command, directory with files can be removed or not
Options: a. Removed b. Not removed c. Both a and b d. None of above

Ans:1 – b ,1 – b

Excel displays the current cell address in the ……….
Options: Formula bar B. Status Bar C. Name Box D. Title Bar

Ans:– C ,

The ALU and control unit of most of the microcomputers are combined and manufactured on a single silicon chip. What is it called?
Options: Monochip,    Microprocessor,    ALU,    Control Unit


What do the following declaration signify? int *f();
Options: f is a pointer variable of function type.,    f is a function returning pointer to an int.,    f is a function pointer.,    f is a simple declaration of pointer variable.

Ans:B ,B

Which of the following is(are) true of the EDP auditors?
Options: they should have computer expertise,    they will be replaced by traditional auditors in the near future,    two of the above,    currently, there is a very high demand for them, particularly from firms that use personal computers

Ans:A ,A

"User friendly" computers have ensured that
Options: management requires no system analysis and design.,    programmers are no longer needed,    structured programming is not needed,    All of the above

Ans:E ,E

Which of the following languages is more suited to a structured program?
Options: PL/1,    FORTRAN,    BASIC,    PASCAL

Ans:D ,D

What router command allows you to determine whether an IP access list is enabled on a particular interface?
Options: show ip port,    show access-lists,    show ip interface,    show access-lists interface

Ans:C ,C

Client/server security includes which of the following?
Options: Physical security,    Change control security,    Measures taken to secure all systems,    All of the above.

Ans:D ,D

. 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 report footer section is most useful for displaying:
Options: a. grand totals b. Column headings c. subtotals d. page numbers

Ans:– a,– a

You have a PC with no video* Which of the following is LEAST likely to be causing the problem?
Options: defective RAM (bank zero),    defective microprocessor,    crashed hard drive,    loose video card

Ans:C ,C