Электронные таблицы /Spreadsheets

Select the specified range

• B5:D9

• =B4:D10

• B4:D9

• D9:B5

What color is the label Microsoft Excel?

• green

• White

• yellow

What types of data are used in Excel?

• Number

• formula

• drawing

• text

Select the correct formula entry for the spreadsheet

• C3+4*D4;

• СЗ=С1+2*С2;

• А5В5+23;

• =А2*АЗ-А4.

Expression 5(A2+C3):3(2B2-3D3) in the spreadsheet has the form:

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

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

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

Find the sum of the numbers A1 and B1

• 61

• 39

• 102

• 40

Find the average value of the numbers A1 and С1

• 18

• 61

• 102

• 40