In the form of a circle divided into sectors; //
in the form of vertical bars of various heights; //
in the form of points in a coordinate system; //
in the form of areas painted in different colors; //
representation of the data set using surface effect.
***
A line chart is called://
display the initial data as points connected by line segments;//
column group, height of which is proportional to the specific numeric values;//
sectors of the circle, the angles of which are proportional to the data elements;//
sequence of operations or processes of a certain length;//
representation of complex objects in a tree structure or graph. //
***
MS Excel. In the category of logic functions comprises the functions://
MAX, MIN, SIN; //
TIME, YEAR, DAY; //
IF, TRUE, FALSE; //
DATE, OR, COUNT; //
ABS, FIND, TEXT.
***
MS Excel. The category of statistical functions includes functions://
ABS, ASIN,SUM.//
YEAR, DAY//
TRUE, FALSE.//
LOG, EXP.//
VAR, CORREL.
***
MS Excel. The command to delete the sheet://
View – Delete sheet;//
Contextual menu - Delete;//
Contextual menu - Hide;//
Insert - Delete sheet;//
Data - Delete sheet.
***
The cell address in Excel consisting of the column name, row number and a dollar sign "$" which placed before column name and before row number is called//
numeric//
relative//
mixed//
absolute//
neutral
***
MS Excel. In $A$2 the absolute is ://
Row number.//
Name of the column.//
The row number and column name.//
Not row number, not column name.//
Range name.
***
MS Excel. In $A2 the absolute is://
Row number.//
Name of the column.//
The row number and column name.//
Not row number, not column name.//
Range name.
***
MS Excel. What is the Insert Function ://
Toolbar.//
Library of functions under the various categories.//
Submenu in Excel.//
A special panel with commands.//
A set of characters.
***
MS Excel. The command for adding a column to a sheet://
Context menu – Insert –Entire Column.//
Context menu – Column.//
Context menu – Format cells - Column.//
Context menu – Paste Special - Column.//
Context menu – Filter - Column.
***
MS Excel. Impossible options for the Date format://
30/32/1996.//
14/03/1999.//
January 29, 1994.//
05.12.1996.//
May 03, 2000.
***
Specify in which case Excel correctly specified range of cells //
С4;К6//
С4:К6//
|
|
С4-К6//
С4 К6//
С4,К6
***
MS Excel. The types of data that can be entered in the cells://
Graphic information, text information, musical notations.//
Drawings, pictures and images.//
Numeric information, character information, dates, formulas.//
Tables, drawings and texts.//
Music information, visual information, temporal information.
***
MS Excel. AutoFilter is used for: //
Sorting the data table//
Record of all macro commands//
Renames the data in the table//
Replacement position of the data in the table//
Extract the necessary data from the table//
***
MS Excel. Autofilling can be used://
Months, weekdays, chart names.//
Weekdays, numbers, chart names.//
Months, weekdays, numbers.//
Formulas, charts.//
Seasons, programs.
***
MS Excel. A function that determines the sum of the numbers: //
SUM//
1) MIN//
MAX//
AVERAGE//
VAR
***
MS Excel. Where does dialog window appear by clicking the Insert Function icon? //
On the toolbar "Format"//
On the formula bar//
On the toolbar "Drawing"//
On the toolbar "Standard"//
On the toolbar "Tables and borders"
***
A row or column of numbers that are plotted in a chart is called:
The legend;//
Title;//
Data series; //
Sign;//
Data marker.//
***
Дата добавления: 2019-11-16; просмотров: 186; Мы поможем в написании вашей работы! |
Мы поможем в написании ваших работ!