Question

Question 11

Which formula below successfully performs an operation on a range of values stored in Excel cells?

=SQRT( A1:A15)

= EXP( A1:A15)

=LOG(A1:A15)

=ABS(A1:A15)

=SUM(A1:A15)

Question 12

Cells A1 through A10 contain the values shown in the table below. What does this formula evaluate to?
= SUM(A1:A10) - MAX( A1:A5 )

3

1

4

6

2

0

5

7

6

2

0

29

30

36

nothing - there is a syntax error in one of the formulas

Question 13

Which of the following formulas contains a syntax error?

Group of answer choices

= MAX( A1:A10, A15)

= SUM( A1:B10)

= AVERAGE( A1:A10:-B2)

= MIN( A1, B2, C3)

none of the above

Question 14

What is displayed if you select one data series in a worksheet and then create an x-y scatter chart?

uses data series as x coordinates and integers as y coordinates

uses the data series as y coordinates and integers as x coordinates

uses the data series as both x coordinates and as y coordinates

produces a blank chart

displays an error message but no chart

Question 15

What will be displayed if you select two data series in a worksheet and then choose to create a scatter chart?

Group of answer choices

uses the first data series as y coordinates and second data series as x coordinates

uses the first data series as x coordinates and second data series as y coordinates

uses each data series for y coordinates of separate lines and integers for x coordinates

uses each data series for x coordinates of separate lines and integers for y coordinates

none of the above

Question 16

When you copy a formula, such as = A1 + B2, to another cell, the cell references A1 and B2 will change. Why does a spreadsheet program do this?

to complicate the life of the user

so that the formula will still use the same numbers in its calculations

to allow the same formula to be used with other values in other cells

to show that the inverse of the square root of the radical computation is still valid

Question 17

The main strength of a spreadsheet program is that it allows the presentation of data and charts based on that data in a way that can be explained to and manipulated by the user.

True

False

Question 18

If the two data series used for an x-y scatter chart have different amounts of values in them, a spreadsheet program will treat this as an error and not produce a chart.

True

False

Question 19

If you copy a table of numbers from a web page and paste them into a worksheet, each value will be pasted into its own cell and the number of rows and columns will be preserved.

Here is a webpage (Links to an external site.) with a table on it that you can use to test this out.

True

False

Question 20

If you copy and paste a range from a worksheet into a word processor document, a table is created with one value per cell and the same number of rows and columns.

Group of answer choices

True

False

Answer 1

Which formula below successfully performs an operation on a range of values stored in Excel cells?

=SQRT( A1:A15)

= EXP( A1:A15)

=LOG(A1:A15)

=ABS(A1:A15)

=SUM(A1:A15)

Ans: =sum(A1:A15)

  

       Remaining all operations can perform operation individually. The sum only performs range of values.

Question 12

Cells A1 through A10 contain the values shown in the table below. What does this formula evaluate to?
= SUM(A1:A10) - MAX( A1:A5 )

3

1

4

6

2

0

5

7

6

2

0

29

30

36

nothing - there is a syntax error in one of the formulas

Ans: 30

Sum(A1:A10)=36 and max(A1:A5)=6 . so 36-6=30

Question 13

Which of the following formulas contains a syntax error?

Group of answer choices

= MAX( A1:A10, A15)

= SUM( A1:B10)

= AVERAGE( A1:A10:-B2)

= MIN( A1, B2, C3)

none of the above

ans: = AVERAGE( A1:A10:-B2)

Question 14

What is displayed if you select one data series in a worksheet and then create an x-y scatter chart?

uses data series as x coordinates and integers as y coordinates

uses the data series as y coordinates and integers as x coordinates

uses the data series as both x coordinates and as y coordinates

produces a blank chart

displays an error message but no chart

ans: uses the data series as y coordinates and integers as x coordinates

Question 15

What will be displayed if you select two data series in a worksheet and then choose to create a scatter chart?

Group of answer choices

uses the first data series as y coordinates and second data series as x coordinates

uses the first data series as x coordinates and second data series as y coordinates

uses each data series for y coordinates of separate lines and integers for x coordinates

uses each data series for x coordinates of separate lines and integers for y coordinates

none of the above

ans: uses the first data series as x coordinates and second data series as y coordinates

Question 16

When you copy a formula, such as = A1 + B2, to another cell, the cell references A1 and B2 will change. Why does a spreadsheet program do this?

to complicate the life of the user

so that the formula will still use the same numbers in its calculations

to allow the same formula to be used with other values in other cells

to show that the inverse of the square root of the radical computation is still valid

ans: so that the formula will still use the same numbers in its calculations

Question 17

The main strength of a spreadsheet program is that it allows the presentation of data and charts based on that data in a way that can be explained to and manipulated by the user.

True

False

Ans: True

Question 18

If the two data series used for an x-y scatter chart have different amounts of values in them, a spreadsheet program will treat this as an error and not produce a chart.

True

False

Ans : false

Question 19

If you copy a table of numbers from a web page and paste them into a worksheet, each value will be pasted into its own cell and the number of rows and columns will be preserved.

Here is a webpage (Links to an external site.) with a table on it that you can use to test this out.

True

False

Ans: True

Question 20

If you copy and paste a range from a worksheet into a word processor document, a table is created with one value per cell and the same number of rows and columns.

Group of answer choices

True

False

Ans: True