The first cell in EXCEL worksheet is labeled as


Options: AA B. A1 C. Aa D. A0

Ans:– B ,


Description: mcqquestions

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

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


You can create a new presentation by completing all of the following except
Options: a. Clicking the new button on the standard toolbar b. Clicking file, new c. Clicking file open d. Pressing ctrl + N

Ans: – C , – C


. What value will display if the formula = “$55.00″+5 is entered into a cell?
Options: a. $60 b. 60 c. “$55.00″+5 d. $60.00

Ans:– b,– b


In Word, the mailing list is known as the ____________.
Options:  A) Data sheet, B) Source, C) Data source, D) Sheet,

Ans:-C,-C


A language which is close to that used within the computer is
Options: High-level language,    Assembly language,    Low-level language,    All of the above

Ans:C,(Canswer


To insert slide numbers
Options: a. Insert a text box and select Insert >> Page Number b. Insert a textbox and select Insert >> Number >> PageNumber c. Choose Insert >> Slide Number d. Insert a new text box and select Insert >> slide Number

Ans: – D , – D


Which of the following tool enables you to add text to a slide without using the standard placeholders?
Options: a. Text tool box b. Line tool c. Drawing tool d. Auto shapes tool

Ans: – A , – A


What process prepares the magnetic surface of a disk by creating concentric circles, called tracks, around the disk? (Each track is further divided into pic-shaped sections called sectors.)
Options: Tracking,    Formatting,    Copying,    Sectioning

Ans:B ,B


The SQL WHERE clause:
Options: limits the column data that are returned.,    limits the row data are returned.,    Both A and B are correct.,    Neither A nor B are correct.

Ans:B ,B


Who invented the first junction transistor?
Options: Smith,    Gomes,    Fisher,    Shockley

Ans:D ,D


Individuals who intend to pursue a career as an information-system manager should have:
Options: technical expertise in information systems,    human-relations skills,    ability to communicate in written form,    two of the above

Ans:E ,E


Elapsed time, between initiating a query and receiving a response is called
Options: response time,    waiting time,    processing time,    Turnaround time

Ans:D ,D


The most common input device used today is
Options: Motherboard,    Track ball,    Scanner,    Mouse

Ans:A,Motherboard


. Which of the following is suitable after you install new drivers?
Options: a. Shut Down b. Restart c. Sleep d. Hibernate

Ans: b, b


. What is the process of eliminating redundant fields by separating data into tables called?
Options: a. Renormalizations b. Filtering c. Normalization d. Sorting

Ans:4 – c ,4 – c


To define what columns should be displayed in an SQL SELECT statement:
Options: use FROM to name the source table(s) and list the columns to be shown after SELECT.,    use USING to name the source table(s) and list the columns to be shown after SELECT.,    use SELECT to name the source table(s) and list the columns to be shown after USING.,    use USING to name the source table(s) and list the columns to be shown after WHERE.

Ans:A ,A


. when working in the page break preview, you can
Options: a. view exactly where each page break occurs b. add or remove page breaks c. change the print area d. all of above

Ans:– d,– d


Today’s computer giant IBM was earlier known by different name which was changes in 1924. What was that name?
Options: A) Tabulator Machine Co. B) Computing Tabulating Recording Co. C) The Tabulator Ltd. D) International Computer Ltd.

Ans:-B,-B


While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
Options: a. a doctor’s sign b. thin + sign c. outline rectangle d. None of above

Ans:ndash; c,ndash; c


On a leased line installation a known good external modem shows no carrier detect light. Where is the problem most likely to be?
Options: In the modem,    In the phone line,    In the computer,    In the DTC equipment

Ans:B ,B


. Which is the latest version of MS Windows?
Options: a. Windows 2007 b. Windows 8.1 c. Windows 2008 d.Windows 7

Ans: b, b


A device that converts one type of signal into another is called
Options: Modem,    Transducer,    Punched paper tape,    Punched card

Ans:B ,B


Which three statements are true about the operation of a full-duplex Ethernet network? There are no collisions in full-duplex mode. A dedicated switch port is required for each full-duplex node. Ethernet hub ports are preconfigured for full-duplex mode. In a full-duplex environment, the host network card must check for the availability of the network media before transmitting. The host network card and the switch port must be capable of operating in full-duplex mode.
Options: 1, 2, and 5,    2 and 4,    2, 3 and 4,    5 only

Ans:A ,A


. WAN is a most used abbreviation in Newtorking, what is its full form?
Options: A) WAP Area Network B) Wide Area Network C) Wide Array of Network D) Wireless Access Network

Ans:B,B


. Which of the following is not available on the Ruler of MS Word screen?
Options: a. Tab stop box b. Left Indent c. Right Indent d. Center Indent

Ans:– D,– D


. Which command is used to open the directory?
Options: a. Open b. Chdir c. Move d. All of above

Ans:2 – b ,2 – b


Which of the following enables you to paste data multiple times?
Options: Windows Clipboard B. Office Clipboard C. Both Windows & Office Clipboard D. None of the all

Ans:– C ,


Excel displays the current cell address in the ……….
Options: Formula bar B. Status Bar C. Name Box D. Title Bar

Ans:– C ,


The complexity of the average case of an algorithm is
Options: a. Much more complicated to analyze than that of worst case b. Much more simpler to analyze than that of worst case c. Sometimes more complicated and some other times simpler than that of worst case d. None or above  

Ans:a,a


A database management system (DBMS) is a:
Options: hardware system used to create, maintain, and provide controlled access to a database.,    hardware system used to create, maintain, and provide uncontrolled access to a database.,    software system used to create, maintain, and provide controlled access to a database.,    software system used to create, maintain, and provide uncontrolled access to a database.

Ans:C ,C


Which of the following scheduling objectives should be applied to the following: the system should admit jobs to create a mix that will keep most devices busy
Options: to be fair,    to balance resource utilization,    to obey priorities,    to be predictable

Ans:B ,B


What is the name given to the weapons which use computerised guidance system?
Options: Guided weapons,    Smart weapons,    Dumb weapons,    Starwars weapons

Ans:B,Smart weapons


. To access properties of an object, the mouse technique to use is __________.
Options: a. dragging b. dropping c. right-clicking d. shift-clicking

Ans:6 – c ,6 – c


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

Ans:D,D


Page stealing
Options: is a sign of an efficient system,    is taking page frames from other working sets,    should be the tuning goal,    is taking larger disk spaces for pages paged out

Ans:B ,B


The traditional way to exit and LISP system is to enter
Options: quit,    exit,    bye,    ok

Ans:B ,B


The systems have been classified in different ways
Options: physical or abstract,    open or closed,    man-made information system,    All of the above

Ans:D ,D


Which file executes commands in DOS?
Options: MS-DOS.SYS,    CONFIG.SYS,    COMMAND.COM,    SYSTEM.INI

Ans:C ,C


The process of reading a database schema and producing a data model from that schema is known as:
Options: data modeling.,    database design.,    reverse engineering.,    None of the above is correct.

Ans:C ,C


Maximum length of DOS command using any optional parameter is
Options: a. 26 characters b. 87 characters c. 127 characters d. None of above

Ans:Correct Answer: c ,Correct Answer: c


What will be the output of the program ? #include<stdio.h> int main() { union a { int i; char ch[2]; }; union a u; u.ch[0]=3; u.ch[1]=2; printf("%d, %d, %d\n", u.ch[0], u.ch[1], u.i); return 0; }
Options: 3, 2, 515,    515, 2, 3,    3, 2, 5,    515, 515, 4

Ans:A ,A


What is the maximum distance running the lowest data rate for 802.11b?
Options: About 100 feet,    About 175 feet,    About 300 feet,    About 350 feet

Ans:D ,D


Sensors:
Options: are easily developed,    probably will not improve over the next decade,    are not important in automation,    will be much smarter and more sophisticated in the future

Ans:D ,D


When mapping a regular entity into a relation which of the following is true?
Options: One relation is created.,    Two relations are created.,    Three relations are created.,    Four relations are created.

Ans:A ,A


An integrated circuit is
Options: a complicated circuit,    an integrating device,    much costlier than a single transistor,    fabricated on a tiny silicon chip

Ans:D,D


47. If you want to convert a symbol or several lines of text into an AutoCorrect entry, you should:
Options: a. Insert the symbol or type the text in a Word document first. Then, select the text or symbol and go to the AutoCorrect dialog box. b. Click the Tools menu and choose AutoCorrect Options. Then, click the Insert menu and choose Symbol (or click the Format menu and choose Paragraph) to add the symbol or paragraph to AutoCorrect. c. AutoCorrect can only accommodate one line of text. It is not possible to convert a symbol or multiple lines of text into an AutoCorrect entry. d. Insert the symbol or type the text in a Word document first. Then, select the text or symbol and click the Edit menu followed by Paste Special. Select New AutoCorrect Entry and then click OK.

Ans:– A ,– A


Binary numbers need more places for counting because:
Options: 0's and 1's can be added in front of them,    0's and 1's have to be properly placed,    They are always big numbers,    Binary base is small

Ans:D,D


Which of the following is true concerning a global transaction?
Options: The required data are at one local site and the distributed DBMS routes requests as necessary.,    The required data are located in at least one nonlocal site and the distributed DBMS routes requests as necessary.,    The required data are at one local site and the distributed DBMS passes the request to only the local DBMS.,    The required data are located in at least one nonlocal site and the distributed DBMS passes the request to only the local DBMS.

Ans:B ,B


A stack pointer is 
Options: a . a 16-bit register in the microprocessor that indicate the beginning of the stack memory. b . a register that decodes and executes 16-bit arithmetic expression. c. The first memory location where a subroutine address is stored. d . a register in which flag bits are stored

Ans:7.a,7.a


After installing a sound card, the system locks up when a parallel port tape backup unit is also used. What is most likely the problem?
Options: IRQ,    DMA,    defective LPT port,    defective tape driver

Ans:A ,A


Which of the following program is not a utility?
Options: Debugger,    Editor,    Spooler,    All of the above

Ans:C ,C

www.000webhost.com