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: 16004 | 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 many layers does OSI Reference Model has?
Options:  4 B.  5 C.  6 D.  7

Ans:– D ,


. Which command is used to provide access to program located in other directory or disk?
Options: a. Tree b. Path c. Dir d. CD

Ans:5 – d ,5 – d


Natural language understanding is used in:
Options: natural language interfaces,    natural language front ends,    text understanding systems,    All of the above

Ans:D ,D


World Wide Web is being standard by
Options: a. Worldwide corporation b. W3C c. World Wide Consortium d.World Wide Web Standard

Ans:b,b


Which of the following Operating System does not implement multitasking truly?
Options: Windows 98 B. Windows NT C. Windows XP D. MS DOS

Ans:– D ,


. Which of the following best describes the contents of a mail merge main document?
Options: a. Information that is unique for every form letter created b. Information that is same for every form letter created c. Styles and fonts for the data source d. None of above

Ans: – B , – B


In a computer system, which device is functionally opposite of a Key-board?
Options: Mouse,    Trackball,    Printer,    Joystick

Ans:C,C


The method of solid modeling that defines the topology of faces, edges, and vertics, as well as data that defines the surface in which each face lies is called:
Options: constructive solid geometry,    layering,    boundary representation,    isometric

Ans:C ,C


A type of semiconductor memory that usually has small capacity but very fast access is
Options: PROM,    RAM,    Scratchpad,    ROM

Ans:C ,C


The rate at which scanning is repeated is called the:
Options: stroke rate,    refresh rate,    bandwidth,    resolution

Ans:B ,B


. 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


. Which of the following storage device can store the largest amount of data?
Options: A) Hard Disks B) Flash Disks C) Blu-Ray Disks D) DVDs

Ans:8-A,8-A


51. Why the document you created at home displays with a different font at school?
Options: a. Because you have a different printer at school than at home b. Because you have a different monitor at school than at home c. Because the font you used at home is not installed on your school computer d. Because the version of Windows is different

Ans:– C ,– C


In MS Word, Ctrl+S is for …..
Options: Scenarios B. Size C. Save D. Spelling Check

Ans:– C ,


. A word processor would most likely be used to do
Options: a. keep an account of money spent b. do a computer search in media center c. maintain an inventory d. type a biography

Ans:– D,– D


You want to totally reinitialize the router and replace the current running-config with the current startup-config. What command will you use?
Options: replace run start,    copy run start,    copy start run,    reload

Ans:D ,D


. The most important advantage of a video disk is
Options: A) Compactness B) Potential capacity C) Durability D) Cost effectiveness

Ans:B,B


The ALU of a computer normally contains a number of high speed storage elements called
Options: semiconductor memory,    registers,    hard disk,    magnetic disk

Ans:B,B


For every relationship, how many possible types of actions are there when enforcing minimum cardinalities?
Options: Two,    Three,    Four,    Six

Ans:D ,D


. Which control types is most often associated with a bound control?
Options: a. command button b. label c. text box d. list box

Ans:– c,– c


. The secondary storage devices can only store data but they cannot perform
Options: A) Arithmetic Operation B) Logic operation C) Fetch operations D) Either of the above

Ans:0-D,0-D


Which is used for manufacturing chips?
Options: A) Bus B) Control unit C) Semiconductors D) A and b only

Ans:-C,-C


. Which is an item of storage medium in the form of circular plate?

Options: A) Disk B) CPU C) Printer D) ALU

Ans:A,A


. Who is credited with the idea of using punch cards to control patterns in a waving machine?
Options: A) Pascal B) Hollerith C) Babbage D) Jacquard

Ans:D,D


10. What is the switch that is used to make sure that the copy command copied files correctly
Options: a. /a b. /c c. /s d. /v

Ans:Correct Answer: d ,Correct Answer: d


A transaction manager is which of the following?
Options: Maintains a log of transactions,    Maintains before and after database images,    Maintains appropriate concurrency control,    All of the above.

Ans:D ,D


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


  Which key do you press to check spelling?
Options: F3 B. F5    C. F7 D. F9

Ans:– C ,


Which commands is used to assign executable permission to all of the files named "letter"?
Options: chmod ugo+r letter,    chmod ugo+rw letter,    chmod u+x letter,    chmod ugo+x letter

Ans:D ,D


. Which of the following can be used to navigate documents?
Options: a. frames b. hyperlinks c. web toolbar d. all of the above

Ans: –  B , –  B


The original LISP machines produced by both LMI and Symbolics were based on research performed at:
Options: CMU,    MIT,    Stanford University,    RAMD

Ans:B ,B


Which function will you use to enter current time in a woksheet cell in MS-Excel?
Options: a) =today() b) =now() c) =time() d) =currentTime()

Ans:B,=now()


What are the most likely conditions for ESD?
Options: Hot and dry,    Hot and wet,    Cold and dry,    Cold and wet

Ans:B ,B


Computer memory consists of
Options: RAM,    ROM,    PROM,    All of the above

Ans:D ,D


Which of the following is true concerning a procedure?
Options: You do not create them with SQL.,    They do not need to have a unique name.,    They include procedural and SQL statements.,    They are the same thing as a function.

Ans:C ,C


You can use the drag and drop method to
Options: a. Copy cell contents b. Move cell contents c. Add cell contents d. a and b

Ans:#8211; d,#8211; d


What will be the output of the program? #include<stdio.h> #define JOIN(s1, s2) printf("%s=%s %s=%s \n", #s1, s1, #s2, s2); int main() { char *str1="India"; char *str2="BIX"; JOIN(str1, str2); return 0; }
Options: str1=IndiaBIX str2=BIX,    str1=India str2=BIX,    str1=India str2=IndiaBIX,    Error: in macro substitution

Ans:B ,B


Which of the following is not a key component of the evaluation process in building a DSS?
Options: criteria for evaluation,    means of measuring system-development time spent on the project,    means of monitoring the progress of the DSS,    formal review process

Ans:B ,B


Which SQL phrase is not supported by Oracle?
Options: ON DELETE CASCADE,    ON UPDATE CASCADE,    CREATE SEQUENCE [SequenceName],    DROP SEQUENCE [SequenceName]

Ans:B ,B


. Selecting the Column G & H then choose Insert->Columns. What will happen?
Options: 2 Columns will be inserted after Column F B. 2 Columns will be inserted after Column G C. 2 Columns will be inserted after Column H D. 2 Columns will be inserted after Column I

Ans:– A ,


Which of the following options is not located in the Page Setup dialog box?
Options: a. Page Break Preview. b. Page Orientation c. Margins d. Headers and Footers

Ans:#8211; a,#8211; a


Using the _____ switch causes FDISK to display the partition status of your hard disk without executing FDISK.
Options: /show,    /display,    /status,    /part

Ans:C ,C


. Your German supplier still invoices for parts in Deutsche marks. How can you have Excel convert those sums to Euros?
Options: a. On the Insert menu, click Symbol and from the currency symbols subset, select the Euro sign. b. On the tools menu, click Add-Ins, and select the Euro Currency Tools check box c. Apply a selected background color d. All of above

Ans:– b,– b


The graph of current gain versus collector current indicates that the current gain
Options: varies enormously,    is contant,    varies slightly,    equals the collector current divided by the base current

Ans:D ,D


Information in a memory that is no longer valid or wanted is known as
Options: non-volatile,    volatile,    surplus,    garbage

Ans:D ,D


What is the benefit of the Networking?
Options: File Sharing B. Easier access to Resources C. Easier Backups D. All of the Above

Ans:– D ,


Operating system
Options: links a program with the subroutines it references,    provides a layered, user-friendly interface,    enables the programmer to draw a flowchart,    all of the above

Ans:B ,B


The highest level in the hierarchy of data organization is called
Options: data bank,    database,    data file,    data record

Ans:B ,B


Which device is used to backup the data?
Options: Floppy Disk B. Tape C. Network Drive D. All of the above

Ans:– D ,


. To make file in MS Dos we need command
Options: a. Copy b. Copy con c. MD d. Make File

Ans:0 – b ,0 – b

www.000webhost.com