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: 13290 | 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 policy replace a page if it is not in the favoured subset of a process's pages?
Options: FIFO,    LRU,    LFU,    Working set

Ans:D ,D


. The key F12 opens a
Options: a. Save As dialog box b. Open dialog box c. Save dialog box d. Close dialog box

Ans:– A,– A


What command is used to print a file?
Options: lp,    pg,    prn,    print

Ans:A ,A


The feature of Word that automatically adjusts the amount of space between certain combination of characters so that an entire word looks more evenly spaced. What is that feature called?
Options:  A) Spacing, B) Scaling, C) Kerning, D) Positioning, 

Ans:-C,-C


. This database has only one table.
Options: a. relational b. large c. flat-file d. DBMS

Ans:8 – c ,8 – c


You have an interface on a router with the IP address of 192.168.192.10/29. Including the router interface, how many hosts can have IP addresses on the LAN attached to the router interface?
Options: 6,    8,    30,    32

Ans:A ,A


The data communication support should include, but is not restricted to
Options: file transfer and transaction processing,    file and database access,    terminal support, electronic mail and voice grams.,    All of the above

Ans:D ,D


The register which holds the address of the location to or from which data are to be transferred is known as
Options: index register,    instruction register,    memory address register,    memory data register

Ans:C ,C


Pick the correct choice for the 8088 CPU.
Options: 16 bit word size, 8 bit data path,    8 bit word size, 8 bit data path,    16 bit word size, 16 bit data path,    4 bit word size, 8 bit data path

Ans:A ,A


. To store your picture in a database requires a(n) __________ field.
Options: a. BLOB b. text c. image d. logical

Ans:3 – a ,3 – a


. Which data type is better to use for storing the price of an item?
Options: a. Text b. AutoNumber c. Number d. Currency

Ans:– d,– d


What are the three options available in Insert >> Picture menu?
Options: a. Clipart, Pictures, Shapes b. Clipart, From File, Shapes c. Clipart, From Files, AutoShapes d. Clipart, Pictures, AutoShapes

Ans: – C , – C


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 is a permanent database in the general model of compiler?
Options: Literal Table,    Identifier Table,    Terminal Table,    Source code

Ans:C ,C


. Ctrl + O
Options: Save Document B. Print Document C. Close Document D. Open Document

Ans:– D ,


Which of the following is required when more than one person uses a central computer at the same time?
Options: terminal,    light pen,    digitizer,    mouse

Ans:A ,A


. Who built the first Mechanical Calculator
Options: Joseph Marie Jacquard B. John Mauchly C. Blaise Pascal D. Howard Aiken

Ans: – C ,


Which memory system is not as a mass memory medium?
Options: semiconductor memory,    magnetic tape,    magnetic disk,    magnetic drum

Ans:A,A


Which best describes a fragmented hard drive:
Options: The platters are bad,    Data files are corrupted,    Clusters of data are damaged,    Files are not stored in consecutive clusters

Ans:D ,D


What Oracle backup and recover file contains user and system data?
Options: Control file,    Datafile,    OnLine ReDo file,    Offline ReDo file

Ans:B ,B


What will be the output of the program? #include<stdio.h> #include<math.h> int main() { printf("%f\n", sqrt(36.0)); return 0; }
Options: 6.0,    6,    6.000000,    Error: Prototype sqrt() not found.

Ans:C ,C


How many types of keys in Database Design?
Options: a. Candidate key b. Primary key c. Foreign key d. All of these

Ans:– d ,


_______ provides a connection-oriented reliable service for sending messages
Options: TCP B. IP C. UDP D. All of the above

Ans:– A ,


. ______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.
Options: a. Design View b. Layout View c. Print Preview d. Report View

Ans:4 – b ,4 – b


.   Press animation effects allows you to
Options: a. Add clip art images to your slides b. Create a custom transition to the next slide c. Show bullet items as they are discussed d. None of above

Ans:3 – C ,3 – C


What is the port number for NNTP?
Options: 119,    80,    79,    70

Ans:A ,A


  Which of the following methods will not enter data in a cell?
Options: Pressing the Esc key B. Pressing an arrow key C. Pressing the tab key D. Clicking the enter button to the formula bar

Ans:– A ,


The earliest device that qualifies as a digital computer is
Options: EDSAC,    Abacus,    ENIAC,    EDVAC

Ans:B ,B


What is the total resistance of a series circuit that contains four resistors having values of 220W, 470W, 1W, and 1.2W?
Options: 692.2 Ohm,    844.5 Ohm,    3890 Ohm,    1234 Ohm

Ans:A ,A


Which language has recently become the de-facto standard for interfacing application programs with relational database system?
Options: Oracle,    SQL,    dBASE,    4GL

Ans:B ,B


The FIFO algorithm
Options: executes first the job that last entered the queue,    executes first the job that first entered the queue,    execute first the job that has been in the queue the longest,    executes first the job with the least processor needs

Ans:B ,B


Poor data administration can lead to which of the following?
Options: A single definition of the same data entity,    Familiarity with existing data,    Missing data elements,    All of the above.

Ans:C ,C


How many types of flow are there in a semiconductor?
Options: 0,    1,    2,    3

Ans:B ,B


. Which of the following is correct full form of BCD?
Options: A) Binary Coded Decimal B) Bit Coded Decimal C) Binary Coded Digit D) Bit Coded Digit

Ans:4-A,4-A


Which printer uses a combination of laser-beam & electro photographic techniques.
Options: Laser printers,    Dot-Matrix,    Line printer,    Daisy wheel

Ans:A,A


Which type of entity is related to two or more associated entities that each contain specialized attributes that apply to some but not all of the instances of the entity?
Options: Supertype entity,    Subtype entity,    Archetype entity,    Instance entity

Ans:A ,A


When configuring is a network interface cards without jumpers or plug and play, what is used to set the IRQs?
Options: DMA,    CMOS,    the OS,    configuration software

Ans:D ,D


Telecommunications networks come in a wide range of speed and capacity capabilities. Select the best fit for answer:
Options: Bandwidth alternatives,    Switching alternating,    Inter organizational networks,    Extranets

Ans:A ,A


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

Ans:4 – B ,4 – B


An ODBC data structure that identifies a database and the DBMS that processes it is called a(n):
Options: data source.,    driver manager.,    driver.,    API.

Ans:A ,A


A memory bus is mainly used for communication between
Options: processor and memory,    processor and I/O devices,    I/O devices and memory,    input device and output device

Ans:A ,A


Which of the following persons probably has the least amount of technical knowledge?
Options: User,    Computer Operator,    System Analyst,    Programmer

Ans:A ,A


Repeaters are often used on an 802.3 network to help strengthen the signals being transmitted. As with the length of segments and the number of segments, a limit exists as to how many repeaters can be used between any two nodes. What is the maximum number of repeaters that can be used?
Options: Five,    Two,    Four,    Six

Ans:C ,C


What will be the output of the program? #include<stdio.h> int main() { float a=0.7; if(a < 0.7) printf("C\n"); else printf("C++\n"); return 0; }
Options: C,    C++,    Compiler error,    Non of above

Ans:A ,A


Which of the following products implemented the CODASYL DBTG model?
Options: IDMS,    DB2,    dBase-II,    R:base

Ans:A ,A


. Find can be used to
Options: a. Locate a program b. Locate a document c. Locate a network computer d. All of above

Ans:7 – d ,7 – d


The desirable characteristic(s) of a memory system is (are)
Options: speed and reliability,    low power consumption,    durability and compactness,    All of the above

Ans:D ,D


The computer can potentially be used to monitor most of our actions, thus robbing us of _____
Options: tapping,    privacy,    back log,    security

Ans:B ,B


Which of the following is the correct order of evaluation for the below expression? z = x + y * z / 4 % 2 - 1
Options: * / % + - =,    = * / % + -,    / * % - + =,    * % / - + =

Ans:A ,A


. What will be the output of command prompt $l$p$g
Options: a. C:/> b. <C:> c. C:<> d. None of above

Ans:8 – b ,8 – b

www.000webhost.com