wayground logo

Free Printable Worksheets

Font size

S
M
L
XL
Worksheets

5 Икт

Total questions: 100

Worksheet time: 50mins

Name
Class
Date
1.

In the Excel spreadsheet, select the basic element:

a)

String

b)

Number

c)

Cell

d)

Text

e)

Column

2.

Which types of cell addresses are used in Excel?

a)

numeric, neutral,  absolute

b)

relative, absolute, combined

c)

relative, text, absolute

d)

text, number, combined

e)

numeric, neutral, relative

3.

Which options can we do for MS Excel worksheet?

a)

can not be renamed

b)

only you can rename

c)

you can only delete and replace

d)

can only be copied

e)

rename, move, delete, copy

4.

Office button in MS Excel includes the following commands

a)

Sorting, Filter, Analysis, Prepare.

b)

Submit, Modify, Themes, Print.

c)

Create, Find, Modify.

d)

New, Open, Save, Print

e)

Spelling, Symbol, Save As

5.

What is the best way to higlight a row in MS Excel?

a)

Press ENTER.

b)

Click the middle of the row

c)

Click on the cell.

d)

Click the row number

e)

Click the mouse button.

6.

What is a Link in MS Excel?

a)

Partial socket address.

b)

Displays the cell addresses in the formulas.

c)

Buffer Copy Command.

d)

Buffer Deletion Team.

e)

Column number.

7.

A cell cannot contain data in the form of ...

a)

Text

b)

Formula

c)

Number

d)

Picture

e)

Date

8.

Which type of cell address contains rows number and column name?

a)

Relative

b)

Number

c)

Text

d)

Absolute

e)

Neutral

9.

Which type of cell address contains «$» before rows number or column name?

a)

Number

b)

Relative

c)

Mixed

d)

Absolute

e)

Neutral

10.

Which type of cell address contains «$» before rows number or column name?

a)

Number

b)

Relative

c)

Mixed

d)

Absolute

e)

Neutral

11.

In MS Excel A1:

a)

relative cell address

b)

absolute cell address

c)

cellular address.

d)

formula address.

e)

cell range.

12.

$A$1 in MSExcel:

a)

relative cell address

b)

absolute cell address

c)

cellular address.

d)

formula address.

e)

cell range.

13.

Formula bar in MS Excel displays?

a)

Cell contents

b)

Main commands

c)

Page numbers

d)

Word count

e)

Text styles

14.

What is the current date in MS Excel?

a)

= TDATE ()

b)

= DATE ()

c)

= INFLUENCE ()

d)

= TODAY ()

e)

= TTODAY ()

15.

What is the beginning of the formula in MS Excel?

a)

Plus

b)

Slash

c)

Equality

d)

Minus

e)

Colon

16.

What are the functions in the MS Excel?

a)

Logical

b)

Financial

c)

Statistical

d)

Math

e)

Text

17.

When computing in MS Excel # NAME! What does the mark appear in the form:

a)

the number does not match the cell

b)

that the cell reference is incorrect

c)

it is impossible to execute a number zero separation

d)

the cell name in the formula is invalid

e)

the function specifies the type of argument that can notbe used

18.

What happens when you type in MS Excel # REF:

a)

the number does not match the cell

b)

the cell reference is invalid

c)

it is impossible to execute a number zero separation

d)

the cell name specified in the formula does not work with MS Excel

e)

the function specifies the type of argument that can notbe used

19.

In MS Excel # VALUE! What does the mark appear in the form:

a)

the number does not match the cell

b)

that the cell reference is incorrect

c)

it is impossible to execute a number zero separation

d)

the cell name specified in the formula does not work with MS Excel

e)

the function indicates that an argument can not be used

20.

MS Excel. How is a syntax error calculated?

a)

The system will prevent you from entering a formula containing a syntax error.

b)

The calculation result is zero.

c)

An error message appears in the cell.

d)

The report answers the cell.

e)

An error message appears in the formula row.

21.

In Excel, you need to specify the names of the source and last cells in the cell and then place them in the cell

a)

Colon

b)

Comma

c)

Semicolon

d)

With dash

e)

Space should be left bank

22.

What type of function does MS Excel have?

a)

Mathematical functions.

b)

Standard functions.

c)

Date and time functions.

d)

Logical Functions.

e)

Dictionary functions.

23.

When you fill in the cell mark, the shape of the mouse is:

a)

Cross

b)

Direction line

c)

Double edge

d)

Dual directional line

e)

Wing sing

24.

A group of cells:

a)

We say the range of cells.

b)

We speak the working area.

c)

Let's talk about the book.

d)

We want a page.

e)

Explain the formula.

25.

MS Excel. Graphical representation of table data:

a)

Cells

b)

Column and path

c)

Worksheet

d)

Workbook

e)

Chart

26.

MS Excel. Element of chart is linked to the data being graphically displayed in the plot area of the chart:

a)

File

b)

Legend

c)

View

d)

Command

e)

Format

27.

MS Excel. The number of typical diagrams:

a)

20

b)

16

c)

11

d)

12

e)

13

28.

The chart is ...

a)

graphical representation of data

b)

multiplication of data

c)

sorting data

d)

filtering data;

e)

incorrect representation of data.

29.

Chart, where some values are represented by vertical columns of different heights, called

a)

Histogram

b)

Graph

c)

Line chart

d)

Area chart

e)

Pie chart

30.

The histogram is

a)

Chart, where some values are represented by vertical columns of different heights

b)

A chart consisting of parallelepipeds along the X-axis;

c)

A chart consisting of a three axis coordinate system;

d)

Chart  with different length strips horizontally along the X-axis

e)

A chart which is divided into sectors

31.

MS Excel. Construction of the chart is based:

a)

Data table

b)

Workbook

c)

Graphic file

d)

Text file

e)

Worksheet

32.

Region, which allows to match for each of data set  the color and design

a)

The legend

b)

Title

c)

Data series

d)

Sign

e)

Data marker

33.

A pie chart is a chart:

a)

n the form of a circle divided into sectors;

b)

in the form of vertical bars of various heights;

c)

in the form of points in a coordinate system;

d)

in the form of areas painted in different colors;

e)

representation of the data set using surface effect.

34.

A line chart is called:

a)

display the initial data as points connected by line segments;

b)

column group, height of which is proportional to the specific numeric values;

c)

sectors of the circle, the angles of which are proportional to the data elements;

d)

sequence of operations or processes of a certain length;

e)

representation of complex objects in a tree structure or graph.

35.

MS Excel. In the category of  logic functions comprises the functions:

a)

MAX, MIN, SIN;

b)

TIME, YEAR, DAY;

c)

IF, TRUE, FALSE;

d)

DATE, OR, COUNT;

e)

ABS, FIND, TEXT.

36.

MS Excel. The category of statistical functions includes functions:

a)

ABS, ASIN,SUM.

b)

YEAR, DAY.

c)

TRUE, FALSE.

d)

LOG, EXP.

e)

VAR, CORREL

37.

MS Excel. The command to delete the sheet:

a)

View – Delete sheet

b)

Contextual menu - Delete

c)

Contextual menu - Hide;

d)

Insert - Delete sheet;

e)

Data - Delete sheet.

38.

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

a)

Numeric

b)

Relative

c)

Mixed

d)

Absolute

e)

Neutral

39.

MS Excel. In $A$2 the absolute is

a)

Row number

b)

Name of the column

c)

The row number and column name.

d)

Not row number, not column name.

e)

Range name.

40.

MS Excel. In $A2 the absolute is

a)

Row number

b)

Name of the column

c)

The row number and column name.

d)

Not row number, not column name.

e)

Range name.

41.

MS Excel. What is the Insert Function :

a)

Toolbar

b)

Library of functions under the various categories.

c)

Submenu in Excel.

d)

A special panel with commands.

e)

A set of characters

42.

MS Excel. The command for adding a column to a sheet:

a)

Context menu – Insert –Entire Column.

b)

Context menu – Column.

c)

Context menu – Format cells - Column.

d)

Context menu – Paste Special - Column.

e)

Context menu – Filter - Column.

43.

MS Excel. Impossible options for the Date format:

a)

30/32/1996

b)

14/03/1999.

c)

January 29, 1994.

d)

05.12.1996.

e)

May 03, 2000.

44.

Specify in which case Excel correctly specified range of cells

a)

С4;К6

b)

С4:К6

c)

С4-К6

d)

С4 К6

e)

С4,К6

45.

MS Excel. The types of data that can be entered in the cells:

a)

Graphic information, text information, musical notations.

b)

Drawings, pictures and images.

c)

Numeric information, character information, dates, formulas.

d)

Tables, drawings and texts.

e)

Music information, visual information, temporal information.

46.

MS Excel. AutoFilter is used for:

a)

Sorting the data table

b)

Record of all macro commands

c)

Renames the data in the table

d)

Replacement position of  the data in the table

e)

Extract the necessary data from the table

47.

MS Excel. Autofilling can be used:

a)

Months, weekdays, chart names.

b)

Weekdays, numbers, chart names.

c)

Months, weekdays, numbers.

d)

Formulas, charts.

e)

Seasons, programs.

48.

MS Excel. A function that determines the sum of the numbers:

a)

SUM

b)

MIN

c)

MAX

d)

AVERAGE

e)

VAR

49.

MS  Excel. Where does dialog window appear by clicking the Insert Function icon?

a)

On the toolbar "Format"

b)

On the formula bar

c)

On the toolbar "Drawing"

d)

On the toolbar "Standard"

e)

On the toolbar "Tables and borders"

50.

A row or column of numbers that are plotted in a chart is called:

a)

The legend

b)

Title

c)

Data series

d)

Sign

e)

Data marker

51.

Choose the command to add the row to the Sheet in MS Excel:

a)

Page layout – Insert – Row

b)

Data – Insert – Row

c)

Home – Rows

d)

Context Menu – Insert – Entire Row

e)

View – Rows

52.

How to put a border (frame) in a table of MS Excel?

a)

Home –Alignment – Borders

b)

Home – Font – Borders

c)

Home – Editing – Borders

d)

Home – Styles – Borders

e)

Home – Cells – Borders

53.

Indicate the error in the writing of formula SUMM (C7:C10) in MS Excel:

a)

Insufficient number of arguments

b)

Cell range is incorrect

c)

Nosign "=" before the formula

d)

This function is absent

e)

Missing one more bracket for the SUM function

54.

What is $B1 and B$1 in  MS Excel?

a)

The relative cell address

b)

The absolute cell address

c)

Combining cell address

d)

Formula address

e)

Cell address

55.

MS Excel. How to adjust the size of columns and rows in a cell?

a)

Home –Cells – Format - Row height – Column width

b)

Home – Row (Column) –Height (Width)

c)

Data– Cells – Format - Row – Column

d)

View - Row (Column) – Height (Width)

e)

Data - Row height – Column width

56.

Formula for summation the range of cells:

a)

=SUM(А1:А7)

b)

=SUM(А1,А7)

c)

=SUM(А1 А7)

d)

=SUM(А1;А7)

e)

=SUM(А1,A3,А7)

57.

Correct version of the formula in MS Excel:

a)

=А3*100:В3.

b)

=А3*100/В3.

c)

А3!*100/В3.

d)

=А3!*100/В3.

e)

А3*100:В3.

58.

MS Excel. Inserted number 0.3674 in cell B6. If you select this cell and select Percentage format, how does this number change?

a)

0,003674%

b)

0,03674%

c)

0,3674%

d)

3,674%

e)

36,74%

59.

MS Excel. Inserted number 8675in cell B6. If you select this cell and select Currency format, how does this number change?

a)

86,75₽

b)

867,5₽

c)

8675,00₽

d)

86750,00₽

e)

867500,00₽

60.

Command that can be used to merge cells in MS Excel:

a)

Insert – Cells – Alignment – Merge cells

b)

Home – Alignment – Merge cells

c)

Home – Cells - Alignment – Merge cells

d)

Review - Cells - Alignment – Merge cells

e)

Data - Alignment – Merge cells

61.

What is the following record in MS Excel = $B3 * C$3?

a)

Add the values of the cells B3 and C3

b)

Divide cell B3 into cell C3

c)

Multiplication the values of cell B3 and C3

d)

Copy cell C3 to cell B3

e)

Insert cell C3 into cell B3

62.

What commands do you need to completelycopythe pagein MS Excel?

a)

Sheet label – Context Menu – Move or copy – OK

b)

Insert – Copy sheet – Create copy – OK

c)

View - Move or copy– Create copy – OK

d)

Context Menu – Page layout - Copy sheet – Create copy – OK

e)

Sheet label –Move or copy– Create copy – OK

63.

What is the type of chart shown in figure?

a)

Pie

b)

Bar

c)

Histogram

d)

Scatter

e)

Organizational

64.

What is the type of chart shown in figure?

a)

Bar

b)

Scatter

c)

Cone

d)

Pie

e)

Line

65.

What is the type of chart shown in figure?

a)

Line

b)

Histogram

c)

Pie

d)

Bar

e)

Cone

66.

What is the type of chart shown in figure?

a)

Doughnut

b)

Pie

c)

Bar

d)

Scatter

e)

Line

67.

MSExcel. What to do if data does not fit in the visible part of the cell?

a)

To increase the cell width or select the check box wrap text for that cell.

b)

Reduce the information to fit across the width of the cell.

c)

Find the cell wider and enter the information there.

d)

Merge cells and type the information there.

e)

Merge two rows and type the information there.

68.

MS Excel.A command to remove the sheet protection:

a)

Insert-Protection– Unprotect Sheet

b)

Home – Protection- Unprotect Sheet

c)

Data – Protection- Unprotect Sheet

d)

Review– Changes-Unprotect Sheet

e)

Formulas - Unprotect Sheet.

69.

How to get the command to calculate the square root of a value in Excel?

a)

Formulas tab – Insert function – Math & Trig – SQRT

b)

Formulas tab – Insert function – Statistical – SQRT

c)

Formulas tab – Insert function – Financial – SQRT

d)

Formulas tab – Insert function –SQRT

e)

Formulas tab – Calculate –SQRT

70.

MS Excel. A command of the formulas for calculating SIN, COS:

a)

Formulas-Insert function-Math & Trig

b)

Formulas-Insert function-Statistical

c)

Formulas-Insert function-Financial

d)

Formulas-Function

e)

Formulas-Calculation

71.

In cell B6 was entered a number 8675. If you select this cell and select "Scientific", then this number turns into:

a)

8 675,00 p

b)

8675,00

c)

867500,00%

d)

8,68E+0,3

e)

8675

72.

The formula for calculating the mean values of cells in MS Excel (A1: A10):

a)

AVERAGE (A1; A10)

b)

AVERAGE (A1: A10)

c)

AVERAGE (A1. A10)

d)

AVERAGE (A1, A10)

e)

AVERAGE (A: С10)

73.

Correct version of the function to determine the absolute value of the number in MS Excel:

a)

=АВS(F5)

b)

=АВS(f5, 2)

c)

=АВS(f5:f6)

d)

=АВS(F5:F6)

e)

АВS(С5:6)

74.

MSExcel. The HOME tab includes the following groups of commands:

a)

Tables, Illustrations, Charts, Text

b)

Themes, Page setup, Scale to feet, Sheet Options

c)

Font, Alignment, Number, Cells

d)

Connections, Sort & Filter, Data Tools

e)

Proofing, Comments, Changes.

75.

MSExcel. The INSERT tab includes the following groups of commands:

a)

Tables, Illustrations, Charts, Text

b)

Themes, Page setup, Scale to feet, Sheet Options

c)

Font, Alignment, Number, Cells

d)

Connections, Sort & Filter, Data Tools

e)

Proofing, Comments, Changes.

76.

MSExcel. The PAGE LAYOUT tab includes the following groups of commands:

a)

Tables, Illustrations, Charts, Text

b)

Themes, Page setup, Scale to feet, Sheet Options

c)

Font, Alignment, Number, Cells

d)

Connections, Sort & Filter, Data Tools

e)

Proofing, Comments, Changes.

77.

MSExcel. The REVIEW tab includes the following groups of commands:

a)

Tables, Illustrations, Charts, Text

b)

Themes, Page setup, Scale to feet, Sheet Options

c)

Font, Alignment, Number, Cells

d)

Connections, Sort & Filter, Data Tools

e)

Proofing, Comments, Changes.

78.

This error value appears when you incorrectly type the range name:

a)

######

b)

#DIV/0

c)

#NAME?

d)

#NUM!

e)

#REF!

79.

This error can be caused by an invalid argument in an Excel function:

a)

######

b)

#DIV/0

c)

#NAME?

d)

#NUM!

e)

#REF!

80.

How to insert pie chart in MS Excel?

a)

Insert – Charts – Pie

b)

Insert – Initial data – Pie

c)

Insert – Charts – Chart parameters – Pie

d)

Charts – Insert – Pie

e)

Charts – Charts window

81.

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)

a)

32

b)

52

c)

93

d)

9

e)

56

82.

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)

a)

32

b)

52

c)

93

d)

9

e)

56

83.

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)

a)

32

b)

52

c)

93

d)

9

e)

56

84.

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)

a)

32

b)

52

c)

93

d)

64

e)

82

85.

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)

a)

32

b)

52

c)

93

d)

37

e)

44

86.

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:

a)

25

b)

12

c)

20

d)

10

e)

5

87.

MS Excel. What function is written correctly?

a)

if (logical1,  valum_if_true);

b)

(if condition, logical1, ());

c)

=if (logical_test,valum_if_true_if_false);

d)

if (logical_test,valum_if_true_if);

e)

(if_ logical_test,valum_if_true_if_false);

88.

The result of the calculation, obtained in Excel tables by the formula "= B1 * C1", if B1= 5, C1= 2

a)

10

b)

13/4

c)

-7

d)

13/14

e)

7

89.

The result of the calculation, obtained in Excel tables by the formula

" = SQRT(B1+C1)", if  B1 = 55, C1 = 26:

a)

5

b)

8

c)

3

d)

7

e)

9

90.

How to specify in the Excel worksheet, a selected range of cells.

a)

A3:A6

b)

A3;A6

c)

A3…A6

d)

A3,A6

e)

A3-A6

91.

The result in cell D1 would be:

a)

5

b)

30

c)

25

d)

14

e)

45

92.

Given a fragment of the table. What appears in cell D2, if you put the formula = A2*B2*C2?

a)

0

b)

2

c)

-3

d)

-2

e)

-1

93.

The result of the calculation in cell C1 would be: 

a)

5

b)

10

c)

20

d)

15

e)

25

94.

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:

a)

Alimova

b)

Ibrayev

c)

Semenov

d)

Kuzmin

e)

Leonova

95.

Given a fragment of the MS Excel spreadsheet: What we get in cell E7, if you put the formula "=average(E2:E6)"?

a)

95000

b)

106000

c)

100000

d)

105000

e)

the error Message

96.

Given a fragment of the MS Excel spreadsheet: What we get in cell D7, if you put the formula "=MAX (D2:D6)"?

a)

20000

b)

70000

c)

130000

d)

10000

e)

the error Message

97.

Which of the following actions performed by the formula =PRODUCT(F8:F9):

a)

It sums the values in cells F8 and F9.

b)

It multiplies the values in cells F8 and F9.

c)

It produces an error, because there is no such formula.

d)

It divides the cell value of F8 to F9.

e)

It multiplies the arguments in parentheses.

98.

MS Excel. The formula for calculating the minimum value of the cells between the 1st and 2nd columns, 5 rows:

a)

=MIN(А5:А1).

b)

= MIN (А1:В5).

c)

= MIN (А1:А1).

d)

= MIN (А5:В5).

e)

= MIN (А5;А5).

99.

MS Excel. To edit the chart details, you need to do the following action

a)

2 mouse clicks of the given fraction of the chart

b)

click on the part of the chart 3 times with the mouse

c)

right-click on the given fraction of the chart

d)

click on the right mouse button of the given part of the diagram 2 times.

e)

mouse click on a given part of the chart

100.

MS Excel. How to place a diagram on a separate sheet?

a)

Insert – Charts – chart placement – on a separate sheet.

b)

Insert – Charts – on a separate sheet.

c)

The pop-up menu Desing – Location – Move chart – on a separate sheet.

d)

Data – Charts – chart placement – on a separate sheet.

e)

Charts – Location chart – on a separate.

Similar Resources on Wayground

CPSC Exam review

99 questions

CPSC Exam review

quiz

Worksheet

•

University

EMTECH Pop Quiz 2402

100 questions

EMTECH Pop Quiz 2402

quiz

Worksheet

•

University

Test robot 3ITE

100 questions

Test robot 3ITE

quiz

Worksheet

•

University

Cloud Computing

100 questions

Cloud Computing

quiz

Worksheet

•

University

Kuis 2 Dasar Teknologi Digital

95 questions

Kuis 2 Dasar Teknologi Digital

quiz

Worksheet

•

University

КСиСА

100 questions

КСиСА

quiz

Worksheet

•

University

Soal Pilihan Ganda Jaringan Komputer dan Teknologi Informasi

100 questions

Soal Pilihan Ganda Jaringan Komputer dan Teknologi Informasi

quiz

Worksheet

•

10th Grade - University

Quiz Berpikir Komputasional

100 questions

Quiz Berpikir Komputasional

quiz

Worksheet

•

10th Grade - University