. If the cell B1 contains the formula = $A$1, which of the following statements is true

Options: There is a relative reference to cell A1 B. There is an absolute reference to cell A1 C. Further changes in value of A1 will not affect the value of B1 D. Further changes in value of B1 will affect the value of A1

Ans:– B ,

More MS-Excel Related questions:

The temperature needed to keep the earth's surface and the atmosphere in thermal equilibrium is called
Options: the surface temperature,    equilibrium temperature,    the mean global surface temperature,    global temperature


. Excel uniquely identifies cells within a worksheet with a cell name
Options: a. Cell names b. Column numbers and row letters c. Column letters and row numbers d. Cell locator coordinates

Ans:– c,– c

Headquarters of UNO are situated at
Options: New York, USA,    Haque (Netherlands),    Geneva,    Paris


In a rule-based system, procedural domain knowledge is in the form of:
Options: production rules,    rule interpreters,    meta-rules,    control rules

Ans:A ,A

who was founder of trigart riyasat


The primary memory of a personal computer consists of:
Options: ROM only,    RAM only,    Both ROM and RAM,    Memory module

Ans:C ,C

5.Window class, onCreate/1 ,defines
Options: (A)is executed when a visible window is being created (B) is executed when a window is being closed, it is possible to prevent the window from closing (C) when the background of a window must be erased this event is executed (D) when a window must be re-painted this event is executed 1

Ans:15. (A),15. (A)

In CRC the quotient at the sender
Options: becomes the dividend at the receiver,    becomes the divisor at the receiver,    is discarded,    is the remainder

Ans:C ,C

How many worksheets can a workbook have?
Options: 3 B. 8 C. 255 D. none of above

Ans:– D ,

The metal used to recover copper from a solution of copper sulphate is
Options: Na,    Ag,    Hg,    Fe


. What is placed to the left of horizontal scroll bar
Options: a. Tab stop buttons b. View buttons c. Split buttons d. Indicators

Ans:– B,– B

. Ctrl + K
Options: Insert Page Humber B. Insert Hyperlink C. Insert Header D. Insert Footer

Ans:– B ,

The intersection of a column and row in a spreadsheet is called a bon or
Options: Key,    Field,    Cell,    Menu

Ans:C ,C

Yamuna JVP


How to add a Border to a Paragraph in Word 2010?
Options: Borders button in the Edit group on the Insert ribbon,Borders button in the Insert group on the Home ribbon,Borders button in the Format group on the Insert ribbon, Borders button in the Paragraph group on the Home ribbon


Which device is required for the Internet connection?
Options: Joystick B. Modem C. CD Drive D. NIC Card

Ans:– B ,

1.In Microsoft PowerPoint we can replace a font on all slides with another font using the …. option
Options: (A)Edit, Fonts (B) Tools, Fonts (C) Tools, Replace Fonts (D) Format, Replace Fonts 15

Ans:151. (D),151. (D)

3.In Windows operating system to move backward through the tabs
Options: (A)CTRL+TAB (B) CTRL+SHIFT+TAB (C) SHIFT+TAB (D) None of these 1

Ans:13. (B),13. (B)

Which programming language is based on Algol 60.
Options: PILOT,    SNOBOL,    ADA,    SIMULA

Ans:D ,D

7.In Excel worksheet range is a
Options: (A)A command used for data modeling (B) A range of values such as from 23 to 234 (C) A group of cells (D) A group of worksheets 5

Ans:57. (C),57. (C)

Which command will delete the contents of NVRAM on a router?
Options: delete NVRAM,    delete startup-config,    erase NVRAM,    erase start

Ans:D ,D

The gas used for artificial ripening of green fruit is
Options: ethylene,    ethane,    carbon dioxide,    acetylene


In ancient times kangra town was known as ?
Options: NA

Ans:Nagarkot ,Nagarkot

Point out the error in the following program. #include<stdio.h> #include<stdlib.h> int main() { static char *p = (char *)malloc(10); return 0; }
Options: Error: Lvalue required,    Error: Rvalue required,    Error: invalid *p declaration,    No error

Ans:D ,D

. Raw facts and figures about any particular topic are
Options: A) Information B) facts C) data D) none of above


. What is the shortcut key to hide entire column?
Options: a. CTRL + − b. CTRL + 0 c. CTRL + H d. CTRL + C

Ans:– b,– b

. When you cut or copy the text or picture, it stores temporarily in the
Options: a. File b. Clipboard c. Icon d. All of above

Ans:3 – b ,3 – b

Which of the following is not an important principle for evaluating the raw data for decision-making:
Options: selection,    pattern,    everage,    overview

Ans:C ,C

. In MS Access “Lookup Wizard” is used to
Options: a. to select from previous values b. to select values from Excel Sheet c. to select value from another table d. Not a valid Data Type

Ans:– c,– c

. Which switch will be used in dir to see screen full contents of disk at a time?
Options: a. /s b. /w c. /p d. /b

Ans:5 – c ,5 – c

Which of the following is not anti-viruses software?
Options: NAV B. F-Prot C. Oracle D. McAfee

Ans:– C ,

Computers normally solve problem by breaking them down into a series of yes-or-no decisions represented by 1s and 0s. What is the name of the logic that allows computers to assign numerical values that fail somewhere between 0 and 1?
Options: Human logic,    Fuzzy logic,    Boolean logic,    Operational logic

Ans:B ,B

Information is produced by processing data from which of the following sources?
Options: data provided by higher levels of management,    data provided by lower levels of management,    internally generated data,    externally generated data

Ans:E ,E

. Give me an example of a cell address.
Options: a. 11 25 b. 911 c. 41A d. A21

Ans:– d,– d

To which king belongs the Lion capital at Sarnath?
Options: Chandragupta,    Ashoka,    Kanishka,    Harsha


What is the smallest number of polarities required for current flow?
Options: One - a negative terminal,    Two - a negative terminal and a positive terminal,    Three - negative, positive and neutral terminals,    Four - two negative and two positive

Ans:B ,B

440. saarch (saark) ya dakshes ka mukhyaalay kahaan hai?
Options: NA

Ans: kaathamaandoo (nepaal), kaathamaandoo (nepaal)

The command to count the number of files in the current directory by using pipes, is
Options: ls | wc,    ls -l | wc -l,    ls | wc -w,    ls | ws -c

Ans:C ,C

Gopal Krishna Gokhale
Options: started as a maths teacher and rose to the position of the principal of Ferguson College, Pune,    founded the servants of India Society,    served as President of the Indian National Congress in 1905,    All of the above


On a leased line installation a known good external modem shows no carrier detect light. Where is the problem most likely to be?
Options: In the modem,    In the phone line,    In the computer,    In the DTC equipment

Ans:B ,B

. internal command in Dos are
Options: a. Cls, rd label b. Dir, ren, sys c. Time, type, dir d. Del, disk copy, label

Ans:Correct Answer: c ,Correct Answer: c

4.Organizational measures
Options: (A)Extent to which a system or component complies with standards (B) Trustworthiness of operating the software. (C) Measures that estimates system cost to operate and maintain (D) None of these 27

Ans:274. (C),274. (C)

A memory bus is mainly used for communication between
Options: processor and memory,    processor and I/O devices,    I/O devices and memory,    input device and output device

Ans:A ,A

. Relationships between tables can be graphically viewed in the _______________ window.
Options: a. Design b. Joins c. Relationships d. Tables

Ans:4 – c ,4 – c

In a pure inductor:
Options: ac current leads the voltage by 90 degree,    ac current and voltage are exactly in phase,    ac current lags the voltage by 90 degree,    ac current is converted to dc voltage

Ans:C ,C

What invention caused many deaths while testing it?
Options: Dynamite,    Ladders,    Race cars,    Parachute


Human Rights Day is on
Options: 24 February,    10 December,    15 May,    21 July


1.The checking operation performed on input is called
Options: (A)validation of data (B) verification of data (C) vilification of data (D) control of data 4

Ans:41. (A),41. (A)

1.Scalability is
Options: (A)Avoiding catastrophic moment (B) Ease with which a system or component are modified to fit the problem area. (C) It is a bounded area of responsibility. (D) None of these 23

Ans:231. (B),231. (B)

0.A specialist in charge of the database of an organization select the best fit for answer
Options: (A)Database management approach (B) DBMS uses (C) Database administrator (D) Query language 6

Ans:60. (B),60. (B)