Videos

This is default featured slide 1 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 2 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 3 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 4 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

This is default featured slide 5 title

Go to Blogger edit html and find these sentences.Now replace these sentences with your own descriptions.This theme is Bloggerized by Lasantha Bandara - Premiumbloggertemplates.com.

How To Install LibreOffice

LibreOffice is an Open Source office suite that works in almost all major computing platforms. The applications in the suite include a word processor Writer, a spreadsheet manager Calc, a presentation creator Impress, a drawing tool draw, a formulae creator Math and a database management system Base. This free and light office program is available in over 110 languages and is the first choice for open source enthusiasts.
LibreOffice package is available in two different versions – “fresh” and “still”. The “fresh” version consists of the latest enhancements that have been made since the latest release and the “still” version is for people who want to operate in an older yet more stable environment. In this tutorial, we would be seeing the installation procedure of the LibreOffice fresh version 4.3.5 for Windows. But before we can begin, we need to know the software and hardware prerequisites.
  • Operating system: Microsoft XP SP2, Vista, Windows 7 or Windows 8.
  • Processor: Pentium III or Athlon or more recent system-recommended processor.
  • RAM: A minimum of 256 MB, but we would recommend using a 512 MB.
  • Disk space: A maximum of 1.5 GB is needed.
  • Monitor resolution: 1024×768 with at least 256 colors; higher resolution is recommended
  • For some programs, especially Base, Java is required.
  • Administrator privilege is required.
As good practice, we would recommend you backup all your data before you begin the installation of any software.
The installation procedures are simple and straightforward. Follow these steps with me.
I am using Google Chrome Browser on Windows 8.1. If you have a different configuration the first part of this tutorial may look slightly different.
Step 1:
Download the latest LibreOffice package from here and save it in a directory on your system. If you already have the setup file of the package in your system, then double-click it.
Step 2:
When the setup file starts, you will be getting a dialog box asking if this file can be run in your system. Press “Run”
Step 3:
The setup file begins to run in your system and in a minute a welcome dialog box would pop in your screen. Press “Next”.
Step 4:
The next step involves you selecting the mode of installation- typical or custom. “Typical” mode will install the package with the default setting and configurations while the “Custom” mode lets you set program features that you want to be installed.
Step 5.1:
If you choose the “Typical” mode of installation you would be straightaway directed to the “Installation Wizard”. Check the relevant options for you and press “Install” for the installation to start.
The installation will begin right away in the “Typical” mode.
Step 5.2:
If you choose “Custom” mode of installation, you would be looking at custom setup dialog box asking you to choose optional components and the language packs.
Click on the dropdown arrow near the icon and select the type of installation of the components. There are some components that are installed by default. You can choose to not install it by the setting the icon to the red cross as shown in the picture. For example, you can expand the dictionaries module and can select the languages you want.
In the same step, you can select the additional user interface language. By default, the package will have English and the language of the operating system as interface languages. You can select more or remove one of them as per your preference.
As you can see in the description to the left, when you select a component or the language you want to install, the wizard will automatically calculate the amount of space required to install that particular component in your hard disk. When you are done with the selection of languages, continue with the installation by pressing “Next”.
Step 5.3:
The next step will open up a dialog box asking if you want to set LibreOffice as the default office program. It means that, if you check “Microsoft Word Documents”, you will open a Word document in LibreOffice. By default, all the boxes will be unchecked. After choosing, press “Next”.
You will be getting the dialog box mentioned in Step 5.1 after all the customization. Check the appropriate boxes and click “Install”.
Step 6:
Step 6 involves waiting. The installation would begin and depending on the speed of your computer this may take several minutes.
Step 7:
If you get this dialog box, then your installation is successful and complete. Click “Finish” and start working on your projects using the all new LibreOffice.
Share:

Office Productivity Software

Computers could be considered as the biggest invention of the 20th century. This Technology Era has removed so many obstacles and pushed boundaries much farther. You can love it or hate it, but they have invaded our present and would continue to expand in the future. From simple computing operations to robotic science, much of mankind’s progress till date could be attributed to computers and its related technologies. The functionalities of the computers have grown leaps and bounds and we are discovering new necessities every passing day. This machine has a great impact in advancements of every field that we cared to venture upon. Several tasks that were considered as uphill and mundane before are reduced to a matter of just-a-few-clicks now. One such development that made this dream possible for human beings is the productivity software.
The Productivity software, often called as Office Suite, is an application program that is programmed to make operations related to creating and processing of information much easier. We can now manage huge amount of data and perform a variety of operations in just a few seconds. With many million downloads a day and so many office programs in the market, there is no dearth in the availability of options. Let us dive deeper and know more about office software’s functions and how it has managed to make our lives easier.

The multi-faceted program

Office Suites can perform an array of operations, each with many dimensions, thus providing you all the solutions for your office needs. A few programs such as Word Processors, Spreadsheets and Presentation creators are used widely than other programs like mailer, database software, note-takers, project management software etc. These programs have cross-linking and sharing capabilities which make them so powerful and efficient.
The Word Processor is a program such as Microsoft Word, iWork Pages, Google Docs etc. that lets you create a document with pictures, hyperlinks and graphics. It offers you full freedom to customize the layout, fonts, size etc.; helps you to correct the grammar and spelling mistakes in the documents; provides you with suggestions from dictionary and thesaurus and allows you to save in many formats to run across many platforms. Advanced word processors help multiple users to edit a single document at the same time, help to create table of contents, provide version control for a document and so on. The Word Processors are widely used by authors, editors, copy writers, and students for their everyday works.
The Spreadsheet is intelligent software that typically has many sheets with thousands of rows and columns. The main purpose of a spreadsheet is to allow a user to record and analyze data in a tabular format. These spreadsheets have made accounting and other calculations easier with their built-in formulae. All you have to do is enter data, choose a row for your answer and select the formula that you want to apply. Advanced spreadsheets allow users to enter their own formulae to scale its functions. We can also compare the data entered and produce an analysis report with a variety of graphs and charts. A spreadsheet is capable of much more functionalities that make it one of the best tools for an organization. This software is especially useful for data analysts and accountants. Examples of spreadsheets are Microsoft Excel, Google Sheets, and iWork Numbers etc.
Presentation programs are designed to project your thoughts in a more intuitive and elegant way. This program has built-in layouts for slides that you can fill with the information you intend to present with pictures, graphs and animations. This software is very useful to create an effective visual aid for the students to learn. For businesses, this tool has become a necessity during meetings and brain-storming sessions. The presentations can be also be loaded with audio clippings and flash animations. When your presentation is equipped with interactive integrated hardware elements, you can project your information across many geographic locations.
The other products of productivity suites like email clients, desktop publishing software and personal information managers etc. are used by specific set of people for their business or academic requirements. The mailer software is used for sending and receiving of emails – from small groups to big enterprises. Note-taking programs are used to create and maintain notes from various sources. It also allows editing, analyzing and sharing of the notes. There are so much more programs that are tailored for personal use, thanks to the open source network.

The Audience

These office programs are particularly beneficial for the so-called “Knowledge Workers”. The knowledge workers can be students, doctors, engineers, data analysts, inventors or coders. This group consists of people from many streams of life whose day-to-day work involves processing of information. These programs evolve in order to meet the new challenges that they are exposed to everyday, thereby reducing time and increasing the efficiency. They need data and they need it in the way they can easily understand and process. These office suites are designed with them as the target beneficiaries.
Another group of users are the businessmen. They need information everyday to introspect and grow. In the age where information is considered to be the wealth, no wonder they consider these programs as God-sent. They use many office programs such as spreadsheets, presentation, note-taker etc. The dynamic nature of their industries goes well with the dynamic capabilities of these applications.

The Future

With the technology moving towards smaller and more compact models, smart phones and tablets have almost replaced the computers. Subsequently, these application programs are designed to work effortlessly in all these platforms. With many new service providers entering the market every day, the necessity to scale and fit has become inevitable for every technology. Another major enhancement that has been recently added to all these programs is the cloud-share capability for storing and sharing of information on the go. While we cannot accurately predict the next big thing in this industry, we can still say that we are equipped with technologies that can evolve, fit and work efficiently in any given scenario.
Share:

Office

Not so long ago people used pens and papers to create documents; manually calculated and tallied the expenditure statements; drew meticulously in OHP sheets for presentations? The development and popularity of office productivity programs has completely revolutionized the way offices function and has almost made the methodologies adopted a couple of decades back obsolete. The multi-dimensional functionalities of these application programs have made them a necessity for every kind of industry.

From the day of there inception as a tool for office administration, these programs have been refined, restructured and written over and over again to meet the growing demands. Probably, Microsoft’s office has been the winner by and large; but it hasn’t stopped its competitors from coming up with programs that are equal and in some cases superior in functionality. Here we will discuss the four main players in the market by mentioning their top features and the ways in which one is more suitable than the others.

Office:

MS OfficeMicrosoft Office is the most popular productivity suite with over 500 million users worldwide. It is compatible with both Windows and Mac operating systems. The Office 365 service is the non-PC, cloud based version of Office and it allows you to operate the application program in phones, tablets and iPads. The most used programs in the Office’s arsenal are Word, Excel, PowerPoint and Outlook. The abundant formatting options in Word, alluring designs in PowerPoint and the robust functionalities of Excel has definitely made office operations much easier.
However, this closed-source package has certain limitations like poor support for importing many graphics formats, layout problems in Word, lack of support for spreadsheet comparison, no auto-completion in Excel and the absence of work-around for XHTML or HTML conversion in PowerPoint, to name a few. Also, this application program is not free. Although The complete Microsoft Office Package is offered at a discount for student edition the full priced commercial edition is outside many peoples budget. Office 365’s package offers a monthly or yearly subscription. Also, you need a subscription to use Office 365 in Android and iOS devices.
Weighing up the functionality and the shortcomings, Microsoft’s office is clearly best suited for offices, commercial enterprises and schools that require high-level functionality and want to seamlessly manage their works across mobiles, PCs and tablets.

iWork:

iWorkiWork is Apple’s answer to Microsoft’s office. It is an Apple proprietary product that is built to run only in MAC operating system. iWork boasts of providing an intuitive user interface that is as simple as it can get. The easier menu and formatting options are a boon for people who have just started to learn about these programs. Pages is a much cleaner and simpler Word Processor program that has all the layouts and formatting options required to create and maintain documents. The MS Excel equivalent of iWork is Numbers which has similar functionality to Excel put together with complete control over the fonts and design used. Keynote is the presentation program of iWork that possesses rich designs, better animations and audio-video integration. The biggest advantage of them all is it is free for people owning a MAC device.
The main problem while operating in iWork is the lack of compatibility of the file types. It is difficult to open or save an Office document in iWorks without importing or exporting certain functions. Unfortunately, this is as difficult as it sounds. There is this danger of a few components of the original documents disapearing during this transition. Because iWork has a smaller ecosystem as compared to Office, this might be a big problem in the longer run.
pages As mentioned earlier, iWork does everything that Office does with much more clarity and simplicity. If you are a MAC user and your needs are limited to only medium range of functionality then iWork could be the choice for you.

Google Docs:

Google DocsGoogle came with an application suite solution known as Google Drive that lets you create and manage your works online. Google Drive is a whole package with individual apps – Docs for word processing, Sheets for spreadsheet functionality and Slides for presentations. All these applications run together in the Google Drive ecosystem. The biggest advantage of this package is all that you need is a Google account to access all these applications. It is free, it is online and it can be operated from almost anywhere. The capabilities of Docs, Sheets and slides for various operations are as competent as iWorks or Office but with limited sophistication. The sharing option allows you to share your documents or spreadsheets anywhere across the globe almost instantaneously. Google Drive also provides other features like form tool that allows you to build an online survey that stores results in a spreadsheet, create PDFs, fax documents etc.
But one major aspect that we need to worry about working in Google Drive is that you should be online, at least for creating a new document. While there are options available to edit your works offline, you would still need an internet connection for synchronization. So this would be a disadvantage when all you have is a stand-alone PC. So Google Drive is best suited when you want the information to be processed immediately and to be shared on the fly.

LibreOffice:

Libre OfficeLibre Office is a free and open-source application program. It is the forked version of OpenOffice with programs to cover all the functionality of Microsoft Office. Libre Office is available in over 110 languages and is slowly gaining popularity. Being an open-source program, this is considered as one of most sophisticated office suites available. It is available across Windows, Mac and Linux platforms and it has the capability to run on USB flash disks without any installation. The word processor in Libre is known as Writer; spreadsheet tool is known as Calc and the presentation tool is Impress. The functionality of these tools are akin to that of its Microsoft or Apple equivalents and in some cases, even better.
Being built in an open source environment has its short-comings. The presentation app has only a few themes and the customizable tool bars doesn’t adjust to your most-frequented options like it does in MS office. Libre office is suitable for tech-savvy people who strongly believe in the open source system.
Share:

স্প্রেডশীট ক্যুইজ বোঝা ? 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?
 
 
 
 
2.In LibreOffice Calc, which tool can be used to make incremental data entries into a spreadsheet?
 
 
 
 
3.Which of the following is not good practice when entering data to the cells of a spreadsheet in LibreOffice Calc?
 
 
 
 
4.Which of the following basic options/preferences can be set in the LibreOffice Calc application?
 
 
 
 
5.In LibreOffice Calc, the logical function ‘If’, takes how many arguments?
 
 
 
 
6.Which of the following error code signifies that the column, row or sheet for the referenced cell is missing?
 
 
 
 
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’.
 
 
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.
 
 
9.When we enter a text value in a cell in LibreOffice Calc, then these are by default……
 
 
 
 
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.
 
 
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.
 
 
12.Which among these is not a chart type available in LibreOffice Calc?
 
 
 
 
13.Which of the following cannot be changed when a spreadsheet is saved?
 
 
 
 
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.
 
 
15.It is possible to hide/display the different types of toolbars which are displayed at a time in LibreOffice Calc.
 
 
16.Which of the following is an acceptable syntax for absolute cell referencing in LibreOffice Calc?
 
 
 
 
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 ….
 
 
 
 
18.Which of the following error code signifies no valid reference for an argument?
 
 
 
 
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.
 
 
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?
 
 
 
 

Be sure to click Submit Quiz to see your results!
Share:

একটি ওয়ার্কশীট প্রাকদর্শন ? Preview a worksheet

একটি কর্মশালার পূর্বরূপ দেখতে, প্রধান মেনু বার থেকে 'ফাইল' এ ক্লিক করুন এবং ফলস্বরূপ ড্রপ-ডাউন মেনু থেকে 'মুদ্রণ পূর্বরূপ' এ ক্লিক করুন। এটি নীচের দেখানো হয়েছে এমন ওয়ার্কশীটের পূর্বরূপ প্রদর্শন খুলবে। পূর্বরূপ বন্ধ করতে 'বন্ধ পূর্বরূপ' ক্লিক করুন।
To preview a worksheet, click on ‘File’ from the main menu bar and from the resulting drop-down menu, click on ‘Print Preview’. This will open the preview display of the worksheet as has been shown below. To close the preview, click on ‘Close Preview’.
Print Preview

একটি ওয়ার্কশীট, একটি সম্পূর্ণ ওয়ার্কশীট, একটি ওয়ার্কশীটের কপি সংখ্যা, সমগ্র স্প্রেডশীট, একটি নির্বাচিত চার্ট থেকে একটি নির্বাচিত ঘর পরিসর মুদ্রণ করুন।

Print a selected cell range from a worksheet, an entire worksheet, number of copies of a worksheet, the entire spreadsheet, a selected chart.

একটি কার্যপত্র মুদ্রণ করতে, প্রধান মেনু বার থেকে 'ফাইল' এ ক্লিক করুন এবং ফলাফল মেনু থেকে 'মুদ্রণ' এ ক্লিক করুন। এটি 'মুদ্রণ' ডায়লগ বক্স খুলবে। এই কথোপকথনে, 'সাধারণ' ট্যাবে, আমাদের 'রেঞ্জ এবং কপি' এর অধীনে কিছু বিকল্প রয়েছে।
To print a worksheet, click on ‘File’ from the main menu bar and from the resulting menu, click on ‘Print’. This will open the ‘Print’ dialog box. In this dialog, under the ‘General’ tab, we have certain options under ‘Range and Copies’.
ওয়ার্কশীট থেকে কেবল একটি নির্বাচিত ঘর পরিসর মুদ্রণ করতে, 'মুদ্রণ' ডায়ালগ বক্সটি খুলার আগে প্রয়োজনীয় ঘর নির্বাচন করুন এবং তারপরে ডায়লগ বাক্সে 'রেঞ্জ এবং কপি' এর অধীনে 'নির্বাচিত ঘর' রেডিও বাটনটি নির্বাচন করুন। এর পর, 'ওকে' ক্লিক করুন। এই শুধুমাত্র নির্বাচিত কোষ মুদ্রণ করবে।
To print only a selected cell range from the worksheet, select the required cells before opening the ‘Print’ dialog box and then in the dialog box, select the ‘Selected cells’ radio button under ‘Range and Copies’. After this, click on ‘OK’. This will print only the selected cells.
একটি ওয়ার্কশীট মুদ্রণ করতে, 'রেঞ্জ এবং কপি' এর অধীনে 'সিলেক্টেড শীটস' রেডিও বাটন নির্বাচন করুন এবং 'ওকে' ক্লিক করুন। এটি শুধুমাত্র বর্তমান ওয়ার্কশীট মুদ্রণ করবে।
To print a worksheet, simply select the ‘Selected sheets’ radio button under ‘Range and Copies’ and click on ‘OK’. This will print only the current worksheet.
পুরো স্প্রেডশীটটি মুদ্রণ করতে 'রেঞ্জ এবং কপি' এর অধীনে 'সমস্ত শীট' নির্বাচন করুন এবং তারপরে 'ওকে' ক্লিক করুন। এটি পুরো স্প্রেডশীটটি মুদ্রণ করবে।
To print multiple copies of a worksheet, select the value of copies to be required under ‘Number of copies’ and then click on ‘OK’. This will print the required number of copies.
পুরো স্প্রেডশীটটি মুদ্রণ করতে 'রেঞ্জ এবং কপি' এর অধীনে 'সমস্ত শীট' নির্বাচন করুন এবং তারপরে 'ওকে' ক্লিক করুন। এটি পুরো স্প্রেডশীটটি মুদ্রণ করবে।
To print the entire spreadsheet, select ‘All sheets’ under ‘Range and Copies’ and then click on ‘OK’. This will print the entire spreadsheet.
Print copies
চার্ট মুদ্রণ সক্ষম করতে, প্রধান মেনু বার থেকে 'বিন্যাস' এ ক্লিক করুন এবং ফলস্বরূপ ড্রপ ডাউন থেকে 'পৃষ্ঠা' এ ক্লিক করুন। এটি 'পৃষ্ঠা শৈলী' ডায়লগ বক্স খুলবে। এখানে, 'শীট' ট্যাবের অধীনে আমাদের একটি 'মুদ্রণ' নামক একটি বিভাগ রয়েছে। এই বিভাগের অধীনে আমাদের একটি 'চার্ট' চেকবক্স রয়েছে। চার্ট মুদ্রণ সক্ষম করতে এই বক্সটি চেক করুন এবং এটি নিষ্ক্রিয় করতে অচিহ্নিত করুন। আমরা ক্যালক এ চার্ট মুদ্রণ নিয়ন্ত্রণ করতে পারেন।
To enable the printing of charts, click on ‘Format’ from the main menu bar, and from the resulting drop-down click on ‘Page’. This will open the ‘Page Style’ dialog box. Here, under the ‘Sheet’ tab, we have a section called ‘Print’. Under this section we have a ‘Charts’ checkbox. Check this box to enable the printing of charts and uncheck to disable it. This is how we can control the printing of charts in Calc.
Print Chart
Share:

চেক এবং মুদ্রণ ? Check and Print

স্প্রেডশীট গণনা চেক করার জন্য, আমাদের ত্রুটির কোডগুলির জন্য শীটটি পরীক্ষা করতে হবে। এই ত্রুটি কোড ইতিমধ্যে আলোচনা করা হয়েছে। ত্রুটি কোড উপস্থিত থাকলে, এর অর্থ হল কিছু হিসাবের মধ্যে কিছু ত্রুটি বিদ্যমান এবং আমাদের অবশ্যই এই গণনাগুলি অবশ্যই পরীক্ষা করতে হবে।
In order to check the spreadsheet calculations, we need to check the sheet for the error codes. These error codes have already been discussed. If error codes are present, this means that some errors exist in some of the calculations and we must check these calculations again.
শীটের পাঠ্য মানগুলি পরীক্ষা করতে, প্রধান মেনু বার থেকে 'সরঞ্জাম' এ ক্লিক করুন এবং ফলস্বরূপ ড্রপ-ডাউন থেকে 'স্বয়ংক্রিয় বানান পরীক্ষণ' এ ক্লিক করুন। এটি 'বানান' ডায়লগ বক্স খুলবে। এই ডায়লগ বক্সটি শিটের সমস্ত ভুল বানান তালিকাভুক্ত করে। আপনি বানান পরীক্ষা এবং এখানে থেকে তাদের সংশোধন করতে পারেন। সব পরিবর্তন করার পরে, 'বন্ধ' ক্লিক করুন। এইভাবে আমরা ক্যালক এ পাঠ্য মানগুলি পরীক্ষা করতে পারি।
to check the text values in the sheet, click on ‘Tools’ from the main menu bar and from the resulting drop-down, click on ‘Automatic Spell Checking’. This will open the ‘Spelling’ dialog box. This dialog box lists all the incorrect spellings in the sheet. You can check the spellings and also correct them from here. After making all the changes, click on ‘Close’. This is how we can check the text values in Calc.
Spell Checker

মুদ্রণ উদ্দেশ্যে গ্রিডলাইন প্রদর্শন, সারি এবং কলাম শিরোনাম প্রদর্শন চালু করুন।

Turn on, off display of gridlines, display of row and column headings for printing purposes.

গ্রিডলাইনে প্রদর্শন বা সারি এবং কলামের শিরোনাম প্রদর্শন চালু / বন্ধ করতে, প্রধান মেনু বার থেকে 'বিন্যাস' এ ক্লিক করুন এবং ফলস্বরূপ ড্রপ-ডাউন থেকে 'পৃষ্ঠা' এ ক্লিক করুন। এটি 'পৃষ্ঠা শৈলী' ডায়লগ বাক্সটি খোলে। এই কথোপকথন বাক্সে, 'মুদ্রণ' এর অধীনে, আমাদের দুটি কলাম 'কলাম এবং সারি শিরোনাম এবং গ্রিড' রয়েছে। গ্রিড লাইন প্রদর্শন 'গ্রিড' চেক বক্সটি চেক বা অচিহ্নিত করে চালু বা বন্ধ করা যেতে পারে এবং 'কলাম এবং সারি শিরোনাম' চেক বাক্সটি চেক বা অচিহ্নিত করে সারি এবং কলাম শিরোনাম প্রদর্শনটি চালু এবং বন্ধ করা যেতে পারে। প্রয়োজনীয় মান নির্বাচন করার পরে, 'ওকে' ক্লিক করুন। এই আপনার সেটিংস সংরক্ষণ করা হবে।
To turn on/off the display of gridlines or the display of row and column headings, click on ‘Format’ from the main menu bar and from the resulting drop-down, click on ‘Page’. This opens the ‘Page Style’ dialog box. In this dialog box, under ‘Print’, we have two check boxes named ‘Column and row headers’ and Grid’. The display of grid lines can be switched on or off by checking or unchecking the ‘Grid’ check box and the display of row and column headings can be switched on and off by checking or unchecking the ‘Column and row headers’ check box. After selecting the required values, click on ‘OK’. This will save your settings.
Print

মুদ্রিত ওয়ার্কশীটের প্রতিটি পৃষ্ঠায় স্বয়ংক্রিয় শিরোনাম সারি (গুলি) মুদ্রণ প্রয়োগ করুন।

Apply automatic title row(s) printing on every page of a printed worksheet.

মুদ্রিত ওয়ার্কশীটের প্রতিটি পৃষ্ঠায় স্বয়ংক্রিয় শিরোনাম সারি মুদ্রণ করতে, প্রধান মেনু বার থেকে 'বিন্যাস' এ ক্লিক করুন। ফলস্বরূপ ড্রপ ডাউন মেনু থেকে, 'প্রিন্ট রেঞ্জ' এ ক্লিক করুন এবং উপ-মেনু থেকে যা প্রদর্শিত হয়, 'সম্পাদনা' এ ক্লিক করুন। এটি 'প্রিন্ট রেঞ্জগুলি সম্পাদনা করুন' ডায়লগ বাক্সটি খুলবে।
To apply automatic title rows printing on every page of a printed worksheet, click on ‘Format’ from the main menu bar. From the resulting drop-down menu, click on ‘Print Ranges’ and from the sub-menu which gets displayed, click on ‘Edit’. This will open the ‘Edit Print Ranges’ dialog box.
Print Range
এই ডায়লগ বাক্সে আমাদের 'সারি থেকে পুনরাবৃত্তি' নামক একটি বিভাগ রয়েছে। এই বিভাগের সামনে 'সঙ্কুচিত' বোতামটিতে ক্লিক করুন এবং এটি ডায়ালগ বক্সটি কমিয়ে দেবে। এখন যে সারিটি নির্বাচন করুন আপনি শিরোনামের জন্য প্রতিটি পৃষ্ঠায় স্বয়ংক্রিয় মুদ্রণের জন্য শিরোনাম সারি হিসাবে সেট করতে চান এবং আবার 'সঙ্কুচিত' বোতামে ক্লিক করুন।
In this dialog box, we have a section called ‘Rows to Repeat’. Click on the ‘Shrink’ button in front of this section and this will minimize the dialog box. Now select the row which you want to set as the title row for automatic printing on every page for the worksheet and again click on the ‘Shrink’ button.
এটি আবার 'মুদ্রণ রেঞ্জগুলি সম্পাদনা করুন' ডায়ালগ বাক্সটি সম্পূর্ণ করে তুলবে তবে এখন নির্বাচিত সারি 'সারি থেকে পুনরাবৃত্তি' বিভাগে প্রদর্শিত হবে। 'ওকে' ক্লিক করুন এবং এটি নির্বাচিত সারিগুলিকে ওয়ার্কশীটের প্রতিটি পৃষ্ঠায় মুদ্রণের জন্য স্বয়ংক্রিয় শিরোনাম সারি হিসেবে সেট আপ করবে।
This will again bring up the full ‘Edit Print Ranges’ dialog box but now the rows selected will get displayed in the ‘Rows to Repeat’ section. Click on ‘OK’ and this will set up the selected rows as the automatic title rows for printing on each page of the worksheet.
Share:

Definition List

Unordered List

Support