. In order to perform a calculation in a spreadsheet, you need to use a:


Options: table B. formula C. field D. variable

Ans: – B ,


Description: mcqquestions

Asked in: KCC-2018   |   JOA 556-2018  |  HRTC JTO-2017

Hits Today: 6849 | Level: Moderate


******************************************************

Want to see where do you stand among other aspirants in "Computer" category?

Click Here to take quick 10 mins MCQ test to find out.




Got some suggestion about this question or to make this site better? Please leave your comments below.




More MS-Excel Related questions:


A batch processing terminal would not include a
Options: CPU,    card reader,    card punch,    line printer

Ans:A ,A


Layer 2 switching provides which of the following? Hardware-based bridging (ASIC) Wire speed Low latency Low cost
Options: 1 and 3,    2 and 4,    1, 2 and 4,    All of the above

Ans:D ,D


. Ctrl + K
Options: Insert Page Humber B. Insert Hyperlink C. Insert Header D. Insert Footer

Ans:– B ,


. Which of the following is not a view for interacting with a form object?
Options: a. Datasheet view b. Design view c. Form view d. Layout view

Ans:– d,– d


. According to the Leszynski Naming Conventions, which of the following is the prefix for a combo box control?
Options: a. cbo b. cob c. cmb d. cbx

Ans:3 – a ,3 – a


Which input device is able to scan & interpret an entire page that is typed in a special font
Options: Floppy disk,    Page reader,    Paper tape punch,    Optical card readers

Ans:B ,B


Which of the following device cannot be shared in Network?
Options: CD Drive B. Printer C. Mouse D. Hard Disk

Ans:– C ,


Front-end processor is a _____ designed specifically to handle the communications processing task.
Options: ALU,    Control unit,    CPU,    Register

Ans:C ,C


If a robot can alter its own trajectory in response to external conditions, it is considered to be:
Options: intelligent,    mobile,    open loop,    non-servo

Ans:A ,A


What will be the output of the program in 16-bit platform (under DOS)? #include<stdio.h> int main() { struct node { int data; struct node *link; }; struct node *p, *q; p = (struct node *) malloc(sizeof(struct node)); q = (struct node *) malloc(sizeof(struct node)); printf("%d, %d\n", sizeof(p), sizeof(q)); return 0; }
Options: 2, 2,    8, 8,    5, 5,    4, 4

Ans:A ,A


Which values are held in CMOS for the hard drive
Options: size (heads, cylinders, sectors),    IRQ,    Free space,    Virus alert

Ans:A ,A


The seventh field of /etc/password is
Options: password,    login,    shell,    home

Ans:C ,C


. The maximum size of a write file is limited to only
Options: a. Name of the file b. Extension of the file c. The amount of memory in your computer d. All of above

Ans: c, c


To save a workbook, you:
Options: a. Click the save button on the standard toolbar from the menu b. Press Ctrl+F5 c. Click Save on the Windows Start button d. Select Edit>Save

Ans:#8211; a,#8211; a


. The acronym of WORM in a Computer System is
Options: Write Only Read Only B. Write Once Read Many C. Write Only Read Memory D. Write Once Read Memory

Ans:– B ,


. What is the shortcut key to insert new sheet in current workbook?
Options: F11 B. Alt + F11 C. Ctrl + F11 D. Shift + F11

Ans:– D ,


. A tiny dot of light on the monitor is called
Options: a. Silicon chip b. Optical illusion c. Icon d. Pixel

Ans:4 – d ,4 – d


The first industrial robot for commercial uses was installed in a Japanese plant at Toyota Automatic Loom Company, the parent company of the Toyota Automobile Group. When did this robot go into operation?
Options: June 1965,    November 1966,    December 1967,    April 1970

Ans:C ,C


Which command is used to locate all the .profile files in the system?
Options: ls profile,    find /-name profile -print,    cd /.profile,    l -u .profile

Ans:B ,B


The total number of messages handled by a computerized telephone system on a daily basis is an example of:
Options: Frequency,    Updating,    Volume,    All of the above

Ans:C ,C


Data are sent over pin _____ of the EIA-232 interface.
Options: 2,    3,    4,    All of the above

Ans:A ,A


In order to use a record management system
Options: You need to understand the low-level details of how information in stored,    You need to understand the model the record management system uses.,    Both (a) and (b),    All of the above

Ans:B ,B


. Where will store data first time when you copy
Options: a. Clipboard b. Clipbook c. Hard disk d. CD

Ans:1 – a ,1 – a


What will be the output of the program? #include<stdio.h> typedef void v; typedef int i; int main() { v fun(i, i); fun(2, 3); return 0; } v fun(i a, i b) { i s=2; float i; printf("%d,", sizeof(i)); printf(" %d", a*b*s); }
Options: 2, 8,    4, 8,    2, 4,    4, 12

Ans:D ,D


Which one of the following statements is true for the impedance of a series RC circuit?
Options: The impedance is greater than the sum of the resistance and capacitive reactance,    The impedance is equal to the sum of the resistance and capacitive reactance,    The impedance is greater than either the resistance or capacitive reactance but less than their sum,    The impedance is less than the sum of the resistance and capacitive reactance

Ans:C ,C


Why is the width of the data bus so important to the processing speed of a computer?
Options: The narrower it is, the greater the computer's processing speed,    The wider it is, the more data that can fit into main memory,    The wider it is, the greater the computer's processing speed,    The wider it is, the slower the computer's processing speed

Ans:C ,C


Which of the following protocols support VLSM, summarization, and discontiguous networking? RIPv1 IGRP EIGRP OSPF BGP RIPv2
Options: 1 and 4,    2 and 5,    3, 4 and 6,    All of the above

Ans:C ,C


. Which is not a valid property for attribute setting?
Options: a. C,b. S,c. H,d. R

Ans:3 – a ,3 – a


Which of the following are not likely to be found on a PC main circuit board
Options: RAM chips,    Microprocessor chips,    ROM chips,    LCD clocks

Ans:D ,D


Which of the following is correct in CIDR?
Options: Class A includes Class B network B. There are only two networks C. There are high & low class network D. There is no concept of class A, B, C networks

Ans:– D ,


A bidirectional feedback loop links computer modelling with:
Options: artificial science,    heuristic processing,    human intelligence,    cognitive science

Ans:D ,D


Which of the following refers to an entity in which the identifier of one entity includes the identifier of another entity?
Options: Weak entity,    Strong entity,    ID-dependent entity,    ID-independent entity

Ans:C ,C


Point out the error in the program? struct emp { int ecode; struct emp *e; };
Options: Error: in structure declaration,    Linker Error,    No Error,    None of above

Ans:C ,C


What command is used with vi editor to move forward to the end of a word?
Options: c,    d,    b,    e

Ans:D ,D


. The __________ performs document tracking.
Options: a. distributed application b. enterprise software c. Oracle software d. EDM software

Ans:2 – d ,2 – d


. “Ctrl + Home” is used to
Options: Moves the cursor to the beginning of Document B. Moves the cursor to the beginning of Line C. Moves the cursor to the beginning of Paragraph D. All of the above

Ans:– A ,


. Which unit converts user data into machine readable form?
Options: A) Input unit B) Output unit C) ALU D) Control Unit

Ans:A,A


After entering all fields required for a table, if you realize that the third field is not needed, how will you remove?
Options: a. You need to delete the whole tablThere is no method to remove a particular field only. b. Delete all the fields from third downwards and reenter the required fields again. c. Select the third column in datasheet view then  Delete d. Select the third row in table design view then Delete

Ans:ndash; d,ndash; d


Which two of the following commands will place network 10.2.3.0/24 into area 0? router eigrp 10 router ospf 10 network 10.0.0.0 network 10.2.3.0 0.0.0.255 area0 network 10.2.3.0 0.0.0.255 area 0
Options: 1 and 4,    2, 4, and 5,    2 and 5,    3 and 4

Ans:C ,C


What two disciplines are usually tied by a common data base?
Options: Documentation and geometric modeling,    Computer-aided design and computer-aided manufacturing,    Testing and analysis,    Drafting and documentation

Ans:B ,B


What should you do if you require pasting the same format in many places?
Options:  A) Click the Format painter and go on pasting in many places holding Alt Key, B) Double click the format painter then go on pasting in many places, C) Click the format painter then go on pasting to many places holding Ctrl Key, D) All of above,

Ans:-B,-B


You want to track the progress of the stock market on a daily basis. Which type of chart should you use?
Options: a. Pie chart b. Row chart c. Line chart d. Column chart

Ans:#8211; c,#8211; c


Which of the following types of decision-making would depend heavily on real-time information?
Options: strategic,    tactical,    operational,    nonprogrammable

Ans:C ,C


A Relation is a
Options: Subset of a Cartesian product of a list of attributes B. Subset of a Cartesian product of a list of domains C. Subset of a Cartesian product of a list of tuple D. Subset of a Cartesian product of a list of relations

Ans:– B ,


Four basic elements are required for an automated machine tool or production process. They are: input interface, memory, output interface and:
Options: logic,    software,    NC tape programming,    computer graphics workstation

Ans:A ,A


. 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


A compiler means
Options: A person who compiles source programs,    The same thing as a programmer,    Keypunch operator,    A program which translates source program into object program

Ans:D,(Danswer


Conversion of an octal number 208 to its binary number is
Options: 100002,    101112,    101102,    111102

Ans:A ,A


. It is a database object to view, change, and analyze data in different ways
Options: a. Query b. Form c. Report d. None of the above

Ans:9 – a ,9 – a


What frequency range is used for microwave communications, satellite and radar?
Options: Low Frequency : 30 kHz to 300 kHz,    Medium Frequency : 300 kHz to 3 MHz,    Super High Frequency : 3000 MHz to 30000 MHz,    Extremely High Frequency :30,000 MHz

Ans:D ,D

www.000webhost.com