In help menu of Excel, which of the following tabs are found?

Options: Contents tab B. Answer Wizard tab C. Index tab D. all of the above.

Ans:– D ,

Description: mcqquestions

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

Hits Today: 11804 | Level: Moderate

Got some suggestion about this question or to make this site better? Please leave your comments below.

Want to see where do you stand among other aspirants in "Computer" Category?

Click Here to take quick 5 mins MCQ test to find out.

More MS-Excel Related questions:

How would you allow device drivers and TSR's to be loaded into Upper Memory Blocks ?
Options: DOS=High,    devicehigh=,    loadhigh=,    DOS=UMB

Ans:D ,D

The terminal device that functions as a cash register, computer terminal, and OCR reader is the:
Options: A) Data collection terminal B) OCR register terminal C) Video Display terminal D) POS terminal


The processing capability of a microcomputer can be enhanced with the help of
Options: addition processor,    expansion cards,    secondary memory,    buffer memory

Ans:B ,B

The process of transferring data intended for a peripheral device into a disk (or intermediate store) so that it can be transferred to peripheral at a more convenient time or in bulk, is known as
Options: multiprogramming,    spooling,    caching,    virtual programming

Ans:B ,B

You must service the laser printer in your office. Which part of the printer shoud you avoid touching because it is hot?
Options: fuser,    printer head,    primary corona,    high-voltage power supply

Ans:A ,A

.  Which of the following syntax is correct regarding to SUM function in Excel?
Options: a. =SUM (A1, B1) b. =SUM (A1:B9) c. =SUM (A1:A9, B1:B9) d. All of the above

Ans:– d,– d

. You can automatically include all of the field in a table in a query by___ a strike that appear list box in query design view
Options: a. Clicking b. Right clicking c. Double clicking d. None of the above

Ans:0 – c ,0 – c

On which toolbar can you find Format Painter tool in MS Word?
Options:  A) Standard toolbar, B) Formatting toolbar, C) Drawing Toolbar, D) Picture Toolbar,

Ans:A,Standard toolbar

Logical models form the basis for computing systems that generate information useful in dealing with
Options: dynamic situations,    uncertain situations,    complex situations,    All of the above

Ans:D ,D

In the PROLOG language system, facts are manipulated by:
Options: algorithms,    rules,    memory,    simulations

Ans:B ,B

Which was the first commercial computer built by M.V. Wilkies.
Options: Super computer,    LEO,    Mainframe,    Micro computer

Ans:B ,B

What is the name given to the 8-bit unit used for coding data?
Options: block of characters,    byte,    word,    K

Ans:B ,B

A program component that allows structuring of a program in an unusual way is known as
Options: Correlation,    Coroutine,    Diagonalization,    Quene


Which part of the computer were is used for calculating and comparing?
Options: Disk unit,    Control unit,    ALU,    Modem


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

Ans:– b,– b

What is the name of the device that converts computer output into a form that can be transmitted over a telephone line?
Options: Teleport,    Modem,    Multiplexer,    Concentrator

Ans:B ,B

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

In slide layout panel how many layouts are available for text layout by default?
Options: a. 4 b. 7 c. 12 d. None of above

Ans: – A , – A

What will be the output of the program? #include<stdio.h> int main() { int X=40; { int X=20; printf("%d ", X); } printf("%d\n", X); return 0; }
Options: 40 40,    20 40,    20,    Error

Ans:B ,B

The reliability life cycle of a product:
Options: has three distinct rates of failure,    cannot be predicted,    All of the above,    stays constant with environmental conditions

Ans:A ,A

If you want to disable STP on a port connected to a server, which command would you use?
Options: disable spanning-tree,    spanning-tree off,    spanning-tree security,    spanning-tree portfast

Ans:D ,D

. Which one of the following key is used to refresh the active window?
Options: a. F7 b. F8 c. F9 d. F5

Ans:6 – d ,6 – d

. Which command is used to delete all the files from root directory of drive A?
Options: a. Del a: b. Del *.* c. Del A d. Erase *

Ans:3 – a ,3 – a

. __________ are documents that when filled in create records.
Options: a. Forms b. Reports c. Tables d. Queries

Ans:7 – a ,7 – a

In slide layout panel how many layouts are available for text layout by default?
Options: a. 4, b. 7, c. 12, d.  None of the above

Ans:A ,None of the above

In an experiment in which a new drug was being tested on 1000 rats, which one of the following would a computer be least able to do?
Options: determine the total amount of drug that had been given to all 1000 rats keep records of weight changes of the 1000 rats,    keep records of the dosages and the dates the drug was given to each rat,    determine the total dosage that had been given to each rat,    keep records of weight changes of the 1000 rates

Ans:E ,E

Which memory stores the values of variables.
Options: SAM,    ROM,    RAM,    PROM

Ans:C ,C

Which of the following device is used with an X.25 network to provide service to asynchronous terminals
Options: repeater,    bridges,    gateway,    Packet assembler/disassemble

Ans:D ,D

. When you press and release the secondary mouse button you are ….
Options: a. Right clicking b. Left clicking c. Either a or b d. None of above

Ans:6 – a ,6 – a

.   Right clicking something in PowerPoint
Options: a. Deletes the object b. Selects the object c. Opens a shortcut menu listing for the object d. Nothing he right mouse button for operation

Ans:9 – C ,9 – C

Change the _____ to create a document in wide format
Options: a. Page Orientation b. Page margins c. Paper Style d. Paper Source

Ans:– A,– A

Which of the following symbol modes are used to input of graphics to General CAD system?
Options: Live and Rectangle mode,    Arc and Circle mode,    Dimension and Alphanumeric mode,    All of the above

Ans:D ,D

. You have field ‘Sex’ of type Byte Number. How to limit its value to 0 and 1 only?
Options: a. By setting required to ‘Yes’ b. By using default value c. By defining validation rule d. By using format

Ans:– c,– c

Which command is used to display the characteristics of a process?
Options: pid,    du,    ps,    au

Ans:C ,C

A modulator converts a _____ signal to a(n) _____ signal.
Options: FSK; PSK,    PSK; FSK,    analog; digital,    digital; analog

Ans:D ,D

The minimal set of super key is called
Options: Primary key B. Secondary key C. Candidate key D. Foreign key

Ans:– C ,

Which of the following operations moves text from clipboard?
Options: Copy B. Paste C. Drag and Drop D. Cut

Ans:– B ,

A device mounted on a communication satellite which receives, amplifies and re-transmits signals from earth station is
Options: Track,    Transponder,    Transistor,    Terminal

Ans:B ,B

Which of the following tools is not used in modeling the new system?
Options: decision tables,    data dictionary,    data-flow diagrams,    All of the above

Ans:D ,D

. The ….command is used to open windows based application directly from DOS prompt
Options: a. Run b. Start c. Load d. Execute

Ans:9 – b ,9 – b

Which of the following protocols are used to configure trunking on a switch? VLAN Trunk Protocol VLAN 802.1Q ISL
Options: 1 only,    3 only,    3 and 4,    1, 3 and 4

Ans:C ,C

. When you add fields in ____, a Field List pane displays.
Options: a. Design View b. Layout View c. Print Preview d. Report View

Ans:0 – b ,0 – b

. Which was the world’s first minicomputer and when was it introduced?
Options: A) PDP-I, 1958 B) IBM System/36, 1960 C) PDP-II, 1961 D) VAX 11/780, 1962


. when you print preview a worksheet
Options: a. the entire worksheet is displayed b. the selected range is displayed c. the active portion of the worksheet is displayed d. a, b and c

Ans:– d,– d

. What was the first computer brought in Nepal?
Options: A) ICL/2950 B) ENIAC C) IBM 1401 D) None of above


The physical layer, in reference to the OSI model, defines
Options: data link procedures that provide for the exchange of data via frames that can be sent and received,    the interface between the X.25 network and packet mode device,    the virtual circuit interface to packet-switched service,    All of the above

Ans:B ,B

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 relation is considered a:
Options: Column.,    one-dimensional table.,    two-dimensional table.,    three-dimensional table.

Ans:C ,C

A hard disk is divided into tracks which are further subdivided into:
Options: clusters,    sectors,    vectors,    heads

Ans:B ,B

. Ctrl + P
Options: Open Paragraph Dialog Box B. Open Page Format Dialog Box C. Open Save Dialog Box D. Open Print Dialog box

Ans:– D ,