Large And Complex Microsoft Excel Spreadsheets

Date: 2015-10-07; view: 541.

UNIT 15

Откройте скобки

1. Max (to be not) ………..here. He (to wash)……………… his car. He always (to wash) ………………it in the evening.

2. He (to play) …………… the piano at every party. But he (not to play) …………… tomorrow. He (to meet) …………….his sister. She (to come) ………………… back from Italy. She (to go) ………………to Italy every summer. She sometimes (to spend) ………………there three months.

3. The train (to leave) ………….. at 6.

4. I (to leave) ………………… tomorrow. I (to go)………………….to Spain.

5. We (to write) ……………………….. a dictation tomorrow. We (to write) ……………………..dictations very often.

SPREADSHEETS AND DATABASES

TASK 1

You are going to read an article about Microsoft Excel Spreadsheets. For questions 1-6 choose the answer A-D which you think fits best according to the article.

When Microsoft Excel is used to construct large and complex spreadsheets containing multiple worksheets, it can become extremely difficult for someone to navigate, let alone track or trace numbers through the spreadsheet with all of the values and formulas contained within it. This is because in a large spreadsheet like a financial document, there can often be hundreds if not thousands of different formula down and across each page including calculations which may contain several links to other sheets within the financial workbook. The difficulty experienced with navigating through the formulas of large and complex spreadsheets exists even when you were the one who designed and built the spreadsheet.

Microsoft Excel does come up with some basic functionality to help users navigate through spreadsheets formulas. Some common methods are the following:

• Utilizing the ‘Go To' window [ctrl + G] and typing in cell addresses
• Outlining same sheet precedents in different colors
• Using formula to move back and forth between same sheet references and the ‘Go To' window to move back and forth between off-sheet references.

However, the main problem is that when trying to check or understand a formula you must first take a look at the precedents cells or ranges, but then be able to quickly jump to the other precedent cells and finally back to the original formula you were originally looking at. Navigating to these precedents and then back again using Microsoft Excel's existing functionality is time consuming to say the least as many have felt the frustration of editing, checking, de-bugging, enhancing or auditing a formula that you, or worse, someone else has created in their spreadsheet when multiple precedents and sheets are involved.

This common complaint with Microsoft Excel is heard time and time again by engineers, accountants, bankers and finance professionals who work with Excel spreadsheets on a daily basis. Many spreadsheet users including financial modelers (who seem to be in charge) are turning towards Excel Add-ins and software tools that plug into Microsoft Excel to help them navigate through formulas and complex spreadsheets more easily.

Probably the most popular and widely used Excel add-in for this purpose is ‘Formula Navigator'. An add-in created by the company ‘Spreadsheet Guys'. They have developed a unique add-in utilising a re-sizeable floating window and hyperlink system to help Excel users understand a formula and efficiently jump to all of its precedent and dependent cells and ranges no matter whether they are on a different worksheet or a different open workbook. An additional history window added as part of the products 2nd release also allows the user to click back to any cell previously looked at using the tool, during the current open session.

Whether the spreadsheet was designed by you or someone else, ‘Formula Navigator' definitely fills a need and has already cured the frustration of many Excel spreadsheet users, helping them to more quickly understand the logic in a formula and links between sheets, thus helping to reduce spreadsheet errors, facilitate debugging and assist with spreadsheet auditing.

1. The difficulty with navigating through the large and complex spreadsheets exists because:

1. they are too large and complex
2. there are hundreds of formula down and across
3. they contain complex financial calculating
4. they contain several links
   
   

2. Microsoft Excel's help with navigating through spreadsheets is:

1. using the ‘Go To' window and typing in cell addresses
2. colouring same sheet precedents differently
3. using formula to move back and forth
4. providing users with some basic functionality
   
   

3. The main problem with spreadsheets remains because:

1. navigating to the precedents and then back again is time consuming
2. you feel the frustration of editing, checking or debugging them
3. someone else but not you created these spreadsheets
4. Microsoft Excel's existing functionality for spreadsheets is not efficient

4. As a result of having difficulties with spreadsheets many users:

1. keep complaining about their problems
2. turned to specifically designed Excel Add-ins
3. don't want to work with spreadsheets on a daily basis
4. want to simplify formulas in complex spreadsheets

5. The company ‘Spreadsheet Guys' have developed:

1. ‘Formula Navigator' add-in
2. a hyperlink system
3. a utilising and re-sizeable floating window
4. an additional history window

6. Dissatisfaction of many Excel spreadsheet users has been reduced because they:

1. are able to reduce spreadsheet errors
2. can do debugging mo quickly and efficiently
3. they can understand the logic in a formulae and links
4. started to use ‘Formula Navigator'

TASK 2

Find Russian equivalents to the following words and word combinations from the article in TASK 1.

1. multiple worksheets
2. track or trace numbers
3. time consuming
4. time and time again
5. on a daily basis
6. to be in charge
7. floating window
8. reduce spreadsheet errors
9. facilitate debugging
10. was designed by

TASK 3

Translate the following words and word combinations into English (TASK 1).

1. используя существующий функционал Excel
2. редактирование, проверка формулы
3. большие и сложные таблицы
4. типичная/обычная жалоба
5. обращаться в сторону
6. работать с таблицами ежедневно
7. таблица была создана кем-то
8. система гиперссылок
9. недовольство/разочарование
10. понять логику формулы

TASK 4

Read the text below and decide which word A-D best fits each place.