Which area in an Excel window allows entering values and formulas?


Options: Title Bar B. Menu Bar C. Formula Bar D. Standard Tool Bar

Ans:– C ,


Description: mcqquestions

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

Hits Today: 9543 | 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 of the following syntax is correct regarding to SUM function in Excel?
Options: =SUM (A1, B1) B. =SUM (A1:B9) C. =SUM (A1:A9, B1:B9) D. All of the above

Ans:– D ,


Which bus is bidirectional?
Options: data bus,    control bus,    address bus,    multiplexed bus

Ans:A ,A


The purpose of an application program is to
Options: Convert program written in high level language to machine language,    Meet specific user needs,    Allow the operating system to control resources better,    Make off-line equpment run better

Ans:B ,B


. Which of the following is best for quick copy operation?
Options: Copy and Paste B. Windows Clipboard C. Drag and Drop D. Auto Text

Ans: – C ,


What type of join is needed when you wish to include rows that do not have matching values?
Options: Equi-join,    Natural join,    Outer join,    All of the above.

Ans:C ,C


The term "remote job entry" relates to
Options: batch processing,    realtime processing,    transaction processing,    distributed processing

Ans:A ,A


Each entity is represented as a(n):
Options: tuple.,    table.,    attribute.,    file.

Ans:B ,B


In computer based information system (CBIS), DFD stands for:
Options: data flow diagram,    data flow descent,    dotted flow diagram,    such a terminology does not exist in CBIS

Ans:A ,A


The addition of _____ can reduce processing time.
Options: A buffer,    An EPROM,    A converter,    A co-processor

Ans:D ,D


A Decision - Table is
Options: a way of representing the information flow,    a way of representing multiple conditions,    a ways to get an accurate picture of the system,    All of the above

Ans:B ,B


. The instructions for starting the computer are house on
Options: A) Random access memory B) CD-Rom C) Read only memory chip D) All of above

Ans:7-C,7-C


Which technique is being investigated as an approach to automatic programming?
Options: generative CAI,    specification by example,    All of the above,    non-hierarchical planning

Ans:B ,B


The DBMS that is most difficult to use is ________ .
Options: Microsoft's SQL Server,    Microsoft's Access,    IBM's DB2,    Oracle Corporation's Oracle

Ans:D ,D


57. To move the cursor page to page of document
Options: a. Ctrl+PgDn b. Ctrl+PgUp c. Both of above d. None of above

Ans:– C ,– C


The value of each bead in heaven is
Options: A) 1 B) 3 C) 5 D) 7

Ans:-C,-C


The second set of the three permissions (r-) indicates that
Options: group has read permission only,    other has read permission only,    owner has read permission only,    group has write permission only

Ans:A ,A


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


If gross requirements are 2,000, inventory on hand is 3,000, reorder point is 500, and EOQ is 1,300, the order quantity is
Options: 3,000,    2,000,    7,000,    zero

Ans:D ,D


A data dictionary doesn't provide information about:
Options: where data is located,    the size of the disk storage device,    It allows a many-to-many relationship,    It is conceptually simple

Ans:B ,B


In the following program how long will the for loop get executed? #include<stdio.h> int main() { int i=5; for(;scanf("%s", &i); printf("%d\n", i)); return 0; }
Options: The for loop would not get executed at all,    The for loop would get executed only once,    The for loop would get executed 5 times,    The for loop would get executed infinite times

Ans:D ,D


. A kind of serial dot-matrix printer that forms characters with magnetically-charged ink sprayed dots is called
Options: A) Laser printer B) Ink-jet printer C) Drum printer D) Chan printer

Ans:B,B


. Which command is not an internal command?
Options: a. Dir b. Edit c. CD d. CLS

Ans:2 – b ,2 – b


Which command-line tool is included with every Microsoft TCP/IP client?
Options: DHCP,    WINS,    PING,    WINIPCFG

Ans:C ,C


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


. Computer system comprises of major units
Options: A) input unit, output unit, control unit B) input unit, output unit, control unit and storage C) input unit, output unit, central processing unit and storage unit D) input, output and storage units

Ans:C,C


Storage capacity of magnetic disk depends on
Options: A) tracks per inch of surface B) bits per inch of tracks C) disk pack in disk surface D) All of above

Ans:D,D


In SQL, which command is used to create a database user?
Options: ADD USER TO DATABASE,    MK USER,    CREATE USER,    All of the above

Ans:C ,C


Which type of processing that produces output results immediately after input data are entered into a computer system
Options: Time-sharing,    Interactive,    Batch processing,    Real-time processing

Ans:B ,B


The language that the computer can understand and execute is called
Options: Machine language,    Application software,    System program,    All of the above

Ans:A ,A


After a table has been created, its structure can be modified using the SQL command:
Options: UPDATE TABLE [TableName].,    MODIFY TABLE [TableName].,    ALTER TABLE [TableName].,    CHANGE TABLE [TableName].

Ans:C ,C


What type of RJ45 UTP cable do you use to connect a PC's COM port to a router or switch console port?
Options: Straight-through,    Crossover cable,    Crossover with a CSU/DSU,    Rolled

Ans:D ,D


Mistakes made in the system analysis stage show up in :
Options: implementation,    system design,    system developments,    All of the above

Ans:A ,A


_____ assist traditional auditors both in the review of computer controls and in the production of audit information through the use of computers.
Options: CDP,    CISA,    DPMA,    EDP auditor

Ans:D ,D


. Which report section only prints one time at the end of the report?
Options: a. Report Header b. Page Header c. Report Footer d. Page Footer

Ans:6 – c ,6 – c


Which of the following function key activates the speller?
Options:  A) F5, B) F7, C) F9, D) Shift + F7,

Ans:-B,-B


Which one of the following devices is most often used for measuring opposition to current flow in a circuit?
Options: Ammeter,    Voltmeter,    Ohmmeter,    Wattmeter

Ans:C ,C


Which of the following is a disadvantage of replication?
Options: Reduced network traffic,    If the database fails at one site, a copy can be located at another site.,    Each site must have the same storage capacity.,    Each transaction may proceed without coordination across the network.

Ans:C ,C


Filename extensions help identify certain files. What filename extension identifies executable files?
Options: INF,    PRO,    EXE,    SYS

Ans:C ,C


. Which of the following queries can create a table?
Options: a. Append b. Delete c. Make-Table d. Update

Ans:7 – c ,7 – c


The saturation point is approximately the same as
Options: cutoff point,    lower end of the load line,    upper end of the load line,    infinity

Ans:C ,C


A composite attribute is which of the following?
Options: An attribute that can be broken into components,    An attribute that cannot be broken into components,    Multiple attributes,    An identifier

Ans:A ,A


“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


Who is called the "grand father" of the computer?
Options: Blaise Pascal,    Charles Babbage,    Joseph Jacquard,    Dr. Herman Hollerith

Ans:B ,B


A diode is in series with 220W. If the voltage across the resister is 4V, what is the current through the diode?
Options: 55 A,    55.86 A,    18.2 mA,    16.3 mA

Ans:C ,C


Which of the following is not a characteristic of a system
Options: operates for some purpose,    has homogeneous components,    has interacting components,    operates within a boundary

Ans:B ,B


All Operating Systems get their total memory initialized from?
Options: CPU,    BIOS,    ROM,    RAM

Ans:B ,B


Link encryption
Options: is more secure than end-to-end encryption,    is less secure than end-to-end encryption,    can not be used in a public network,    is used only to debug

Ans:B ,B


One of the major benefits of using CAD in tool design is that:
Options: product design represents approximately one-half the engineering costs,    tool motions can be checked to see if there is interference between the tool and the object,    there is better coordination in the materials-handling area,    it simplifies the trial-and-error method

Ans:B ,B


A single packet on a data link is known as
Options: Path,    Frame,    Block,    Group

Ans:B,(Banswer


Natural language processing can be divided into the two subfields of:
Options: context and expectations,    generation and understanding,    semantics of pragmatics,    recognition and synthesis

Ans:B ,B

www.000webhost.com