The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is…

135 views
The cell reference fro a range of cells that starts in cell B1 and goes over to column G and down to row 10 is…

(1) B1-G10 (2) B1.G10 (3) B1;G10 (4) B1:G10

Related questions

Which of the following is a group of one or more attributes that uniquely identifies a row?  (1) Key (2) Tuple (3) Determinant (4) Relation

An amplifier operating over the frequency range from 18 to 20 MHz has 10 kilo ohm input resistor. What is the r.m.s. noise voltage at the input to this amplifier if the ambient temperature is 27o C

State the principle of solar cell. What is necessity of series and parallel connection of solar cells.

State working principle of column type load cell and state its any four applications.

In the Bode plot of a unity feedback control system, the value of phase of G(jw) at the gain cross -over frequency is - 125°.. The phase margin of the system is (a) - 125° (b) - 55° (c) 55° (d) 125°

A signal other than the reference input that tends to affect the value of controlled variable is known as ?

If the range of an analog transducer is 0 to 10 V, then for a resolution of 5 mV, the bits of ADC will be _____.

In 8 bit successive approximation ADC, clock frequency is 1MHz and reference voltage is 10 V.Conversion time in µS for 5 V input is  A) 4 B) 8 C) 10 D) None of these

The number of cross -points needed for 10 lines in a cross-point switch which is full duplex in nature and there are no self connection is  A) 100 B) 45 C) 50 D) 90

For an 8 bit DAC, reference voltage is 10 V. If input to DAC starting from MSB is 10111100, output (in volts) is  A) 5.8 B) 6.4 C) 7.3 D) 8.2

The efficiency of a solar cell can be expected in the range : (A) 10 to 15 percent (B) 25 to 30 percent (C) 45 to 60 percent (D) 70 to 80 percent

For transmission line load matching over a range of frequencies, it is best to use a  (a) Balun (b) broadband directional coupler (c) double stub (d) single stub

While forming a Routh array, the situation of a row of zeros indicates that the system (a) has symmetrically located roots (b) is stable (c) is insensitive to variations in gain (d) has asymmetrically located roots

An ammeter has a current change of 0—5A and its internal resistance is 0.2 ohm. In order to Change the range to 0-25 A, wear need to add a resistance of  A) 0.8 ohm in series with the meter B) 1.0 ohm in series with the meter C) 0.04 ohm in parallel with the meter D) 0.05 ohm in parallel with the meter

Information that a computer produces and delivers back to the user is known as ____.  a) Input b) Output c) Both (a) and (b) d) None of the above

In a network, the computer that stores the files and processes the data is named as?  a) Terminal b) Modem c) Server d) None

The network layer, in reference to the OSI model, provide  (a) data link procedures that provide for the exchange of data via frames that can be sent and received (b) the interface between the X.25 network and packet mode device (c) the virtual circuit interface to packet-switched service (d) all of the above

Once SCR starts conducting a forward current, its gate losses control over (A) Anode circuit voltage only (B) Anode circuit current only (C) Anode circuit voltage and current (D) None of the above

In Print server which is a buffer that holds data before it is send to the printer.  (1) Queue (2) Spool (3) Node (4) Jobs

In a variable speed induction motor derive V/f kept constant over a wide range of its frequency variation. The motor operates in the following mode : -  a) Constant power mode b) Constant torque mode c) Constant slip mode d) Variable power and variable torque mode

A radioactive isotope has a half-life of 10 days. If today there are 125 g of it left, what was its original weight 40 days earlier  (a) 600 g (b) 1000 g (c) 1250 g (d) 2000 g

In a particular circuit connection, AWG 18 wire is selected over AWG 22. The reason is that it is having

____ is the software that controls all the other software programs and allows to perform basic tasks.  a) Software b) Hardware c) Windows d) Operating System

A voltage signal 10 Sinwt is applied to the circuit with ideal diodes, as shown in figure. The maximum and minimum values of the output waveform vout of the circuit are respectively

DC ammeter has a resistance of 0.1 Ω and its current range is 0-100 A. If the range is to be extended to 0-300 A, what shunt resistance need to be connected?  A) 0.025 Ω B) 0.05 Ω C) 0.015 Ω D) 0.03 Ω

Ripple in output current of a step-down chopper feeding RLE load is maximum, when duty cycle is equal to:  (1) 1 (2) 0.5 (3) 0.75 (4) 0.33

A data dictionary is a special file that contains  (1) The name of all fields in all files (2) Data types of all fields in all files (3) The width of all fields in all files (4) All of these

Row is synonymous with the term:  (1) record. (2) column. (3) relation. (4) field.

What is the nature of supply current in parallel RC circuit with reference to the voltage?  (A) In phase (B) Lags by 90 degree (C) Leads by 90 degree (D) Compensates and becomes zero

What is the best data type definition for Oracle when a field is alphanumeric and has a length that can vary?  (1) VARCHAR2 (2) LONG (3) CHAR (4) NUMBER

An energy signal has G(f) = 10. Its energy density spectrum is:  (1) 10 (2) 100 (3) 50 (4) 20

____ is a set of instructions, also called a program that tells a computer how to perform tasks.  a) Hardware b) Software c) Both (a) and (b) d) None of the above

A condition that led to the development of database was  (1) Demand for more data to support information needs (2) An increase in the amount of data handled by organizations (3) Proliferation of data files (4) All of these

In a microprocessor the service routine for a certain interrupt starts from a fixed location of memory which cannot be externally set but the interrupt can be delayed or rejected. Such an interrupt is

An iron cored inductance coil can be modelled, over a normal operating range of networks ,as A) non-Linear bilateral element B) linear bilateral element C) linear time varying element D) non-linear time invariant element

A 4-bit R/2R digital-to-analog (DAC) converter has a reference of 5 volts. What is the analog output for the input code 1010:  (1) 0.3125 V (2) 3.125 V (3) 0.78125 V (4) –3.125 V

Which of the following statements with reference to a generic microprocessor is correct?  a. Instruction cycle time period is exactly equal to machine cycle time period  b. Instruction cycle time period is shorter than machine cycle time period   c. Machine cycle time period is shorter than instruction cycle time period  d. Instruction cycle time period is exactly half of machine cycle time period

When The dc converter in figure shown has a resistance load of R = 10 Ω and the input voltage is Vs 220 V the converter switch remains on, its voltage drop is Vo -2 V. The chopping frequency is fI K sW Vs If the duty cycle is 50%, determine: (a) the average output voltage V (b) the RMS output voltage Vo (c) the converter efficiency (d) the effective input resistance of the converter

The transfer function of a phase lead compensator is found to be the form (s+z1 ) / (s + p1 ) and that of a lag compensator to be of the form (s+z2 ) / (s + p2 ). Then which of the following conditions must be satisfied?  (A) z1 > p1 and z2 > p2 (B) z1 > p1 and z2 < p2 (C) z1 < p1 and z2 < p2 (D) z1 < p1 and z2 > p2

If an energy meter disc makes 10 revolutions in 100 seconds when a load of 450W is connected to it, the meter constant in revolutions per kWh is  A) 1000 B) 500 C) 1600 D) 800

Three single phase transformers are connected in delta-delta to step down a line voltage of 138 kV to 4160 V to supply power to a production plant. The plant draws 21 MW at a lagging power factor of 86 %. Calculate the apparent power furnished by the HV line.  (A) 24.4 MVA (B) 48.8 MVA (C) 12.2 MVA (D) 6.1 MVA

In a step-up or step-down transformer, electrical power is transferred from one circuit to another without change in

Two metallic blocks having masses in the ratio 2:3 are made to slide down a frictionless inclined plane starting from rest position. When the blocks reach the bottom of the inclined plane, they will have their kinetic energies in the ratio : (A) 2:3 (B) 3:5 (C) 3:2 (D) 7:4

System 1 : The first column of the RH array consists of the terms 6,3,9,-2, and 4. System 2 : The first column of the RH array consists of the terms 3,6,9,2, and -4. The number of unstable poles for system1, and system 2, are respectively, (A) 1,1 (B) none, none (C) 2,2 (D) 2,1

You can copy cell formats from one cell to another by using the  (1) Backspace key (2) Default font (3) Format painter (4) Formatting toolbar