The cell reference for a range of cells that starts in cell C1 and goes over to column H and down to row 10 is

A C1:10H
B C1:H10
C C1:H-10
D C1:H:10

Correct Answer: C1:H10

Spreadsheet analysis প্রোগ্রামের সিটে কোনো একটি সেল থেকে অপর একটি সেল পর‌্যন্ত (কোনো সেল বাদ না দিয়ে) দেখাতে বা প্রকাশ করতে প্রথম সেলের Adress লিখে কোলন চিহ্ন ( : ) দিয়ে পরের সেলের Adress লিখতে হয়। যেমন, C কলামের 1 নং রো (Row) থেকে H কলামের 10 নং রো পর‌্যন্ত cell গুলোকে একসাথে দেখাতে C1 : H10 লিখতে হবে।
Bissoy MCQ
#তথ্য প্রযুক্তি #এক্সেল (MS Excel) #Bangladesh Development Bank Ltd #Bangladesh Development Bank Ltd - Senior Officer - 24.11.2017

Related Questions

-Column row+Column row+Column row এই ফরমূলা কিসের?
A ভাগ এর
B যোগ এর
C গুণ এর
D বিয়োগ এর
A brother and sister leave home for school. The brother goes 0.5 km East, then turns right and goes 3.5 km and reaches his school. The sister goes 2.5 km North, then 1 km West, then turns left and goes 6 km and reaches her school. Where is the brother's school with respect to the sister's school?
A 0.5 km East
B 1.5 km West
C 0.5 km West
D 1.5 km East
Which of the following data constraints would be used to specify that the value of a cell in one column must be less than the value of a cell in another column in the same row of the same table?
A A domain constraint
B A range constraint
C An intrarelation constraint
D An interrelation constraint
Nurse Kemp has worked more night shifts in a row than Nurse Rogers, who has worked five. Nurse Miller has worked fifteen night shifts in a row, more than Nurses Kemp and Rogers combined. Nurse Calvin has worked eight night shifts in a row, less than Nurse Kemp. How many night shifts in a row has Nurse Kemp worked?
A eight
B nine
C ten
D eleven
Which of the following column properties would be used to specify that cells in a column must contain a monetary value that is less than another monetary value in the same row?
A Null status
B Data type
C Default value
D Data constraints
Arif starting from x goes to Y. t the same time Boby starts from Y and goes towards X. Once Arif reaches Y, he changes his direction and returns to X. Once Boby reaches X, he changes his direction and returns to Y. Throughout the journey, Arif travels at 54 kmph and Boby travels at 72 kmph. By the time they meet for the second tike, boby covers 36 km more than Arif. Find the distance (in km) between X and Y.
A 72
B 84
C 96
D None
In a row, there are 12 professors between Akash and Bhumi and Akash being the first professor in the row. There are 6 professors between Bhumi and Charu. If there are 15 professors after Charu, then how many minimum professors are there in the row?
A 21
B 24
C 20
D 22
Ms. Forest likes to let her students choose who their partners will be; however, no pair of students may work together more than seven class periods in a row. Adam and Baxter have studied together seven class periods in a row. Carter and Dennis have worked together three class periods in a row. Carter does not want to work with Adam. Who should be assigned to work with Baxter?
A Carter
B Adam
C Dennis
D Forest
In a row of children facing north, Mita is third to the right the right of Amir. Ravi is fifth to the left of Mita and twentieth from the left end. Amir's position is seventeen from the right end of the row. How many children are there in the row?
A 39
B 37
C 38
D 41
Which of the following refers to a cursor type that when the cursor is opened, a primary key value is saved for each row in the recordset; when the application accesses a row, the key is used to fetch the current values of the row?
A Forward only
B Static
C Keyset
D Dynamic

Next steps