The function indicates that an argument can not be used
Proofing, Comments, Changes.
***
This error value appears when you incorrectly type the range name://
#######//
#DIV/0 //
#NAME?//
#NUM!//
#REF!
***
This error can be caused by an invalid argument in an Excel function://
#######//
#DIV/0//
#NAME? //
#NUM!//
#REF!
***
How to insert pie chart in MS Excel?//
Insert – Charts – Pie//
Insert – Initial data – Pie//
Insert – Charts – Chart parameters – Pie//
Charts – Insert – Pie//
Charts – Charts window
***
The numbers 44, 64, 52, 37, 82, 52, 32, 93, 48 are entered in the range of cells B2: B10. What calculates the Microsoft Excel function, having the form MEDIAN (B2: B10) //
32//
52//
93//
9//
56
***
The numbers 44, 64, 52, 37, 82, 52, 52, 93, 48 are entered in the range of cells B2: B10. What calculates the Microsoft Excel function, having the form MODE(B2: B10) //
32//
52//
93//
9//
56
***
The numbers 44, 64, 52, 37, 82, 52, 32, 93, 48 are entered in the range of cells B2: B10. What calculates the Microsoft Excel function, having the form COUNT(В2:В10) //
32//
52//
93//
9//
56
***
The numbers 44, 64, 52, 37, 82, 52, 32, 93, 48 are entered in the range of cells B2: B10. What calculates the Microsoft Excel function, having the form MAX (B2: B10) //
32//
52//
93//
9//
56
***
The numbers 44, 64, 52, 37, 82, 52, 32, 93, 48 are entered in the range of cells B2: B10. What calculates the Microsoft Excel function, having the form MIN(B2: B10) //
32//
52//
93//
37//
56
***
In cell A1 the number 4 is written, in cell B1 the formula = A1 * 2 is written. Specify the result of C1 if it contains the formula = A1 + B1://
25.//
12.//
20.//
10.//
5.
***
MS Excel. What function is written correctly?
if (logical1, valum_if_true);
(if condition, logical1, ());
=if (logical_test,valum_if_true_if_false);
if (logical_test,valum_if_true_if);
(if_ logical_test,valum_if_true_if_false);
***
The result of the calculation, obtained in Excel tables by the formula "= B1 * C1", if B1= 5, C1= 2//
10 //
13/4 //
-7//
13/14 //
7
***
The result of the calculation, obtained in Excel tables by the formula
" = SQRT(B1C1)", if B1 = 55, C1 = 26://
5; //
8; //
3; //
7; //
9.
***
How to specify in the Excel worksheet, a selected range of cells.
A3:C6
A3:C3
A3,C6
A3…C6
A3-C6
***
The result in cell D1 would be:
|
|
A.
B.
5;
30;
25;
14;
45.
***
Given a fragment of the table . What appears in cell D2, if you put the formula = A2*B2*C2?
0
2
-3
-1
-2
***
The result of the calculation in cell C1 would be:
15
10
20
5
25
***
Given a fragment of the MS Excel spreadsheet:
Which name would go first, if you sort the data by the salary field in ascending order:
Alimova
Ibrayev
Semenov
Kuzmin
Leonova
***
Given a fragment of the MS Excel spreadsheet:
What we get in cell E7, if you put the formula "=average(E2:E6)"?
95000//
106000//
100000//
105000//
the error Message
***
Given a fragment of the MS Excel spreadsheet:
What we get in cell D7, if you put the formula "=MAX (D2:D6)"?
2000//
7000//
1400//
1000//
the error Message
***
Which of the following actions performed by the formula =PRODUCT(F8:F9): //
It sums the values in cells F8 and F9.//
It multiplies the values in cells F8 and F9.//
It produces an error, because there is no such formula.//
It divides the cell value of F8 to F9.//
It multiplies the arguments in parentheses.
***
MS Excel. The formula for calculating the minimum value of the cells between the 1st and 2nd columns, 5 rows: //
=MIN(А5:А1).//
= MIN (А1;В5).//
= MIN (А1:А1).//
= MIN (А5:В5).//
= MIN (А5;А5).
***
MS Excel. To edit the chart details, you need to do the following action
mouse click on a given part of the chart //
2 mouse clicks of the given fraction of the chart //
click on the part of the chart 3 times with the mouse //
right-click on the given fraction of the chart //
click on the right mouse button of the given part of the diagram 2 times.
***
MS Excel. How to place a diagram on a separate sheet?//
The pop-up menu Desing – Location – Move chart – on a separate sheet. //
Insert – Charts – chart placement – on a separate sheet. //
Insert – Charts – on a separate sheet. //
Data – Charts – chart placement – on a separate sheet. //
Charts – Location chart – on a separate.
***
In the Excel spreadsheet, select the basic element: //
|
|
string //
number //
cell //
text //
column
***
Which types of cell addresses are used in Excel? //
numeric, neutral, absolute //
relative, absolute, combined //
relative, text, absolute //
text, number, combined //
numeric, neutral, relative
***
Which options can we do for MS Excel worksheet? //
can not be renamed //
only you can rename //
you can only delete and replace //
can only be copied //
Rename, move, delete, copy
***
Office button in MS Excel includes the following commands: //
Sorting, Filter, Analysis, Prepare. //
Submit, Modify, Themes, Print. //
Create, Find, Modify. //
New, Open, Save, Print //
Spelling, Symbol, Save As
***
What is the best way to higlight a row in MS Excel? //
Press ENTER. //
Click the middle of the row//
Click on the cell.//
Click the row number .//
Click the mouse button.
***
What is a Link in MS Excel? //
Partial socket address. //
Displays the cell addresses in the formulas. //
Buffer Copy Command. //
Buffer Deletion Team. //
Column number.
***
A cell cannot contain data in the form of ... //
text; //
formula; //
number; //
Picture; //
date;
***
Which type of cell address contains rows number and column name? //
number //
relative //
text //
absolute //
neutral
***
Which type of cell address contains «$» before rows number or column name? //
number //
relative //
mixed //
absolute //
neutral
***
Which type of cell address contains «$» before rows number and column name? //
number //
relative //
mixed //
absolute //
neutral
***
In MS Excel A1: //
relative cell address //
absolute cell address //
cellular address. //
formula address. //
cell range.
***
$A$1 in MSExcel: //
relative cell address //
absolute cell address //
cellular address. //
formula address. //
cell range.
***
Formula bar in MS Excel displays? //
Cell contents//
Main commands//
Page numbers//
Word count//
Text styles.
***
What is the current date in MS Excel? //
= TDATE () .//
= DATE () .//
= INFLUENCE () .//
|
|
= TODAY () .//
= TTODAY ().
***
What is the beginning of the formula in MS Excel? //
plus //
Slash //
equality //
minus //
colon
***
What are the functions in the MS Excel? //
Logical
Financial. //
Statistical
Math.//
Text.
***
When computing in MS Excel # NAME! What does the mark appear in the form://
the number does not match the cell //
that the cell reference is incorrect //
it is impossible to execute a number zero separation //
The cell name in the formula is invalid
the function specifies the type of argument that can not be used
***
What happens when you type in MS Excel # REF: //
the number does not match the cell //
The cell reference is invalid
it is impossible to execute a number zero separation //
the cell name specified in the formula does not work with MS Excel //
the function specifies the type of argument that can not be used
***
In MS Excel # VALUE! What does the mark appear in the form: //
the number does not match the cell //
that the cell reference is incorrect //
it is impossible to execute a number zero separation //
the cell name specified in the formula does not work with MS Excel //
The function indicates that an argument can not be used
***
MS Excel. How is a syntax error calculated? //
The system will prevent you from entering a formula containing a syntax error. //
The calculation result is zero. //
An error message appears in the cell. //
The report answers the cell. //
An error message appears in the formula row.
***
In Excel, you need to specify the names of the source and last cells in the cell and then place them in the cell //
Colon
comma //
semicolon //
with dash //
space should be left blank
***
What type of function does MS Excel have? //
Mathematical functions. //
Standard functions. //
Date and time functions. //
Logical Functions. //
Dictionary functions.
***
When you fill in the cell mark, the shape of the mouse is: //
Cross. //
Direction line. //
Double edge. //
Dual directional line. //
Wing sign.
***
A group of cells: //
|
|
We say the range of cells. //
We speak the working area. //
Let's talk about the book. //
We want a page. //
Explain the formula.
***
MS Excel. Graphical representation of table data: //
Cells. //
Column and path. //
Worksheet. //
Workbook. //
Chart.
***
MS Excel. Element of chart is linked to the data being graphically displayed in the plot area of the chart://
File.//
Legend.//
View.//
Command.//
Format.
***
MS Excel. The number of typical diagrams://
20.//
16.//
11.//
12.//
13.
***
The chart is ...//
graphical representation of data;//
multiplication of data;//
sorting data;//
filtering data;//
incorrect representation of data.//
***
Chart, where some values are represented by vertical columns of different heights, called://
histogram;//
graph;//
line chart;//
area chart;//
pie chart.
***
The histogram is://
Chart, where some values are represented by vertical columns of different heights; //
A chart consisting of parallelepipeds along the X-axis; //
A chart consisting of a three axis coordinate system; //
Chart with different length strips horizontally along the X-axis; //
A chart which is divided into sectors.//
***
MS Excel. Construction of the chart is based://
Data table;//
workbook; //
graphic file;//
text file;//
worksheet.
***
Region, which allows to match for each of data set the color and design://
The legend;//
Title;//
Data series; //
Sign;//
Data marker.//
***
A pie chart is a chart: //
Дата добавления: 2019-11-16; просмотров: 387; Мы поможем в написании вашей работы! |
Мы поможем в написании ваших работ!