analysis-in – ms-excel – কুইজ মডেল টেস্ট অনুশীলন – 2

analysis-in – ms-excel – কুইজ মডেল টেস্ট অনুশীলন – 2

5108. When you see a cell with a red triangle in the top right corner, what does this signify?

1. A formula cannot be entered into the cell
2. The font color for text in the cell is red
3. There is a comment associated with the cell
4. There is an error in the cell

5109. What is an expression that tells how the numbers in a determined set of cells are to be calculated?

1. Field
2. Query
3. Formula
4. Data

5110. You can use drag and drop to embed excel worksheet data in a word document _________.

1. By displaying both applications side-by-side and dragging a selected range of Excel data into the word application window while pressing the Ctrl key
2. By dragging a range of excel data to the word button on the taskbar while pressing the Ctrl key
3. a and c
4. By dragging a range of excel data to the Word button on the taskbar while pressing Shift key

5111. What Pivot Table toolbar button updates the data in a Pivot Table or Pivot Chart report if the source data has changed?

1. Refresh Data
2. Show Detail
3. Pivot Table
4. Format Report

5112. To delete and embedded object, first _________.

1. Press the Shift + Delete keys
2. Select the object by clicking it
3. Select it and then press Delete key
4. Double click the object

5113. Which formula can add the all the numeric values in a range of cells, ignoring those which are not numeric, and place the resulting a different cell?

1. Average
2. Sum
3. Count
4. None of above

5114. Which of the following is a correct order of precedence in a formula calculation?

1. Addition and subtraction
2. positive and negative values
3. exponentiationNone of aboveMultiplication and division
4. exponential positive and negative valueMultiplication and division

5115. A _________ is a group of cells that form a rectangle on the screen.

1. Calculation
2. Formula
3. Range
4. Range address

5116. A data map is helpful _________.

1. When you have too much data to chart
2. To show a geographic distribution of data
3. To show changes in data over time
4. To compare data points

5117. To select several cells or ranges that are not touching each other, you would _________ while selecting

1. hold down Ctrl + Shift key
2. hold down the Shift key
3. hold down the Ctrl key
4. hold down the Alt key

আমাদের কাছে থাকা লক্ষ লক্ষ মডেল টেস্ট থেকে প্রাকটিজের জন্য কিছু এখানে তুলে ধরা হল। প্রতিটি অধ্যায়ের উপরে ইশিখন.কম কুইজ চ্যালেঞ্জ এ আছে শত শত মডেল টেস্ট বার বার মডেল টেস্ট দিয়ে নিজেকে যাচাই কর এবং পুরো বাংলাদেশের সকল শিক্ষার্থীর সাথে আপনার মেধা তালিকা দেখুন। প্রশ্নে কোন প্রকার ভুল থাকলে সঠিক উত্তরসহ নিচে কমেন্ট করে জানাবেন, আমরা ঠিক করে দেবো।