Value2 - Study guides, Class notes & Summaries

Which of the following error values indicates that a cell reference is empty? :~~ #Ref! Which of the following database functions averages the values of cells in the field that meet the criteria? :~~ DAVERAGE Which of the following error values indicates that the formula uses an invalid numeric entry? :~~ #NUM! Which function has one or more logical tests with corresponding results for each test? :~~ IFS Consider the function =INDEX(array,row_number,column_num). Which of the ...

1. What is the informal language, used by programmers use to create models of programs, that has no syntax rules and is not meant to be compiled or executed? a. flowchart b. algorithm c. source code d. pseudocode - d. pseudocode 2. A(n) ________ is a diagram that graphically depicts the steps that take place in a program. a. flowchart b. algorithm c. source code d. pseudocode - a. flowchart 3. The ________ function reads a piece of data that has been entered at the keyboard and retur...

1. What is the informal language, used by programmers use to create models of programs, that has no syntax rules and is not meant to be compiled or executed? a. flowchart b. algorithm c. source code d. pseudocode - d. pseudocode 2. A(n) ________ is a diagram that graphically depicts the steps that take place in a program. a. flowchart b. algorithm c. source code d. pseudocode - a. flowchart 3. The ________ function reads a piece of data that has been entered at the keyboard and retur...

Add New Row - Answer-INSERT INTO table_name (column1, column2, ...) VALUES (value1, value2, value3, ...); Update Row - Answer-UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Delete Row - Answer-DELETE FROM table_name WHERE condition; Inner Join - Answer-SELECT column_name(s) FROM table1 INNER JOIN table2 ON n_name = n_name; CREATE VIEW - Answer-CREATE VIEW viewname AS SELECT Col1, Col2 FROM table WHERE condition; Concatenate - Answer-CONCAT(Col1, Col...

The SELECT statement is used to select data from a database. The result is stored in a result table, called the result-set. correct answers SELECT column_name,column_name FROM table_name; SELECT * FROM table_name; The SELECT DISTINCT statement is used to return only distinct (different) values correct answers SELECT DISTINCT column_name,column_name FROM table_name; The WHERE clause is used to extract only those records that fulfill a specified criterion. correct answers SELECT colu...

Keep it ________ stupid - Answer-simple Never invest purely for ___ _______ - Answer-tax savings Never invest using _____ money - Answer-barrowed Risk-management technique that mixes a wide variety of investments within a portfolio - AnswerDiversification With all investments, as the ____ goes up, so does the potential return - Answer-risk When discussing investments, _____ is availability. - Answer-liquidity As there is more liquidity, there is typically ____ return - Answer-less A CD is...

=CHOOSE(index_num, value1, value2, . . . ) - returns a value from a list based on the position in the list, specified by index_num =HLOOKUP(lookup_value,table_array,row_index_num,[range lookup]) - looks up a value in the top row of a table and returns a value in the same column from a row you specify. =INDEX(array,row_num,col_num) - returns a value or reference of the cell at the intersection of a particular row and column in a given range. =MATCH(lookup_value,lookup_array,match_type) - re...

COMPUTER PROGRAMMING [ MYSQL COMMANDS ] Test Questions with Answers ESCRIBE [table name]; - Answer-display the table structure SELECT * FROM [table name]; - Answer-command to show all data in a table SELECT * FROM [table name] WHERE [field name] = "whatever"; - Answer-how certain selected rows with the value "whatever" INSERT INTO [table name] (field1, field 2, ...) values (value1, value2,...); - Answer-inserting another filed into the table SELECT * FROM [table name] ORDER BY [...

ISTM 210 Exam 2- Excel Questions with 100% Correct Answers Fill Feature - answerAllows you to automatically populate cells in a worksheet Series Feature - answerAllows you to complete a pattern within a range of cells Freeze Pain Feature - answerAllows you to lock rows and columns when you navigate through a data table Sorting Feature - answerAllows information on the table to be presented in an organized fashion Filtering Feature - answerAllows you to display only specific information o...

WGU C175 Fundamentals of Data Management Test Exam Review Questions with all Answers verified for accuracy Updated 2024/2025 What is called a decomposition process? - correct answer Data normalization In which of the normal forms should every non-key attribute be fully functionally dependent on the entire key of a table? - correct answer Second form What is the correct syntax of the CREATE TABLE command? - correct answer CREATE TABLE table_name ( column_name data_type(size), ); Wh...