In the formula, which symbol specifies the fixed columns or rows?


Options: $ B. * C. % D. &

Ans:– A ,


Description: mcqquestions

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

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


. Model 5100 was ______ in 1957.
Options: A) The first PC built by IBM B) The first PC built by Apple C) The first PC built by Motorola D) The first PC built by Intel

Ans:A,A


A small film-plate which is used for microfilming the output from a microcomputer screen is called
Options: microfilm,    microfiche,    film card,    COM

Ans:B ,B


What will be the output of the program ? #include<stdio.h> int main() { struct value { int bit1:1; int bit3:4; int bit4:4; }bit={1, 2, 13}; printf("%d, %d, %d\n", bit.bit1, bit.bit3, bit.bit4); return 0; }
Options: 1, 2, 13,    1, 4, 4,    -1, 2, -3,    -1, -2, -13

Ans:C ,C


How many times the while loop will get executed if a short int is 2 byte wide? #include<stdio.h> int main() { int j=1; while(j <= 255) { printf("%c %d\n", j, j); j++; } return 0; }
Options: Infinite times,    255 times,    256 times,    254 times

Ans:B ,B


You are working with a network that has the network ID 192.168.10.0. What subnet should you use that supports up to 25 hosts and a maximum number of subnets?
Options: 255.255.255.192,    255.255.255.224,    255.255.255.240,    255.255.255.248

Ans:B ,B


What type of RJ45 UTP cable is used between switches?
Options: Straight-through,    Crossover cable,    Crossover with a CSU/DSU,    Crossover with a router in between the two switches

Ans:B ,B


. Which of the following statements about option group is incorrect?
Options: a. It is a control object. b. It is bound to two fields. c. It is a control to identify a choice. d. It contains a set of controls representing choices.

Ans:– b,– b


What is an SQL virtual table that is constructed from other tables?
Options: Just another table,    A view,    A relation,    Query results

Ans:B ,B


The four major corporate resources are money, materials, information, and
Options: people,    icons,    information system,    on-line

Ans:A ,A


If the ASCII character H is sent and the character I is received, what type of error is this?
Options: single-bit,    multiple-bit,    burst,    recoverable

Ans:A ,A


. Serial access memories are useful in applications where
Options: A) Data consists of numbers B) Short access time is required C) Each stored word is processed differently D) Data naturally needs to flow in and out in serial form

Ans:2-D,2-D


In which circumstance are multiple copies of the same unicast frame likely to be transmitted in a switched LAN?
Options: During high-traffic periods,    After broken links are reestablished,    When upper-layer protocols require high reliability,    In an improperly implemented redundant topology

Ans:D ,D


Resistance is measured:
Options: in parallel,    in series,    after breaking the circuit,    after checking voltage

Ans:C ,C


Which of the structure is correct? 1 : struct book { char name[10]; float price; int pages; }; 2 : struct aa { char name[10]; float price; int pages; } 3 : struct aa { char name[10]; float price; int pages; }
Options: 1,    2,    3,    All of above

Ans:A ,A


Point out the error in the following program. #include<stdio.h> void display(int (*ff)()); int main() { int show(); int (*f)(); f = show; display(f); return 0; } void display(int (*ff)()) { (*ff)(); } int show() { printf("IndiaBIX"); }
Options: Error: invalid parameter in function display(),    Error: invalid function call f=show;,    No error and prints "IndiaBIX",    No error and prints nothing.

Ans:C ,C


. A command to remove a relation from an SQL database
Options: Delete table <table name> B. Drop table <table name> C. Erase table <table name> D. Alter table <table name>

Ans: – B ,


If a firm wanted to transmit data from 1,000 punched cards to a remote computer, they would use a(n)
Options: POS terminal,    data collection terminal,    batch processing terminal,    intelligent terminal

Ans:C ,C


Which runs on computer hardware and serve as platform for other software to run on?
Options: Operating System B. Application Software C. System Software D. All

Ans:– A ,


Which network is a packet switching network?
Options: Ring network,    LAN,    Star network,    EuroNET

Ans:D ,D


. In Access 2007, to make changes in the Trust Center, you need to go to the ____.
Options: a. Microsoft Office button b. Navigation Pane c. Quick Access toolbar d. Database Tools command tab

Ans:1 – a ,1 – a


What will be the output of the program? #include<stdio.h> #define MAN(x, y) ((x)>(y)) ? (x):(y); int main() { int i=10, j=5, k=0; k = MAN(++i, j++); printf("%d, %d, %d\n", i, j, k); return 0; }
Options: 12, 6, 12,    11, 5, 11,    11, 5, Garbage,    12, 6, Garbage

Ans:A ,A


. In a report, you need to show the monthly rainfall in NepaThe best way to do this is to insert a
Options: a. calendar b. photograph of rainfall c. chart showing rainfall amounts d. database of rainfall

Ans:– c,– c


Header labels contain
Options: creation data,    control totals,    both (a) and (b),    neither (a) nor (b)

Ans:A ,A


How many steps are there between Start and Finish in AutoContent Wizard?
Options: a. 3 b. 4 c. 5 d. 6

Ans: – A , – A


The SQL command to create a table is:
Options: MAKE TABLE.,    ALTER TABLE.,    DEFINE TABLE.,    CREATE TABLE.

Ans:D ,D


The ODBC Level 1 API contains which of the following functions?
Options: Browse possible connections and data sources only,    Connect to data sources with driver-specific information only,    Process a scrollable cursor only,    Both 1 and 3 above are in the OBDC Level 1 API.

Ans:B ,B


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

Ans:- a,- a


The size of the organization chart object
Options: a. Is determined by the presentation design and cannot be changed b. Is determined by the presentation design but can be changed in PowerPoint c. Is dependent on the amount of text within the organization chart d. b and c

Ans: – D , – D


______ is used in operating system to separate mechanism from policy
Options: Single level implementation B. Two level implementation C. Multi level implementation D. None

Ans:– B ,


. Which operating system can you give smallest file name?
Options: a. Ps/2 b. Dos c. Windows d. Windows NT

Ans: b, b


The Management Information system (MIS) structure with one main computer system is called a
Options: hierarchical MIS structure,    distributed MIS structure,    centralized MIS structure,    decentralized MIS structure

Ans:C ,C


To locate a data item for storage is
Options: Field,    Feed,    Database,    Fetch

Ans:D,D


Punched cards were first introduced by
Options: Powers B. Pascal C. Jacquard D. Herman Hollerith

Ans:– D ,


Which of the following is the decimal and hexadecimal equivalents of the binary number 10011101?
Options: 155, 0x9B,    157, 0x9D,    159, 0x9F,    185, 0xB9

Ans:B ,B


. The three parts of an IIF function are separated by _____.
Options: a. dashes b. asterisks c. semicolons d. commas

Ans:8 – d ,8 – d


A _____ is a brief message to an operator that describes what data are to be entered.
Options: prompt,    passwords,    MIS,    Tactical

Ans:A ,A


When connecting two internal SCSI hard disks to a computer, where do you connect the second hard drive?
Options: Any open SCSI port on the computer,    A Serial port on the first host adapter,    An open parallel port on the computer,    An open SCSI port on the first hard drive

Ans:A ,A


. Which command is used to get the current date only?
Options: a. Date b. Time c. Second d. All of the above

Ans:Correct Answer: a ,Correct Answer: a


How can you remove tab stop markers from ruler?
Options:  A) Double click the tab marker and choose Clear All, B) Drag the tab stop marker out of the ruler, C) Right click the tab stop marker and choose remove, D) All of above,

Ans:-B,-B


Which of the following is not a term of MS-Excel?
Options: Cells B. Rows C. Columns D. Document

Ans:– D ,


. Which of the following is called low level languages?

Options: A) Machine language B) Assembly language C) Both of the above D) None of above

Ans:C,C


. To make file in MS Dos we need command
Options: a. Copy b. Copy con c. MD d. Make File

Ans:0 – b ,0 – b


What was the name of the Japanese worker who was killed by an industrial robot at the Akashi plant of Kawasaki Heavy Industries in Japan?
Options: M. Shubhagya,    Harun Shimada,    Kenji Urada,    K. Miceni

Ans:C ,C


. Font folder is located on
Options: a. Program folder b. Ms Word file c. Control Panel folder d. Desktop folder

Ans:0 – c ,0 – c


Which output device is used for translating information from a computer into pictorial form on paper.
Options: Mouse,    Plotter,    Touch panel,    Card punch

Ans:B,(Banswer


Electron current is flowing through a conductor in a direction you might describe as straight into this page. What is the direction of the resulting magnetic field?
Options: Clockwise,    Counterclockwise,    Out of this page,    Into this page

Ans:B ,B


An enterprise data model is:
Options: a graphical model that shows the high-level entities for an organization.,    a graphical model that shows all entities for an organization.,    a non-graphical model that shows the high-level entities for an organization.,    a non-graphical model that shows the all entities for an organization.

Ans:A ,A


One of the main feature that distinguish microprocessors from microcomputers is
Options: words are usually larger in microprocessors,    words are shorter in microprocessors,    microprocessor does not contain I/O devices,    exactly the same as the machine cycle time

Ans:C ,C


. Which of the following is not an advantage of open source operating system over proprietary version?
Options: a. Free to use and distribution b. Availability of technical support c. Availability of source code d. Ability to modify code

Ans:4 – b ,4 – b


What is the default subnet mask for a class A network?
Options: 127.0.0.1,    255.0.0.0,    255.255.255.0.0,    255.255.255.0

Ans:B ,B

www.000webhost.com