"test___SPIRITHEET_1 9th grade"

ELECTRONIC TABLES

1. A spreadsheet is:

2. The expression 5(A2+C3):3(2B2-3D3) in the spreadsheet looks like:

5(A2+C3)/3(2B2-3D3);

5*(A2+C3)/3*(2*B2-3*D3);

5*(A2+C3)/(3*(2*B2-3*D3));

5(A2+C3)/(3(2B2-3D3)).

3. What will be the value of cell C1 if you enter the formula =A1+B1 into it:

20; 2. 15; 3. 30; 4. 10?

4. The spreadsheet is intended for:

processing predominantly numerical data structured using tables;

orderly storage and processing of significant amounts of data;

visualization of structural relationships between data presented in tables;

editing graphical representations of large amounts of information.

5. When moving or copying in a spreadsheet, absolute references:

do not change;

are transformed depending on the new position of the formula;

are transformed depending on the rules specified in the formula.

6. The address of a spreadsheet cell is

1. any sequence of characters;
2. number of bytes of RAM allocated for the cell;
3. name, consisting of the column name and row number;
4. address of the RAM byte allocated for the cell;
5. address of the machine word of RAM allocated for the cell.

7. What will be the value of cell A8 if you enter the formula =SUM(A1:A7)/2 into it:

8. In general, the columns of a spreadsheet are:

numbered;

9. For the user, the spreadsheet cell is identified:

a special code word;

10. Select the correct formula entry for the spreadsheet:

11. Before the designation of the column or row number in the absolute address of the cell, a sign is placed ...

1. $ 2. = 3. % 4. &

12. The active cell is the cell:

to record commands;

13. What formula will be obtained when copying the formula from cell C2 into cell C3:

3. =$A$1*$A$2+$B$2?

14. The main element of ET is:

15. To select several intervals of cells, hold down the key:
1. Alt; 2. Ctrl ; 3.Insert ; 4. Arrows.

16. An autocomplete marker (black cross) will appear if the cursor is placed:

2. in the lower right corner of the cell;
3. to the gray rectangle at the intersection of the row and column headings;
4. in the middle of the cell.

17. The data contained in the cell can be edited:

1. in the menu;
2. in the formula bar;
3. in a cell;
4. in a special window.

18. In ET you cannot delete:

19. What Formula will be obtained by copying the formula from E2 into E4?
1. =$A$2*$C$4;
2. =A2*$C$2;
3. =$A$2*C4;
4. =A4*C4.

View document contents
"test_SPREADSHEETS_2. 9th gradedoc"

ELECTRONIC TABLES

1. A spreadsheet is:

an application program designed to process data structured in the form of a table;

application program for processing code tables;

a PC device that manages its resources in the process of processing data in tabular form;

a system program that manages PC resources when processing tables.

2. To select several intervals of cells, hold down the key:

1. Shift ; 2. Ctrl ; 3.Insert ; 4. Arrows.

3. An autocomplete marker (black cross) will appear if the cursor is placed:

1. in the upper left corner of the cell;
2. on the gray rectangle at the intersection of the row and column headings;
3. in the middle of the cell.
4. in the lower right corner of the cell;

4. The spreadsheet is:

a set of numbered lines and columns named by letters of the Latin alphabet;

a set of rows and numbered columns named in letters of the Latin alphabet;

a collection of numbered rows and columns;

a collection of rows and columns named arbitrarily by the user.

5. Spreadsheet Rows:

are named by users in an arbitrary manner;

are indicated by letters of the Russian alphabet;

are indicated by letters of the Latin alphabet;

are numbered.

6. For the user, the spreadsheet cell is identified:

by sequentially specifying the column name and row number at the intersection of which the cell is located;

the address of the machine word of RAM allocated for the cell;

a name arbitrarily specified by the user.

a special code word;

7. The expression 5(A2+C3):3(2B2-3D3) in the spreadsheet looks like:

5(A2+C3)/3(2B2-3D3) ;

5*(A2+C3)/(3*(2*B2-3*D3)) ;

5(A2+C3)/(3(2B2-3D3)) .

5*(A2+C3)/3*(2*B2-3*D3) ;

8. Find the formula for ET among those given:

1. A3B8+12;
2. A1=A3*B8+12;
3. A3*B8+12;
4. =A3*B8+12.

9. The data contained in the cell can be edited:

1. in the menu; 2. in a cell; 3. in the formula bar; 4. in a special window.

10. When moving or copying in a spreadsheet, relative links:

are transformed regardless of the new position of the formula;

are converted depending on the length of the formula;

do not change;

are transformed depending on the new position of the formula.

11. The active cell is the cell:

to record commands;

in which commands are entered.

12. What formula will be obtained when copying the formula from cell C2 into cell C3:

=$A$1*$A$2+$B$2;

13. What will be the value in cell C1 if you enter the formula: =SUM(A1:B1)*2?

14. What will the value of cell A8 be equal to if you enter the formula =SUM(A1:A7)/2 into it:

15. What character does a formula in Excel begin with?

1. it doesn’t matter which one; 2. +; 3. Space; 4. =.

16. In ET you cannot delete:

17. Before the designation of the column or row number in the absolute address of the cell, a sign is placed ...

1. & 2. = 3. % 4. $

18. What Formula will be obtained by copying the formula from E2 into E4?
1. =A2*5;
2. =$A$2*4;
3. =A2*$C$4;
4. =$A$2*5.

19. The main element of ET is.

Spreadsheets

Table processor- a category of software designed to work with spreadsheets. Initially, table editors allowed processing exclusively two-dimensional tables, primarily with numerical data, but then products appeared that also had the ability to include text, graphic and other multimedia elements. Spreadsheet tools include powerful mathematical functions that enable complex statistical, financial, and other calculations.

Spreadsheets(or table processors) are application programs designed to carry out spreadsheet calculations. The appearance of spreadsheets historically coincides with the beginning of the spread of personal computers. The first program for working with spreadsheets, a spreadsheet processor, was created in 1979, intended for computers like the Apple II and called VisiCalc. In 1982, the famous table processor Lotus 1-2-3 appeared, designed for the IBM PC. Lotus combined the computing power of spreadsheets, business graphics, and the functions of a relational database management system. The popularity of table processors grew very quickly. New software products of this class appeared: Multiplan, Quattro Pro, SuperCalc and others. One of the most popular spreadsheet processors today is MS Excel, part of the Microsoft Office suite.

What is a spreadsheet? This is an information technology tool that allows you to solve a whole range of problems: First of all, performing calculations. For a long time, many calculations have been carried out in tabular form, especially in the field of office work: numerous pay sheets, tabulagrams, cost estimates, etc. In addition, the solution of a number of mathematical problems by numerical methods; convenient to do in tabular form. Spreadsheets are a convenient tool for automating such calculations. Solving many computing problems on a computer, which previously could only be done through programming, has become possible to implement Mathematical modeling. The use of mathematical formulas in ET allows one to imagine the relationship between various parameters of some real system. The main property of ET is the instant recalculation of formulas when the values ​​of their operands change. Thanks to this property, the table is a convenient tool for organizing a numerical experiment:

1. selection of parameters,
2. prediction of the behavior of the simulated system,
3. dependency analysis,
4. planning.

Additional convenience for modeling is provided by the possibility of graphical presentation of data (diagrams); Using a spreadsheet as a database. Of course, compared to DBMSs, spreadsheets have less capabilities in this area. However, some data manipulation operations characteristic of relational DBMSs are implemented in them. This is searching for information based on specified conditions and sorting information.

Spreadsheets also provide a graphical mode of operation, which makes it possible to graphically represent (in the form of graphs, charts) the numerical information contained in the table.

Main data types: numbers, both in regular and exponential format, text - a sequence of characters consisting of letters, numbers and spaces, formulas. Formulas must begin with an equal sign, and can include numbers, cell names, functions (mathematical, statistical, financial, text, date and time, etc.) and mathematical symbols.

Spreadsheets are easy to use, quickly mastered by non-professional computer users, and greatly simplify and speed up the work of accountants, economists, and scientists.

Basic elements of spreadsheets:

1. Column,
2. Column headings,
3. Line,
4. Row headers,
5. Inactive cell
6. Active cell.

Story

The idea of ​​spreadsheets was first formulated by the American scientist Richard Mattessich, who published a study entitled “Budgeting Models and System Simulation”. The concept was supplemented by Pardo and Landau, who filed an application for the corresponding patent (U.S. Patent 4,398,249 (English)). The patent office rejected the application, but the authors through the court got this decision overturned.

The generally recognized founder of spreadsheets as a separate class of software is Dan Bricklin, who, together with Bob Frankston, developed the legendary VisiCalc program in the city. This spreadsheet editor for the Apple II computer became a “killer application” that turned the personal computer from an exotic toy for technophiles into a mass tool for business.

Subsequently, numerous products in this class appeared on the market - SuperCalc, Microsoft MultiPlan, Quattro Pro, Lotus 1-2-3, Microsoft Excel, OpenOffice.org Calc, AppleWorks spreadsheets and

List of software products

Links

Wikimedia Foundation. 2010.

See what “Spreadsheets” are in other dictionaries:

A computer program that supports the presentation of data in the form of tables consisting of rows and graphs, at the intersection of which cells (table cells) are located. The value in a numeric cell of the table is either specified explicitly, or... ... Financial Dictionary

Spreadsheets- A computer program in the form of a spreadsheet that presents digital data on a computer screen, organized in rows and columns, and allows you to analyze financial information, make calculations, and make changes to those calculations on... ... Investment Dictionary

Graphic images and elements of numerous and varied instruments and devices of electronics, automation, radio and computer technology. The design and development of basic electronic circuits and more complex systems created from them is just... Collier's Encyclopedia

Optical-electronic detectors- 4.2.2. Optical-electronic detectors Optical-electronic detectors with a linear or surface narrowly directed detection zone (curtain type) are recommended to be used for blocking windows (including double-glazed windows), doors, walls, ceilings,... ... Dictionary-reference book of terms of normative and technical documentation

This is a collection of chemical elements with a similar arrangement of valence electrons in the atom. The similarity is that their highest energy valence electrons occupy the same type of orbital. The term first appeared in the works... ...Wikipedia

A category of software designed to work with spreadsheets. Initially, table editors made it possible to process exclusively two-dimensional tables, primarily with numerical data, but then products appeared that... ... Wikipedia

OpenOffice.org Calc Spreadsheet is a computer program that allows you to perform calculations with data, pre ... Wikipedia

- ... Wikipedia

Type spreadsheet word processor presentation ... Wikipedia

Review article about currency signs (symbols) Currency signs For individual signs, see the articles Ruble symbol, Dollar symbol, Euro symbol, Pound symbol, Dram symbol, Drachma symbol, Denarius symbol, Rial symbol, Rupee symbol, Yen symbol, Symbol... ... Wikipedia

Books

• Spreadsheets, functions, databases and relationships. Diagrams. Lists. Macros, Svetlana Muratova. This laboratory workshop is used when studying the course “Spreadsheets, Functions, Databases and Relationships” (section “Charts. Lists. Macros”) and is a continuation…

Spreadsheet Test

Select all correct answers to the test questions

1. A spreadsheet is:

1) a personal computer device that manages its resources in the process of processing data in tabular form;

2) application program for processing code tables;

3) an application program designed to process data structured in the form of a table;

4) a system program that manages the resources of a personal computer when processing tables.

2. The spreadsheet is intended for:

1) processing predominantly numerical data structured using tables;

2) orderly storage and processing of significant amounts of data;

3) visualization of structural relationships between data presented in tables;

4) editing graphical representations of large amounts of information.

3. The spreadsheet is:

1) a collection of rows and columns named arbitrarily by the user.

2) a set of rows and numbered columns named in letters of the Latin alphabet;

3) a collection of numbered rows and columns;

4) a set of numbered lines and columns named in Latin letters.

4. Spreadsheet Rows:

1) are named by the user in any way;

2) are indicated by letters of the Russian alphabet;

E.V. Kovrigina. Creating and editing spreadsheets in the OpenOffice.org environment.

3) are designated by letters of the Latin alphabet;

4) are numbered.

5. In general, the columns of a spreadsheet are:

1) are numbered;

2) are designated by letters of the Latin alphabet;

3) are designated by letters of the Russian alphabet;

4) are named by the user in an arbitrary manner.

6. For the user, the spreadsheet cell is identified:

1) a name arbitrarily specified by the user;

2) the address of the machine word of RAM allocated for the cell;

3) a special code word;

4) by sequentially specifying the column name and row number at the intersection of which the cell is located.

7. Calculation formulas in the spreadsheet cells are written:

1) in ordinary mathematical notation;

2) in a special way using built-in functions and according to the rules adopted for writing expressions in programming languages;

3) according to the rules adopted exclusively for spreadsheets;

4) according to the rules adopted exclusively for databases.

8. Expression 3(A1+B1):5(2B1-3A2), written in accordance with the rules accepted in mathematics, in the OpenOffice.org Calc spreadsheet has the form:

10.Recording a formula in a spreadsheet cannot include:

11.The range of cells is:

1) a set of cells forming a rectangular area in the table;

2) all cells of one row;

3) all cells of one column;

4) set of valid values.

12.An active cell is a cell:

1) to record commands;

2) containing a formula that includes the name of the cell in which data is entered;

3) a formula that contains references to the contents of the dependent cell;

4) in which data entry is performed.

13.What formula will be obtained in OpenOffice.org Calc when copying formulas from cell E2 into cell E4 (in E2: =A2*C2):

E.V. Kovrigina. Creating and editing spreadsheets in the OpenOffice.org environment.

16.What should be changed if a cell shows an error ###:

17.An underlined letter in the menu bar means:

1) opening a cascade menu;

2) command not available;

3) launch a command when pressed with the Alt key;

4) the team is active.

18.Relative addressing of cells:

1) the cell address is determined relative to its location;

2) the cell address is defined relative to the column name;

3) The cell address is defined relative to the row name.

20.To transfer the words of a cell to OpenOffice.org Calc, you must use:

E.V. Kovrigina. Creating and editing spreadsheets in the OpenOffice.org environment.

1) Format – String;

2) Format – Column;

3) Format – Cells.

21.To frame part of a table in OpenOffice.org Calc, use:

1) the corresponding button on the toolbar;

2) Format – Cells – Border;

3) Format – Styles;

4) draw by hand.

22.Each formula in ET begins with:

23.A diagram is:

1) visual representation;

2) graphical display of table data;

3) schedule;

4) addiction.

24.What is the correct action to take to get an answer to the question: “What percent is 25 of the number 93?”:

1) write the formula “25/93” in the cells;

2) write the formula “=25/93” into the cells;

3) write the formula “=25*100/93” into the cells;

4) Write the formula “=25/93” in the cells and select the percentage format.

25.To write text vertically you need:

E.V. Kovrigina. Creating and editing spreadsheets in the OpenOffice.org environment.

1) merge cells;

2) put a $ sign;

3) select the direction of the text in the cell format;

4) align text in cell format.

26.To sort a table in OpenOffice.org Calc:

1) specify the range and select the “sort by...” button from the toolbar;

2) use the menu item Data – Filter;

3) use the menu item Data – Sorting;

4) specify the range and use the menu item Data – Sorting.

27.To build a pie chart, you must select:

1) diagram option;

2) chart type;

3) chart range.

28.To save an OpenOffice.org Calc document in another format, you must:

2) change file extensions after saving;

3) select Tools – Options – Open Office Calc;

4) select Tools – Options – Load/Save. 29.What is the $ sign used for:

1) for relative cell addressing;

2) to set a range of cells;

3) for absolute addressing of cells;

4) for writing formulas.

30.What you can do using AutoFilter:

1) data sorting;

E.V. Kovrigina. Creating and editing spreadsheets in the OpenOffice.org environment.

2) selecting data that matches the request;

3) data deletion;

4) filling the cells.

31.To find the autosum in OpenOffice.org Calc use:

32.The range of cells is written through:

34.To select individual cells, you must hold down the key:

35.To change the format in OpenOffice.org Calc, under certain conditions, you must use:

1) Format – Cells;

2) Format – Page;

3) Format – Conditional formatting;

4) Format – Styles.

36.Is it possible to sort by several parameters?

1) yes;

E.V. Kovrigina. Creating and editing spreadsheets in the OpenOffice.org environment.

3) under certain conditions.

37.To remove grid lines in OpenOffice.org Calc, you need to use:

2) Tools – Options – OpenOffice.org Calc – Grid;

38.How will the formula “=A1+B$1” (OpenOffice.org Calc) written in cells A2 change to cells A4?

39.How will the formula “=A1+B$1” (OpenOffice.org Calc) written in cells A2 change to cells B4?

40.To create a list in OpenOffice.org Calc used for autocomplete, you must:

1) Tools – Options – OpenOffice.org Calc – View;

2) Tools – Options – OpenOffice.org Calc – Sort lists;

3) Tools – Options – OpenOffice.org Calc – General;

4) Tools – Options – OpenOffice.org Calc – Changes.

41.The line where formulas are displayed in OpenOffice.org Calc is called:

1) formula bar;

2) input line;

E.V. Kovrigina. Creating and editing spreadsheets in the OpenOffice.org environment.

3) name line.

42. At the intersection of a row and a column it turns out:

43.The cell name is obtained from:

1) row name and column name;

2) column name and row name;

3) string name;

4) column name.

44.What is the name of the selected object

1) figure;

2) filling;

3) autocomplete marker;

4) marker.

45.How can you change the width of column B:

1) drag the border between columns A and B;

2) drag the border between columns B and C;

3) drag the border between columns A1 and B1;

4) drag the border between columns B1 and C1.

46.How can you confirm text entry simultaneously into all selected

1) press the Alt keyboard key;

2) press the keyboard keys Ctrl + Enter;

E.V. Kovrigina. Creating and editing spreadsheets in the OpenOffice.org environment.

4) press the “cross” next to the input line.

47.How can I confirm text entered into a cell?

1) press one of the control keys on the keyboard;

2) press the keyboard keys Enter;

3) click the check mark next to the input line;

4) press the “cross” next to the input line.

48.For what purpose in OpenOffice.org Calc can the specified

1) to display the currency;

2) for horizontal alignment;

3) to merge cells;

4) to display number format.

49.Is it possible to create several diagrams on one sheet?

1) yes, any quantity;

2) yes, any quantity, only for tables located on this sheet;

3) yes, any quantity, only for the tables located in this book;

4) no.

50.What symbol is used as a multiplication sign?

51.Can I use parentheses when entering formulas?

1) yes, always;

2) yes, but only when using absolute links;

3) yes, but only when using links to other sheets;

4) no E. .V. Kovrigina. Creating and editing spreadsheets in the OpenOffice.org environment.

52.What symbols can be used as division signs in formulas?

54.Which menu can you use to complexly sort data in a table?

55.What cannot be used as input data when creating a diagram:

1) two tables located on one sheet;

2) two tables located on different sheets;

3) two tables located in different books;

4) another diagram.

Option 1

1. A spreadsheet is:

A) an application program designed to process data structured in the form of a table;

B) application program for processing code tables;

C) a PC device that controls its resources in the process of processing data in tabular form;

D) a system program that controls PC resources when processing tables.

2. The spreadsheet is intended for:

A) processing predominantly numerical data structured using tables;

B) orderly storage and processing of significant amounts of data;

C) visualization of structural relationships between data presented in tables;

3. The spreadsheet is:

A) a set of numbered lines and columns named in letters of the Latin alphabet;

B) a set of rows and numbered columns named in letters of the Latin alphabet;

C) a set of numbered rows and columns;

D) a set of rows and columns named by the user in an arbitrary manner.

4. Spreadsheet Rows:

A) are named by users in an arbitrary manner;

B) are designated by letters of the Russian alphabet;

B) are designated by letters of the Latin alphabet;

D) are numbered.

5. In general, the columns of a spreadsheet are:

A) are designated by letters of the Latin alphabet;

B) are numbered;

B) are designated by letters of the Russian alphabet;

D) are named by users in an arbitrary manner;

6. For the user, the spreadsheet cell is identified:

A) by sequentially specifying the column name and row number at the intersection of which the cell is located;

B) the address of the machine word of RAM allocated for the cell;

B) a special code word;

D) a name arbitrarily specified by the user.

7. Calculation formulas are written in the spreadsheet cells:

A) in ordinary mathematical notation;

B) in a special way using built-in functions and according to the rules adopted

C) to write expressions in programming languages;

D) according to the rules adopted exclusively for spreadsheets;

D) according to the rules adopted exclusively for databases.

8. The expression 5(A2+C3):3(2B2-3D3) in the spreadsheet looks like:

A) 5(A2+C3)/3(2B2-3D3) ;

B) 5*(A2+C3)/3*(2*B2-3*D3) ;

IN) 5*(A2+C3)/(3*(2*B2-3*D3)) ;

D) 5(A2+C3)/(3(2B2-3D3)) .

9. Select the correct formula entry for the spreadsheet:

G) =A2* A3- A4

10. When moving or copying in a spreadsheet, absolute references:

A) do not change;

D) are transformed depending on the length of the formula;

D) are transformed depending on the rules specified in the formula.

11. When moving or copying in a spreadsheet, relative links:

A) are transformed regardless of the new position of the formula;

B) are transformed depending on the length of the formula;

B) do not change;

D) are transformed depending on the new position of the formula.

12. Range is:

A) a set of cells forming a rectangular area in the table;

B) all cells of one row;

C) all cells of one column;

13. The active cell is the cell:

A) to record commands;

D) in which commands are entered.

14. What formula will be obtained when copying the formula from cell C2 into cell C3:
A) =A1*A2+B2;

B) =$A$1*$A$2+$B$2;

IN ) =$A$1*A3+B3;

D) =$A$2*A3+B3;

D) =$B$2*A3+B4?

Option 2

5.The main element of ET is:

7.When moving or copying to ET, absolute links:

A) do not change;

B) are transformed regardless of the new position of the formula;

B) are transformed depending on the new position of the formula;

D) are transformed depending on the length of the formula.

8. Range is:

A) all cells of one row;

B) a set of cells forming a rectangular area in the table;

C) all cells of one column;

D) set of acceptable values.

9. A spreadsheet is:

A) application program for processing code tables;

B) a personal computer device that manages its resources;

C) an application program designed to process data structured in the form of a table;

D) a system program that controls the resources of a personal computer when processing tables.

D3, formulas from cellD2:

A) =A2*$C$2;

B) = A 3*$ C $2;

The spreadsheet is:

a) a set of numbered lines and columns named using letters of the Latin alphabet;

b) a set of rows and numbered columns named using letters of the Latin alphabet;

c) a set of numbered rows and columns;

d) a set of rows and columns named by the user in an arbitrary manner;

e) a table typed in a text editor.

The spreadsheet is intended for:

a) orderly storage and processing of significant amounts of data;

b) visualization of structural relationships between data presented in tables;

c) editing graphical representations of large amounts of information;

d) processing of predominantly numerical data, structured using tables, carried out in the process of economic, accounting, engineering calculations;

e) broadcasting files over a computer network.

The fundamental difference between a spreadsheet and a regular one is the ability to:

a) automatic recalculation of values ​​determined by formulas when the source data changes;

b) processing data in the table;

c) visual representation of connections between data;

d) simultaneous processing of data of various types;

e) copying the table.

In the spreadsheet, cell A1 contains the number 10, B1 contains the formula =A1/2, and C1 contains the formula =SUM(A1:B1)*2. What is the value of C1:

a) 100; b) 150; c) 10; d) 30; e) 75.

Option 3

1.Indicate the correct cell address:

3. The result of calculations in cell C1 will be:

5.In ET the cell name is formed:

6.Indicate the wrong formula:

7.When moving or copying relative links to ET:

A) do not change;

B) are transformed regardless of the new position of the formula;

C) are transformed depending on the new position of the formula;

D) are transformed depending on the length of the formula.

8. An active cell is a cell:

A) to record commands;

D) in which data entry is performed.

9. The spreadsheet is intended for:

A) processing predominantly numerical data structured using tables;

B) orderly storage and processing of significant amounts of data;

C) visualization of structural relationships between data presented in tables;

D) editing graphical representations of large amounts of information.

10. What formula will be obtained when copied into a cell?D3, formulas from cellD2:

A ) =A2*C2;

B) =$ A $2* C 3;

Calculation formulas in the spreadsheet cells are written:

a) in ordinary mathematical notation;

b) according to the rules adopted in logic programming languages;

c) in a special way using built-in functions and according to the rules adopted for writing expressions in imperative programming languages ;

d) according to the rules adopted exclusively for databases;

d) in an arbitrary manner.

In the spreadsheet, cell A1 contains the number 5, B1 contains the formula =A1*2, and C1 contains the formula =A1+B1. What is the value of C1:

a) 10; b) 15 ; c) 20; d) 25; e) 45.

Among the given formulas, find the formula for the spreadsheet:

A ) =A3*B8+12;

b) A1=A3*B8+12;

e) A1=A3B8+12.

A spreadsheet cell is identified by:

a) the address of the machine word of RAM allocated for the cell;

b) a special code word;

c) by sequentially specifying the column name and row number at the intersection of which the cell is located;

d) a name arbitrarily specified by the user;

e) by sequentially specifying the row number and column name at the intersection of which the cell is located.

Test on the topic “Graphs and charts in a spreadsheet environment”

Business graphics are:

a) meeting schedule;

b) graphic illustrations;

c) a set of function graphs;

d) a set of software tools that make it possible to present in graphical form patterns of changes in numerical data.

The diagram is:

a) a form of graphical representation of numerical values, which makes it easier to interpret numerical data;

b) schedule;

c) a beautifully designed table;

By computer science developed...

Kolpashnikova I.A. Teacher at OGOI NPO “PU No. 35”

ELECTRONIC TABLES

TEST

1. A spreadsheet is:

an application program designed to process data structured in the form of a table;

application program for processing code tables;

a PC device that manages its resources in the process of processing data in tabular form;

a system program that manages PC resources when processing tables.

2. The spreadsheet is intended for:

processing predominantly numerical data structured using tables;

orderly storage and processing of significant amounts of data;

visualization of structural relationships between data presented in tables;

editing graphical representations of large amounts of information.

3. The spreadsheet is:

a set of numbered lines and columns named by letters of the Latin alphabet;

a set of rows and numbered columns named in letters of the Latin alphabet;

a collection of numbered rows and columns;

a collection of rows and columns named arbitrarily by the user.

4. Spreadsheet Rows:

are numbered.

5. In general, the columns of a spreadsheet are:

are indicated by letters of the Latin alphabet;

numbered;

are indicated by letters of the Russian alphabet;

are named by users in an arbitrary manner;

6. For the user, the spreadsheet cell is identified:

by sequentially specifying the column name and row number at the intersection of which the cell is located;

the address of the machine word of RAM allocated for the cell;

a special code word;

a name arbitrarily specified by the user.

7. Calculation formulas are written in the spreadsheet cells:

in ordinary mathematical notation;

in a special way using built-in functions and according to the rules adopted for writing expressions in programming languages;

according to the rules adopted exclusively for spreadsheets;

according to the rules adopted exclusively for databases.

8. The expression 5(A2+C3):3(2B2-3D3) in the spreadsheet looks like:

5(A2+C3)/3(2B2-3D3) ;

5*(A2+C3)/3*(2*B2-3*D3) ;

5*(A2+C3)/(3*(2*B2-3*D3)) ;

5(A2+C3)/(3(2B2-3D3)) .

9. Select the correct formula entry for the spreadsheet:

C3+4*D4

C3=C1+2*C2

A5B5+23

A2*A3-A4

10. When moving or copying in a spreadsheet, absolute references:

do not change;

are transformed depending on the new position of the formula;

are transformed depending on the rules specified in the formula.

11. When moving or copying in a spreadsheet, relative links:

are transformed regardless of the new position of the formula;

are converted depending on the length of the formula;

do not change;

are transformed depending on the new position of the formula.

12. Range is:

a set of cells forming a rectangular area in the table;

all cells of one row;

all cells of one column;

set of valid values.

13. An active cell is a cell:

to record commands;

containing a formula that includes the name of the cell in which data is entered;

a formula that contains references to the contents of the dependent cell;

in which commands are entered.

14. What formula will be obtained when copying the formula from cell C2 into cell C3:

A1*A2+B2;

=$A$1*$A$2+$B$2;

=$A$1*A3+B3;

=$A$2*A3+B3;

=$B$2*A3+B4?

15. What will be the value of cell C1 if you enter the formula =A1+B1 into it:

20;

15;

10;

30?

16. What will be the value of cell C1 if you enter the formula =SUM(A1:A7)/2 into it:

280;

140;

40;

35?

KEY

Home » Investments » A spreadsheet contains a collection of fill cells. Business graphics represent Main Presentation - information coding Russian aviation Su 35 maximum flight speed Magazine “Legendary Aircraft Legendary Aircraft” release schedule Customs clearance of transported goods - rules and conditions Customs clearance services as correctly called Business graphics represent