. How to specify cell range from A9 to A99 in Excel?


Options: (A9, A99) B. (A9 to A99) C. (A9 : A99) D. (A9 – A99)

Ans:– C ,


Description: mcqquestions

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

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


. What is the shortcut key to insert new sheet in current workbook?
Options: a. F11 b. Alt + F11 c. Ctrl + F11 d. Shift + F11

Ans:– d,– d


Which of the following are word processing software?
Options:  A) WordPerfect, B) Easy Word, C) MS Word, D) All of above, 

Ans:-D,-D


. In a datasheet, what does each row represent?
Options: a. Record b. Field c. Database d. Table

Ans:– a,– a


Which of the following is the expansion of EBCDIC
Options: Extended bit comparable to digital interface for computer,    Extended bootable computerised digital infrared calculator,    Extended binary coded decimal interchange code,    Extended binary coded decimal information code

Ans:C ,C


Which of the following types of databases are the most common?
Options: Personal,    Workgroup,    Department,    Enterprise

Ans:C ,C


The register which keeps track of the execution of a program and which contains the memory address of the instruction currently being executed is known as
Options: Index register,    Memory address register,    Program counter,    Instruction register

Ans:C ,C


Data items in the fixed asset record of a newly purchased asset that a well-designed application program could obtain automatically include
Options: estimated disposal data,    source,    first cost,    All of the above

Ans:D ,D


  A function inside another function is called _______
Options: Nested function B. Round function C. Sum function D. Text function

Ans:– A ,


The logic gate that will have HIGH or "1" at its output when any one of its inputs is HIGH is a(n):
Options: OR gate,    AND gate,    NOR gate,    NOT gate

Ans:A ,A


The invention of the slide rule is attributed to
Options: Babbage,    Oughtred,    Pascal,    Napier

Ans:B ,B


Convert the CHARI h#000F, s assembly language instructions into hexadecimal machine language:
Options: 0111EF,    9001E6,    DA000F,    40

Ans:C ,C


34. The word wrap reature
Options: a. Automatically move text to the next line when necessary b. Appears at the bottom of the document c. Allows you to type over text d. is the short horizontal line

Ans:– A ,– A


. Essential files of MS DOS are
Options: a. Command . com b. Io.sys c. Msdos.sys d. All of above

Ans:8 – d ,8 – d


. What is the symbol for dividing?
Options: a. A ./ b. % c. & d. #

Ans:– a,– a


What is defined by Handout Master?
Options: Slide Formatting B. Slide Transaction C. Layout of Handout D. Layout of Slide

Ans:– C ,


.   Which of the following you must first complete in order to delete an object?
Options: a. Double click the image b. Select the image c. Resize the image d. Move the image to a new location

Ans:6 – B ,6 – B


Which of the following registers hold the information before it goes to the decoder
Options: control register,    data register,    accumulator,    address register

Ans:B ,B


. To get to the ‘Symbol’ dialog box, click on the ______ menu and choose ‘Symbol’.
Options: a. Insert b. Format c. Tools d. Table

Ans: – A , – A


. The Second Generation Computer was based on ________.
Options: A) Vacuum Tube B) Silicon Chips C) Transistor D) Bio Chips

Ans:C,C


. You can merge the main document with data source in Excel. In mail merge operation, Word is usually
Options: a.  server b.  source c.  client d.  none

Ans:– c,– c


The dialogue techniques for terminal use do not include
Options: questions and answers,    open-ended questions,    form fillings,    menu display

Ans:B ,B


In an intrinsic semiconductor, the number of free electrons
Options: Equals the number of holes,    Is less than the number of holes,    Is greater than the number of holes,    Impossible to say

Ans:A ,A


Storing a separate copy of the database at multiple locations is which of the following?
Options: Data Replication,    Horizontal Partitioning,    Vertical Partitioning,    Horizontal and Vertical Partitioning

Ans:A ,A


What are the most commonly used transmission speeds in BPS used in data communication?
Options: 300,    1200,    2400,    9600

Ans:D ,D


The ALU and control unit of most of the microcomputers are combined and manufacture on a single silicon chip. What is it called?
Options: a . monochip b . microprocessor c. ALU d . control unit 

Ans:7.b,7.b


The characteristics of strategic decisions include all of the following except:
Options: they are structured,    they are future oriented,    they have a high level of uncertainty,    they are concerned with long-range plans

Ans:A ,A


to edit the text within the boxes of an organization chart, you
Options: a. select the box and text, then make changes b. select the box, then make the changes c. highlight the text, them make the changes d. a and b both

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


Demodulation is a process of
Options: converting analog to digital signals,    converting digital to analog signals,    multiplexing various signals into one high speed line signals,    performing data description.

Ans:A ,A


Concatenation of text can be done using
Options: Apostrophe (‘) B. Exclamation (!) C. Hash (#) D. Ampersand (&)

Ans:– D ,


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


. Internal commands are
Options: a. Incorporated in the command.com b. Incorporate in the command directory c. Have external files d. All of the above

Ans:0 – a ,0 – a


Carrier is
Options: One or more conductors that serve as a common connection for a related group of devices,    a continuous frequency capable of being modulated or impressed with a second signal,    the condition when two or more sections attempt to use the same channel at the same time,    a collection of interconnected functional units that provides a data communications service among stations attached to the network

Ans:B ,B


A microprocessor unit, a memory unit, and an input/output unit form a:
Options: CPU,    compiler,    microcomputer,    ALU

Ans:C ,C


Computers normally solve problem by breaking them down into a series of yes-or-no decisions represented by 1s and 0s. What is the name of the logic that allows computers to assign numerical values that fail somewhere between 0 and 1?
Options: Human logic,    Fuzzy logic,    Boolean logic,    Operational logic

Ans:B ,B


How do you select an entire column?
Options: a. Select Edit > Select > Column from the menu b. Click the column heading letter c. Hold down the shift key as you click anywhere in the column. d. Hold down the Ctrl key as you click anywhere in the column

Ans:8211; b,8211; b


. The _____ on the right side of the menu bar lets users type free-form questions, such as how do I save, or terms, such as copy, and Word responds by displaying a list of topics related to the word or phrase entered.
Options: a. Type a question for help box b. Question Mark button c. What’s this? command d. Index sheet

Ans: – A , – A


Which device should not be plugged into a standard ups?
Options: monitor,    laser printer,    ink-jet printer,    an external modem

Ans:B ,B


The axis of movement of a robot may include:
Options: Wrist rotation,    X-Y coordinate motion,    elbow rotation,    All of the above

Ans:D ,D


Where was the India's first computer installed and when?
Options: Institute of Social Science, Agra, 1955,    Indian Institute of Statistics, Delhi, 1957,    Indian Statistical Institute, Calcutta, 1955,    Indian Institute of Science, Bangalore, 1971

Ans:C ,C


. To locate a data item for storage is
Options: A) Field B) Feed C) Database D) Fetch

Ans:4-D,4-D


Which of the following commands is used to count the total number of lines, words, and characters contained in a file.
Options: count p,    wc,    wcount,    countw

Ans:B ,B


Which one of the following sorts rows in SQL?
Options: SORT BY,    ALIGN BY,    ORDER BY,    GROUP BY

Ans:C ,C


Computer Network is
Options:  Collection of hardware components and computers B.  Interconnected by communication channels C.  Sharing of resources and information D.  All of the Above

Ans:– D ,


What is the main advantage of magnetic core memory over semiconductor RAM memory?
Options: more compact and smaller,    more economical,    a bit does not have to write after reading,    non volatile

Ans:D ,D


The processes at the most detailed level of the data flow diagrams are called
Options: transform descriptions,    functional primitives,    data flows,    interfaces

Ans:B ,B


A billionth of a second is defined as a:
Options: millisecond,    microsecond,    nanosecond,    picoseconds

Ans:C,C


Which is the make given to the database management system which is able to handle full text data, image data, audio and video?
Options: a. full media b. graphics media c. multimedia d. hypertext 

Ans:.c,.c


What do you call ‘a collection of character and paragraph formatting commands’?
Options: the defaults B. a template C. a style D. a boilerplate

Ans:– C ,


In SQL, which command(s) is(are) used to enable/disable a database trigger?
Options: MODIFY USER,    CHANGE USER,    ALTER TRIGGER,    All of the above

Ans:C ,C

www.000webhost.com