স্প্রেডশীট ক্যুইজ বোঝা ? Understanding Spreadsheets Quiz

স্প্রেডশীট ক্যুইজ বোঝা ? 

Understanding Spreadsheets Quiz

এই সফ্টওয়্যারটি সফ্টওয়্যার সুইট সিরিজের অংশ, বোঝার স্প্রেডশিটস কোর্সের সামগ্রীর আপনার জ্ঞান পরীক্ষা করার জন্য ডিজাইন করা হয়েছে। এই কুইজ আপনার স্প্রেডশীট দক্ষতা উন্নত করার জন্য ডিজাইন করা হয়।

This quiz is designed to test your knowledge of the contents of the Understanding Spreadsheets Course, part of the Office Software Suite series. These quizzes are designed to improve your Spreadsheet skills.

সেখানে বিশ প্রশ্ন আছে। পাস চিহ্নটি সম্ভাব্য 100 পয়েন্টের মধ্যে 70 টি, প্রতিটি প্রশ্নের জন্য 5।

There are twenty questions. The pass mark is 70 out of a potential 100 points, 5 for each question.

একবার আপনি আপনার উত্তরের সাথে সন্তুষ্ট হয়ে গেলে, আপনার নাম এবং ইমেল ঠিকানাটি পূরণ করুন এবং আপনার উত্তরগুলি চিহ্নিত করার জন্য "ক্যুইজ জমা দিন" নির্বাচন করুন।

Once you are satisfied with your answers, complete your name and email address and select “Submit Quiz“ to have your answers marked.

আপনি শীঘ্রই আপনার স্কোর সম্পর্কে পরামর্শ দেওয়ার জন্য একটি ইমেল পাবেন, আপনি কুইজটি পাস করেছেন কিনা এবং আপনার উত্তরগুলি কীভাবে স্কোর করা হয়েছে। এটি আপনার বিনামূল্যে অনলাইন প্রশিক্ষণ কোর্স যথাযথ ক্যুইজ জন্য কুইজ সমাপ্তি সার্টিফিকেট অন্তর্ভুক্ত করা হবে।

You will shortly receive an email advising you of your score, whether you have passed the quiz, and how your answers have been scored. It will also include your Free Online Training course quiz completion Certificate for the appropriate quiz.

1.What is the shortcut keyboard command for selecting the entire worksheet?

 ctrl + R

 ctrl + S

 ctrl + F

 ctrl + A

2.In LibreOffice Calc, which tool can be used to make incremental data entries into a spreadsheet?

 Auto Fill Tool

 None of these.

 Both Paste Special and Auto Fill Tool

 Paste Special Tool

3.Which of the following is not good practice when entering data to the cells of a spreadsheet in LibreOffice Calc?

 Each cell should contain only one element of data

 A blank row should not be inserted before the total row

 The cells bordering a list should be blank

 The main body of a list should not contain any blank rows or columns

4.Which of the following basic options/preferences can be set in the LibreOffice Calc application?

 Default data entry for spreadsheet files

 Default folder to open/save spreadsheets

 Default size of the spreadsheet files

 None of these.

5.In LibreOffice Calc, the logical function ‘If’, takes how many arguments?

 None of these.

 4

 3

 2

6.Which of the following error code signifies that the column, row or sheet for the referenced cell is missing?

 #Div/0!

 None of these.

 #REF!

 #Name?

7.To insert a new column into a spread sheet, we need to right-click on the column header to the right of which we want to insert a new column, and from the resulting menu we need to click on ‘Insert Columns Right’.

 False

 True

8.When working with worksheets, we should just accept the default names for the new worksheets instead of changing the names as it saves us time and does not make much of a difference.

 True

 False

9.When we enter a text value in a cell in LibreOffice Calc, then these are by default……

 Centre Aligned

 No Default Setting

 Right Aligned

 Left Aligned

10.The ‘COUNT’ function from the ‘Statistical’ category in LibreOffice Calc counts how many values are present in the argument list. This function counts the number of all kinds of values present in the argument list, be it numbers or text or any other.

 True

 False

11.The undo command undoes the effect of the recent changes which were made to the document in such a way so that the most recent change is undone in the end.

 False

 True

12.Which among these is not a chart type available in LibreOffice Calc?

 3D Chart

 Column and Line Chart

 Pie Chart

 4D Chart

13.Which of the following cannot be changed when a spreadsheet is saved?

 File size

 Name

 File Type

 Location

14.In Calc, freezing locks a number of rows at the top of a spread sheet or a number of columns on the left of a spread sheet or both rows and columns. Then, when moving around within a sheet, the cells in frozen rows and columns always remain in view.

 False

 True

15.It is possible to hide/display the different types of toolbars which are displayed at a time in LibreOffice Calc.

 False

 True

16.Which of the following is an acceptable syntax for absolute cell referencing in LibreOffice Calc?

 =b4+b6

 =b4+b$6

 =b4+$b$6

 =b4+$b6

17.In LibreOffice Calc, for the ‘ROUND’ function from the ‘Mathematical’ category, if the ‘number’ selected from a cell is ‘1006.5555’ and the ‘count’ given is 2, then the result will be ….

 1006

 1006.56

 1006.54

 1006.55

18.Which of the following error code signifies no valid reference for an argument?

 #Name?

 #REF!

 #Div/0!

 None of these.

19.When using functions and formulas in LibreOffice Calc, it is always better to enter cell references rather than typing numbers directly into the formulas.

 True

 False

20.Which among these tools is most commonly used to copy the formatting from a cell or a cell range to another cell or cell range?

 Paste Special Tool

 Text Wrap Tool

 Paste Tool

 Cell Formatting Tool

Be sure to click Submit Quiz to see your results!