Which of the following can be a cell reference that starts in cell B1, column G and selects row 10?

B1-G10
B1.G10
B1;G10
B1:G10
None of these

LohaHridoy

5 views

2025-01-04 04:42

1 Answers

AhmedNazir

Option 4 : B1:G10

Cell References: There are 16384 rows and 256 columns in one worksheet. The first cell is labeled as A1 (column as A and row number as 1).

The cell reference is given in the format as “Starting cell:ColumnRow” so a cell starting in B1 with column G and row 10 will be given as “B1:G10” in Microsoft excel.

Types of Cell Reference:

Relative: This refers to the cell relative to the given position.
Absolute: This refers to the specific cell irrespective of the position of the formula. The '$' sign is used to denote an absolute reference.
Mixed: It is a combination of both relative and mixed references. It has one absolute co-ordinate and one relative co-ordinate. $D1 and D$1 are both examples of mixed references.

5 views Answered 2022-09-04 04:29

Related Questions

In the following question, 2 columns are given containing three phrases/ sentence each. In the first column sentences A, B, C and in the second column D, E, F are given. A sentence from the first column may or may not connect with another sentence/ phrase from the second column to make a grammatically and contextually correct sentence. Each question has five options, four of which display the sequences of the sentences. If none of the above is the answer, then mark option (e) as the answer. Column 1 Column 2 A. There is no country in the world D. to maintain the nitrogen calcium ratio B. The Prime Minister said on Monday E. that has not suffered from terrorism C. As the results were out F. culture is deprived?

1 Answers 6 Views

Given below are three quantities named 1, 2 and 3. Based on the given information, you have to determine the relation between the three quantities. You should use the given data and knowledge of Mathematics to choose between the possible answer. Quantity 1: Manish can row at a speed of 4.5 km/h in still water and rows to a certain upstream point and back to the starting point in a river which flows at 1.5 km/hr. Find his average speed for total journey. Quantity 2: A man can row 6 km/h in still water. It takes him twice as long to row up as to row down the river. Find the rate of stream. Quantity 3: The rate of flow of river water is 4 km/h. A boat goes up 6 km and back to the starting point in 2 hour. Find the speed of the boat in still water.?

1 Answers 5 Views

In the following question, 2 columns are given containing three phrases/ sentences each. In the first column sentences A, B, C and in the second column D, E, F are given. A sentence from the first column may or may not connect with another sentence/phrase from the second column to make a grammatically and contextually correct sentence. The question has five options, four of which display the sequences of the sentences. If none of the above is the answer, then mark option (e) as the answer. Column 1: Column 2: A. The heavy rains in Mumbai D. is considered an act of kindness B. The school across the lane E. was tortured for the rest of his life C. Catering to the needs of poor people F. have flood the banks of the country?

1 Answers 5 Views

In the following question, 2 columns are given containing three phrases/ sentences each. In the first column sentences A, B, C and in the second column D, E, F are given. A sentence from the first column may or may not connect with another sentence/phrase from the second column to make a grammatically and contextually correct sentence. The question has five options, four of which display the sequences of the sentences. If none of the above is the answer, then mark option (e) as the answer. Column 1: Column 2: A. The rising terrorism in some places D. Is the breeding place for germs B. Stagnant water E. Has inspired many people C. You must study hard F. Is hurting the sentiments of women?

1 Answers 4 Views

In the following question, 2 columns are given containing three phrases/ sentences each. In the first column sentences A, B, C and in the second column D, E, F are given. A sentence from the first column may or may not connect with another sentence/phrase from the second column to make a grammatically and contextually correct sentence. The question has five options, four of which display the sequences of the sentences. If none of the above is the answer, then mark option (e) as the answer. Column 1: Column 2: A. It is the duty of the government D. To safeguard the rights of its citizens B. The children in our neighbourhood E. Are late for the financial year. C. The Indian monsoon F. Are enjoying their summer break from school?

1 Answers 5 Views

In the following question, 2 columns are given containing three phrases/ sentences each. In the first column sentences A, B, C and in the second column D, E, F are given. A sentence from the first column may or may not connect with another sentence/phrase from the second column to make a grammatically and contextually correct sentence. The question has five options, four of which display the sequences of the sentences. If none of the above is the answer, then mark option (e) as the answer. Column 1 Column 2 A. Blowing the horn loudly in front of a school D. Every trees dirty B. The pollution has made E. Is strictly forbidden by law C. The old man was rushed to the hospital F. After the movie was a hit at the premier?

1 Answers 5 Views

During a party, a game is being played. For the game 9 people from A to I (mix of boys and girls) have to stand in vertical row. Boys are wearing Red t-shirts and girls are wearing Pink t-shirts. The row starts with pink t-shirt. Boys and girls stand alternately in the row. Each position in the row can occupied by one person only 1) A stands seven places before B. 2) Third pink t – shirt is C. 3) Second boy after C is D. 4) Fourth place in the row is occupied by E. 5) F stands ahead of A. 6) G stands between C and A 7) I is girl Which of the following is a pair of boys?

1 Answers 8 Views

Which of the following represents correct matching of the different vitamins in column A with their functions in column B Column A Column B (a) Vitamin A (i) Helps body to use calcium for bones and teeth (b) Vitamin C (ii) Keeps our skin and eyes healthy (c) Vitamin D (iii) Helps body to fight many diseases (d) Vitamin B (iv) Proper functioning of body cells and maintaining health?

1 Answers 5 Views

Which of the following represents correct matching set A Power house of cell i) Cell membrane B Store house of cell ii) Nucleus C Information centre of cell iii) Mitochondria D Gate keeper of cell iv) Chloroplast v) Vacoule?

1 Answers 5 Views

In the following question, two columns are given containing three phrases each. In the first column phrases are A, B, and C and in the second column, the phrases are D, E, and F. A phrase from the first column may or may not connect with phrase from the second column to make grammatically and contextually correct sentence. There are five options, four of which display the sequence(s) in which the phrases can be joined to form a grammatically and contextually correct sentence. If none of the options forms a correct sentence after combination, select ‘None of these’ as your answer. Column 1 Column 2 A. A cable car taking visitors to a mountaintop view of some of northern Italy’s D. relatively rare but doctors suspect that the sudden increase in the infection could further complicate India’s fight against the pandemic. B. Scientists have unearthed a 43-million-year-old fossil of an extinct E. products claiming to be cures and preventions are on the rise. C. China reopened a key terminal at the world's third-busiest cargo, after a shutdown to F. four-legged whale that once lived both on land and in the sea, making it amphibious.?

1 Answers 4 Views

এক্সাম দিয়ে মেধা যাচাই করুন

Job Preparation (1125)

Admission (754)

এসএসসি (10)

এইচএসসি (5)