Question

Question 1

Which of the following spreadsheet formulas contains a syntax error?

Group of answer choices

=SQRT( A1 * LN( F3 / G2 + 12 * B6 )

=SQRT( A1 * LN( F3 / G2 + 12 * B6 ) )

=SQRT( A1 * LN( F3 / G2 ) + 12 * B6 )

=SQRT( A1 * LN( F3 ) / G2 + 12 * B6 )

=SQRT( A1 * LN( F3 / G2 + 12 ) * B6 )

Question 2

Which of the formulas below does NOT contain a syntax error?

=SQRT( A1 * LN( F3 / G2 + 12 * B6 )

=SQRT( A1 * LN( F3 / G2 + 12 * B6 ) )

=SQRT( A1 LN( F3 / G2 + 12 * B6 ) )

=SQRT( A1 * LN * ( F3 / G2 + 12 * B6 ) )

=SQRT ( ( A1 * LN( F3 / G2 + 12 * B6 ) )

Question 3

Cell A1 contains 3

Cell A2 contain -2

Cell B3 contains = 2 * A1 - A2

Cell C3 contains = 3 * B3 + 2 * A2

What do you see in cell C3?

8

10

20

26

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

Question 4

Cell A2 contains 5

Cell B2 contains = 2 * A2

Cell C5 contains = B2 + C5

What do you see in cell C5?

5

10

15

20

Some form of error - there is a syntax error in one of the formulas

Question 5

The area of a circle is written in math as πr². A student wants to calculate the area of the circle whose radius is 3. Which formula is correct if the radius is in cell D12?

= PI * SQRT( D12 )

= PI() * D12^2

= PI( D12 ^2 )

= PI * () * D12 * 2

none of the above

Question 6

The hypotenuse of a right triangle is calculated as the square root of the sum of the squares of the other two sides. If side 1 is stored in cell C1 and side 2 is stored in cell D1, which formula will correctly calculate the hypotenuse?

= SQRT( C1 * D1 )

= SQRT( C1 + D1^2 )

= SQRT( C1^2 ) + SQRT( D1^2 )

= SQRT( C1^2 + D1^2 )

none of the above

Question 7

Which type of spreadsheet chart do we use to present y as a function of x?

Horizontal bar chart

Vertical bar chart

scatter chart

line chart

pie chart

Question 8

What is a data series in a spreadsheet?

Group of answer choices

a special built-in formula

a group of numbers usually stored in consecutive rows of the same column

another name for a chart

the index numbers associated with each number on the x-axis

none of the above

Question 9

What happens when you produce a column chart after selecting one data series?

Group of answer choices

uses your last data selection for the x-axis data then produces a bar chart

displays chart with each bar height representing one value and x axis is integer index starting at 1

always displays a straight line because it uses the same data series for x and y axes

displays chart showing y values as a function of x values

displays an error message but no chart

Question 10

What will be displayed if you select two data series and then select a bar chart?

Group of answer choices

first data series is displayed on horizontal axis and second data series is displayed on vertical axis of a scatter chart

first data series is displayed on vertical axis and second data series is displayed on horizontal axis of a bar chart

both data series are used to create the horizontal axis scale, integers used on the vertical axis, with two separate bars drawn for each integer

both data series are used to create the vertical axis scale, integers used on the horizontal axis, with two separate bars drawn for each integer

Answer 1

1. =SQRT( A1 * LN( F3 / G2 + 12 * B6 )

2. =SQRT( A1 * LN( F3 / G2 + 12 * B6 ) )

3. 20

4. 10 (if initial value of C2 is NULL/0)

5. none of the above

6. = SQRT( C1^2 + D1^2 )

7. line chart

8. a group of numbers usually stored in consecutive rows of the same column

9. displays chart showing y values as a function of x values

10. both data series are used to create the vertical axis scale, integers used on the horizontal axis, with two separate bars drawn for each integer