Introduction to Information Technology - EL3701 B

  

Cumulative Exam

What is relative referencing?

a system of referring to cells using letters for columns and numbers for rows

a method of formatting text in spreadsheet cells so none of it is cut off

a formula for calculating the optimal width of columns and height of rows

a bulleted list of all of the information included in a spreadsheet

Which is a linear presentation? 

A company includes a presentation with every new bookcase that has step-by-step building instructions that includes hyperlinks to skip ahead to a further step.

A teacher allows students to explore a presentation about New York by choosing hyperlinks to attractions in the city that they are interested in seeing.

An insurance salesperson follows a presentation while explaining the different plans he sells.

A real estate agent prepares a slide stack for a couple so that they can click on pictures of condos that are in the school district they like.

“Jan23” can be stored using which data type?

an alphanumeric string

a boolean operator

characters

floating point numbers

Which feature of spreadsheet software can display numerical data in a visually appealing and easily understood format?

sheets and workbooks

rows and columns

formulas and functions

charts and graphs

A company chooses blue and green for its signs and employee uniforms. It decides to write the company name in all capital letters with fancy letters. The company wants to show the new colors and lettering in the annual report. Which formatting options would best accomplish this?

using a theme

choosing a plain font for the title

applying conditional formatting

inserting an image

Which describes the conditions that must be met in order to use Subtotal in a spreadsheet?

The data must be in adjacent cells and organized in rows using headings.

The data must be in adjacent cells and organized in columns using headings.

The data must be distributed in different spreadsheets using the same range of cells.

The data must be distributed in different tabs within the same spreadsheet using the same range of cells.

When creating a presentation in LibreOffice Impress, where does the editing of slides take place?

the slides panel

the center panel

the tasks panel, under the master pages tab

the tasks panel, under the layouts tab

Character encoding uses bit patterns, sequences of numbers, or electrical pulses to

recover errors in software programming.

represent characters in a given set.

correct grammatical and spelling errors.

define the placement of graphics on a website.

Which statement allows more than one condition in an If statement?

Else

While

Elif

If-then

The following is an excerpt from a slide in a presentation.

Today, we will address

• inverse operations

• solving equations using inverse operations

• solving inequalities using inverse operations

From which part of the presentation does this slide most likely come?

introduction

outline

body

conclusion

Which best describes desktop publishing?

the process of designing and laying out printed material

the positioning of text, graphics, and white space on a page

the style of letters and how they are arranged

the use of images and colors

What part of digital video processing is practical because it saves space, reduces the expense of file storage, and reduces the amount of time required to upload and download a file?

framing

converting to analog

compression

streaming

Why are audio files compressed?

Compressed audio files are protected from being edited or deleted.

Compressed audio files have no loss of amplitude.

Compressed audio files have a better sound quality.

Compressed audio files takes less time to upload, download, and transfer.

A Python programmer is writing a function definition. What syntax should be used?

def( statement ): functionName

argument1

argument2

argument3

def functionName( arguments ):

statement1

statement2

statement3

def functionName( statement ):

argument1

argument2

argument3

def( arguments ): functionName

statement1

statement2

statement3

A program contains the following statements:

x = grade

If x ≥ 90:

Print (“you are an A student!”)

What action will the program take when x = 89?

print “You are an A student!”

print “grade = 89”

print nothing

print “You are a B student!”

Mikhail is working in an IDE and needs to test a program one step at a time to find and fix errors. What tool should he use?

a compiler

a source code editor

a debugger

a build automation tool

In a student scheduling program, a variable HasFreePeriod is set as True or False. This variable is an example of

an abstract data type.

a user defined type.

an array.

a scalar.

Which is a conditional statement?

If it is sunny, we can play ball.

It is sunny today.

It is sunny or rainy.

It is sunny across the street, but not sunny here.

Normalization of tables in the Employee database could be useful in eliminating all records that

contain the same employee last name.

contain the same employee ID number.

are missing information.

were entered after a certain date.

Why is it important to use correct syntax?

to demonstrate a sophisticated programming style

to demonstrate a flexible programming style

to ensure that programs will work on any computer platform

to ensure that programs run properly and return expected results

Which is an example of an incremental approach to solving a problem?

writing the program code of the solution informally

representing the steps of a solution in a flowchart

representing the code of the solution in different programming languages

writing the steps of a solution in small pieces of code

Libraries order items, check out items to patrons, process returned items, and organize items on shelves. What data management solution should a library use to track this information?

a spreadsheet

a database

a flat file

a filing cabinet

Seth, a zoologist, has a spreadsheet containing data on all the animals in a zoo. He wants to sort the column that contains the weights of all of the animals. Which sort tool could he use to reorganize the numbers so they are listed from smallest to largest?

sort descending

custom sort - font color

sort ascending

custom sort - columns

Which line of code will eliminate the element “calculator” from an array of supplies?

supplies.append(“calculator”)

supplies.pop(“calculator”)

supplies.delete(“calculator”)

supplies.remove(“calculator”)

The word processing feature that allows you to refer to prior versions and edits is 

the Track Changes feature.

the Comments feature.

the Editing group.

the Styles gallery.