Bissoy.com
Doctors Medicines MCQs Q&A

The symbol '$' in MS excel is used for _________ the cell

The symbol '$' in MS excel is used for _________ the cell Correct Answer Fixing

MS Excel - এ কোনো Cell - এর অন্য Formula অন্য Cell - এ কপি করা মাধ্যমে পূর্বের Cell - এর ডেটার যে কোনো পরিবর্তন পরের Cell - এ সরাসরি প্রদর্শন করানো যায়। এভাবে একাধিক Cell - এর মধ্যে লিংক (fixing) করানোর সময় column ও row reference - এর সাথে $ চিহ্ন ব্যবহৃত হয়। যেমন A1 - A$1 বা $A$1।

Related Questions

In an MS-Excel sheet, cell A1 contains 5, A2 contains 6, and cell A3 contains the formula = A1 + A2. The formula in cell A3 is copied into cell B3 by dragging. Which of the following will be the result (output) displayed in cell B3?
Column A lists the cell parts and Column B lists the functions of the cell part. Column A Column B i. Cell wall A. Control what happens ii. Cell membrane B. Supports the cell. iii. Cytoplasm C. Controls what passes in and out of the cell. iv. Nucleus D. Cell reactions happen in it. Which one of the following options is correct?
Which of the following statements is/are FALSE? (i) In MS-Excel, intersecting grid of a row and column is called cell. (ii) In MS-Excel, the address of any cell starts with "A‟. 
Which of the following statement is CORRECT in order to select the group of cell in MS Excel? i) Select a cell, Hold Shift Key and Select the final cell ii) Drag the cells with mouse iii) elect a cell, Hold shift key using Arrow keys
Which of the following statements is/are TRUE? (a) The grammar S → SS | a is ambiguous. (Where S is the start symbol) (b) The grammar S → 0S1 | 01S |e is ambiguous. (The special symbol e represents the empty string) (Where S is the start symbol) (c) The grammar (Where S is the start symbol) S → T / U T → x S y | xy | ϵ U → yT generates a language consisting of the string yxxyy.
In an imaginary mathematical system, symbol '–' stands for addition, symbol '+' stands for division, symbol '×' stands for subtraction, and symbol '÷' stands for multiplication. All other rules of mathematics are the same as in the existing system. What is the value of the following expression? 240 × 72 + 8 ÷ 24 – 6
Availability of drinking water is continuously decreasing. The government decided to identify those sources of drinking water which getting polluted. The following table depicts the number of polluted sources in a district. Source of drinking water getting polluted Number Wells 24 Handpump 12 Dam 12 Borewell 6 Ponds 18 The pictograph table for the above table will be (A) Source of drinking water getting polluted Number symbol = 6 source Wells Handpump Dam Borewell Ponds (B) Source of drinking water getting polluted Number symbol  = 6 source Wells Handpump Dam Borewell Ponds (C) Source of drinking water getting polluted Number symbol  = 6 source Wells Handpump Dam Borewell Ponds (D) Source of drinking water getting polluted Number symbol  = 6 source Wells Handpump Dam Borewell Ponds
Suppose the A1 cell of an MS-Excel worksheet contains the formula " =C5+A4". If A1 cell is copied and pasted into D5 cell, then what will be formula in D5?
Which of the following represents correct set of the cells and their shapes in human beings A Nerve cell i) flat shaped B Red blood cell ii) disc shaped C White blood cell iii) long and thin D Muscle cell iv) changing shapes E Skin cell v) long and branched
Which of the following statements are correct regarding the general difference between cell and nuclear membranes? 1. A cell membrane occurs in both Eukaryotes and Prokaryotes while a Nuclear membrane occurs only in Eukaryotes.  2. Both cell membrane and nuclear membrane persists throughout the lifetime of a cell. 3. The main feature of the nuclear membrane is the presence of two lipid bilayer structures while a cell membrane has single lipid bilayer structures. Select the correct answer using the code given below.