Worksheetsикт река
Total questions: 50
Worksheet time: 25mins
1. MS Excel. Calculating by the formula "= СРЗНАЧ(А1;С1)", if
2,5
3,33
2,8
2,3
3,35
1. MS Excel. Calculating by the formula "= СУММ(А1:С1)", if
10
13
28
12
15
1. MS Excel. Calculating by the formula "= СУММ(А1;С2)", if
4
5
6
3
8
1. MS Excel. Calculating by the formula "= СУММ(А1:B2)", if
23
13
28
12
10
MS Excel. Management panel by table sheets is located:
on the left line under the working area
on the toolbar
in the condition line
on the right line under the working area
in the middle of the main working area
MS Excel. Combination of buttons of copying data:
«Ctrl + C»
«Alt + C»
«Alt + Ins»
«Ctrl + X»
«Alt + V»
MS Excel. Cell’s address, which is located at the intersection of the second row and the first column:
A2
2A
AA
B1
A1
MS Excel. Group of cells:
range
workspace
book
sheet
formula
MS Excel. Diagram element, showing the name of the data displayed in the diagram:
«Legend»
«File»
«View»
«Command»
«Format»
MS Excel. Minimum element for data storing:
cell
worksheet
workbook
table
file
MS Excel. Printable area - is taking out to print:
part of the worksheet
page layout
rectangular border
workspace
part of the desktop
MS Excel. Spreadsheet - is:
table in electronic form, performing automatic data processing
document created by means of panel instruments "drawing"
file created on the basic of charts
electronic document for storage of text data
table for the budget calculations
MS Excel. Graphical representation of tabular data is called:
diagram
columns
worksheet
workbook
CELL
MS Excel. Menu command for copying the data in the worksheet:
"Home" - "Copy"
File" - "Copy"
"Data" - "Copy"
"Insert" - "Copy"
"View" - "Copy"
MS Excel. At assigning of a percentage format:
number is multiplied to 100 and the sign % is added
the sign % is added to the number
number is multiplied to 100 and the sign # is added
a negative number becomes positive and the sign % is added
a negative number becomes positive and is multiplied to 100
MS Excel. Wrong version of the number format "Date":
30/32/2012
14.03.2012
January 29, 2012
10.12.12
Wednesday, December 10, 2012
MS Excel. Function «abs» is classified as:
mathematical
financial
statistical
logical
textual
MS Excel. Workbook - is a set of:
worksheet as a table
electronic forms
bulk objects
simple tabular data with chart
text documents
MS Excel. Vertical components of the screen net:
columns
cell
rows
worksheet
working field
MS Excel. Horizontal components of the screen net:
rows
columns
cell
worksheet
working field
MS Excel. Correct cell address:
B125
A12S
123c
B1A
22A
MS Excel. For changing of an active cell are used buttons:
cursor management
«Enter» or «Delete»
functional
«Insert» or «Shift»
«Tab» or «Ctrl»
MS Excel. Cell highlighted with bold rectangle is called:
active
passive
highlighted
special
working
MS Excel. Command of formulas inserting:
"Formula" - "Insert Function"
"Insert" - "Diagram"
"View" - "Function"
"Data" - "Graph"
Format" - "Function"
MS Excel. Non-existent type of functions:
absolute
statistical
financial
mathematical
logical
MS Excel. Conversational query "Pivot Table" can not allow to create a table based on data are stored in:
graphical form
several ranges
external data source
another pivot table
database
MS Excel. The formula = B3-C8:
subtract the contents of cell c8 from contents of the cells B3
allocates cells B3 and C8
subtracts the contents of cell B3 from the contents of the cells C8
adds the contents of cells B3 and C8
indicates the range of cells B3 and C8
MS Excel. In the formula "= (B2+B8)/10+500*C3» operators are used:
«+,/, +, *»
«+,\,+,:»
«B2, C3 B8»
«+,(,), \»
«+,*, =»
MS Excel. For writing of the absolute cell addresses is necessary a sign, before a letter and a number:
«$»
«&»
«*»
«^»
«@»
MS Excel. The cell formulas are separated from each other:
semicolon
space
brackets
ellipsis
comma
MS Excel. Functions "AVERAGE, MIN, MAX, COUNT" belong to the … category.
statistical
logical
financial
math&trig
text
MS Excel. Functions "TIME, YEAR, DATE, DAY" belong to the … category.
date&time
logical
financial
math&trig
text
MS Excel. Functions "ABS, ACOS, SIN, TAN" belong to the … category.
math&trig
statistical
logical
financial
text
MS Excel. Functions "IF, OR, AND, TRUE, FALSE" belong to the … category.
logical
math&trig
statistical
financial
text
MS Excel. Functions "REPLACE, FIND, REPEAT, SYMBOL" belong to the the … category.
text
logical
math&trig
statistical
financial
MS Excel. Functions statistical category belong to the:
A) AVERAGE, MIN, MAX, COUNT
B) REPLACE, FIND, REPEAT, SYMBOL
IF, OR, AND, TRUE, FALSE
ABS, ACOS, SIN, TAN
TIME, YEAR, DATE, DAY
MS Excel. Functions logical category belong to the:
IF, OR, AND, TRUE, FALSE
REPLACE, FIND, REPEAT, SYMBOL
AVERAGE, MIN, MAX, COUNT
ABS, ACOS, SIN, TAN
TIME, YEAR, DATE, DAY
MS Excel. Summarizing range formula of cells from B5 to B9:
=SUM (B5:B9)
=SUM (B5,B9)
=SUM (B5-B9)
SUM (B5:B9)
SUM (B5-B9)
MS Excel. Determining function of the root’s number:
ROOT (number)
COS (number)
MIN (number)
SIN (number)
SQR (number
MS Excel. Wrong type of argument expresses a sign:
#VALUE!
#NAME?
#####
#DIV/0!
#SUM
MS Excel. A number is divided by 0:
#DIV/0!
#NAME?
#####
#VALUE!
#SUM
MS Excel. Column isn’t wide enough to display data:
#####
#DIV/0!
#NAME?
#VALUE!
#SUM
MS Excel. Invalid cell reference:
#REF!
#DIV/0!
#NAME?
#VALUE!
SUM
MS Excel. Information is recorded at saving the table:
entire workbook
worksheet
three first sheets
worksbook
worksheet and chart
MS Excel. Variant of incorrect recording of function amounts:
=SUM(V2.V8)
=SUM(B2,B8)
=SUM(B2,B8:B20)
=SUM(B2:B8)
=SUM((B2:B8))
MS Excel. Table processors are ... software.
application
service
systemic
tabular
standard
MS Excel. Button of selecting of noncontiguous cells:
«CTRL»
«SHIFT»
«ALT»
«TAB»
«INSERT»
MS Excel. Button, which opens cell’s meaning for editing:
F2
F1
F5
F10
F12
MS Excel. Call button of program menu:
F10
F1
F5
F2
F12
MS Excel. A separate cell contains data types:
text, number, formula
lowercase data, icons
complex data
pictures, photos
symbols, icons, formula
