. What is the correct way to refer the cell A10 on sheet3 from sheet1?


Options: sheet3!A10 B. sheet1!A10 C. Sheet3.A10 D. A10

Ans: – A ,






More MS-Excel Related questions:


How is the integral mode implemented using analog methods?
Options: Op amp and resistors,    Op amp and a capacitor,    Op amp and an RC network to place the error voltage across the capacitor,    All of the above

Ans:B ,B


How is ink transferred to paper in common ink jet printers?
Options: Boiling ink,    Crystal,    Motorized pump,    Screens deflect ink on the paper into the proper positions

Ans:B ,B


. For which of the following computers can’t be used?

Options: A) gathering data B) calculating data C) comparing data D) Arranging data

Ans:A,A


A data structure where elements can be added or removed at either end but not in the middle
Options: a. Linked lists b. Stacks c. Queues d. Deque  

Ans:d,d


Which of the following are word processing software?
Options: a. WordPerfect b. Easy Word c. MS Word d. All of above

Ans:– D,– D


. Any and every command can be found on the
Options: a. Drawing toolbar b. Formatting toolbar c. Standard toolbar d. Menu bar

Ans:1 – D ,1 – D


. Which of the following command is an internal command?
Options: a. Del b. Scandisk c. CHKDSK d. Deltree

Ans:0 – a ,0 – a


Which of the following memories needs refresh?
Options: DRAM B. SRAM C. ROM D. All of above

Ans:– A ,


To edit in an embedded excel worksheet object in a word document
Options: a. Use the excel menu bar and toolbars inside the word application b. Edit the hyperlink c. Edit the data in a excel source application d. Use the word menu bar and toolbars

Ans:#8211; a,#8211; a


A device which converts human readable data into machine language is
Options: Card reader,    Card punch,    Punched paper tape,    Character reader

Ans:D ,D


.   To create a PowerPoint presentation from a template
Options: a. Click File, New, select the presentations tab and choose a template b. Click File, New Template and choose a template c. Import a presentation template from PowerPoint’s template wizard d. Click Create Template from scratch, Now

Ans:1 – A ,1 – A


The lowest form of computer language is called:
Options: FORTRAN,    BASIC,    machine language,    COBOL

Ans:C ,C


Bringing a page into memory only when it is needed, this mechanism is called
Options:  Deadlock B.  Page Fault C.  Dormant Paging D.  Demand Paging

Ans:– D ,


Presentation designs regulate the formatting and layout for the slide and are commonly called
Options: a. Design plates b. Templates c. Placeholders d. Blueprints

Ans: – B , – B


    Which command lists the contents of current directory of a disk
Options: a.    Copy b.    Tree c.    Cd d.    Dir

Ans:D,Correct Answer: Dir


The process of writing computer instructions in a programming language is known as
Options: Coding,    Processing,    Programming,    File

Ans:A ,A


The characteristics of strategic decisions include all of the following except:
Options: they are structured,    they are future oriented,    they have a high level of uncertainty,    they are concerned with long-range plans

Ans:A ,A


The Storage-to-Storage instructions
Options: have both their operands in the main store.,    which perform an operation on a register operand and an operand which is located in the main store, generally leaving the result in the register, expect in the case of store operation when it is also written into the specified storage location.,    which perform indicated operations on two fast registers of the machine and have the result in one of the registers,    all of the above

Ans:A ,A


What will be the output of the program ? #include<stdio.h> int main() { static int a[2][2] = {1, 2, 3, 4}; int i, j; static int *p[] = {(int*)a, (int*)a+1, (int*)a+2}; for(i=0; i<2; i++) { for(j=0; j<2; j++) { printf("%d, %d, %d, %d\n", *(*(p+i)+j), *(*(j+p)+i), *(*(i+p)+j), *(*(p+j)+i)); } } return 0; }
Options: 1, 1, 1, 1 2, 3, 2, 3 3, 2, 3, 2 4, 4, 4, 4,    1, 2, 1, 2 2, 3, 2, 3 3, 4, 3, 4 4, 2, 4, 2,    1, 1, 1, 1 2, 2, 2, 2 2, 2, 2, 2 3, 3, 3, 3,    1, 2, 3, 4 2, 3, 4, 1 3, 4, 1, 2 4, 1, 2, 3

Ans:C ,C


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 ,


. What do you mean by one to many relationship between student and class table?
Options: a. One student can have many classes b. One class may have many student c. Many classes may have many students d. Many students may have manu classes

Ans:0 – a ,0 – a


Which command will be used to display file and directory names only, without size, date, and time information?
Options: DIR/W,    DIR A:,    DIR/B,    DIR/S

Ans:C ,C


H.P. Luhn and Stephen E. Forth developed an application for the computer named
Options: selective dissemination of information,    management information system,    information retrieval,    document retrieval

Ans:C ,C


One solution to the multivalued dependency constraint problem is to:
Options: split the relation into two relations, each with a single theme.,    change the theme.,    create a new theme.,    add a composite key.

Ans:A ,A


How many primary partitions can exist on one drive?
Options: 16,    4,    2,    1

Ans:B ,B


Which of the following is not a way to complete a cell entry?
Options: a. Pressing enter b. Pressing any arrow key on the keyboard c. Clicking the Enter button on the Formula bar d. Pressing spacebar

Ans:8211; d,8211; d


The floppy drive uses which DMA (direct memory access) channel?
Options: 5,    4,    1,    2

Ans:2,D


The combination of the top-down and the bottom-up approach may be referred to as an:
Options: interactive approach,    interpretive approach,    integrative approach,    All of the above

Ans:C ,C


. What happens if you mark on Hidden check box of Font dialog box after you select some text?
Options: a. The text is deleted from document and you need to bring from Recycle Bin if required again. b. The text is hidden and you need to bring it by removing the check box if needed again c. The text is deleted and cannot be returned back d. The text is hidden and cannot be returned back

Ans: – B , – B


.   Which of the following are types of sound files?
Options: a. LOG files b. DAT files c. WAV files d. DRV files

Ans:1 – C ,1 – C


. The commonly used standard data code to represent alphabetical, numerical and punctuation characters used in electronic data processing system is called
Options: A) ASCII B) EBCDIC C) BCD D) All of above

Ans:D,D


Concatenation of text can be done using
Options: a. Apostrophe ,b. Exclamation, c. Hash , d. Ampersand

Ans:d,Ampersand


2. Which command is used to see the sub-directory structure of drive?
Options: a. Tree b. List c. Subdir d. Subtree

Ans:Correct Answer: a ,Correct Answer: a


Which is not a data source component?
Options:  A) mail merge toolbar, B) header row, C) data fields, D) data records, 

Ans:-A,-A


Which command of DOS is used to sort the file in reverse order?
Options: SORT > filename,    SORT < filename,    SORT/R < filename,    SORT/V < filename

Ans:C ,C


. The Search tool is best used when searching for ______ data.
Options: a. simple b. multiple c. unique d. formatted

Ans:6 – a ,6 – a


A small film-plate which is used for microfilming the output from a microcomputer screen is called
Options: microfilm,    microfiche,    film card,    COM

Ans:B ,B


"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 field type will you select when creating a new table if you require to enter long text in that field?
Options: a. Text b. Memo c. Currency d. Hyperlink

Ans:ndash; b,ndash; b


Which type of OSPF network will elect a backup designated router? Broadcast multi-access Non-broadcast multi-access Point-to-point Broadcast multipoint
Options: 1 and 2,    3 and 4,    3 only,    None of the above

Ans:A ,A


A CASE SQL statement is which of the following?
Options: A way to establish an IF-THEN-ELSE in SQL.,    A way to establish a loop in SQL.,    A way to establish a data definition in SQL.,    All of the above.

Ans:A ,A


The problem of thrashing is affected significantly by:
Options: program structure,    program size,    primary-storage size,    all of the above

Ans:A ,A


Primitive operations common to all record management system include
Options: a. print b. sort c. look-up d. all of above

Ans:. c ,. c


Which fields are contained within an IEEE Ethernet frame header? Source and destination MAC address Source and destination network address Source and destination MAC address and source and destination network address FCS field
Options: 1 and 4,    2 only,    2 and 3 only,    3 only

Ans:A ,A


Which of the following disallows both dirty reads and nonrepeatable reads, but allows phantom reads?
Options: Read committed,    Read uncommitted,    Repeatable read,    Serializable

Ans:C ,C


. When you add fields in ____, a Field List pane displays.
Options: a. Design View b. Layout View c. Print Preview d. Report View

Ans:0 – b ,0 – b


The general range of speed in revolutions per minute (rpm) at which floppy disks rotate is
Options: 2400-4700,    390-600,    150-250,    300-600

Ans:C ,C


. EBCDIC can code up to how many different characters?
Options: A) 256 B) 16 C) 32 D) 64

Ans:A,A


XML is which of the following?
Options: A scripting language that states the rules for tagging elements.,    A programming language that states the rules for tagging elements.,    A programming language that allows the creation of customized tags.,    A scripting language that allows the creation of customized tags.

Ans:D ,D


. Which is the system prompt?
Options: a. c> b. c:> c. c:> d. None

Ans:7 – b ,7 – b

www.000webhost.com