If cell A1 contains 55 and cell B1 contains 11, which entry into cell C1 results in 66?

Question

Question 41 options:

A1 + B1

= A1 + B1

A1, B1

= A1, B1
Question 42 (1 point)

If cell C1 has a formula that correctly computes the sum of cells A1 and B1, and A1 contains 55 and B1 contains 11, then C1 will be 66. What happens if A1's content is then changed to 20?
Question 42 options:

C1 stays at 66, until a user re-enters a new formula into C1

C1 stays at 66, until a user closes and re-opens the spreadsheet

C1 immediately changes to 20

C1 immediately changes to 31
Question 43 (1 point)

Which is NOT a common use of spreadsheets?
Question 43 options:

Displaying a table of data, like a table showing recent home sales

Drawing a chart, like a chart showing stock prices over the past year

Creating formatted text, like a resume that nicely shows a person's education/experience

Performing calculations, like adding a restaurant's daily sales into a month's total sales
Question 44 (1 point)

In a spreadsheet, a(n) _____ like AVERAGE is a pre-built set of instructions for performing a calculation.
Question 44 options:

function

address

query

protocol
Question 45 (1 point)

A relational database is a database that has a collection of tables of data items, all of which is formally described and organized according to the relational model.

Question 45 options:
True
False
Question 46 (1 point)

Given the following relation named "Student":

eagleID last first year major
90045321 Browne Kaitlyn Senior Information Technology
90075896 Bowlen Jimmy Freshman Basket Weaving
90052563 Morris LaShunta Junior Engineering
90058934 Keen Henry Senior Information Technology
90026544 Terry Amanda Freshman Business
90034898 Kim Eugene Sophomore Underwater Basket Weaving
90000001 Keen Davante Junior Business
Which SQL statement would retrieve only the first and last name values for all tuples ?

Question 46 options:

FROM Student SELECT first, last;

SELECT 2, 3 FROM Student;

SELECT first, last FROM Student;

SELECT first, last;

Question 47 (1 point)

SELECT Population FROM City WHERE Name='Tokyo';
is a correctly written SQL statement.

Question 47 options:
True
False
Question 48 (1 point)

An Excel spreadsheet function that returns the value of the cell with the largest value within a range of cells.

Question 48 options:

LARGEST

MAX

BIG

COUNTIF

Answer 1

Here are the answers based on the questions you've provided:

Question 41: Which entry into cell C1 results in 66?

• Answer: = A1 + B1

Question 42: If cell C1 has a formula that computes the sum of A1 and B1, and A1 changes to 20, what happens to C1?

• Answer: C1 immediately changes to 31 (since C1 would reflect the new sum: 20 + 11 = 31).

Question 43: Which is NOT a common use of spreadsheets?

• Answer: Creating formatted text, like a resume that nicely shows a person's education/experience (although spreadsheets can be manipulated for this purpose, it's not their primary use).

Question 44: In a spreadsheet, a(n) _____ like AVERAGE is a pre-built set of instructions for performing a calculation.

• Answer: function

Question 45: A relational database is a database that has a collection of tables of data items, all of which is formally described and organized according to the relational model.

• Answer: True

Question 46: Which SQL statement would retrieve only the first and last name values for all tuples?

• Answer: SELECT first, last FROM Student;

Question 47: SELECT Population FROM City WHERE Name='Tokyo'; is a correctly written SQL statement.

• Answer: True

Question 48: An Excel spreadsheet function that returns the value of the cell with the largest value within a range of cells.

• Answer: MAX

Let me know if you need any more assistance!