SECTION 2: SOFTWARE 2.11 Spreadsheets CHECK YOUR ENGLISH VOCABULARY FOR COMPUTER AND INFORMATION TECHNOLOGY

CHECK YOUR ENGLISH VOCABULARY

FOR COMPUTER AND INFORMATION TECHNOLOGY

SECTION 2: SOFTWARE

2.11 Spreadsheets

A. Choose the best word. 1 A basic spreadsheet is a __________ of spaces for data. A grid B cage C ladder 2 A spreadsheet consists of columns and __________. A lengths B lines C rows 3 A spreadsheet grid is called a worksheet. A file containing one or more worksheets is called a __________. A workout B work C workbook 4 In the worksheet above, the __________ cell is in column B, row 3. A important B active C focus 5 Use the mouse pointer to select a single cell or _________ of cells. A bunch B group C block 6 It's easy to adjust the column __________. A size B width C space 7 Spreadsheets can perform mathematical __________. A calculations B deductions C jobs 8 To get a worksheet to perform a mathematical calculation, you have to enter a ___________. A format B form C formula 9 A number in a spreadsheet cell is often called a __________. A digit B numeral C value 10 To remove the contents of a cell is to __________ that cell. A clean B wash C clear 11 To remove a complete row is to __________ that row. A wipe B delete C erase 12 Changing the fonts, colours etc. of a spreadsheet is called __________. A formatting B forming C reforming B. Add the arithmetic operator symbols to the table below. *     /     ^       -       + Symbol verb noun everyday speech add addition "five plus three equals eight" subtract subtraction "five minus three equals two" multiply multiplication "five multiplied by three equals fifteen" "five times three equals fifteen" divide division "fifteen divided by three equals five" raise to the power of "ten to the power of five is 100,000" C. Answer true or false. 1 0.75 → 7.5 The decimal point has been shifted one place to the right. TRUE / FALSE 2 188 102 65 12 The four numbers above have been sorted in ascending order. TRUE / FALSE 3 0.005 0.05 5,000 5,055.5 The four numbers above have been sorted in descending order. TRUE / FALSE 4 apples bananas pears pineapples The four words above have been sorted in alphabetical order. TRUE / FALSE D. Choose the best words from each pair in grey type. Three useful features in Microsoft Excel: → Cells can contain 1 text / language, numerical 2 values / details and formulas. It's also possible to add pop-up comment 3 boxes / squares containing additional information (choose Comment from the Insert menu → The Fill and Autofill commands can be used for making multiple copies of the contents of a cell. Autofill can also be used to automatically create a 4 list / series of months, numbers etc. → You can improve the 5 looks / appearance of a spreadsheet very quickly by using the AutoFormat feature.

 

ANSWER KEY

2.11 Spreadsheets A: 1 a, 2 c, 3 c, 4 b, 5 c, 6 b, 7 a, 8 c, 9 c, 10 c, 11 b, 12 a C: 1 true, 2 false (descending), 3 false (ascending), 4 true D: 1 text, 2 values, 3 boxes, 4 series, 5 appearance