![]()
|
|||||||
Student : Saleh kariem MosaadGroup: 19ll8aPractical work “TABULAR PROCESSORS”Control questions:
1. Describe structure of the typical interface of the electronic spread sheet 2. Enumerate and explain the main types of the input data which can be entered into electronic spreadsheet cells. formulas and functions, and also dates. Character (text) data has descriptive character. They can include alphabetic, numerical and special characters. As their first character the apostrophe is often used and sometimes - inverted commas or a gap. 3. Enumerate and explain existing formats of representation of numeric data in electronic spreadsheet cells. § The Main format is used by default, providing record of numeric data in cells in the same type as they are entered or calculated. § The Format with the fixed amount of decimal signs provides representation of numbers in cells with the given accuracy defined by the user with an amount of decimal signs after a comma (decimal points). For example, if you set format, including two decimal places, then you enter in cell number 12345 will be recorded as a 12345. 00, and the number of 0. 12345 - as. 12. 4. Enumerate and explain existing formats of representation of symbolic data in cells. § Alignment to the cell left edge allocates the first character entered by you дан-ных in an extreme left position of a cell. For many programs this mode is used by default as the main. § Alignment to the right edge of the cell has the last character entered in a data cell in itsrightmost position
5. What is the formula in the electronic spreadsheet and its types. Show examples. In arithmetical formulas following operators of arithmetical actions are used: addition, Subtraction, multiplication, division, exponentiation. 6. What is the function in the electronic spreadsheet and its types. Show examples. § The mathematical; § The statistical; § The text; § The logical; § The financial; § Date and time functions, etc. 7. Explain sequence of performance of operations in arithmetical formulas. greater than (> ), less than (< ), not more than (< =), not less than (> =). The result of evaluating an arithmetic formula is a number. Logical formulas may contain the specified comparison operators, as well as a special social logical operators: #NOT# - logical " NOT" #AND# is a logical " AND", #OR# - logical " OR". A B A C 1 3 5 2 2 3 12 1 3 4 7 6 8. How the unit (range) of cells is underlined at performance of any command? The buffer of the intermediate storage is the area of a random access memory that help user to transfer data from one part of the table to another, from one window (table) in another or from one Windows application to another. 9. Explain, for what are used absolute and differential addresses of cells. original, this does not change. To do this, the $ symbol is placed before the name of the column and row number. $5$; $D$12 - full absolute links. 10. What is the meaning of the rules of the automatic adjustment formula at copy and move operations? Generic formula to be moved or copied perceived as a template, which specifies the location of the input data regarding offers a wide R grid cell with the formula. 11. Show on examples all possible variants of automatic change of addresses in formulas atperformance of operation of copying.
|
|||||||
|