You can group noncontiguous worksheets with


Options: The alt+enter key B. The ctrl key and mouse C. The shift key and the mouse D. The group button on the standard toolbar

Ans: – B ,


Description: mcqquestions

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

Hits Today: 11515 | 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 of the following are not likely to be found on a PC main circuit board
Options: RAM chips,    Microprocessor chips,    ROM chips,    LCD clocks

Ans:D ,D


Which device of computer operation dispenses with the use of the keyboard?
Options: Joystick,    Light pen,    Mouse,    Touch

Ans:C,(Canswer


Convert the 48 machine language instructions into assembly language, assuming that they were not generated by pseudo-ops:
Options: ASRA,    LOADA h#OD4E, i,    STOREA h#014B, d,    ADDA h#01FE, i

Ans:A ,A


4. Single spacing in MS-WORD document causes ____ point line spacing?
Options: a. 10 b. 12 c. 14 d. 16

Ans: B , B


. Windows 2000 server uses the
Options: a. FAT 16 b. NTFS c. FAT 64 d. FAT 32

Ans:3 – b ,3 – b


A directly accessible appointment calendar is a feature of a _____ resident package.
Options: CPU,    Memory,    Buffer,    ALU

Ans:B ,B


. Which of the following computer implemented binary numbers, perform calculations using electronics and implemented separate computation and memory for the first time?
Options: A) Mark I B) ABC C) Z3 D) None of above

Ans:B,B


Brad is in charge of a small network and wants to make it simple but secure. The users want to have full control over their data and still be able to share data with the rest of the office. The networking knowledge of the office staff is excellent. Which network(s) would be the best to set up?
Options: Peer-to-peer,    Master domain,    Server-based,    Ethernet

Ans:A ,A


Text boundary can be displayed or hidden from
Options:  A) Auto text option from Insert menu, B) Options from Tools menu, C) Customize from Tools menu, D) All of above, 

Ans:-B,-B


Which Chart can be created in Excel?
Options: Area B. Line C. Pie D. All of the above

Ans:– D ,


The hardware device Jhat acts as both a switching and connecting unit is called a(n):
Options: concentrator,    RS-232C port,    multiplexer,    communications processor

Ans:C ,C


Which of the following is (are) not a tool for Application Prototyping?
Options: Application generators,    third generation language,    screen generators,    report generators

Ans:B ,B


. Which menu option can be used to split windows into two?
Options: a. Format -> Window b. View -> Window-> Split c. Window -> Split d. View –> Split

Ans:– c,– c


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

Ans:B ,B


. Which device is required for the Internet connection?

Options: A) Joystick B) Modem C) CD Drive D) NIC Card

Ans:B,B


You are working with a network that is 172.16.0.0 and would like to have the maximum number of hosts per subnet. This assumes support for eight subnets. What subnet mask should you use?
Options: 255.255.192.0,    255.255.224.0,    255.255.240.0,    255.255.248.0

Ans:C ,C


The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
Options: a. relationship b. Join c. Query d. None of these

Ans:dash; a,dash; a


What will be the output of the program in Turbo C (under DOS)? #include<stdio.h> int main() { struct emp { char *n; int age; }; struct emp e1 = {"Dravid", 23}; struct emp e2 = e1; strupr(e2.n); printf("%s\n", e1.n); return 0; }
Options: Error: Invalid structure assignment,    DRAVID,    Dravid,    No output

Ans:B ,B


What happens when dollar signs ($) are entered in a cell address? (ex. $B$2:$B$10)
Options: An absolute cell address is created. B. Cell address will change when it is copied to another cell. C. The sheet tab is changed. D. The status bar does not display the cell address.

Ans:– A ,


A series of AI systems developed by Pat Langley to explore the role of heuristics in scientific discovery.
Options: RAMD,    BACON,    MIT,    DU

Ans:B ,B


Which command will prevent subsequent changes to the file CBT.EXE?
Options: RENAME + r CBT.EXE,    ATTRIB + r CBT.EXE,    COPY + r CBT.EXE,    MODE + r CBT.EXE

Ans:B ,B


Which CAD display configurability allows work without any host support?
Options: Highly intelligent,    Medium intelligence,    Low intelligence,    One with no secondary storage capacity.

Ans:A ,A


What is the turns ratio of a power transformer that shows 50 V at its secondary winding when you apply 150 V to its primary winding?
Options: 1/4,    1/3,    2,    3

Ans:D ,D


Versatile report generators can provide
Options: Columnar totals,    Subtotals,    Calculations,    All of the above

Ans:D ,D


Which of the following is not a font style?
Options: a. Bold b. Italics c. Regular d. Superscript

Ans:– D,– D


The first machine to successfully perform a long series of arithmetic and logical operations was:
Options: ENIAC,    Mark I,    Analytic engine,    UNIVAC-I

Ans:B ,B


Which of the following is a programming language?
Options:  Lotus B.  Pascal C.  MS-Excel D.  Netscape

Ans:– B ,


Compilers and interpreters are themselves
Options: High-level language,    Codes,    Programs,    Mnemonics

Ans:C,(Canswer


.   Which option in PowerPoint allows to carry slides from one computer to another?
Options: a. Save As b. Save and Go c. Pack and Go d. Web and Go

Ans:0 – C ,0 – C


What is the jumper setting on a SCSI device to configure it to use the fourth SCSI id? Remember, SCSI ids start with zero.
Options: 010,    110,    011,    101

Ans:C ,C


Exclusive-OR (XOR) logic gates can be constructed from what other logic gates?
Options: OR gates only,    AND gates and NOT gates,    AND gates, OR gates, and NOT gates,    OR gates and NOT gates

Ans:C ,C


The personnel who deals with the computer & its management put together are called
Options: Software,    Humanware,    Firmware,    Hardware

Ans:B,(Banswer


Which one of the following is termed a combination input-output device?
Options: VDT,    Keyboard,    Printer,    Laser Jet

Ans:A,A


. Programs are executed on the basis of a priority number in a
Options: A) Batch processing system B) Multiprogramming C) Time sharing D) None of these

Ans:B,B


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

Ans:– D ,


. When a peripheral device needs immediate attention from the operating system, it generatesa(n)
Options: a. Interrupt b. Spool c. Stack d. Page file

Ans: a, a


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

Ans:B ,B


What is the name of the temporary data storage area between a peripheral device and the CPU which compensates for the difference between their speeds?
Options: Backing storage,    Buffer,    Main storage,    Temporary storage

Ans:B,B


What will be the output of the program given below in 16-bit platform ? #include<stdio.h> int main() { enum value{VAL1=0, VAL2, VAL3, VAL4, VAL5} var; printf("%d\n", sizeof(var)); return 0; }
Options: 1,    2,    4,    10

Ans:B ,B


A prewritten program that's sold to perform a common task is called an application
Options: System software,    Package,    Utilities,    Program

Ans:B ,B


Which one of the following equations most directly determines the power dissipation of a resistance when you know the voltage drop and amount of resistance?
Options: P = I2R,    P = IE,    P = E2/R,    I = P/E

Ans:C ,C


The term scheme means
Options: the relationship service bureau,    a map of overall structure of a database.,    a parent with no owners,    two dimensional table

Ans:B ,B


In computer based information system (CBIS), DFD stands for:
Options: data flow diagram,    data flow descent,    dotted flow diagram,    such a terminology does not exist in CBIS

Ans:A ,A


The fastest type of memory from the following list is
Options: tape,    semiconductor memory,    disk,    bubble memory

Ans:B ,B


If the current gain is 200 and the collector current is 100 mA, the base current is
Options: 2 mA,    0.5 mA,    2 A,    200 A

Ans:B ,B


Magnetic tape can serve as :
Options: secondary-storage media,    output media,    input media,    All of the above

Ans:D ,D


What are the different types of real data type in C ?
Options: float, double,    short int, double, long int,    float, double, long double,    double, long int, float

Ans:C ,C


What will be the output of the program ? #include<stdio.h> int main() { enum days {MON=-1, TUE, WED=6, THU, FRI, SAT}; printf("%d, %d, %d, %d, %d, %d\n", ++MON, TUE, WED, THU, FRI, SAT); return 0; }
Options: -1, 0, 1, 2, 3, 4,    Error,    0, 1, 6, 3, 4, 5,    0, 0, 6, 7, 8, 9

Ans:B ,B


What is the output of the program given below ? #include<stdio.h> int main() { enum status { pass, fail, atkt}; enum status stud1, stud2, stud3; stud1 = pass; stud2 = atkt; stud3 = fail; printf("%d, %d, %d\n", stud1, stud2, stud3); return 0; }
Options: 0, 1, 2,    1, 2, 3,    0, 2, 1,    1, 3, 2

Ans:C ,C


Copy and Xcopy are same in the sense
Options: a. Both are internal command of DOS b. Both are external commands of DOS c. Both can be used to copy file or group of files d. Both a and b

Ans:Correct Answer: c ,Correct Answer: c

www.000webhost.com