AnswersIntroduction to Information Technology - EL3701Use Data Structures

Use Data Structures — Cumulative exam Answers

50 verified answers1 views
41
Free Preview

What does a sort tool enable you to do in a database?

A
remove irrelevant data from a form
B
hide irrelevant data in a form
C
arrange records by number of typos entered in a field
D
arrange records by field in a form
42
Free Preview

The spreadsheet below shows a list of fruits with their calorie count, grams of sugar, dietary fiber, and protein.Which set of steps will organize the data to only show foods with more than 100 calories and rank their sugar content from greatest to least?

Question illustration
A
Sort Sugar in descending order, and filter Calories by under 100 calories.
B
Sort Sugar in ascending order, and filter Calories by over 100 calories.
C
Filter Calories by over 100 calories, and sort Sugar in descending order.
D
Filter Calories by over 100 calories, and sort Sugar in ascending order.
43

Conditional statements are useful to computer programmers because

A
they eliminate extra coding by reuse of materials.
B
they allow programmers to set conditions to be met for an action to take place.
C
they use shorthand symbols to represent quantities.
D
they are predefined for each programming language.
44

What are the two parts of a cell reference?

A
column intersection and row range
B
column range and row intersection
C
column letter and row number
D
column number and row letter
45

Which is a characteristic of an effective problem statement?

A
It is based on research.
B
It contains outside information.
C
It contains technical language.
D
It is reviewed by competitors.
46

Which is true regarding pseudocode?

A
It uses simple words and symbols to communicate the design of a program.
B
It compiles and executes code.
C
It expresses only complex processes.
D
It gives a graphical representation of a set of instructions to solve a problem.
47

What is the difference between independent variables and dependent variables in spreadsheets?

A
Independent variables are the values entered into formulas, while dependent variables are the calculations made by formulas.
B
Independent variables are usually displayed in columns, while dependent variables are usually displayed in rows.
C
Independent variables are usually numbers, while dependent variables are usually text.
D
Independent variables can be formatted into charts and graphs, while dependent variables cannot.
48

Audio editing software contains several codecs that allow you to

A
save and compress audio files in different formats.
B
copy audio files.
C
match the words actors speak with the movement of their lips.
D
create your own ringtones.
49

What happens in the process represented by the pseudocode below?get(answer)if(answer is yes)then(multiply 4 and 9)if(answer is no)then(do nothing)

A
The computer multiplies 4 and 9 if the answer is yes.
B
The computer multiplies 4 and 9 if the answer is no.
C
The computer always multiplies 4 and 9.
D
The computer always does nothing.
50

A program is run line by line to determine the source of a logic error. Which best describes the specific tool being used?

A
compiler
B
interpreter
C
stepping function
D
beta tester

Did you find these answers helpful?

More from this Course

RC
25 verified answers

Cumulative Exam

Quiz
25 verified answers

Cumulative Exam

Quiz
15 verified answers

Unit Test