. 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: 17233 | Level: Moderate




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


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

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

More MS-Excel Related questions:


When a group of computers is connected together in a small area without the help of telephone lines, it is called
Options: Remote communication network (RCN),    Local area network(LAN),    Wide area network (WAN),    Value added network (VAN)

Ans:B ,B


. When was the world’s first laptop computer introduced in the market and by whom?
Options: A) Hewlett-Packard B) Epson, 1981 C) Laplink traveling software In1982 D) Tandy model-2000, 1985

Ans:B,B


A network with named nodes and labeled arcs that can be used to represent certain natural language grammars to facilitate parsing.
Options: Tree Network,    Star Network,    Transition Network,    Complete Network

Ans:C ,C


A high speed device used in CPU for temporary storage during processing is called
Options: A register,    A bus,    A databus,    All of the above

Ans:A,A


Which of the following is used for serial access storage only?
Options: RAM,    Magnetic tape,    Magnetic disk,    Core memory

Ans:B,B


A memory space used for the temporary storage of data is
Options: PROM,    SAM,    Scratchpad storage,    Buffer

Ans:C ,C


When did Hewlett-Packard Inc. Introduce its first HP-110 laptop computer?
Options: 1984,    1986,    1990,    1995

Ans:A ,A


An anticipated result from multiprogramming operations is:
Options: reduced computer idle time,    the handling of more jobs,    better scheduling of work,    All of the above

Ans:D ,D


What will be the output of the program? #include<stdio.h> #include<stdlib.h> union employee { char name[15]; int age; float salary; }; const union employee e1; int main() { strcpy(e1.name, "K"); printf("%s %d %f", e1.name, e1.age, e1.salary); return 0; }
Options: Error: RValue required,    Error: cannot convert from 'const int *' to 'int *const',    Error: LValue required in strcpy,    No error

Ans:D ,D


Read-only databases are ________ updated.
Options: always,    commonly,    seldom,    never

Ans:D ,D


The device that can both feed data into and accept data from a computer is
Options: ALU,    CPU,    Input-Output device,    All of the above

Ans:C ,C


When you copy a formula
Options: a. Excel erases the original copy of the formula b. Excel edits cell references in the newly copied formula c. Excel adjusts absolute cell references d. Excel doesn’t adjust relative cell references

Ans:#8211; b,#8211; b


Production machines were first controlled by the computer by means of
Options: punched cards,    punched paper tape,    magnetic tape,    magnetic cards

Ans:B ,B


When inorder traversing a tree resulted E A C K F H D B G; the preorder traversal would return
Options: a. FAEKCDBHG b. FAEKCDHGB c. EAFKHDCBG d. FEAKDCHBG

Ans: b, b


. A computer programmer
Options: A) Does all the thinking for a computer B) Can enter input data quickly C) Can operate all types of computer equipments D) Can draw only flowchart

Ans:A,A


A UML diagram includes which of the following?
Options: Class name,    List of attributes,    List of operations,    All of the above.

Ans:D ,D


What are inserted as cross-reference in Word?
Options: a. Placeholders b. Bookmarks c. Objects d. Word fields

Ans:–  D,–  D


An example of a global allocation problem is
Options: defining plant capacities,    scheduling an entire development project,    setting general inventory guidelines,    All of the above

Ans:D ,D


What command is used to add printing jobs to the queue?
Options: lpd,    lpr,    lpq,    lpc

Ans:B ,B


.   Format painter
Options: a. To paint pretty pictures on your slides b. To copy formatting from one object or piece of text and then apply it elsewhere c. To change the background color of your slides d. To paint pretty pictures on background of slides

Ans:3 – B ,3 – B


The class-based addressing is also known as
Options: Modern Model B. Classful Model C. Classless Model D. Heterogeneous Model

Ans:– B ,


Programming languages currently available for robots:
Options: may be point-to-point languages,    require training,    may allow primitive motion,    All of the above

Ans:D ,D


A multifield transformation does which of the following?
Options: Converts data from one field into multiple fields,    Converts data from multiple fields into one field,    Converts data from multiple fields into multiple fields,    All of the above

Ans:D ,D


There are historical evidences to prove that abacus was first used in
Options: India,    Japan,    China,    Indonesia

Ans:C ,C


. During the boot process, the …. looks for the system file
Options: a. CD b. BIOS c. CPU d. DVD

Ans:7 – b ,7 – b


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

Ans:– B ,


. Which of the following is not an action query?
Options: a. add b. delete c. make-table d. update

Ans:– a,– a


. What is the shortcut key to insert a new comment in a cell?
Options: a. F2 b. Alt + F2 c. Ctrl + F2 d. Shift + F2

Ans:– d,– d


Graphic representation of the control logic of processing functions or modules representing a system, is known as:
Options: Structured analysis,    Structured chart,    Structured English,    System Flow chart

Ans:B ,B


What will be the output of the program? #include<stdio.h> int main() { enum color{red, green, blue}; typedef enum color mycolor; mycolor m = red; printf("%d", m); return 0; }
Options: 1,    0,    2,    red

Ans:B ,B


When your hard drive crashes from any of the correct selections in the question above, or from dropping it, it is known as head-to-disk interference, or HDL
Options: True,    False,    ,    

Ans:A ,A


. Boot startup process
Options: a. Loads system files to RAM b. Checks the computer connections c. Clean up the computer memory d. Prepare the computer ready

Ans:5 – a ,5 – a


When you connect to an online information service, you are asked to provide some kind of identification such as your name, an account number and a password. What is the name given to this brief dialogue between you and the information system?
Options: Security procedure,    Safeguard procedure,    Identification procedure,    Log-on procedure

Ans:D ,D


  What is a slide transition?
Options: Overheads B. Letters C. A special effect used to introduce a slide in a slide show D. The way one slide looks

Ans:– C ,


. Which data type is better to use for storing phone number in the following format “977-1-1234567”?
Options: a. Text b. AutoNumber c. Number d. Currency

Ans:– a,– a


Which of the following have computers traditionally done better than people?
Options: storing information,    responding flexibly,    computing numerically,    both (a) and (c)

Ans:D ,D


Which of the following command options are displayed when you use the Router# show frame-relay ? command? dlci neighbors lmi pvc map
Options: 1 only,    2 and 4,    3, 4 and 5,    All of the above

Ans:C ,C


Which of the following protocols are used to configure trunking on a switch? VLAN Trunk Protocol VLAN 802.1Q ISL
Options: 1 only,    3 only,    3 and 4,    1, 3 and 4

Ans:C ,C


Super-computers
Options: Are found at thousands of sites around the world,    Can now fit on a single silicon chip,    Are usually designed to process accounting applications,    Are not fast enough for some applications

Ans:D ,D


Use of modern control technology in automation systems:
Options: reduces costs,    improves reliability,    increases yield,    All of the above

Ans:D ,D


Point out the error in the program? #include<stdio.h> int main() { struct a { float category:5; char scheme:4; }; printf("size=%d", sizeof(struct a)); return 0; }
Options: Error: invalid structure member in printf,    Error in this float category:5; statement,    No error,    None of above

Ans:B ,B


With respect to personnel matters in the United States, ERISA stands for
Options: Earnings and Revenue Information System Administration,    Early Retirement Income Standards Act,    Employee Review-in-Service Administration,    Employee Retirement Income Security Act

Ans:D ,D


A device that both transmits and receives data, is
Options: Transducer,    Trapdoor,    Translator,    Transceiver

Ans:D ,D


. This database has only one table.
Options: a. relational b. large c. flat-file d. DBMS

Ans:8 – c ,8 – c


A processing unit that coordinates networks and data communication is known as
Options: Control unit,    Communications processor,    Register unit,    CPU

Ans:B,B


“Ctrl + Home” is used to
Options: a. 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,–  A


.   auto clip art is a feature that
Options: a. automatically places clip art in your presentation b. scans your presentation for incorrect spelling of words on each slide c. scans your presentation for incorrect spelling in word art objects d. all of the above

Ans:5 – D ,5 – D


. The operating system is the most common type of .... Software
Options: a. Communication b. Application c. System d. Word processing software

Ans: c, c


A certain Professor at the Stanford University coined the word 'artificial intelligence' in 1956 at a conference held at Dartmouth college. Can you name the Professor?
Options: David Levy,    John McCarthy,    Joseph Weizenbaum,    Hans Berliner

Ans:B ,B


. Computer operators
Options: A) writes computer programs for specific problems B) operate the device which input and output data from the computer C) normally require a college degree in computer science D) all of the above

Ans:B,B

www.000webhost.com