Which is an example of a formula?


Options: =A1+A2 B. =add(A1:A2) C. A1+A2 D. SUM(A1:A2)

Ans:– A ,


Description: mcqquestions

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

Hits Today: 5079 | 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:


Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Options: a. Press Ctrl +Home b. Press Home c. Press Shift + Home d. Press Alt + Home

Ans:#8211; a,#8211; a


Which, of the following, is true for testing and debugging?
Options: Testing checks for logical errors in the programs, while debugging is a process of correcting those errors in the program,    Testing detects the syntax errors in the program while debugging corrects those errors in the program,    Testing and debugging indicate the same thing,    All of the above

Ans:A ,A


What will be the output of the program? #include<stdio.h> int main() { int X=40; { int X=20; printf("%d ", X); } printf("%d\n", X); return 0; }
Options: 40 40,    20 40,    20,    Error

Ans:B ,B


A _____ is software that is designed for drawing diagrams of information systems, writing process specifications, and maintaining data dictionaries.
Options: System Development Life Cycle,    CASE tool,    Phased Conversion,    Success factors

Ans:B ,B


What is the name of the logic circuit which can add two binary digits?
Options: Full adder,    Half adder,    Buffer,    Register

Ans:B,B


Which of the following affects the extent to which you are involved with the system development life cycle in your company?
Options: your job description,    size of the organization,    your relevant experience,    All of the above

Ans:E ,E


Point out the error in the program. #include<stdio.h> int main() { const int x; x=128; printf("%d\n", x); return 0; }
Options: Error: unknown data type const int,    Error: const variable have been initialised when declared.,    Error: stack overflow in x,    No error

Ans:B ,B


Which of the following is used as "Input device" for the computer?
Options: Printer,    VDU,    TV,    Light pen

Ans:D ,D


. What is the purpose of indexing?
Options: a. To reduce table size b. To speedup data search c. both A and B d. none of the above

Ans:– b,– b


Who founded the Linux Kernel?
Options: Bill Gates,    Ben Thomas,    Richard Stallman,    Linus Torvalds

Ans:D ,D


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

Ans:A ,A


What is invoked via HTTP on the Web server computer when it responds to requests from a user's Web browser?
Options: A Java application,    A Java applet,    A Java servlet,    None of the above is correct.

Ans:C ,C


By default, your document prints with:
Options: 1 inch top and bottom margins B. a portrait orientation C. 1.25 inches left and right margins D. all of the above

Ans:D,


. 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 table. There 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:3 – d ,3 – d


.   Which of the following is not a way to cut text ?
Options: a. Select the text and press the delete button b. Select the text and select Edit, Cut from the menu c. Select the text and click the Cut button on the toolbar d. Select the text and press Ctrl + X

Ans:2 – A ,2 – A


The unit of a computer system that executes program, communicates with and often controls the operation of other subsystems of the computer is known as
Options: CPU,    Control Unit,    I/O unit,    Peripheral unit

Ans:A,A


. How to insert Section Break in Microsoft Word 2010?
Options: Insert ribbon – Pages group – Page Break button B. View ribbon – Document Views group – Breaks button C. References ribbon – Index group – Insert Index button D. Print Layout ribbon – Page Setup group – Breaks button

Ans:– D ,


Which of the following is not true of the traditional approach to information processing?
Options: There is common sharing of data among the various applications,    It is file-oriented,    Programs are dependent on the files,    It is inflexible

Ans:A ,A


.   Ellipse Motion is a predefined ….
Options: a. Design template b. Color scheme c. Animation scheme d. None of these

Ans:1 – C ,1 – C


. For what Antikyathera was used?
Options: A) For counting B) For Calculating tax collection C) For calculating astronomical positions D) For calculating firing weapons

Ans:9-C,9-C


. ABC is a
Options: A) Special purpose computer B) General purpose computer C) All Purpose Computer D) None of above

Ans:A,A


Which of the following file organizations is most efficient for a file with a high degree of file activity?
Options: sequential,    ISAM,    VSAM,    B-Tree index

Ans:A ,A


Which of the following is NOT a type of Microsoft Access database object?
Options: a. Table b. Form c. Worksheets d. Modules

Ans:ndash; c,ndash; c


The three different application logic components are which of the following?
Options: Presentation, Client, and Storage,    Presentation, Client, and Processing,    Presentation, Processing, and Storage,    Presentation, Processing, and Network

Ans:C ,C


.  Which of the following syntax is correct regarding to SUM function in Excel?
Options: a. =SUM (A1, B1) b. =SUM (A1:B9) c. =SUM (A1:A9, B1:B9) d. All of the above

Ans:– d,– d


The cp command uses:
Options: standard input file,    standard output file,    both input and output file,    neither standard input nor standard output file

Ans:D ,D


. Virtual memory typically located on
Options: a. RAM b. CPU c. Flash card d. Hard drive

Ans:0 – d ,0 – d


Primitive operations common to all record management systems include
Options: Print,    Sort,    Look-up,    All of the above

Ans:C ,C


Top-down programming is
Options: a group of related fields,    a map of the programmer's view of the data,    an approach in which the top module is first tested then program modules are added from the highest level to the lowest level,    a series or group of components that perform one or more operations of a more complex system

Ans:C ,C


Many large organizations have information _____ where managers can use fourth-generation languages to retrieve the facts they need from online data bases, and where staff experts are available to provide PC hardware/ software guidance.
Options: expert,    centers,    control,    MIS

Ans:B ,B


.Only filenames and extensions are to be displayed in wide format, which command you’ll use?
Options: a.    Dir/w b.    Dir a: c.    Dir/s d.    Dir/b

Ans:a,Correct Answer: Dir/w


Disketts and hard disks are
Options: Direct access devices,    Sequential access devices,    Slower than magnetic tape,    Used only in mainframe computers

Ans:A ,A


Network 206.143.5.0 was assigned to the Acme Company to connect to its ISP. The administrator of Acme would like to configure one router with the commands to access the Internet. Which commands could be configured on the Gateway router to allow Internet access to the entire network? Gateway(config)# ip route 0.0.0.0 0.0.0.0 206.143.5.2 Gateway(config)# router rip Gateway(config-router)# network 206.143.5.0 Gateway(config-router)# network 206.143.5.0 default
Options: 1 only,    3 only,    1, 2 and 4,    1 and 4

Ans:D ,D


. Which is valid statement
Options: A) 1 KB = 1024 Bytes B) 1 MB = 1024 Bytes C) 1 KB = 1000 Bytes D) 1 MB = 1000 Bytes

Ans:A,A


You can show the shortcut menu during the slide show by
Options: a. Clicking the shortcut button on the formatting toolbar b. Right clicking the current slide c. Clicking an icon on the current slide d. a and b

Ans: – B , – B


Which table is a permanent database that has an entry for each terminal symbol.
Options: Terminal table,    Literal table,    Identifier table,    Reductions

Ans:A ,A


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

Ans:D ,D


When a computer is first turned on or restarted, a special type of absolute loader called ____ is executed
Options: Compile and Go loader B. Boot loader C. Bootstrap loader D. Relating loader

Ans:– C ,


. Which of the following devices have a limitation that we can only store information to it but cannot erase or modify it?

Options: A) Floppy Disk B) Hard Disk C) Tape Drive D) CDROM

Ans:D,D


Name of the first guided weapon in the world which used a programmable digital computer:
Options: Sting Ray Torpedo,    Mk 46 Torpedo,    Air-Launched Cruise Missile (ALCM),    Tomahawk Missile

Ans:A,A


An output device that converts data from a binary format in main storage to coded hole patterns punched into a paper tape is
Options: Paper tape punch,    Punched paper tape,    Magnetic disk,    Magnetic tape.

Ans:A ,A


Which of the following is not usually characteristic of upper management decisions?
Options: Decisions require judgment,    Decisions are structured,    Decisions are long range,    Decisions are unpredictable

Ans:D ,D


The fastest type of memory from the following list is
Options: tape,    semiconductor memory,    disk,    bubble memory

Ans:B ,B


A supertype/subtype hierarchy has which of the following features?
Options: Subtypes at the lower lever in the hierarchy inherit attributes only from their immediate supertype.,    Attributes are assigned at the highest logical level.,    Subtypes at the higher lever in the hierarchy inherit attributes only from their immediate subtype.,    Attributes are assigned at the lowest logical level.

Ans:B ,B


Which of the following filename extension suggests that the file is a backup copy of another file?
Options: BAK *,    BAS,    COM,    TXT

Ans:A ,A


In OSI network architecture, the routing is performed by
Options: session layer,    transport layer,    data link layer,    network layer

Ans:D ,D


_____ is the ratio of correct information to the total amount of information produced over a period.
Options: accuracy,    concise,    simulation,    decision

Ans:A ,A


Which of the following refers to a cursor type where changes of any type and from any source are visible?
Options: Forward only,    Static,    Keyset,    Dynamic

Ans:D ,D


What is the default subnet mask for a class B network?
Options: 127.0.01,    255.0.0.0,    255.255.0.0,    255.255.255.0

Ans:C ,C


. You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
Options: a. Clicking b. Right clicking c. Double clicking d. None of the above

Ans:0 – c ,0 – c

www.000webhost.com