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


An enterprise database is which of the following?
Options: A database designed to support only users external to an organization,    A database designed to support an entire organization,    A database designed to support a relatively small group,    A database designed to support a single PC

Ans:B ,B


The command used to compare the files is known as
Options: comp,    cmp,    do,    ccp

Ans:B ,B


Reverse video is a technique of
Options: showing data with half brightness,    showing data upside down on the screen,    hiding confidential data on the screen,    emphasizing data by reversing the foreground and background

Ans:D ,D


The keyword used to transfer control from a function back to the calling function is
Options: switch,    goto,    go back,    return

Ans:D ,D


Without using the mouse or the arrow keys, what is the fastest way of getting to cell A1 in a spreadsheet?
Options: a. Press Ctrl +Home b. Press Home c. Press Shift + Home d. Press Alt + Home

Ans:#8211; a,#8211; a


In which phase of the laser printing process is a positive charge placed on the paper to pull the toner from the print drum?
Options: Writing,    Transferring,    Conditioning,    All of the above

Ans:B ,B


Which of the following is separated by a subnet mask?
Options: DHCP scopes,    Network ID and host ID,    Domains,    Subnets

Ans:B ,B


. What type of relationship is created when you select a primary key in both related tables?
Options: a. One-To-One b. Indeterminate c. One-To-Many d. Many-To-Many

Ans:7 – a ,7 – a


Input/output function prototypes and macros are defined in which header file?
Options: conio.h,    stdlib.h,    stdio.h,    dos.h

Ans:C ,C


Which of the following is used when a company goes outside its organization to develop a new system?
Options: data flow diagram,    systems flowchart,    project dictionary,    request for proposal

Ans:D ,D


. The ability of an operating system to control the activities of multiple program at the same time is called
Options: a. Multitasking b. Multiprocessing c. Multioperating d. Multipaging

Ans:3 – a ,3 – a


What will be the output of the program ? #include<stdio.h> void fun(int **p); int main() { int a[3][4] = {1, 2, 3, 4, 4, 3, 2, 8, 7, 8, 9, 0}; int *ptr; ptr = &a[0][0]; fun(&ptr); return 0; } void fun(int **p) { printf("%d\n", **p); }
Options: 1,    2,    3,    4

Ans:A ,A


If the current gain is 200 and the collector current is 100 mA, the base current is
Options: 2 mA,    0.5 mA,    2 A,    200 A

Ans:B ,B


. The memory which is programmed at the time it is manufactured
Options: A) ROM B) RAM C) PROM D) EPROM

Ans:5-C,5-C


When you ping the loopback address, a packet is sent where?
Options: On the network,    Down through the layers of the IP architecture and then up the layers again,    Across the wire,    through the loopback dongle

Ans:B ,B


. Which of the following is correct regarding Underline in MS-Word?
Options: Color of Underline can be change B. Style of Underline can be change C. Underline can be set using by shortcut key D. All of the above

Ans:– D ,


Which of the following is not a relational database?
Options: a . dBase IV b. 4th Dimension c. FoxPro d. Reflex

Ans:.d,.d


People often call ______ as the brain of computer system
Options: A) Control Unit B) Arithmetic Logic Unit C) Central Processing Unit D) Storage Unit

Ans:-C,-C


Voltage is
Options: The flow of charged particles through a material,    The smallest electrically charged particle,    Trie force that causes electrons to flow,    The number of free electrons in an atom

Ans:C ,C


. In Word, the default alignment for paragraphs is _____.
Options: a. left-aligned, or flush margins at the left edge and uneven edges at the right edge b. centered, or equidistant from both the left edge and the right edge c. right-aligned, or flush margins at the right edge and uneven edges at the left edge d. justified, or flush margins at both the left and right edges

Ans:– A,– A


What is the shortcut key for “Font ” dialog box?
Options: Ctrl + F B. Ctrl + D C. Ctrl + G D. None of the above

Ans:– B ,


A __________ enables you to view data from a table based on a specific criterion
Options: a. Form b. Query c. Macro d. Report

Ans:ndash; b,ndash; b


Determine the resistance value and tolerance of a resistor that has the following color bands; first band is red, second band is red, third band is orange, and the fourth band is gold
Options: 220 Ohm, 5%,    220 Ohm, 10%,    22,000 Ohm, 5%,    22, 000 Ohm, 10%

Ans:C ,C


The model base contains programs
Options: written by the firm's programmers,    provided by the computer vendor,    purchased from outside firms, such as software houses,    All of the above

Ans:D ,D


What will be the output of the program in 16 bit platform (Turbo C under DOS) ? #include<stdio.h> int main() { struct value { int bit1:1; int bit3:4; int bit4:4; }bit; printf("%d\n", sizeof(bit)); return 0; }
Options: 1,    2,    4,    9

Ans:B ,B


What SQL command can be used to delete columns from a table?
Options: MODIFY TABLE TableName DROP COLUMN ColumnName,    MODIFY TABLE TableName DROP ColumnName,    ALTER TABLE TableName DROP COLUMN ColumnName,    ALTER TABLE TableName DROP ColumnName

Ans:C ,C


A translator which reads an entire programme written in a high level language and converts it into machine language code is:
Options: assembler,    translator,    compiler,    system software

Ans:C ,C


Data item characteristics that are important in data management include
Options: punctuation,    language,    spelling,    width

Ans:D ,D


You can jump to the next column by
Options:  A) Clicking with your mouse on the next column, B) Press Alt + Down-arrow, C) Both of above, D) None of Above, 

Ans:-C,-C


When operating below its resonant frequency, a series RLC circuit has the characteristics of a:
Options: series RL circuit,    series RC circuit,    series RLC circuit operated above its resonant frequency,    purely resistive circuit

Ans:B ,B


Which of the following is true about pseudocode
Options: A machine language,    An assembly language,    A high-level language,    All of the above

Ans:E ,E


What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample friday tuesday sunday /* sample.c */ #include<stdio.h> int main(int argc, char *argv[]) { printf("%c", **++argv); return 0; }
Options: s,    f,    sample,    friday

Ans:B ,B


. CAD software is most likely to be used by
Options: a. Web designer b. Engineers c. Project Manager d. Magazine Editor

Ans:0 – b ,0 – b


Which of the following is a secondary memory device?
Options: Keyboard,    Disk,    ALU,    All of the above

Ans:B ,B


. The most popular commercial DBMS.
Options: a. Microsoft SQL Server b. Microsoft Access c. MySQL d. Oracle

Ans:7 – d ,7 – d


. Which of the following series type is not valid for Fill Series dialog box?
Options: a.  Linear b.  Growth c.  Autofill d.  Time

Ans:– d,– d


How many pairs of stations can simultaneously communicate on Ethernet LAN?
Options: 1,    2,    3,    multiple

Ans:A ,A


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 is true when describing an anycast address?
Options: Packets addressed to a unicast address are delivered to a single interface.,    Packets are delivered to all interfaces identified by the address. This is also called one-to-many addresses.,    This address identifies multiple interfaces and the anycast packet is only delivered to one address. This address can also be called one-to-one-of-many.,    These addresses are meant for nonrouting purposes, but they are almost globally unique so it is unlikely they will have an address overlap.

Ans:C ,C


2. Which command is used to see the sub-directory structure of drive?
Options: a. Tree b. List c. Subdir d. Subtree

Ans:Correct Answer: a ,Correct Answer: a


With an IP address set starting with 150, you currently have six offices that you are treating as subnets. Plans are in place to open 10 more offices before the end of the year. What subnet mask should you use to satisfy the needed number of subnets and maximize the number of hosts available at each site?
Options: 192,    224,    240,    248

Ans:D ,D


What will be the output of the program? #include<stdio.h> #define PRINT(i) printf("%d,",i) int main() { int x=2, y=3, z=4; PRINT(x); PRINT(y); PRINT(z); return 0; }
Options: 2, 3, 4,,    2, 2, 2,,    3, 3, 3,,    4, 4, 4,

Ans:A ,A


An excellent linear programming software package for solving large-scale problems is
Options: MIDAS-2,    OPHELIE II,    PDQ/LP,    All of the above

Ans:B ,B


Which of the following items would require you to comply with EPA disposal guidelines?
Options: Keyboard,    System board,    Power supply,    Battery

Ans:D ,D


When you boot a PC and don't hear any beep, this could suggest which of the following?
Options: The monitor is turned off,    Keyboard not plugged in,    Normal PC boot,    Bad or disconnected speaker

Ans:D ,D


. Which of the following is related to fifth generation computers?

Options: A) Knowledge information processing system B) Very large scale integration (VLSI) C) Both of above D) Only b

Ans:A,A


Auto clipart is a feature that
Options: a. Automatically places clipart in your presentation b. Scans your presentation for incorrect spelling in your words on each slide c. Scans your presentation for incorrect spelling in Word Arts objects d. All of above

Ans: – D , – D


Which of the following products was the first to implement true relational algebra in a PC DBMS?
Options: IDMS,    Oracle,    dBase-II,    R:base

Ans:D ,D


The following SQL is which type of join: SELECT CUSTOMER_T. CUSTOMER_ID, ORDER_T. CUSTOMER_ID, NAME, ORDER_ID FROM CUSTOMER_T,ORDER_T WHERE CUSTOMER_T. CUSTOMER_ID = ORDER_T. CUSTOMER_ID
Options: Equi-join,    Natural join,    Outer join,    Cartesian join

Ans:A ,A


Which of the following would not be a major deliverable of the structured systems analysis phase.
Options: data dictionaries,    data flow diagrams,    entity relationship diagrams,    prototype model

Ans:D ,D

www.000webhost.com