Which menu option can be used to split windows into two?

Options: Format -> Window B. View -> Window-> Split C. Window -> Split D. View –> Split

Ans:– C ,

Description: mcqquestions

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

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

The Acme Corporation is implementing dial-up services to enable remote-office employees to connect to the local network. The company uses multiple routed protocols, needs authentication of users connecting to the network, and since some calls will be long distance, needs callback support. Which of the following protocols is the best choice for these remote services?
Options: 802.1,    Frame Relay,    HDLC,    PPP

Ans:D ,D

. Which command will you choose to convert a column of data into row?
Options: a.  Cut and Paste b.  Edit >> Paste Special >> Transpose c.  Both of above d.  None of above

Ans:– b,– b

In analyzing the compilation of PL/I program, the term "Machine independent optimization" is associated with
Options: recognition of basic syntactic constructs through reductions,    recognition of basic elements and creation of uniform symbols,    creation of more optional matrix,    use of macro processor to produce more optimal assembly code

Ans:C ,C

Entities of a given type are grouped into a(n):
Options: database.,    entity class.,    attribute.,    ERD.

Ans:B ,B

The decimal equivalent of the binary number 11100001111 is
Options: 1806,    1807,    2806,    All of the above

Ans:B ,B

Actuarial accounting systems are associated with the _____ industry.
Options: insurance,    reliable,    consistent,    exhaustive

Ans:A ,A

Which of the following condition is used to transmit two packets over a medium at the same time?
Options: Contention,    Collision,    Synchronous,    Asynchronous

Ans:B ,B

Which file starts MS Word?
Options: a. winword.exe b. word.exe c. msword.exe d. word2003.exe

Ans:– A,– A

. The Name box on to the left of formula bar
Options: a.  shows the name of workbook currently working on b.  shows the name of worksheet currently working on c.  shows the name of cell or range currently working on d.  None of above

Ans:– c,– c

Zani's framework of effective MIS argues that MIS can only be designed in a:
Options: top down fashion,    co-ordinative fashion,    by managerial participation,    bottom up

Ans:A ,A

The device that assembles groups of characters into complete messages prior to their entering the CPU is called:
Options: a compiler,    an interpreter,    a communications processor,    an editor

Ans:C ,C

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

A proportional plus integral contro¬ller can:
Options: has no transient response,    can compensate for lag,    can increase the system type,    both (b) and (c)

Ans:D ,D

How does a host on an Ethernet LAN know when to transmit after a collision has occurred? In a CSMA/CD collision domain, multiple stations can successfully transmit data simultaneously. In a CSMA/CD collision domain, stations must wait until the media is not in use before transmitting. You can improve the CSMA/CD network by adding more hubs. After a collision, the station that detected the collision has first priority to resend the lost data. After a collision, all stations run a random backoff algorithm. When the backoff delay period has expired, all stations have equal priority to transmit data.
Options: 1 and 3,    2 and 4,    1,3 and 4,    2 and 5

Ans:D ,D

Which encapsulations can be configured on a serial interface? Ethernet Token Ring HDLC Frame Relay PPP
Options: 1 and 4,    2 only,    3, 4 and 5,    All of the above

Ans:C ,C

System design aid should primarily
Options: help analyse both data and activities,    help in documentation,    help in programming,    generate code

Ans:A ,A

Which of the following is a correct order of precedence in formula calculation?
Options: a. Multiplication and division exponentiation positive and negative values b. Multiplication and division, positive and negative values addition and subtraction c. Addition and subtraction positive and negative values exponentiation d. All of above

Ans:D,All of above

The concept of a general CAD system was that it should provide:
Options: A system for handling user actions.,    A system for the operation of applications programming.,    A set of basic system functions and utilities.,    All of the above

Ans:D ,D

The Ziegler-Nichols method:
Options: is a graphical solution method,    can be used to determine gain factors of a PI loop,    is a method of control,    a and b above

Ans:D ,D

A foreign key is which of the following?
Options: Any attribute,    The same thing as a primary key,    An attribute that serves as the primary key of another relation,    An attribute that serves no purpose

Ans:C ,C

Uniform Symbols Table
Options: contains all constants in the program,    a permanent table of decision rules in the form of patterns for matching with the uniform symbol table to discover syntactic structure.,    consists of a full or partial list of the token's as they appear in the program. Created by Lexical analysis and used for syntax analysis and interpretation,    a permanent table which lists all key words and special symbols of the language in symbolic form.

Ans:C ,C

An optical input device that interprets pencil marks on paper media is
Options: O.M.R,    Punch card reader,    Optical scanners,    Magnetic tape


Which bar is usually located below that Title Bar that provides categorized options?
Options: Menu bar B. Status Bar C. Tool bar D. Scroll bar

Ans:– A ,

In a worksheet you can select
Options: a. The entire worksheet b. Rows c. Columns d. All of the above

Ans:#8211; b,#8211; b

A complete microcomputer system consists of
Options: a . microprocessor b . memory c . peripheral equipment d . all of above


What software packages are commonly used for businesses that have to track extensive lists of clients and inventory?
Options: Special purpose packages,    Custom made programs,    Single function application packages,    Data management packages

Ans:D ,D

Which of the following statements is correct?
Options: Terminal section of a synchronous modem contains the scrambler,    Receiver section of a synchronous modem contains the scrambler,    Transmission section of a synchronous modem contains the scrambler,    Control section of a synchronous modem contains the scrambler

Ans:C ,C

What is the main difference between a mainframe and a super computer?
Options: A) Super computer is much larger than mainframe computers B) Super computers are much smaller than mainframe computers C) Supercomputers are focused to execute few programs as fast as possible while mainframe uses its power to execute as many programs concurrently D) Supercomputers are focused to execute as many programs as possible while mainframe uses its power to execute few programs as fast as possible.


. Using windows explorer, a plus (+) sign in front of a folder indicates
Options: a. An open folder b. The folder contains subfolder c. A text file d. A graphic file

Ans:7 – b ,7 – b

Which of the following is not true of immediate processing?
Options: It is often used in real-time applications,    It can occur with either sequential of direct-access files,    It can be used in an airline-reservation system,    Transactions are processed shortly after a real-world event occurs


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

Which one of the following is a statement of Kirchhoffs current law?
Options: The current through a resistance is proportional to the value of resistance and the IR drop across it,    The total current in a parallel circuit is less than the value of the smallest current,    The algebraic sum of currents in a loop is equal to zero,    The algebraic sum of currents entering and leaving a point is equal to zero

Ans:C ,C

We can receive data either through our television aerial or down our telephone lines and display this data on our television screen. What is the general name given to this process?
Options: Viewdata,    Teletext,    Telesoftware,    Videotex

Ans:D ,D

. Which of the following in not Outer join?
Options: Left outer join B. Right outer join C. Full outer join D. All of the above

Ans: – D ,

. Which term is used to describe RAM?
Options: A) Dynamic RAM (DRAM) B) Static RAM (SRAM) C) Video RAM (VRAM) D) All of the above


. 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 command permits to see the directory structure in DOS?
Options: a. Display structure b. Tree c. Dir/all d. All of above

Ans:0 – b ,0 – b

A medium for transferring data between two locations is called
Options: Network,    Communication channel,    Modem,    Bus

Ans:B ,B

. The two basic types of record access methods are:

Options: A) Sequential and random B) Sequential and indexed C) Direct and immediate D) Online and real time


. One of the popular mass storage device is CD ROM. What does CD ROM stand for?
Options: A) Compactable Read Only Memory B) Compact Data Read Only Memory C) Compactable Disk Read Only Memory D) Compact Disk Read Only Memory


Which of the following commands will allow you to set your Telnet password on a Cisco router?
Options: line telnet 0 4,    line aux 0 4,    line vty 0 4,    line con 0

Ans:C ,C

. Validation Rule in a field will
Options: a. Checks the value entered when user leaves the field b. Displays the value in specified format when user leaves the field c. Defines the appearance for the text d. There is no option of Validation Rule

Ans:– a,– a

. In help menu of Excel, which of the following tabs are found?
Options: a. Contents tab b. Answer Wizard tab c. Index tab d. all of the above.

Ans:– d,– d

An information processor includes
Options: the data base and the model base,    the central processing unit,    incoming data and outgoing information,    incoming data, the central processing unit, the model base, outgoing information, and the data base

Ans:D ,D

If you want to have more than one Telnet session open at the same time, what keystroke combination would you use?
Options: Tab+Spacebar,    Ctrl+X, then 6,    Ctrl+Shift+X, then 6,    Ctrl+Shift+6, then X

Ans:D ,D

Which is not a factor when categorizing a computer?
Options: Speed of the output device,    Amount of main memory the CPU can use,    Cost of the system,    Capacity of the hard disk

Ans:E ,E

94. What is the shortcut key for Spelling Check in document?
Options: a. F7 b. Shift + F7 c. Ctrl + F7 d. Alt + F7

Ans:–  A ,–  A

ON UPDATE CASCADE ensures which of the following?
Options: Normalization,    Data Integrity,    Materialized Views,    All of the above.

Ans:B ,B

.   Which of the following is not a feature of PowerPoint?
Options: a. Printing transparencies b. Printing the speaker’s notes along with slide images c. Linking a slide transition with a laser pointer d. Drawing with a pen

Ans:7 – C ,7 – C

Which is a device that changes information into digital form?
Options: Modem,    Digitizer,    Mouse,    Light pen

Ans:B ,B