Types of Errors — Cumulative exam Answers

2 verified answers
1
Free Preview

Which statement demonstrates the value of an iteration in programming?

A
An iteration can be used instead of many repetitive lines of code in a computer program.
B
An iteration makes a program end without having to press keys on the keyboard.
C
An iteration formats the code in a program into a neat indented form.
D
An iteration controls the order in which a program executes code.
2
Free Preview

A piece of the Student Info table in the Harris Community College database is shown below. What information could an instructor find by querying this table in the database?ID#FirstNameLastNameStudentMajorAddress1BethBorskyArt55 Winsap Ln.2HankHoffChemistry7 Gosling Rd.3StephanieSerlePolitical Science136 Finley Ave.4RafiRohrArt55 W. 79th St.

A
a list of students over the age of 35
B
a list of students grouped by major
C
a list of students who got over a 90% on the entrance exam
D
a list of all male students
3

Read the spreadsheet formula below, then answer the question.cell B5=A5*2If this formula is filled into cell B6, what will the new formula be?

A
=B5*B5
B
=B5*2
C
=A5*B6
D
=A6*2
4

When preparing a photo for a magazine, a graphic designer would most likely need to use a program such as

A
Microsoft Excel to keep track of magazine sales.
B
Microsoft Word to write an article about the photo.
C
Adobe Photoshop to manipulate the photo.
D
Autodesk Maya to create 3-D images that match the photo.
5

Which type of chart or graph shows data with distinct x and y values?

A
a bar graph
B
a scatter plot
C
a line chart
D
a pie chart
6

Which is a feature of audio editing software?

A
It is used only by professionals.
B
It is able to run only on the Windows operating system.
C
It is used to edit images.
D
It is used to add sound effects.
7

Which of the following symbols comes first when a formula or function is written in a spreadsheet?

A
()
B
+
C
=
D
*
8

What kind of video are you are able to watch by downloading it from the Internet?

A
analog video
B
video cassette
C
a movie reel
D
digital video
9

To add a hyperlink to your presentation, select the text, choose Hyperlink from the Insert menu, and then

A
type the word “hyperlink” in the Target field.
B
click Apply.
C
change the font to blue.
D
type the Internet address in the Target field.
10

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
11

The unique identifier for each record in a database table is called the

A
record ID.
B
ID number.
C
primary key.
D
row number.
12

To create a nonlinear presentation that has external links, the designer should

A
include every slide in an order that loops continuously, causing the whole presentation to repeat.
B
include hyperlinks on each page to a table of contents that shows the order of the presentation.
C
include hyperlinks to websites or other slides that the user can choose at will.
D
include slides that move from start to finish following the same path each time.
13

When creating a chart or graph, which should be completed first?

A
selecting, by clicking and dragging, the data to be included in the data display
B
using Chart Wizard to determine the type of data display
C
selecting Insert and then selecting Chart
D
adjusting the data series
14

Which programming language was released first?

A
FORTRAN
B
BASIC
C
Perl
D
Pascal
15

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
16

What is an easy and accurate way that a graphic designer can increase the size of a digital shape while keeping the ratio of height to width the same?

A
First make the height taller, and then drag the width by using one’s eyes to try to make sure the proportions stay the same.
B
Hold the key, such as Shift, that the program uses to make sure all dimensions are adjusted while dragging just one side.
C
Open the shape’s properties window, and type the height value multiplied by 2 and the width value multiplied by 3.
D
First convert the shape into a photo file, and then digitally manipulate it in a program such as Adobe Photoshop.
17

A store manager needs to run a report of last month’s sales. The manager would like the report to highlight products that sold over a quantity of twenty-five for the last month. Which formatting options would accomplish this?

A
inserting an image
B
choosing a plain font for the title
C
applying conditional formatting
D
using a theme
18

A caption is created for a photograph. Which is true?

A
The photograph and the caption are linked and cannot be separated.
B
A frame is created around the photograph and the caption.
C
The photograph is cropped, making room for the caption.
D
A template is created around the photograph and the caption.
19

Which of the following explains why a recipe is considered an algorithm?

A
A recipe gives different steps each time it is executed.
B
The person who uses the recipe will have less time to do other activities.
C
The dish created by a recipe is the same each time it is followed properly.
D
A recipe gives more complex tasks in each step.
20

A looping construct that continues to repeat until the expression becomes false is

A
a while loop.
B
a for loop.
C
an infinite loop.
D
a pass loop.

Did you find these answers helpful?