COMPUTER GK-15

Computer GK-15 – These questions are very important for JOA, Clerk , Bank Clerk, Insurance, SO and other exam where one’s computer knowledge is tested. In this article important questions are given those can be asked in different competitive examinations.

Computer GK-15

Getting data from a cell located in a different sheet is called….Referencing

Which of the following is not a valid data type in Excel———Character

Which elements of a worksheet can be protected from accidental modification——–Contents, Objects, Scenarios

A numeric value can be treated as label value if …… precedes it——-Apostrophe (‘)

Concatenation of text can be done using——-Ampersand (&)

Which area in an Excel window allows entering values and formulas———Formula Bar

Multiple calculations can be made in a single formula using——–Array Formula

How do you delete a column——– Right click the column heading you want to delete and select delete from the shortcut menu

You can use the horizontal and vertical scroll bars to——-View different rows and columns edit the contents of a cell

To Which button do you click to add up a series of numbers——-The autosum button

Which area in an excel window allows entering values and formulas—-Formula bar

Status indicators are located on the——-Formula bar

When you insert an excel file into a word document. The data are—-Linked

Which language is used to create macros in Excel——— Visual Basic

Which would you choose to create a bar diagram———— Insert, Chart

What do you call the chart that shows the proportions of how one or more data elements relate to another data element—- Pie Chart

Which key do you press to check spelling—- F7

To record a sequence of keystrokes and mouse actions to play back later we use—– Macro Recorder

M	T	W	T	F	S	S
				1	2	3
4	5	6	7	8	9	10
11	12	13	14	15	16	17
18	19	20	21	22	23	24
25	26	27	28	29	30

COMPUTER GK-15

Leave a Comment Cancel Reply