This document provides instructions for using various features in Microsoft Excel. It explains what a workbook and worksheet are, how to navigate between cells and rows/columns, how to perform calculations, and shortcuts using Ctrl, Alt, and F keys for common Excel functions like saving, copying, navigating, formatting text and more. Formulas, functions, charts and other Excel topics are also briefly covered.
This document provides an introduction and overview of Microsoft Excel XP. It discusses what Excel and spreadsheets are, how to start Excel, the main interface components, and basic cursor movement functions. It also outlines some common file functions like creating a new workbook, saving, closing, opening, and saving files in different formats or locations. The document is intended to familiarize new Excel users with basic concepts and operations.
This document discusses different types of programming languages used in computer science. It describes machine language as the lowest-level language that uses binary digits to write instructions. Assembly language, introduced in 1950, uses symbolic codes to write programs more easily than machine language. Higher-level languages like C and C++ allow writing programs in a more intuitive way using words and symbols. The document provides examples of advantages and disadvantages of different language types.
This document provides instructions for using various features in Microsoft Excel. It explains what a workbook and worksheet are, how to navigate between cells and rows/columns, how to perform calculations, and shortcuts using Ctrl, Alt, and F keys for common Excel functions like saving, copying, navigating, formatting text and more. Formulas, functions, charts and other Excel topics are also briefly covered.
1. The document provides an introduction to the 2013 version of the Bangladesh Bureau of Statistics' Excel Guidebook.
2. It explains what Excel is and the key components like workbooks, worksheets, and spreadsheets.
3. The guidebook describes how to start the Excel program and explains the interface.
4. It then provides instructions on how to perform basic tasks in Excel like creating new documents and worksheets, saving workbooks, opening files, and changing worksheet names.
5. The goal is to help users learn how to use the different features and functions of Excel.
This document provides an overview of Photoshop and discusses some of its key features and capabilities. It explains that Photoshop is a popular image editing software developed by Adobe Systems. The document outlines various tools in Photoshop for editing, retouching and enhancing images. It also mentions how Photoshop can be used for web design and development in addition to image editing.
This document provides an introduction and overview of Microsoft Excel XP. It discusses what Excel and spreadsheets are, how to start Excel, the main interface components, and basic cursor movement functions. It also outlines some common file functions like creating a new workbook, saving, closing, opening, and saving files in different formats or locations. The document is intended to familiarize new Excel users with basic concepts and operations.
This document discusses different types of programming languages used in computer science. It describes machine language as the lowest-level language that uses binary digits to write instructions. Assembly language, introduced in 1950, uses symbolic codes to write programs more easily than machine language. Higher-level languages like C and C++ allow writing programs in a more intuitive way using words and symbols. The document provides examples of advantages and disadvantages of different language types.
This document provides instructions for using various features in Microsoft Excel. It explains what a workbook and worksheet are, how to navigate between cells and rows/columns, how to perform calculations, and shortcuts using Ctrl, Alt, and F keys for common Excel functions like saving, copying, navigating, formatting text and more. Formulas, functions, charts and other Excel topics are also briefly covered.
1. The document provides an introduction to the 2013 version of the Bangladesh Bureau of Statistics' Excel Guidebook.
2. It explains what Excel is and the key components like workbooks, worksheets, and spreadsheets.
3. The guidebook describes how to start the Excel program and explains the interface.
4. It then provides instructions on how to perform basic tasks in Excel like creating new documents and worksheets, saving workbooks, opening files, and changing worksheet names.
5. The goal is to help users learn how to use the different features and functions of Excel.
This document provides an overview of Photoshop and discusses some of its key features and capabilities. It explains that Photoshop is a popular image editing software developed by Adobe Systems. The document outlines various tools in Photoshop for editing, retouching and enhancing images. It also mentions how Photoshop can be used for web design and development in addition to image editing.
1. The document discusses converting between different number systems including binary, decimal, octal and hexadecimal.
2. Methods are provided for converting integers and decimals from one base to another by breaking down the numbers into place values and recombining in the target base.
3. Examples are given of converting specific numbers between bases such as decimal to binary and vice versa.
This document provides an introduction to HTML 5 in 3 chapters. It discusses what HTML is and how it works, the importance of HTML, and some basic HTML elements and how to use them. The author hopes this book will help readers learn HTML 5 quickly. Contact information is provided for any questions about the book or HTML. An attached CD contains files related to examples in the book.
The document provides an overview of HTML (Hypertext Markup Language) and some basic HTML tags. It defines HTML as a markup language used to structure and present content for display on the web. It explains common HTML tags like <html>, <head>, <body>, <p>, <b>, <i> and <br> and how they are used to create headings, paragraphs, bold and italic text, and line breaks in a web page. It also gives examples of how these tags can be implemented.
There are two main parts of a computer: hardware and software. Hardware refers to the physical components of a computer like the central processing unit (CPU) and input/output devices. Software refers to the programs and operating systems that run on the hardware and allow it to perform tasks. A computer's memory, which can be RAM or ROM, is where data and instructions are stored and accessed by the CPU to carry out operations. An operating system manages the hardware and software resources and allows users to interact with the computer.
The document provides an overview of computer networking fundamentals including definitions of computer network and standalone computer. It discusses the benefits of computer networks such as sharing of resources like printers, scanners and software applications. Common uses of networks mentioned are information sharing, file transfer, data storage and security. Different types of network topologies like star, bus, ring and their features are outlined. Common network devices like hub, switch, router, gateway and their functions are explained. Different network cabling media such as twisted pair, coaxial, fiber optic and common connectors are described. The document also introduces network addressing and protocols.
This document provides an introduction to computers and discusses their key features and capabilities. It defines what a computer is, noting that it is an electronic device that can store and process data very quickly according to programmed instructions. The main points covered include:
- Computers can perform a wide range of tasks like calculations, data storage and processing, communication, entertainment and more through software programs.
- They work with high speed, accuracy and reliability according to the programmed instructions.
- Computers are versatile machines that can perform different types of work efficiently based on their programming.
- The document serves as an overview of computers for readers to understand their basic nature and functions.
The document provides information on HTML tags and elements for creating web pages. It discusses common tags like <p> for paragraphs, <h1>-<h6> for headings, and <body> for the content container. It also covers basic HTML structure with <html>, <head>, and <body> tags. Attributes are described along with examples for aligning, styling and providing additional information for elements. Different lists like ordered, unordered and definition lists are explained with <ol>, <ul> and <dl> tags.
The document discusses the global village concept, providing definitions from various sources. It describes how the term was coined by Herbert Marshall McLuhan and outlines some key advantages of living in a global village, such as access to information from around the world, communication across borders, increased knowledge and skills, and opportunities for education, healthcare and entertainment globally.
This document contains the resume and contact information of MD. IKBAL HOSSAIN, who is a LECTURER (ICT) at ADAMJEE CANTONMENT COLLEGE. It lists his educational qualifications including a B.Sc and M.Sc in Applied Physics and Electronic Engineering from Rajshahi University. It also provides his cell phone number and email address for contact. The document then lists some guidelines and tips for students, including studying regularly, focusing on important topics, maintaining a positive mindset, and preparing well for exams.
উচ্চমাধ্যমিক (HSC) ও ইউনিভার্সিটি ভর্তির জন্য প্রয়োজনীয় সব লেকচার শিট
* প্রশ্ন উত্তর গুলো বিভিন্ন লেখকের বই
থেকে যাচাই বাছাই করে সবচেয়ে সহজ পদ্ধতির উত্তরটা দেওয়া হয়েছে
* পদার্থবিজ্ঞানের মৌলিক গুরুত্বপূর্ন
বিষয়সমূহ সম্পর্কে খুব সহজ ব্যখ্যা দেওয়া আছে?
* জটিল তত্ব গুলো বুঝার জন্য চিত্র সহকারে
উদাহরন দেওয়া আছে
* পদার্থবিজ্ঞানের গুরত্বপূর্ন বিষয়সমূহের
প্রয়োজনীয় উদাহরণ ও চিত্রসহ ব্যাখ্যামূলক সমাধান করে দেওয়া হয়েছে ।
* গাণিতিক প্রশ্ন উত্তর গুলো ভেঙ্গে ভেঙ্গে
বিস্তারিত ভাবে ও প্রয়োজনীয় সাইডনোট সহকারে করে দেওয়া আছে ।
1. The document discusses the author's experience teaching life skills and self-awareness to students and businesspeople over many years through his educational institution.
2. It describes how he realized his students needed more than just knowledge, but strong communication skills to succeed in business or socially.
3. The author reflects on writing a book to share the importance of these soft skills more widely in the country.
This document is about a book titled "Search Engine Optimization" by Md. Rabiul Islam. Some key details provided:
- The book discusses search engine optimization (SEO) techniques to increase visibility of websites on search engines like Google.
- SEO helps businesses generate more traffic, leads, sales and brand awareness through organic search results.
- While SEO knowledge and practice is growing in Bangladesh, there remains a lack of educational materials available in Bengali like eBooks, videos etc. on the topic.
- The author believes this book will contribute to economic development in Bangladesh by helping introduce more local businesses and professionals to SEO strategies.
1. The document discusses converting between different number systems including binary, decimal, octal and hexadecimal.
2. Methods are provided for converting integers and decimals from one base to another by breaking down the numbers into place values and recombining in the target base.
3. Examples are given of converting specific numbers between bases such as decimal to binary and vice versa.
This document provides an introduction to HTML 5 in 3 chapters. It discusses what HTML is and how it works, the importance of HTML, and some basic HTML elements and how to use them. The author hopes this book will help readers learn HTML 5 quickly. Contact information is provided for any questions about the book or HTML. An attached CD contains files related to examples in the book.
The document provides an overview of HTML (Hypertext Markup Language) and some basic HTML tags. It defines HTML as a markup language used to structure and present content for display on the web. It explains common HTML tags like <html>, <head>, <body>, <p>, <b>, <i> and <br> and how they are used to create headings, paragraphs, bold and italic text, and line breaks in a web page. It also gives examples of how these tags can be implemented.
There are two main parts of a computer: hardware and software. Hardware refers to the physical components of a computer like the central processing unit (CPU) and input/output devices. Software refers to the programs and operating systems that run on the hardware and allow it to perform tasks. A computer's memory, which can be RAM or ROM, is where data and instructions are stored and accessed by the CPU to carry out operations. An operating system manages the hardware and software resources and allows users to interact with the computer.
The document provides an overview of computer networking fundamentals including definitions of computer network and standalone computer. It discusses the benefits of computer networks such as sharing of resources like printers, scanners and software applications. Common uses of networks mentioned are information sharing, file transfer, data storage and security. Different types of network topologies like star, bus, ring and their features are outlined. Common network devices like hub, switch, router, gateway and their functions are explained. Different network cabling media such as twisted pair, coaxial, fiber optic and common connectors are described. The document also introduces network addressing and protocols.
This document provides an introduction to computers and discusses their key features and capabilities. It defines what a computer is, noting that it is an electronic device that can store and process data very quickly according to programmed instructions. The main points covered include:
- Computers can perform a wide range of tasks like calculations, data storage and processing, communication, entertainment and more through software programs.
- They work with high speed, accuracy and reliability according to the programmed instructions.
- Computers are versatile machines that can perform different types of work efficiently based on their programming.
- The document serves as an overview of computers for readers to understand their basic nature and functions.
The document provides information on HTML tags and elements for creating web pages. It discusses common tags like <p> for paragraphs, <h1>-<h6> for headings, and <body> for the content container. It also covers basic HTML structure with <html>, <head>, and <body> tags. Attributes are described along with examples for aligning, styling and providing additional information for elements. Different lists like ordered, unordered and definition lists are explained with <ol>, <ul> and <dl> tags.
The document discusses the global village concept, providing definitions from various sources. It describes how the term was coined by Herbert Marshall McLuhan and outlines some key advantages of living in a global village, such as access to information from around the world, communication across borders, increased knowledge and skills, and opportunities for education, healthcare and entertainment globally.
This document contains the resume and contact information of MD. IKBAL HOSSAIN, who is a LECTURER (ICT) at ADAMJEE CANTONMENT COLLEGE. It lists his educational qualifications including a B.Sc and M.Sc in Applied Physics and Electronic Engineering from Rajshahi University. It also provides his cell phone number and email address for contact. The document then lists some guidelines and tips for students, including studying regularly, focusing on important topics, maintaining a positive mindset, and preparing well for exams.
উচ্চমাধ্যমিক (HSC) ও ইউনিভার্সিটি ভর্তির জন্য প্রয়োজনীয় সব লেকচার শিট
* প্রশ্ন উত্তর গুলো বিভিন্ন লেখকের বই
থেকে যাচাই বাছাই করে সবচেয়ে সহজ পদ্ধতির উত্তরটা দেওয়া হয়েছে
* পদার্থবিজ্ঞানের মৌলিক গুরুত্বপূর্ন
বিষয়সমূহ সম্পর্কে খুব সহজ ব্যখ্যা দেওয়া আছে?
* জটিল তত্ব গুলো বুঝার জন্য চিত্র সহকারে
উদাহরন দেওয়া আছে
* পদার্থবিজ্ঞানের গুরত্বপূর্ন বিষয়সমূহের
প্রয়োজনীয় উদাহরণ ও চিত্রসহ ব্যাখ্যামূলক সমাধান করে দেওয়া হয়েছে ।
* গাণিতিক প্রশ্ন উত্তর গুলো ভেঙ্গে ভেঙ্গে
বিস্তারিত ভাবে ও প্রয়োজনীয় সাইডনোট সহকারে করে দেওয়া আছে ।
1. The document discusses the author's experience teaching life skills and self-awareness to students and businesspeople over many years through his educational institution.
2. It describes how he realized his students needed more than just knowledge, but strong communication skills to succeed in business or socially.
3. The author reflects on writing a book to share the importance of these soft skills more widely in the country.
This document is about a book titled "Search Engine Optimization" by Md. Rabiul Islam. Some key details provided:
- The book discusses search engine optimization (SEO) techniques to increase visibility of websites on search engines like Google.
- SEO helps businesses generate more traffic, leads, sales and brand awareness through organic search results.
- While SEO knowledge and practice is growing in Bangladesh, there remains a lack of educational materials available in Bengali like eBooks, videos etc. on the topic.
- The author believes this book will contribute to economic development in Bangladesh by helping introduce more local businesses and professionals to SEO strategies.
The document discusses ways to increase the use and demand for products in the market. It provides examples of products that were originally introduced to solve specific problems but are now used for many other purposes as well, increasing their demand and usefulness. This allows companies to earn more and helps the economy. It encourages exploring new uses for existing products and sharing information about different applications of products with manufacturers to further expand their demand and sales.
The document discusses search engine optimization (SEO) and its importance for increasing website traffic and rankings. SEO involves optimizing a website to rank highly in search engines organically. It can help drive free traffic to a site and boost sales and revenue. While SEO is still developing in Bangladesh, it offers opportunities for local businesses to reach more customers online. The author believes the book "Search engine optimization" will help advance the country's economy by providing guidance on SEO strategies.
The document discusses search engine optimization (SEO) and its importance for increasing website traffic and rankings. SEO involves optimizing a website to rank highly in search engines organically. It can help drive free traffic to a site and boost sales and revenue. While SEO is still developing in Bangladesh, it offers opportunities for local businesses to reach more customers online. The author believes the book "Search engine optimization" will help advance the country's economy by providing guidance on SEO strategies.
The document provides instructions for various formatting and editing functions in Microsoft Word, including how to open, save, copy, cut, paste, find, replace, print preview, change font styles, add bullets and numbering, and add borders and shading. The instructions are provided in the native Bengali language in a step-by-step format with formatting cues like bold and italics.
The document discusses the International Union for Conservation of Nature (IUCN) and its work on environmental protection. Some key points:
1) IUCN is an international organization that supports conservation efforts through projects with organizations like WWF.
2) The IUCN Conservation Centre (IUCC) works to raise awareness of conservation issues among governments. It shares information on conservation programs and projects across different countries.
3) The summary provides background on how the author learned about IUCN and IUCC while attending a conference in Switzerland, meeting representatives who explained their mission.
1) The document is an introduction to a book written for teenagers in India and Bangladesh to encourage them to pursue their dreams.
2) It discusses how society often discourages youth, especially girls, and tries to break stereotypes by showing that everyone has a purpose.
3) The introduction also talks about how innovators in history faced criticism but were able to change the world through their inventions and determination.
Jara baro hote chao by dr. partho chattopadhyay [www.onlinebcs.com]Itmona
1) The document is an introduction to a book written for teenagers in India and Bangladesh to encourage them to pursue their dreams.
2) It discusses how society often discourages youth, especially girls, and tries to break stereotypes by showing that everyone has a purpose.
3) The introduction also talks about how innovators in history faced criticism but were able to change the world through their inventions and determination.
This document provides step-by-step instructions for setting up a Windows XP operating system on a computer. It describes preparing the computer by changing the boot device priority in BIOS, booting from the Windows XP installation CD, completing the installation wizard, and finalizing the basic Windows XP configuration. Key steps include formatting partitions if needed, installing drivers, selecting regional and language options, entering a product key, and creating a user account. The process takes approximately 25-30 minutes to complete once started.
1. The document discusses the importance of spirituality and belief in a higher power in providing meaning and purpose in life. It argues that while humans have many worldly desires and concerns, being bound by dogmas or social pressures limits one's potential.
2. It describes how spirituality can help overcome hardships and difficulties by giving one strength and resolve through faith in something greater. Having a spiritual foundation allows one to distinguish between what is truly valuable versus superficial.
3. The document asserts that spiritual beliefs are essential for humans to understand their inherent worth and potential, and to stay motivated, compassionate and productive in their lives and work.
1. The document discusses the importance of spirituality and belief in a higher power in providing meaning and purpose in life. It argues that while humans have many worldly desires and concerns, being bound by dogmas or social pressures limits one's potential.
2. It describes how spirituality can help overcome hardships and doubts by providing inner strength and confidence. Having faith in something greater than oneself allows one to accept what cannot be explained through worldly logic.
3. The document asserts that spirituality is essential for humans to understand their true nature and potential. It gives perspective in times of suffering and confidence to do good works. Spiritual faith makes one resilient against harm, motivated for positive change, and united in purpose
1) The document is a request from an employee named Bijoy Kumar Das to the Director General of Bangladesh Police requesting a transfer from Dhaka Metropolitan Police to Rajshahi Police.
2) The employee has been working with satisfactory performance for many years in Dhaka and wants a transfer due to family responsibilities in Rajshahi.
3) He requests the Director General to consider his application for transfer from Dhaka to Rajshahi Police.
This document provides information about Ramadan and Laylat al-Qadr in 3 pages divided into sessions. The first session defines Ramadan and explains its significance in Islam. It notes that Ramadan is the ninth month of the Islamic calendar and the month in which the first revelation of the Quran was sent down. The session emphasizes the importance of fasting and teaches about the significance of Laylat al-Qadr. The overall goal of the document is to educate communities about Ramadan and Laylat al-Qadr through several sessions.
This document provides information about education in Bangladesh. It discusses that International Literacy Day is celebrated on September 8th every year to promote literacy across countries. In Bangladesh, both the government and NGOs have various programs to provide education and literacy skills to children, women, and disadvantaged groups. While literacy rates and access to education have improved over the years due to these efforts, many children still do not attend school due to poverty and need to work. The document emphasizes that education is essential for individual and societal development.
This document is a summary of how a Muslim should spend their daily life according to the teachings of the Sunnah and present day context. It discusses 10 important activities like waking up, praying, spending time with family etc. and provides guidance on how to incorporate the teachings of the Prophet Muhammad peace be upon him during these daily activities. The author hopes that following the Sunnah closely while accounting for modern times will help the reader lead a blessed life. The summary is intended to provide concise yet essential information about the document.
This document discusses accounting concepts and the accounting equation. It provides three examples of journal entries to illustrate:
1) The effect of an initial investment on the accounting equation.
2) The effect of withdrawing money from a bank on the accounting equation.
3) How a journal entry can result in both an increase and decrease to different elements of the accounting equation.
The document aims to help students understand how the accounting equation is impacted by business transactions and how the structure of the equation can change.
The document discusses strategies to increase market size for products. It suggests that producers should encourage higher consumption of existing products to expand the market. One way is to raise awareness among consumers about using products more frequently through creative promotion. It also notes that introducing new types of products or variants can increase overall consumption. The example is given of a beverage company that partnered with a popular television show to promote its drink. Viewership and sales of the drink increased significantly. Producers can employ different methods of creative marketing and promotion to boost product usage and market size.
This document introduces a book titled "Quantum: The Answer to a Thousand Questions" by Mahajataq, which aims to answer thousands of questions that people have about life, knowledge, spirituality and more. It notes that while people experience confusion and uncertainty in their lives, the power to find clarity and resolve inner turmoil is within themselves. The book uses quantum principles to explain that there are answers to all questions within one's own consciousness. It seeks to help readers overcome doubts and anxieties by discovering their innate ability to understand life's mysteries.
This document discusses accounting concepts and provides examples of accounting equation entries. It contains:
1. Three examples of journal entries showing how transactions affect the accounting equation and cause changes in asset, liability, and equity accounts.
2. A request to write three journal entries showing different types of changes to the accounting equation, such as conceptual changes.
3. A request to write journal entries summarizing the examples and showing how they caused changes to the accounting equation.
Similar to MS Excel bengali complete tutorial with image (20)
The document repeatedly lists the URL www.amarboi.org over 100 times without providing any other details. It appears to be promoting or drawing attention to the website www.amarboi.org.
The three most holy sites in Islam are Mecca, Medina, and Jerusalem. Mecca is home to the Kaaba and is the holiest city for Muslims, who are expected to make a pilgrimage there at least once in their lifetime if able. Medina is the city where the prophet Muhammad first recited the Quran and where he is buried. Jerusalem contains the Al-Aqsa Mosque compound and is the third holiest city in Islam.
The document contains URLs and descriptions for websites providing free Bangla eBooks. It lists www.facebook.com/tanbir.ebooks and www.tanbircox.blogspot.com as sources for useful Bangla eBooks. It also frequently mentions www.bnebookspdf.com and facebook.com/bnebookspdf as places to access free Bangla eBook PDFs. The document appears to be promoting several online resources for finding and downloading free digital Bangla books and publications.
The document is a lesson in Bengali created by NHK World. It contains 51 sections with dialogues and conversations covering various topics like greetings, asking names, phone numbers, addresses, directions, making plans, and more. Each section introduces new vocabulary and grammatical structures in Bengali. The document was created by NHK World and is available on their website for learning Bengali.
The document repeatedly lists the URL www.amarboi.org over 100 times without providing any other context or information. It appears to be focused solely on promoting or listing the website www.amarboi.org.
The document discusses the benefits of meditation for reducing stress and anxiety. Regular meditation practice can calm the mind and help prevent worrying thoughts. Making meditation a part of a daily routine, even if just 10-15 minutes per day, can significantly improve mood, focus, and overall mental well-being over time.
The document contains a single URL - www.amarboi.org - repeated over 100 times without any other text or context. It provides no meaningful information beyond listing the same website address repeatedly.
The document repeatedly lists the URL www.amarboi.org over 100 times without providing any other context or information. It can be summarized as a document that solely contains repetitions of the URL www.amarboi.org listed multiple times without any other details.
This document provides a summary of an 80-item list of fruits found in Bangladesh. It includes the local name of each fruit in Bangla, its botanical name, and page number. Some key fruits listed include jackfruit, mango, litchi, guava, banana, pineapple, coconut, citrus fruits like lemon and orange, and other tropical and subtropical fruits commonly found in Bangladesh. The list appears to be from a publication on fruit cultivation in Bangladesh produced by the Bangladesh Agricultural Research Council.
This document provides an overview of diabetes mellitus (Wvqv‡ewUm) in Bengali. It discusses the types, causes, symptoms, tests, and management of diabetes. Specifically, it mentions that diabetes has been documented in ancient Indian medical texts from over 2,000 years ago. It was first described as "great emptying of urine". Greek physicians later recognized it as diabetes, meaning "to pass through" referring to the excessive urination. The document provides basic information about diabetes in the Bengali language.
This document appears to be the title page and preface for an English-Bengali dictionary published in 1874 in Calcutta. The title page provides information about the dictionary being for schools and revised by Gopee Kissen Mitter. The preface, written by Gopee Kissen Mitter, explains that he has revised the dictionary for a second time, adding new meanings and terms to better convey English words to juvenile students.
The document discusses the benefits of exercise for mental health. Regular physical activity can help reduce anxiety and depression and improve mood and cognitive function. Exercise causes chemical changes in the brain that may help protect against mental illness and improve symptoms.
The document discusses the history and development of artificial intelligence over the past 70 years. It outlines some of the key milestones in AI research from the early work in the 1950s to modern advances in deep learning. While progress has been significant, fully general human-level AI remains an ongoing challenge that researchers continue working to achieve.
This document discusses key accounting concepts and principles including:
1) The qualitative characteristics of accounting information including relevance, neutrality, and reliability.
2) Key financial statements and their purposes including the balance sheet, income statement, statement of retained earnings, and statement of cash flows.
3) Common accounting transactions and how they affect the accounting equation and financial statements.
The document repeatedly lists the URL www.amarboi.org over 100 times without providing any other context or information. It can be summarized as a document solely focused on listing the same URL more than 100 consecutive times.
The Science of Learning: implications for modern teachingDerek Wenmoth
Keynote presentation to the Educational Leaders hui Kōkiritia Marautanga held in Auckland on 26 June 2024. Provides a high level overview of the history and development of the science of learning, and implications for the design of learning in our modern schools and classrooms.
How to Download & Install Module From the Odoo App Store in Odoo 17Celine George
Custom modules offer the flexibility to extend Odoo's capabilities, address unique requirements, and optimize workflows to align seamlessly with your organization's processes. By leveraging custom modules, businesses can unlock greater efficiency, productivity, and innovation, empowering them to stay competitive in today's dynamic market landscape. In this tutorial, we'll guide you step by step on how to easily download and install modules from the Odoo App Store.
Information and Communication Technology in EducationMJDuyan
(𝐓𝐋𝐄 𝟏𝟎𝟎) (𝐋𝐞𝐬𝐬𝐨𝐧 2)-𝐏𝐫𝐞𝐥𝐢𝐦𝐬
𝐄𝐱𝐩𝐥𝐚𝐢𝐧 𝐭𝐡𝐞 𝐈𝐂𝐓 𝐢𝐧 𝐞𝐝𝐮𝐜𝐚𝐭𝐢𝐨𝐧:
Students will be able to explain the role and impact of Information and Communication Technology (ICT) in education. They will understand how ICT tools, such as computers, the internet, and educational software, enhance learning and teaching processes. By exploring various ICT applications, students will recognize how these technologies facilitate access to information, improve communication, support collaboration, and enable personalized learning experiences.
𝐃𝐢𝐬𝐜𝐮𝐬𝐬 𝐭𝐡𝐞 𝐫𝐞𝐥𝐢𝐚𝐛𝐥𝐞 𝐬𝐨𝐮𝐫𝐜𝐞𝐬 𝐨𝐧 𝐭𝐡𝐞 𝐢𝐧𝐭𝐞𝐫𝐧𝐞𝐭:
-Students will be able to discuss what constitutes reliable sources on the internet. They will learn to identify key characteristics of trustworthy information, such as credibility, accuracy, and authority. By examining different types of online sources, students will develop skills to evaluate the reliability of websites and content, ensuring they can distinguish between reputable information and misinformation.
How to Create a Stage or a Pipeline in Odoo 17 CRMCeline George
Using CRM module, we can manage and keep track of all new leads and opportunities in one location. It helps to manage your sales pipeline with customizable stages. In this slide let’s discuss how to create a stage or pipeline inside the CRM module in odoo 17.
8+8+8 Rule Of Time Management For Better ProductivityRuchiRathor2
This is a great way to be more productive but a few things to
Keep in mind:
- The 8+8+8 rule offers a general guideline. You may need to adjust the schedule depending on your individual needs and commitments.
- Some days may require more work or less sleep, demanding flexibility in your approach.
- The key is to be mindful of your time allocation and strive for a healthy balance across the three categories.
Dreamin in Color '24 - (Workshop) Design an API Specification with MuleSoft's...Alexandra N. Martinez
This workshop was presented in New Orleans for the Dreamin' in Color conference on June 21, 2024.
Presented by Alex Martinez, MuleSoft developer advocate at Salesforce.
How to Setup Default Value for a Field in Odoo 17Celine George
In Odoo, we can set a default value for a field during the creation of a record for a model. We have many methods in odoo for setting a default value to the field.
5. Want more Updates
B4 8000
C1 Quantity
C2 5
C3 3
C4 4
D1 Total
my‡Îi e¨envi t
D2
B2*C2
D2 22500
Kwc Kiv t
D2 Edit
Copy D2
D4 Shift D4
Edit Paste
D3 D4
KvR msi¶Y Kiv t
File Save Save As
Save As...
File name Working Save
Working.xls
G‡·j †_‡K †ei nIqv t
6. Want more Updates
File Exit Save
Save Yes
Save Save No
Kw¤úDUvi eÜ Kiv t
Start Turn Off Computer
Turn off computer Turn off
msiw¶Z dvBj mPj Kiv t
Working
Excel
File Open...
Open
File name: Working Working
Open
GwWU Kiv t
B3 8000 8500 B3
8000
000 500 8000 8500
File Save
19. Want more Updates
֬vUvmevi (Status bar)
Ready
Edit
Ready Ready Esc
Copy Edit Copy
Select destination and press ENTER or choose paste
Destination) Paste
(Special key
indicator) Caps Lock, Scroll Lock, Insert
View Status bar
kxU U¨ve (Sheet tab)
Sheet1, Sheet2, Sheet3 Insert>Worksheet
20. Want more Updates
G‡·‡j KvR Kiv t
‡WUv Gw›Uª Kivi mgq j¶Yxq welqejx t
9/5/97 Feb-97
ý AM PM a p
p am
Format Cells
Alignment
09 009 9
Apostrophe ( ý
Format Cells
132, 734, 293
ý $132, $734, $293
Format Cells... Number Currency
Symbol ý
ý Currency Sign)
New
B B
Format Cells...
21. Want more Updates
Number Number
Currency
Symbol : ý
ý
OK
B ý
ý
ý
Format Cells...
Small Lellter) CapsLock
Caps Lock
(Capital Letter) Caps Lock Off Shift
Format>Column>Width...
evsjv UvBc Kiv
×
Formatting Font
ý Alt+O Format Cells... Font
SutonnyMJ
30. Want more Updates
G‡·‡j dvBj msi¶Y Kiv t
Save
File Save Save As...
File name: mywork1)
Save mywork1.xls
Save File Save
Ctrl+S
†mf G¨vR (Save As...)
Save
Save File
Save As... File name:
Work) Save
gv‡S gv‡S dvBj Save Kiv t
Save
Save Save
Save Save
32. Want more Updates
Tools>Options Security
Password to open:
Dhaka96 Ok Confirm password
(Dhaka96) Ok
Save Ok (Letter2
Ok
Letter2.xls Save Ctrl+F4 Alt+F4
36. Want more Updates
Adjust
Adjust
File Page Setup... Page Scalling Adjust
to:
10-400 ×
A4 8 ½
” x 11”
Page Size :
File Page Setup... Page Paper
Size : Alt+Z
Ok
300 dpi, 600 dpi dpi
dot per inch
Page Setup Print Quality : dpi
Print quality
Page Setup
Print quality: Alt+Q
Ok
c„ôv b¤^i t
1, 2,
3
32 28 60
1 32
1 33
Page Setup First number : 33
Ok
File>Page Setup... Margins
37. Want more Updates
Left, Right, Top Bottom Left : Right: Top:
Bottom:
Header:
Footer:
Ok
38. Want more Updates
Center on Page Horizontally
Page Setup (Margins)
ý
Alt+Z
Horizontal Center
Center on Page Vertically
Vertical Center
Center on Page Horizontal and Vertical
Horizontal and Vertical Center
Header/Footer
Page Setup Header/Footer
View
Print Area
Page
Setup (Sheet Print area:
Print area
C5: E13
File>Page Setup... Sheet
Print area: Alt+A C5:E13 $C$5:$E$13
Page Setup
C5:E13
39. Want more Updates
Ok
File>Page Setup... Sheet
Rows to repeat at top: 1
$1 1 4
$4
Columns to repeat at left:
A $A A C
$A:$C Ok
(Gridline)
40. Want more Updates
File> Page Setup...
Sheet Gridlines ý
Ok
Tools>Options... View
Gridlines Color: Alt+C
Comment)
Page
Setup
File>Page Setup... Sheet
Comments: Alt+M
At the end of Sheet As displayed on
sheet View> Comment
Print Area)
File> Print Area
Print Preview Print Area
Save Save Clear
Clear
Clear
Save
41. Want more Updates
File Print Area Clear Print Area
Clear Save
File
Print Preview
Next:
Next Alt+N
Previous:
Previous Alt+P
Zoom :
Print : Print
Ok
Setup...: Alt+S Page Setup
Margins :
42. Want more Updates
Page Break Preview : Page break)
Close : Alt+C
Help : Alt+H
File>Print...
Ctrl+P
× ×
Ok
All :
Pages : Pages
From: To:
From : 7 To: 15 Ok
Selection :
Selection Ok
Active Sheet(s) :
Selected Chart
Entire Workbook :
Print to file : Print to file
Ok
Number of Copies :
Number of Copies
Collate
43. Want more Updates
File Print...
Printer Name
Alt+N
Printer
Add)
Start>Settings>Printers Start>Settings>Control Panel
Printers Printer
Add a printer Add printer Wizard Next
Next Next
44. Want more Updates
Manufacturer:
Manufacturer:
Printers: Next>
LPT1
Next Add printer wizard Do
you want your windows-based programs to use the printer as the default
pritner?)
Yes No
Next
Yes No
Finish
Add Printers Add
Add
Add CD
File>Print...
Ok
45. Want more Updates
FTP
FTP (File Transfer Protocol)
FTP
FTP Add
FTP File>Open... Open
Look in: FTP Locations
FTP
FTP (Comunication Protocol)
URL (Universal Resource Locator ) fttp://
46. Want more Updates
এক নজরে Microsoft Excel G †hvM, we‡qvM, ¸Y, fvM Kivi wbqgt
Microsoft Excel G †hvM Kivi wbqgt 1| †QvU †hv‡Mi m~Î nj t Zvi Av‡M 1wU K_v e‡j
†bB m~Î ïiæ nq
= w`‡q Avi †kl nq Enter w`‡q ZvB m~Î cÖ‡qvM Kivi Av‡M GB `ywU wRwbm fvjfv‡e †Lqvj
ivL‡Z n‡e|
61. Want more Updates
(Paste)
Edit Paste Cut Copy
Paste Ctrl+V Paste
Paste Special
Paste
Paste Special
Transpose
Paste Special Paste
Special Test
B6 =SUM($B$1:$B$5)
B6 1045
Esc A6
A4 Insert Comment
Fuzi Disk Made by Japan
62. Want more Updates
B6
All Borders B6
Paste Special
Paste All t Test.xls A6
D1 Edit>Paste Special...
All Ok A6
Paste
Formulas t
Paste Special Formulas
Test.xls B6
E1 Edit>Paste Special... Formulas
Formulas Alt+F Ok
E1 B6 Esc Ready
B1 100 200 B6 1045 1145
E1
1145
Values t
Test.xls B6
Ctrl+C
E3 Edit>Paste Special... Paste Special
Values Ok E3 B6
Value Esc A1 200 300
B6 E1 1145 1245 E3
1145 E3 Value
Formats t
Paste Special Formats
Test.xls A6
D3 Edit>Paste Special... Formats
Ok D3 A6
Esc D3 Test A6
63. Want more Updates
D3 Paste Special
A6
Comments t
A4 A4
Paste Special Comments
Test.xls
A4 D5 Edit>Paste Special
Paste Special Comments Ok
Esc D5 A4 D5
All except borders t
Paste Special All except borders Paste
B6
Copy D6 Edit>Paste Special...
All except borders Ok B6
D6
Transpose t
Paste Special Transpose
Test.xls A1:B4
65. Want more Updates
Ab¨ A¨vwc−‡Kkb †cÖvMÖvg †_‡K Object ‡c÷ Kiv t
Paste Special
Edit Copy
Edit>Paste Special... As:
Ok
Edit>Paste Special... Microsoft Word
Document Object Ok
Clear Command t
Edit>Clear
Clear
A6
A4
Insert>Comment Fuzi disk Made by Japan
A1 14
Clear>All t
Edit
A1 Edit
Clear All
Clear>Format
Edit
A6 Edit
Clear Format
67. Want more Updates
(A,B,C
Sex C Delete
K‡qKwU Column Gi †jLv Delete Kiv t
Shift Delete
mvwi (Row) Gi †jLv Delete Kiv t
Edit>Delete... Entire Row
Ok
×
1,2,3...)
8
Delete
Row)
Shift
Delete
Delete
Row
Edit>Delete...
68. Want more Updates
Shift Cells Left Shift
Shift Cells Up Ok
Shift
Delete
Edit>Delete Sheet...
Delete
×
edit Undo delete Ctrl+Z
Find t
Edit Find
Edit Find...
Options>>
Find what: Find Next:
Next
Range Find
69. Want more Updates
Find WvqvjM e‡·i wewfbœ Ack‡bi e¨envi t
Find Find
Find
Search:
By Columns By Rows
By Comumn Find
Search By Rows Find Row wise
Look in: Formulas Values
Comments Find
Find
Match Case
Ahmed Find what:
ahmed aHmed Find
Match Case Alt+C
ý Find
Replace
(Replace)
Find Replace
Replace
Replace with: Replace
Find Replace Replace
Find Replace Replace All
Replace
Replace KgvÛ t
Position Officer
Manager Replace
Data
70. Want more Updates
Edit Replace...
Find what: Officer Replace with: Alt+E
Manager Replace All Officer, Manager
GoTo t
F5
Edit>GoTo... Ok
J75 F5 Edit GoTo...
GoTo
71. Want more Updates
Reference: J75 Ok J75
Fill t
January,
February, March Sunday, Monday, Tuesday... ×
100,101,102,103) 5,10,15,20...)
2/11/97,3/11/97,4/11/97
Fill
Fill Fill
Fill Handle
Edit Fill
January, February
A1 January
A1 Black Cross (+) ý
ý Black Cross ý Fill Handle
A12
Fill
72. Want more Updates
‡gby KgvÛ e¨envi K‡i Fill Kiv t
A2 A12
A2:A12 Delete A2:A12 A1
A1 A12
Edit Series...
Series
AutoFill Ok
(Automatic)
D`vniY-2 t ZvwiL (Date) ‡WUv Fill Kiv|
B 1/1/2010,
2/1/2010, 3/1/2010
B1 1/1/97
B1 Fill Handle
74. Want more Updates
A First, Second...
A1:A10 Tools Options... Custom Lists
A1:A10 Import List From Cells: $A$1:$A$10
Import List entries : First,Second... Add
Close Custom List Add
Autofill
B1 First
Fill Handle B6 Auto Fill
5,10,15,20.... Fill Fill Handle
A A1 5, A2 10 A1:A2
Fill Handle A2
A11 A1 A11
5
Fill Handle Autofill Fill
Handle
Fill B 10,20,30...
130 B1 10 B1 B13
Edit Fill Series... Step Value: 10
Stop Value: 130 Ok
75. Want more Updates
10,20,30 130
1/1/2010,
2/1/2010, 3/1/2010 1/1/2010,1/1/2011/,
1/1/2012 Auto fill
A1 1/1/2010 A1
A1 A15 Edit>Fill>Series...
Date Unit Ok Alt+Y
Auto Fill
Ab¨vb¨ A¨vwc−‡Kk‡bi mv‡_ Link Kiv t
Paste Link Paste Link
Link Paste
76. Want more Updates
C5 =C2+C3+C4 A1:C5
Edit>Copy
Start>Programs>MSWord Edit
Paste Special...
Paste Link
As: Microsoft Excel Worksheet Object Ok
Microsoft Excel...
C4 45 55 Total 193 203
Microsoft Word...
193 203
Edit Move or Copy Sheet...
Test
Data
Edit Move or Copy Worksheet...
To book: Alt+T Test.xls
Ok Data.xls Test.xls
Window Test Data Test
Test
78. Want more Updates
wfD †gby (View) t
View
View
Alt+V
Normal View t
Normal
View
Normal View
Normal View
View>Task Pane t
Page Break Preview
Insert>PageBreak
View Page Break
81. Want more Updates
Bold
Italic
Underline
Align Left Align
Align Center
Align Right Align
Merge and Center
Currency ý $
Currency ý ý
ý
Percent Style Percent
Comma Style
Increase Decimal
307.250)
Decrease Decimal
Decrease Indent
Increase Indent
Borders
Fill Color
Font Color
Wªwqs Uzjevi (Drawing Toolbar) t
View>Toolbars
Drawing ý
82. Want more Updates
Draw
Select Object
AutoShape AutoShape
AutoShape Shape
Shape
Line
Arrow ý
Rectangle
Oval
Text Box
Insert WordArt
Fill Color Fill
Color
Line Color
Font Color
Line Style
Desh Style
Arrow Style
Shadow Shadow
3-D Three Dimentional Effect
85. Want more Updates
wcK&Pvi Uzjevi (Picture Toolbar) t
Insert>Picture Picture Toolbar
View Toolbars Picture
ý
Insert Picture from File
Color
More Contrast Contrast
Less Contrast Contrast
More Brightness
Less Brightness
Crop
Line Style
Format Picture
Reset Picture
87. Want more Updates
Status Bar (֬vUvm evi) t
Caps Lock
CAPS View
Toolbars Status Bar ý
Header and Footer t
Header and Footer
View Header and Footer Header
and Footer
88. Want more Updates
Custom Header...
Left Section: Silicon World
Computer Sys
Center Section:
Right Section:
Page#
Ok
Print Preview Header
Next
89. Want more Updates
Header/Footer ‡jLvi wbqg t
Header
Left Section: Right Section:
Font Button Left, Center Right
Font
Ok
Page Number Button 1, 2,
3 Page #, Page No
Total Pages Button
Page 1 of 12, Page 2 of 12, 3 of 12........ ( 12
Date Button
Time Button
File Path & Name
File Name
Sheet Tab
Picture
Format Picture
Left Section, Center Section
Right Section
Header GwWU Kiv t
View Header and Footer
CustomHeader... Section Section
90. Want more Updates
Ok OK
Save
Header Delete Kiv t
View Header and Footer...
Header:
(None) Ok File>Print Preview
Save
dzUvi ˆZwi Kiv Footer t
View Comments t
Insert>Comment
View>Comments
Insert Comment
K‡g›U View Kiv t
View Comments
Comments
91. Want more Updates
Reviewing Uzjevi t
View>Comments... Reviewing
ý
New Comment/Edit Comment
Previous Comment
Next Comment
Hide Comment
Hide All Comments
Delete Comment
Create Microsoft Outlook Task
9.Send to Mail Recipient Attachment
Full Screen t
19 Full Screen
Full Screen 41
Full Full Screen
View Full Screen
Full Screen Full Screen Close Full
Screen Alt+C
97. Want more Updates
To book:
Ok
Before Sheet: Ok
Move or Copy
Create a Copy
Ctrl
c„ôv wefvRb (Page Break)t
Page Break
Page Break
Insert>Page Break
Page Break
103. Want more Updates
Insert Hyperlink
Address:
Look in:
Ok
nvBcviwjsK e¨envi Kiv t
HLink Save
New Ctrl+N
G55 F5 G55
Hewlett Packard Printer Model 2100M
Resulation 1200 dpi
Tonner 2000Pages
Memory 16MB
104. Want more Updates
Test1 Save
HLink
A2
Insert Hyperlink...
Address:
Test1 Look in:
Ok
A2
HLink
ScreenTip ‰Zwi Kiv t
Insert Hyperlink...
ScreenTip
105. Want more Updates
Ok
HP Hewlett Packard Printer Model 2100M Ok
nvBcviwjsK gyQv t
(Right Click)
Remove Hyperlink
Qwe mwbœ‡ewkZ Kiv t
Insert Picture ClipArt...
(Academic, Animals, Buildings, Cartoons.... Form File,
Auto Shapes WordArt, Chart
107. Want more Updates
Office Collections
Academic
Copy
(Ctrl+V
ý
ý
ý
ý ý
ý
ý
Qwe ¯’vbvš—wiZ Kiv t
Move
Qwe Kwc Kiv t
Ctrl
×
108. Want more Updates
Create your drawing here Esc
Silicon World
Format Text box Colors and
Lines Line Color: No
Line
Format>Font>Color
G‡·‡j ¯‹¨vbvi e¨enviKiY t
Save Adobe Photoshop, Quark
Express
119. Want more Updates
Chart Options Chart Title, X-axis, Value (Y) axis
X Y
4-YRS REPORT Production Rate)
4-YRS REPORT
(Production Rate)
X-axis Y-axis
Ok
wj‡RÛ t
Chart>Chart Options... Chart Options Leagend
Placement (Bottom, Center....)
Ok
Show Legend Alt+S ý
†WUv‡j‡ej t
Chart Chart Options... Data Label
120. Want more Updates
Value ý Ok
Show Lable Ok
†WUv †Uwej t
Chart Chart Options...
Data Table
125. Want more Updates
Format
Selected Chart Area...
Format Chart Area
Patterns Fill Effects...
Texture
White marble
Ok Ok Texture
Format
Selected Legend
Fill Effects...
Water Droplests
Ok
Ok
Water Droplets
126. Want more Updates
dig¨vU Zz‡j †`qv t
Format Chart Area...
Fill Effects... Area Automatic Ok
dig¨vU Gw·m t
X 1994, 1995, 1996, 1997
1994, 1995...
Format Axis... Format Axis
Font
Font Style: Italic
127. Want more Updates
Size: 7
Ok
X-Axis 1994, 1995...
x
Alignment)
Y 0 10 20 30....
0, 10, 20, 30, 40, 50, 60
Format Axis...
Alignment
Orientation Text
Degrees 45
Ok Y
141. Want more Updates
=LEFT(String,n)
String n
=LEFT(“Silicon World Computer”,7) Silicon
=LEFT(“Mahabub”,3) =Mah
=LEFT(“Hasmal Ali”,5)=Hasma
=RIGHT(String,n)
=Left String n
=RIGHT(“Silicon World Computer sys”,12)
Computer sys
=RIGHT(“Mahbub”,3)=bub
=RIGHT(“Babul”,3)=bul
=MID(String,Start numbers,n)
Start number, n
=MID(“Silicon World Computer sys”,8,7) World
=MID(“Mahbub”,3,2)=bu
=LOWER(String)
String (Small Letter)
=LOWER(“Silicon world”) silicon world
=LOWER(“BABUL”) = babul
142. Want more Updates
=UPPER(String)
String Capital Letter)
=UPPER(“Silicon World computer SYS”) SILICON WORLD
COMPUTER SYS
=UPPER(“babul”)=BABUL
‡WUv‡eR m~Î mg~n t
(Title)
Data
Data base
POSITION
Officer
(Officer) SALARY
=DSUM,
=DAVG, =DMAX, =DMIN
=DCOUNT
DSTD =DVAR
=DSUM
m~Î t =DSUM(INPUT,FIELD,CRITERIA) GLv‡b,
INPUT Address
Input A1..D9
FIELD Input INPUT
1, 2,
3 NAME FIELD
1, AGE FIELD 2, POSITION FIELD 3,
SALARY FIELD 4...
CRITERIA
Address Input, Field
ý
143. Want more Updates
=DSUM POSITION OFFICER
SALARY
B12
DSUM(A..D9:3,F1:F2)
B12 OFFICER 12200)
=DAVERAGE
144. Want more Updates
OFFICER
B13 =DAVERAGE(A1:D9,4,F1:F2)
=DMAX
(Maximum) Officer
B14
=DMAX(A1..D9,4,F1..F2) Maximum
Mathmatical & Trig dvskb
=ABS(X)
Absolute
=ABS(-59) 59
†KvY welqK cwigv‡ci m~Îvewj t
145. Want more Updates
Sim Ө =
Cos Ө = =
Tan Ө =
=ACOS
Cosine
0 π 0o
180o
180/PI()
ACOS(X)
X Cosine angle -1 1
X AB=2
BC=1
=COS(X)
Cosine
=COS 1 1
146. Want more Updates
PI()/180
=ASIN(X)
Sine
∏/2 ∏/2 90o
90o
=SIN(X)
Sine
=SIN 1 1 Sin (X)
Sin
147. Want more Updates
=ATAN(X)
Tanget
∏ 2 ∏ 2 90o
90o
180/=PI()
X)
=ATAN2
X Y
∏ ∏ 180o
-180o
148. Want more Updates
=ATAN2(X,Y)
X
Y X Y = 0 =ATAN2 0
X Y=0 =ATAN2=∏; X,Y 0
(ERR
X Y =ATAN2 Quandrant
Ө π/2 I
π 2 π II
π π 2 III
π 2 0 IV
tan x =
=ATAN2(-1,-1)=-2.35619
=ATAN2(-1,-1)*180/PI()=-135
149. Want more Updates
X -135o
=EXP
x Power) e
e =2.718282(approximately) Natural logarithms, Base e
e Power
=EXP
=EXP(X)
X e Power ex
x=2 e2
=(2.718282)2
=7.392 ;
x=3 e3
=(2.718282)3
=20.08
x 709 x 230 -227
X
Scientific
=EXP(1.25)
3.490342
=INT(X)
X X
Address or Name
INT(29.9297)=29
=INT(E2)=102 [E2 102.95
=LN(X)
=EXP base e)
Compound growth or loss)
=LN(2) 0.693147
=LOG
Common logarithm) 10)
=MOD
=MOD(9,4) 1 9 4 1 Date Number 7
=MOD
0 1 2 3
=MOD(=DATE(93,11,01),7) 2
=PI()
π
3.1415 π
150. Want more Updates
4 (Area)
πr2
=PI()*4^2 area=50.26548
=RAND()
random Value 1 0 =RAND
F9 (Recalculation)
=RAND random Value Simulation test data
=RAND 1 0 general
=RAND 0 10 Random
Value =RAND()*10
[=RAND()
=RAND()*10+2 9.7470278
F9 0-12 random value
=ROUND(X,N)
=ROUND(X,N) X
N N 15 15 N
(+) Round N (-)
Round N
Integer
=ROUND(134.5789,2)=134.57
=ROUND(134.5789,3)=134.578
=ROUND(134.5789,-2)=100
[134 2 134-34=100]
=ROUND(134.5789,-1)=130
[ 134-4=130]
=ROUND(134.5789,0)=135
[
=SQRT(X)
=SQRT(X) X
=SQRT(64)=8
=SQRT(25)=5
=SQRT(-25)=ERR
153. Want more Updates
pv=
PV 0
Type= 0 1 FV Type
Type=0 (at the end of the period)
Type=0 Type=1
Rate=12% / 12
Rate=12% moc=4
100000 6%
× 6% / 12 =.05%)
× 10000 12
12 (Future Value)
FV
Rate=6%/12=.05%
npr=12
pmt=10000
pv=100000
type = payments are due at the beginning of the period)
FV(.05%,12,-10000,-100000,1)=220992.37
=PV(Present Value)
Syntax:
PV(rate,nper,pmt,fv,type)
Rate=
nper=
pmt=
fv=
type=1 0 0
type=0 When payment are due at the end of the period.
type=1, when payment are due at the end of the period.
171. Want more Updates
di&g¨vU †gby (Format menu)
Format Alt+O
Format>Cells...
Currency (gy`ªvwPý) Format
ý
ý
Format Cells... Format Cells
Cetegory: Currency
Symbol : ý ý Ok
ý Symbol :
ý Ok
177. Want more Updates
Looked ý Ok
Tools Protection
Protect Sheet ... Enter
Ok
Ok
Tools>Protection>unprotectSheet...
†iv dig¨vU (Row Format)
Format Row
Row Height
12.75 409
Format Row
Height...
Row Height:
Ok
×
1,2,3,...
Autofit
Height
Format Row
178. Want more Updates
AutoFit
Row Hide
Unhide
Format Row
Hide
Row Unhide
Hide Unhide
Format Row
Unhide
Format Column
Format Column
Column Width
Format Column
Width...
Column Width: Ok
×
(A,B,C...
179. Want more Updates
Auto Fit Selection
text)
Autofit Selection
Autofit Selection
Autofit Selection
Standard Width
8.43
Standard Width
Format Column
Standard Width...
Ok
kxU dig¨vU (Sheet Format)
Format Sheet
Sheet1, Sheet2, Sheet3
Format Sheet Rename
(Sheet1 Sheet2...)
kxU jyKv‡bv
180. Want more Updates
Format Sheet
Hide Hide
jyKv‡bv kxU wdwi‡q Avbv
Hide
Format Sheet
Unhide... Unhide
hide Unhide
Unhide
Ok
kx‡Ui e¨vKMÖvDÛ
Format Sheet
Background... Sheet Backgr ound
File name:
181. Want more Updates
A‡Uv dig¨vU
Predefined
Auto Format
Auto Format
Auto Format
Auto Format
Auto Format (Data
Auto Format
Format Auto Format... Auto Format
Ok
Auto Format Sample
Auto Format Options>>
Formats to apply
ý
Font
Alt+F
Ok
182. Want more Updates
Conditional Formatting
Conditional Formatting
Data
( Income
Income 40000 Income 21000
Income Conditional Formatting
Income
Format Conditional Formatting...
Conditional formatting
Between Greater than
40000
183. Want more Updates
Format...
Color:
Ok
Add>>
between Less that
21000
Format... Color:
Ok
184. Want more Updates
Ok
Income 40000 21000
÷vBj Style
Times New Roman
14 pt
Bold
Italic