The intersection of a row and column in a spreadsheet is called a(n) _____.

Question

Question 24 options:

cell

address

formula

function
Question 25 (1 point)

Which most properly uses the SUM function to sum the values in cells A1 through A4?
Question 25 options:

=SUM(A1:A4)

=SUM(A1, A2, A3, A4)

=SUM(A1+A2+A3+A4)

=SUM(A1) + SUM(A2) + SUM(A3) + SUM(A4)
Question 26 (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 26 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 27 (1 point)

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

A1 + B1

= A1 + B1

A1, B1

= A1, B1
Question 28 (1 point)

A spreadsheet cell contains 'B1 + B2'. What type of value is this?
Question 28 options:

Text

Number

Function

Formula
Question 29 (1 point)

A spreadsheet's columns and rows are labeled with letters and numbers. Which represents the cell 5 rows down and 3 columns to the right?
Question 29 options:

53

35

15

C5
Question 30 (1 point)

A special-purpose programming language designed for managing data held in a relational database management system (RDBMS) is called:

Question 30 options:

Java

Python

SQL

HTML

Question 31 (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 all records where the major is Information Technology?

Question 31 options:

SELECT WHERE major = 'Information Technology';

SELECT * FROM Student WHERE major = 'Information Technology';

FROM Student SELECT * WHERE major = 'Information Technology';

SELECT FROM Student WHERE major = 'Information Technology';

Question 32 (1 point)

An individual piece of data, such as a student's last name, stored in a database table is called a _____.
Question 32 options:

key

query

field

record
Question 33 (1 point)

A user runs a command to find all entries in a database whose "year" field is 2016. Such a command is called a _____.
Question 33 options:

DBMS

query

field

cell
Question 34 (1 point)

Which is most suitable to serve as the primary key for employee records in a database.
Question 34 options:

The employee's unique identification number

The employee's start date

The employee's last name

The employee's gender
Question 35 (1 point)

What would be the first word of an SQL instruction used to list all people in a database who are 21 years old?
Question 35 options:

SELECT

INSERT

AGE

21
Question 36 (1 point)

Data _____ refers to the accuracy of the data in a database.
Question 36 options:

integrity

validation

coherence

solidity
Question 37 (1 point)

Each row of a database consists of an employee's id number, name, hire date, and salary. The entire row is known as a _____.
Question 37 options:

query

field

record

cell
Question 38 (1 point)

A user wishes to keep a record of all employees that work at a company, and to quickly be able to get answers to questions like "Which employees earn over $50,000?" or "How many employees live in California?". Which application is best suited?
Question 38 options:

Word processor app

Spreadsheet app

Presentation app

Database app
Question 39 (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 39 options:

SELECT first, last FROM Student;

SELECT 2, 3 FROM Student;

SELECT first, last;

FROM Student SELECT first, last;

Question 40 (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 all tuples and attributes?

Question 40 options:

FROM Student SELECT ALL;

SELECT Student;

SELECT ALL FROM Student;

SELECT * FROM Student;

Answer 1

Here are the answers to your questions:

Question 24:
The intersection of a row and column in a spreadsheet is called a(n) cell.

Question 25:
Which most properly uses the SUM function to sum the values in cells A1 through A4?
Answer: =SUM(A1:A4)

Question 26:
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. If A1's content is then changed to 20, what happens?
Answer: C1 immediately changes to 31.

Question 27:
If cell A1 contains 55 and cell B1 contains 11, which entry into cell C1 results in 66?
Answer: = A1 + B1

Question 28:
A spreadsheet cell contains 'B1 + B2'. What type of value is this?
Answer: Formula

Question 29:
A spreadsheet's columns and rows are labeled with letters and numbers. Which represents the cell 5 rows down and 3 columns to the right?
Answer: C5

Question 30:
A special-purpose programming language designed for managing data held in a relational database management system (RDBMS) is called:
Answer: SQL

Question 31:
Which SQL statement would retrieve all records where the major is Information Technology?
Answer: SELECT * FROM Student WHERE major = 'Information Technology';

Question 32:
An individual piece of data, such as a student's last name, stored in a database table is called a _____.
Answer: field

Question 33:
A user runs a command to find all entries in a database whose "year" field is 2016. Such a command is called a _____.
Answer: query

Question 34:
Which is most suitable to serve as the primary key for employee records in a database?
Answer: The employee's unique identification number

Question 35:
What would be the first word of an SQL instruction used to list all people in a database who are 21 years old?
Answer: SELECT

Question 36:
Data _____ refers to the accuracy of the data in a database.
Answer: integrity

Question 37:
Each row of a database consists of an employee's id number, name, hire date, and salary. The entire row is known as a ____.
Answer: record

Question 38:
A user wishes to keep a record of all employees that work at a company, and to quickly be able to get answers to questions like "Which employees earn over $50,000?" or "How many employees live in California?". Which application is best suited?
Answer: Database app

Question 39:
Which SQL statement would retrieve only the first and last name values for all tuples?
Answer: SELECT first, last FROM Student;

Question 40:
Which SQL statement would retrieve all tuples and attributes?
Answer: SELECT * FROM Student;

Feel free to ask if you have more questions or need clarification!