. Which function is used to calculate depreciation, rates of return, future values and loan payment amounts?


Options: Logical B. Math & Trigonometry C. Statistical D. Financial

Ans: – D ,


Description: mcqquestions

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

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


Which scheduler selects which processes should be brought into the ready queue?
Options: Real-term B. Long-term C. Mid-term D. Short-term

Ans:– B ,


Which of the following characteristic(s) is/are suited to the PSS applications?
Options: bursty traffic and low communications intensity,    widely dispersed terminals and access to international packets switched services,    Multiple remote host or applications accessed by a single local access circuit terminal and circuit,    All of the above

Ans:D ,D


A stand-alone system which produces one page of printed output at a time is
Options: Page printer,    Line printer,    Laser printer,    Dot matrix printer

Ans:A,(Aanswer


Operating system is also known as:
Options: a.database b. system software c. hardware d. printer

Ans:2 b.        ,2 b.       


You should save your computer from?
Options: a. Viruses b. Time bombs c. Worms d. All of the above

Ans:d,d


. It is an association established between common
Options: a. Line b. Relationship c. Primary key d. Records

Ans:0 – b ,0 – b


You get a call from a network administrator who tells you that he typed the following into his router: Router(config)#router ospf 1 Router(config-router)#network 10.0.0.0 255.0.0.0 area 0 He tells you he still can't see any routes in the routing table. What configuration error did the administrator make?
Options: The wildcard mask is incorrect.,    The OSPF area is wrong.,    The OSPF Process ID is incorrect.,    The AS configuration is wrong.

Ans:A ,A


. A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?
Options: a. 1 b. ? c. r d. None

Ans:5 – d ,5 – d


. We can replace a font on all sides with another font using the option :
Options: a. Edit –> Fonts b. Tools –> Fonts c. Tools -> Replace Fonts d. Format -> Replace Fonts

Ans:1 – D ,1 – D


Which is not the function of “Edit, Clear” command?
Options: a. Delete contents, B. Delete notes, C. Delete cells, D. Delete formats

Ans:C ,Delete cells


Convert the 11014B machine language instructions into assembly language, assuming that they were not generated by pseudo-ops:
Options: ASRA,    LOADA h#OD4E, i,    STOREA h#014B, d,    ADDA h#01FE, i

Ans:C ,C


A single transistor can be used to build which of the following digital logic gates?
Options: AND gates,    OR gates,    NOT gates,    NAND gates

Ans:C ,C


. Analog computer works on the supply of
Options: A) Continuous electrical pulses B) Electrical pulses but not continuous C) Magnetic strength D) None of the above

Ans:A,A


Uniform Symbols Table
Options: contains all constants in the program,    a permanent table of decision rules in the form of patterns for matching with the uniform symbol table to discover syntactic structure.,    consists of a full or partial list of the token's as they appear in the program. Created by Lexical analysis and used for syntax analysis and interpretation,    a permanent table which lists all key words and special symbols of the language in symbolic form.

Ans:C ,C


. in MS Access, AutoNumber Data Type
Options: a. Can be Sequential b. Can be Random c. Can be Edited d. Only A & B

Ans:– d,– d


Which of the following data structure cant store the non-homogeneous data elements?
Options: a. Arrays b. Records c. Pointers d. None  

Ans:a,a


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


What is the maximum distance with maximum data rate for 802.11g?
Options: About 65-75 feet,    About 90-100 feet,    About 150 feet,    Over 200 feet

Ans:B ,B


Latches constructed with NOR and NAND gates tend to remain in the latched condition due to which configuration feature?
Options: asynchronous operation,    low input voltages,    gate impedance,    cross coupling

Ans:D ,D


The equation for the output frequency of a 555 timer operating in the astable mode is: . What value of C1 will be required if R1 = 1 k, R2 = 1 k, and f = 1 kHz?
Options: 0.33 F,    0.48 F,    480 F,    33 nF

Ans:B ,B


The PATH command is usually found as part of your _____ file.
Options: CONFIG.SYS,    CONFIG.BAT,    AUTOEXEC.SYS,    AUTOEXEC.BAT

Ans:D ,D


File record length
Options: should always be fixed,    Should always be variable,    depends upon the size of the file,    should be chosen to match the data characteristics

Ans:D ,D


. Cursor is a ____
Options: A) Pixel B) Thin blinking line C) Pointing device D) None of these

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 option can be used to create a new slide show with the current slides but presented in a different order?
Options: Rehearsal B. Custom Slide show C. Slide Show Setup D. Slide Show View

Ans:– B ,


Which of the following high speed non¬impact printers are fast enough to print the entire book in about 1 minute.
Options: Laser,    Dot-matrix,    Page,    Line

Ans:C ,C


MSD exe does not have information on:
Options: cache,    video,    operation system,    com ports

Ans:A ,A


Suppose that you have a customer who has a central HQ and six branch offices. They anticipate adding six more branches in the near future. They wish to implement a WAN technology that will allow the branches to economically connect to HQ and you have no free ports on the HQ router. Which of the following would you recommend?
Options: PPP,    HDLC,    Frame Relay,    ISDN

Ans:C ,C


. What are the computers called that performs calculations and comparisons usually in the binary numbering system?
Options: A) Analog Computers B) Digital Computers C) Hybrid Computers D) None of above

Ans:B,B


. As compared to diskettes, the hard disks are
Options: A) More expensive B) More portable C) Less rigid D) Slowly accessed

Ans:4-A,4-A


The peak value of a sine waveform is:
Options: the amplitude at 70.7% of the maximum value,    the amplitude at 90% of the maximum value,    the amplitude at 1.41 times the maximum value,    the maximum positive or negative value

Ans:D ,D


Filename extensions help identify certain files. What filename extension identifies command files?
Options: COM,    BAT,    EXE,    SYS

Ans:A ,A


Multiprogramming systems:
Options: are easier to develop than single programming system,    execute each job faster,    execute more jobs in the same time period,    are used only on large mainframe computers

Ans:C ,C


What does the acronym RTS represent?
Options: Required to save,    Ready to start,    Request to send,    Right to separate

Ans:C ,C


Different components on the motherboard of a PC processor unit are linked together by sets of parallel electrical conducting lines. What are these lines called?
Options: Conductors,    Buses,    Connectors,    Connectively

Ans:B,B


What command is used to display a file contents in octal form?
Options: oct,    of,    od,    cd

Ans:C ,C


In a file contains the line "I am a boy\r\n" then on reading this line into the array str using fgets(). What will str contain?
Options: "I am a boy\r\n\0",    "I am a boy\r\0",    "I am a boy\n\0",    "I am a boy"

Ans:C ,C


What do you call the translator which takes assembly language program as input & produce machine language code as output?
Options:  Compiler B.  Interpreter C.  Debugger D.  Assembler

Ans:– D ,


. … are list of commands that appear on the screen
Options: a. GUIS b. Icons c. Menus d. Windows

Ans:6 – c ,6 – c


Which of the following is not true about documentation?
Options: Documentation, of a system, should be as clear and direct as possible,    Documentation increases the maintenance time and cost,    Documentation gives better understanding of the problem,    All of the above

Ans:B ,B


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


Number of bits per symbol used in Baudot code is
Options: 1,    5,    8,    9

Ans:B ,B


. To display hidden files
Options: a. Dir/hidden b. Attrib/ah c. Dir/ah d. None of above

Ans:1 – c ,1 – c


What will be the output of the program in Turbo C? #include<stdio.h> int main(int argc, char *argv, char *env[]) { int i; for(i=1; i<argc; i++) printf("%s\n", env[i]); return 0; }
Options: List of all environment variables,    List of all command-line arguments,    count of command-line arguments,    Error: cannot have more than two arguments in main()

Ans:A ,A


An input device that is able to interpret pencil marks on paper media is known as
Options: Magnetic disk,    Optical Mark Reader,    Card Puncher,    Magnetic tape

Ans:B ,B


The microelectronics is the technology of
Options: microwaves,    microcomputers,    chips,    automatic processing

Ans:C ,C


As compared to diskettes, the hard disks are
Options: more expensive,    more portable,    less rigid,    slowly accessed

Ans:A ,A


In memory systems, boundary registers
Options: are used for temporary program variable storage,    are only necessary with fixed partitions,    track page boundaries,    track the beginning and ending of programs

Ans:D ,D


. If 4/6 entered in a cell without applying any formats, Excel will treat this as
Options: Fraction B. Number C. Text D. Date

Ans:– D ,


What does Router do in a network?
Options: Forwards a packet to all outgoing links B. Forwards a packet to the next free outgoing link C. Determines on which outing link a packet is to be forwarded D. Forwards a packet to all outgoing links except the originated link

Ans:– C ,

www.000webhost.com