To return the remainder after a number is divided by a divisor in EXCEL we use the function?

Options: ROUND ( ) B. FACT ( ) C. MOD ( ) D. DIV ( )

Ans:– C ,

Description: mcqquestions

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

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

The control unit of a microprocessor
Options: stores data in the memory,    accepts input data from a keyboard,    Performs arithmetic / logic / functions,    none of the above

Ans:D,None of the above

The accident file is commonly updated in the
Options: accident and claims data system,    payroll system,    employment control reporting system,    personnel activity reporting system

Ans:A ,A

. If you want to insert some slides from other presentation into current one choose
Options: a.  From Insert menu choose Slides from Files b.  From Insert menu choose Slides from Presentation c.  From Insert menu choose Slides d.  None of above

Ans:6 – A ,6 – A

Your company has a LAN in its downtown office and has now set up a LAN in the manufacturing plant in the suburbs. To enable everyone to share data and resources between the two LANs, what type of device(s) are needed to connect them? Choose the most correct answer.
Options: Modem,    Cable,    Hub,    Router

Ans:D ,D

The central processor of a modern digital computer consists of
Options: control unit,    primary memory,    control unit and primary memory,    All of the above


. Internal commands are
Options: a. Incorporated in the b. Incorporate in the command directory c. Have external files d. All of the above

Ans:0 – a ,0 – a

. Most of the first generation computers were
Options: A) Special purpose computers B) General purpose computers C) Both of above D) None of above


. Whenever you move a directory from one location to another
Options: a. All files inside the directory are moved b. All the subdirectory inside that directoryare moved c. The directory is moved the source file is not moved d. Both a and b

Ans: d, d

An intranet provides which of the following?
Options: Connectivity to all customers,    Connectivity to selected customers,    Connectivity to no customers,    Connectivity to all of the above

Ans:C ,C

An autonomous homogenous environment is which of the following?
Options: The same DBMS is at each node and each DBMS works independently.,    The same DBMS is at each node and a central DBMS coordinates database access.,    A different DBMS is at each node and each DBMS works independently.,    A different DBMS is at each node and a central DBMS coordinates database access.

Ans:A ,A

. On a PC, how much memory is available to application software?
Options: A) 1024 KB B) 760 KB C) 640 KB D) 560 KB


When was the IBM XT microcomputer released in the market?
Options: 1970,    1971,    1987,    1986

Ans:C ,C

What is the impedance of a circuit composed of a 100 ohm resistor connected in parallel with a capacitor that has a reactance of 100 ohm?
Options: 60 Ohm,    99.3 Ohm,    250 Ohm,    70.7Ohm

Ans:D ,D

A network consists of eight NT servers. You are planning to move servers to different segments of your network, what utility should be used at each server to determine which server generates the most traffic?
Options: NBTSTAT,    NETSTAT.EXE,    Performance Monitor,    Network Monitor

Ans:D ,D

When new data are to be inserted into a data structure, but there is no available space; this situation is usually called
Options: a. underflow b. overflow c. housefull d. saturated

Ans:- b,- b

Which of the following set options is used with vi editor to ignore case while searching for patterns?
Options: ic,    ai,    sm,    ts

Ans:A ,A

Which is a device that changes information into digital form?
Options: Modem,    Digitizer,    Mouse,    Light pen


The operating system of a computer serves as a software interface between the user and
Options: hardware,    peripheral,    memory,    screen

Ans:A ,A

The following are functions of a DBMS except ________ .
Options: creating and processing forms,    creating databases,    processing data,    administrating databases

Ans:A ,A

How many class A, B, and C network IDs can exist?
Options: 2,113,658,    16,382,    126,    128

Ans:A ,A

One byte can be used to encode any integer between 'O' and -inclusive
Options: 16,    256,    128,    255

Ans:D ,D

Which of the following are disadvantages of using NAT? Translation introduces switching path delays. Conserves legally registered addresses. Causes loss of end-to-end IP traceability. Increases flexibility when connecting to the Internet. Certain applications will not function with NAT enabled. Reduces address overlap occurrence.
Options: 1, 3 and 5,    3 and 4,    2, 4 and 5,    1 and 3

Ans:A ,A

When the Language bar is _____, it means that you do not see it on the screen but it will be displayed the next time you start your computer.
Options: a. restored b. hidden c. minimized d. closed

Ans:– B,– B

Demodulation is the process of
Options: converting digital signals to analog signals,    converting analog signals to digital signals,    combining many low speed channels into one high speed channel,    dividing the high-speed signals into frequency bands

Ans:B ,B

What is the first stage in software development?
Options: Specification and design B. Testing C. System Analysis D. Maintenance

Ans:– C ,

. Referential integrity means
Options: a. Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table b. Do not enter a value in the primary key field of chield table if that value does not exist in the primary key of the parent table c. Do not enter a value in the foreign key field of a parent table if that value does not exist in the primary key of the child table d. All of above

Ans:1 – a ,1 – a

Which company produces processors for the Apple Macintosh?
Options: IBM,    Motorola,    Intel,    AMD

Ans:B ,B

33. The spike
Options: a. Allows you to combine text from several documents and tehn insert all the text into one document at onwe time b. Allows you to edit auto text entries c. Allows you to format uto text entries d. All of above

Ans:– A ,– A

. Which of the following memory medium is not used as main memory system?
Options: A) Magnetic core B) Semiconductor C) Magnetic tape D) Both semiconductor and magnetic tape


. Which technology is used in Compact disks?
Options: A) Mechanical B) Electrical C) Electro Magnetic D) Laser


. Which is an item of storage medium in the form of circular plate?

Options: A) Disk B) CPU C) Printer D) ALU


It is most common type of query. It retrieves records from one or more tables and then displays the
Options: a. Parameter b. Select c. crosstab d. All of above

Ans:ndash; b,ndash; b

. Which of the following field properties is an expression that specifies criteria or requirements for entering data?
Options: a. Field Size b. Format c. Input Mask d. Validation Rule

Ans:1 – d ,1 – d

When assessing the table structure of an acquired set of tables with data, determining foreign keys is (part of) the:
Options: first step.,    second step.,    third step.,    fourth step.

Ans:B ,B

. Which of the following statements about the Label Wizard is NOT true?
Options: a. Adding groups can help organize the labels. b. It helps users to create package labels. c. It allows users to select a label type and size. d. It allows users to sort the labels.

Ans:8 – a ,8 – a

Functional subsystems are connected by
Options: resource flows,    decision flows,    information flows,    data flows

Ans:A ,A

Command Interpreter is also known as
Options: Prompt B. Shell C. Command D. DOS Prompt

Ans:– B ,

Which of the following TCP/IP protocol is used for remote terminal connection service?
Options: TELNET,    FTP,    RARP,    UDP

Ans:A ,A

Which one of. the following phrases most accurately describes the nature of a pulsating dc voltage?
Options: The voltage remains at one polarity and at a steady level,    The voltage remains at one polarity but changes value periodically,    The voltage causes current to flow in two directions at the same time,    The voltage reverses polarity periodically

Ans:B ,B

. Which of the following data type is used to store logical value in MS Access?
Options: a. True/False b. On/Off c. Yes/No d. All of Above

Ans:– c,– c

Which of the following can be use as slide background?
Options: Gradient B. Texture C. Picture D. All of the Above

Ans:– D ,

First generation computers are characterised by
Options: Vaccum tubes and magnetic drum,    Minicomputers,    Magnetic tape and transistors,    All of the above


What is the name of the earliest calculating machine which was based on concepts found in modern computers but was unfortunately never built?
Options: Babbage's Difference Engine,    Pascal's Adder,    Leibnitz's Multiplier,    Differential Analyser

Ans:A ,A

The model for a _____ resembles the hierarchical model in many respects.
Options: Network database,    Relational database,    Distributed database,    Hierarchical database

Ans:A ,A

What is the purpose of inserting header and footer in document?
Options:  A) To enhance the overall appearance of the document, B) To mark the starting and ending of page, C) To make large document more readable, D) To allow page headers and footers appear on document when printed,


. You can switch from one program to another on the desktop by clicking within the desired program’s window or by clicking on its ….button
Options: a. Icon b. Taskbar button c. Folder d. None of above

Ans:8 – b ,8 – b

. What is the shortcut key to hide entire column?
Options: a. CTRL + − b. CTRL + 0 c. CTRL + H d. CTRL + C

Ans:– b,– b

The CPU is made up of control unit ALU and
Options: Memory,    Input-Output,    Register unit,    All of the above

Ans:A ,A

Computing systems most often facilitate planning because they:
Options: make it possible to take into account many possibilities in an uncertain situation,    make it possible to solve complex problems,    enable an appropriate data processing system to provide answers quickly,    All of the above

Ans:A ,A

. Where can you find the horizontal split bar on MS Word screen?
Options: a. On the left of horizontal scroll bar b. On the right of horizontal scroll bar c. On the top of vertical scroll bar d. On the bottom of vertical scroll bar

Ans:– C,– C