Which elements of a worksheet can be protected from accidental modification?


Options: Contents B. Objects C. Scenarios D. All of the above

Ans:– D ,


Description: mcqquestions

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

Hits Today: 13480 | 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 IP address are based on
Options: 16-bit addresses,    32-bit addresses,    64-bit addresses,    8-bit addresses

Ans:B ,B


What command would you type to list all of the files in the current directory?
Options: DIR,    LIST ALL,    SHOW,    SHOW ME

Ans:A ,A


The truth table for an S-R flip-flop has how many VALID entries?
Options: 3,    1,    4,    2

Ans:A ,A


. Hard disk is coated in both sides with
Options: A) Magnetic metallic oxide B) Optical metallic oxide C) Carbon layer D) All of the above

Ans:6-A,6-A


If safety stock is 6 and the EOQ is 50, average inventory level is
Options: 80,    86,    85,    90

Ans:E ,E


The report card and merit list forms the
Options: Output data,    Data processing,    Central Processing,    Input data

Ans:A,(Aanswer


The ESD wrist strap is designed to protect PC Components or Service Technicians ?
Options: PC Components,    Service Technicians,    Both,    

Ans:C ,C


. What is the purpose of indexing?
Options: a. To reduce table size b. To speedup data search c. both A and B d. none of the above

Ans:– b,– b


Creating a read-only database is a task that is ________ assigned to beginning database professionals.
Options: always,    commonly,    seldom,    never

Ans:B ,B


Which of the following is used to create newspaper style columns?
Options:  A) Format Tabs, B) Table Insert Table, C) Insert Textbox, D) Format Columns, 

Ans:-D,-D


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


If the two strings are identical, then strcmp() function returns
Options: -1,    1,    0,    Yes

Ans:C ,C


An _____ system has a stored knowledge base and an inference engine.
Options: expert,    centers,    control,    MIS

Ans:A ,A


What will be the output of the program (sample.c) given below if it is executed from the command line? cmd> sample Jan Feb Mar /* sample.c */ #include<stdio.h> #include<dos.h> int main(int arc, char *arv[]) { int i; for(i=1; i<_argc; i++) printf("%s ", _argv[i]); return 0; }
Options: No output,    sample Jan Feb Mar,    Jan Feb Mar,    Error

Ans:C ,C


. External command in DOS are
Options: a. Copy, edit, sys, format b. Edit, sys, chkdsk c. Chkdsk, prompt, date d. Sys, ver, vol

Ans:Correct Answer: b ,Correct Answer: b


What is required when more than one person uses a central computer at the same time?
Options: A) Light pen B) Mouse C) Digitizer D) Terminal

Ans:-D,-D


Texas Instruments Incorporated produces a low-cost LISP machine called:
Options: The Computer-Based Consultant,    The Explorer,    Smalltalk,    The Personal Consultant

Ans:B ,B


Which of the following systems software does the job of merging the records from two files into one?
Options: Security software,    Utility program,    Networking software,    Documentation system

Ans:B ,B


. Who invented Integrated Circuits?
Options: A) Jack Kilby B) Robert Noyce C) Both of above D) None of above

Ans:C,C


When was Apple Macintosh II microcomputer introduced in the market?
Options: 1964,    1970,    1983,    1986

Ans:C,1983


Which command sends the word count of the file infile to the newfile.
Options: wc infile >newfile,    wc <infile >newfile,    wc infile - newfile,    wc infile | newfile

Ans:A ,A


The first firm to mass-market a microcomputer as a personal computer was
Options: IBM,    Sperry Univac,    Radio Shack,    Data General Corporation

Ans:C ,C


Hardware _____ memory is seldom used in modern computers.
Options: ROM,    RAM,    LIFO,    PROM

Ans:C ,C


The task of arranging data in order is called
Options: a. Searching b. Sorting c. Ordering d. Shorting

Ans:ndash; b,ndash; b


The standard VGA display has _____ pixels in its native graphics mode?
Options: 648 x 320,    640 x 480,    680 x 440,    1024 x 786

Ans:B ,B


A group of magnetic tapes, videos or terminals usually under the control of one master is
Options: Cylinder,    Cluster,    Surface,    Track

Ans:B,(Banswer


. Which is a semi conductor memory?
Options: A) Dynamic B) Static C) Bubble D) Both a & b

Ans:D,D


RAM is used as a short memory because it is
Options: Volatile,    Has small capacity,    Is very expensive,    Is programmable

Ans:A ,A


An output device that uses words or messages recorded on a magnetic medium to produce audio response is
Options: Magnetic tape,    Voice response unit,    Voice recognition unit.,    Voice band

Ans:B,B


A database server is responsible for which of the following?
Options: Database storage,    Data processing logic,    Data presentation logic,    All of the above.

Ans:A ,A


Files created with Lotus 1-2-3 have an extension
Options: a. DOC b. XLS c. 123 d. WK1

Ans:#8211; c,#8211; c


Portrait and Landscape are
Options:  A) Page Orientation, B) Paper Size, C) Page Layout, D) All of above, 

Ans:-A,-A


The traditional way to exit and LISP system is to enter
Options: quit,    exit,    bye,    ok

Ans:B ,B


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


. Pre-made sheet formats like Simple, Classic, Accounting, Colorful et can be applied from
Options: a. from Fromat >> Cells b. from Format >> Autoformat c. from Table >> Autoformat d. All of above

Ans:– b,– b


In vi editor, forward search is performed using the command.
Options: :pat,    ?pat,    /pat,    All of the above

Ans:C ,C


What are the two main types of access control lists (ACLs)? Standard IEEE Extended Specialized
Options: 1 and 3,    2 and 4,    3 and 4,    1 and 2

Ans:A ,A


The two form layout types which display multiple records at one time are tabular and___
Options: a. columnar b. justified c. date sheet d. pivot table

Ans:ndash; b,ndash; b


A _____ DBMS distributes data processing tasks between the workstation and a network server.
Options: Network,    Relational,    Client Server,    Hierarchical

Ans:C ,C


In Bourne shell, which file sets the Unix environment for the user when the logs into his HOME directory.
Options: .exrc,    .profile,    lastlogin,    .mbox

Ans:B ,B


. What is the shortcut key to insert current date in a cell?
Options: a. CTRL + D b. CTRL + T c. CTRL + ; d. CTRL + /

Ans:– c,– c


Which of the following are layers in the TCP/IP model? Application Session Transport Internet Data Link Physical
Options: 1 and 2,    1, 3 and 4,    2, 3 and 5,    3, 4 and 5

Ans:B ,B


The SQL command to create a table is:
Options: MAKE TABLE.,    ALTER TABLE.,    DEFINE TABLE.,    CREATE TABLE.

Ans:D ,D


What will be the output of the program ? #include<stdio.h> int main() { int arr[1]={10}; printf("%d\n", 0[arr]); return 0; }
Options: 1,    10,    0,    6

Ans:B ,B


. Which of the following does not occur during the power-on-self-test (POST)?
Options: a. The scandisk utility begins to run b. The video card and video memory are tested c. The BIOS identification process occurs d. Memory chipare checked to ensure that they are working properly

Ans: a, a


. The first cell in EXCEL worksheet is labeled as
Options: a. AA b. A1 c. Aa d. A0

Ans:– b,– b


.   Which of the following views is the best view to use when setting transition effects for all slides in a presentation
Options: a. Slide sorter view b. Notes page view c. Slide view d. Outline view

Ans:9 – A ,9 – A


The area of computer science which is concerned with the display of pictures is
Options: Networks,    Graphics,    Designing,    Architecture

Ans:B ,B


Ctrl + M
Options: a. New Document b. Close Document c. Right Indent d. Left Indent

Ans:–  D,–  D


The north pole of a magnet is the one:
Options: that has its molecules arranged in a random pattern,    that would be attracted to the earth's north magnetic pole,    that would be repelled by the south pole of another magnet,    that would be attracted to the earth's south magnetic pole

Ans:B ,B

www.000webhost.com