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: 9782 | 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:


Trailer labels contain
Options: file identification,    retention period,    both (a) and (b),    neither (a) nor (b)

Ans:D ,D


. Which of the following is the default join between two recordsets?
Options: a. Inner join b. Left outer join c. Right outer join d. Self join

Ans:2 – a ,2 – a


Essential business letter elements include the _____.
Options: a. date line and inside address b. message c. signature block d. all of the above

Ans:– D,– D


In LISP, the function X (x). (2x+l) would be rendered as
Options: (lambda (x) (+(*2 x)l)),    (lambda (x) (+1 (* 2x),    (+ lambda (x) 1 (*2x)),    (* lambda(x) (+2x1)

Ans:A ,A


The data model that is produced from reverse engineering is:
Options: a conceptual model.,    an internal model.,    a logical model.,    None of the above is correct.

Ans:D ,D


8. Which type of command in DOS needs additional files for their execution?
Options: a. Internal commands b. External commands c. Batch commands d. Redirectors

Ans:Correct Answer: b,Correct Answer: b


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


This data type allows alphanumeric characters and special symbols.
Options: a. text b. memo c. auto number d. None of the above

Ans:dash; a,dash; a


. The __________ is the software tool to store or access data.
Options: a. table b. DBMS c. query d. report

Ans:6 – b ,6 – b


CAD/CAM is the inter-relationship between:
Options: manufacturing and marketing,    marketing and design,    engineering and marketing,    engineering and manufacturing

Ans:D ,D


Which protocol is used to send a destination network unknown message back to originating hosts?
Options: TCP,    ARP,    ICMP,    BootP

Ans:C ,C


A front-end processor is
Options: a user computer system,    a processor in a large-scale computer that executes operating system instructions,    a minicomputer that relieves main-frame computers at a computer centre of communications control functions,    preliminary processor of batch jobs.

Ans:C ,C


The working set theory of programming behaviour of processes running within an operating system involves
Options: the collection of pages that a process accesses,    disk scheduling mechanisms,    coalescing holes in memory,    assigning the CPU to processes

Ans:A ,A


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

Ans:D,D


Data scrubbing is which of the following?
Options: A process to reject data from the data warehouse and to create the necessary indexes,    A process to load the data in the data warehouse and to create the necessary indexes,    A process to upgrade the quality of data after it is moved into a data warehouse,    A process to upgrade the quality of data before it is moved into a data warehouse

Ans:D ,D


The ls -l command tells
Options: who the owner of the file is,    the name of the group owner of the file,    how large the file is and when the file was last modified.,    All of the above

Ans:D ,D


What command is used with vi editor to move back to the beginning of a word?
Options: w,    e,    a,    b

Ans:D ,D


Needing to assess the validity of assumed referential integrity constraints on foreign keys is a(n) ________ of normalization.
Options: advantage,    disadvantage,    either an advantage or disadvantage,    neither an advantage nor disadvantage

Ans:D ,D


. What is the function of folder?
Options: a. Save files b. Delete files c. Move files d. All of the above

Ans:1 – d ,1 – d


Devices on one network can communicate with devices on another network via a
Options: file server,    utility server,    printer server,    gateway

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


A hashing scheme is used with
Options: sequential file organization,    direct file organization,    indexed sequential file organization,    partitioned file organization

Ans:B,B


On a systems flowchart, the online manual keeping of input data is identified by using the
Options: online storage symbol,    Online keyboard symbol,    keeping operation symbols,    manual operation symbols

Ans:B ,B


Ctrl + V
Options: a. Paste Texts in the beginning of Document b. Paste Images in the beginning of Document c. Paste Tables at the middle of Document d. None of the above

Ans:–  D,–  D


. If the values in A1 is “MCQ” and B1 is “Questions”, which function will return “MCQ@Questions” in cell C1?
Options: =A1 + “@” + B1 B. =A1 # “@” # B1 C. =A1 & “@” & B1 D. =A1 $ “@” $ B1

Ans:– C ,


A microprogram written as string of 0s and 1s is a 
Options: a . symbolic microinstruction b . binary microinstruction c . symbolic microprogram d . binary microprogram

Ans:8.d,8.d


. Which computers used operating systems by Microsoft?
Options: A) IBM PCs B) Apple/Macintosh PCs C) IBM Compatibles D) Both A & C

Ans:D,D


The system unit of a personal computer typically contains all of the following except:
Options: microprocessor,    disk controller,    serial interface,    modem

Ans:D,D


The name given to the test that determines whether a machine can think is the:
Options: Gaussian test,    McCarthy test,    Turing test,    Boolean test

Ans:C ,C


What are the distinct functions of layer 2 switching that increase available bandwidth on the network? Address learning Routing Forwarding and filtering Creating network loops Loop avoidance IP addressing
Options: 1, 3 and 5,    2, 4 and 6,    2 and 6,    3 and 5

Ans:A ,A


What will be the output of the program ? #include<stdio.h> int main() { enum status {pass, fail, absent}; enum status stud1, stud2, stud3; stud1 = pass; stud2 = absent; stud3 = fail; printf("%d %d %d\n", stud1, stud2, stud3); return 0; }
Options: 0, 1, 2,    1, 2, 3,    0, 2, 1,    1, 3, 2

Ans:C ,C


Which of the following statements is not true
Options: A structured chart is a sequential representation of program design,    the Real-Time system is a particular case of a on-line-system,    Batch totals are not incorporated while designing real-time applications,    4GLs are used for application proto typing

Ans:A ,A


Which of the following is not a basic element within the microprocessor?
Options: microcontroller,    arithmetic-logic unit (ALU),    temporary register,    accumulator

Ans:A ,A


What is the paper feeding technology most commonly associated with dot-matrix printers?
Options: sheet feed,    tractor feed,    friction feed,    manual feed

Ans:B ,B


You're on your PC at midnight and an electric storm pops up. What's the best way to protect your PC.
Options: you don't worry; you have a lightning rod on your house,    you don't worry; you've got a surge protector on your PC,    you don't worry; you've got a surge protector on your PC and phone line to your modem,    unplug the PC and remove phone line from the modem

Ans:D ,D


To exit from the Resume Wizard and return to the document window without creating a resume , click the _____ button in any panel in the Resume Wizard dialog box.
Options: a. Cancel b. Back c. Next d. Finish

Ans:– D,– D


The database language that allows you to access or maintain data in a database
Options: a. DCL b. DML c. DDL d. None of above

Ans:ndash; b,ndash; b


Computer-based controllers:
Options: should be built in a modular fashion wherever possible,    are very difficult to change,    are very flexible,    (a) and (c) above

Ans:D ,D


.   To maintain the perspective (height and width ratio) of an object when resizing, you need to
Options: a. Press and hold the shift key while dragging a corner sizing handle b. Press and hold the alt + ctrl keys while dragging a middle handle c. Drag a corner sizing handle d. A and c

Ans:7 – A ,7 – A


. Pick the one that is used for logical operations or comparisons such as less than equal to or greater than.
Options: A) Arithmetic and Logic Unit B) Control Unit C) Both of above D) None of above

Ans:A,A


A modern electronic computer is a machine that is meant for
Options: A) Doing quick mathematical calculations B) Input, storage, manipulation and outputting of data C) Electronic data processing D) Performing repetitive tasks accurately

Ans:-B,-B


. What is the use of Notes in slides?
Options: a. It will be displays at the time of Slide Presentation b. This is just Note about the slide c. This is just for printing purpose only d. Notes cannot be inserted in Slides

Ans:0 – B ,0 – B


Which of the following is a storage device?
Options: Tape B. Hard Disk C. Floppy Disk D. All of the above

Ans:– D ,


What Is a process variable?
Options: A manipulated variable,    A controlled variable,    A process parameter that changes value,    All of the above

Ans:D ,D


Off-line operation is the operation of devices without the control of
Options: Memory,    CPU,    ALU,    Control unit

Ans:B,B


. Which of the following commands should you always use before submitting a document to others?
Options: a. find command b. Replace command c. Spelling and Grammar d. Thesaurus

Ans:–  C,–  C


. The first electronic general purpose digital computer built by Eckert and Mauchly called ENIAC did not work on the stored program concept. How many numbers could it store in its internal memory?
Options: A) 100 B) 20 C) 40 D) 80

Ans:B,B


. This task pane shows the design that is currently being used in a presentation.
Options: a. Slide Show b. Slide Style c. Slide Design d. Slide Format

Ans:8 – C ,8 – C


Instructions and memory address are represented by
Options: A) Character code B) Binary codes C) Binary word D) Parity bit

Ans:-B,-B


How many non-overlapping channels are available with 802.11g?
Options: 3,    12,    23,    40

Ans:A ,A

www.000webhost.com