1. ict companies and organizations. Task Work on new vocabulary
Yüklə 0,74 Mb.
|
- Bu səhifədəki naviqasiya:
- TitleBar
Task 2. Write formal letter to your manager regarding office supply problems by using given sample. ( See sample 1 ) To: johnmanager@gmail.com From: kamoliddinmirzaboyev05@gmail.com Subject: Application for the post of content writer Mr.John I want to introduce myself to you. I am a graduate of qualification engineering and have enough experience. I am looking forward to your reply. Respectfully, Kamoliddin Mirzaboyev Task 3. Write informal letter to your friend informing about your trip to France using by given sample. ( See sample 2 ) December 3. 2023 Dear Anna Hello John. I want to tell you about my trip to France. I traveled to Paris, France last month. I was there for a week. I studied the culture of France, tasted its food and visited its museums. I had dinner at the Eiffel Tower. I really enjoyed the trip. Yours lovingly. Kamoliddin Mirzaboyev. 11. SPREADSHEETS AND FORMULAE Task 1. Read and translate the given text orally. A spreadsheet is a computer application that is designed to add, display, analyze, organize, and manipulate data arranged in rows and columns. It is the most popular application for accounting, analytics, data presentation, etc. In other words, spreadsheets are scalable grid-based files that are used to organize data and perform calculations. People all across the world use spreadsheets to create tables for personal and business usage. You can also use the tool’s features and formulas to help you make sense of your data. For example – You may track data in a spreadsheet and see sums, differences, multiplication, division, and fill dates automatically, among other things. Microsoft Excel, Google Sheets, Apache Open Office, LibreOffice, etc. are some spreadsheet software. Among all these software, Microsoft Excel is the most commonly used spreadsheet tool and it is available for Windows, macOS, Android, etc. ( See picture 6). An Excel spreadsheet is a collection of spreadsheets is known as a workbook. Picture 6. An Excel spreadsheet. Every Excel file is called a workbook. Every time you start a new project in Excel, you’ll need to create a new workbook. Rows and columns are two distinct features in a spreadsheet that come together to make a cell, a range, or a table. Components of a spreadsheet. Picture 7. Components of spreadsheet. TitleBar: The title bar displays the name of the spreadsheet and application.Toolbar: It displays all the options or commands available in Excel for use.NameBox: It displays the address of the current or active cell.Formula Bar: It is used to display the data entered by us in the active cell. Also, this bar is used to apply formulas to the data of the spreadsheet.Column Headings: Every Excel spreadsheet contains 256 columns and each column present in the spreadsheet is named by letters or a combination of letters.Row Headings: Every Excel spreadsheet contains 65,536 rows and each row present in the spreadsheet is named by a number.Cell: In a spreadsheet, everything like a numeric value, functions, expressions, etc., is recorded in the cell. Or we can say that an intersection of rows and columns is known as a cell. Every cell has its own name or address according to its column and rows and when the cursor is present on the first cell then that cell is known as an active cell.Cell referring: A cell reference, also known as a cell address, is a way for describing a cell on a worksheet that combines a column letter and a row number. We can refer to any cell on the worksheet using cell references (in excel formulae). As shown in the above image the cell in column A and row 1 is referred to as A1. Such notations can be used in any formula or to duplicate the value of one cell to another (by using = A1).Navigation buttons: A spreadsheet contains first, previous, next, and last navigation buttons. These buttons are used to move from one worksheet to another workbook.Sheet tabs: As we know that, a workbook is a collection of worksheets. So this tab contains all the worksheets present in the workbook, by default it contains three worksheets but you can add more according to your requirement.The symbols These are all ‘basic maths functions’ - the kind of things you would find on a simple calculator. =: Tells your spreadsheet that you are writing a formula. This is the first thing that should go in your formula cell. (NOTE: A spreadsheet assumes that everything that begins with an ‘=’ is a formula… so be careful how you use it!) +: Add -: Subtract *: Multiply (this would be ‘x’ on a calculator) /: Divide (this would be ‘÷’ on a calculator) Tip: Get your symbols in the right order It is worth remembering that basic maths rules about the order of functions apply. For example, the formula =3+5*2 will give you 13, NOT 16. If you’re not sure why or can’t quite remember the rules, check out this basic introduction. If you want to change the order of function you’ll need parentheses: Formulas inside parenthesis will be evaluated before any other formula. If you want the formula above to result in 16 you’ll need to type: =(3+5)*2 Vocabulary:
Yüklə 0,74 Mb. Dostları ilə paylaş:
|