Introduction to Information Technology - Spreadsheets and Presentations - All correct

  

Unit: Spreadsheets and Presentations

Unit test

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

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

The spreadsheet below shows the age, grade level, major, and minor of four students in college. A purple background in the Major column indicates that a student has previously changed his or her major.

  

A

B

C

D

E

 

1

Age 

Year 

Major 

Minor

 

2

Student 1

19

Sophomore 

Physics 

Math

 

3

Student 2

18

Sophomore 

Education 

Music

 

4

Student 3

21

Junior 

Engineering 

Math 

 

5

Student 4 

18

freshman

Engineering 

Business 

Which tool can be used so that the spreadsheet shows information only for students older than 20?

sort by age from smallest to largest

sort by age from largest to smallest

filter by age on values greater than 20

filter by age on values less than 20

What lookup function should be used to search for values in a specific row of a table and return values from adjacent rows?

HLOOKUP

VLOOKUP

MAXLOOKUP

TABLOOKUP

What is a series of slides used in a presentation?

a slide layout

a slide show

a slide view

a slide master

Conditional formatting allows spreadsheet users to

turn cell protection functions on and off.

calculate the average number of people at sporting events.

highlight test scores of below 90% in a grade book.

add additional formatting options to a menu.

A presentation has bullet points that move. The presenter wants to use these bullet points in several other places in the presentation. Which command would the presenter use to copy the feature to other places?

Animation Painter

Format Painter

Animation

Video from File

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 of the following is true of operations within a spreadsheet program’s built-in functions?

Operations within parentheses, then multiplication and division, and then addition and subtraction are computed.

Operations within parentheses, then addition and subtraction, and then multiplication and division are computed.

Multiplication and division, then addition and subtraction, and then operations within parentheses are computed.

Addition and subtraction, then multiplication and division, and then operations within parentheses are computed.

An employer uses the spreadsheet below to determine the average hourly salary of her four employees. She begins by determining the hourly salary of each person and displaying that in column D. Which formula can she then use to determine the average hourly salary?

  

A

B

C

D

 

1

Employee 

Hours worked 

Amount earned

 

2

Alise 

14

$101.50

 

3

Callie 

19

$147.25

 

4

Chiara 

23

$164.45

 

5

Ming 

21

$157.50

=average(D2:D5)

=average(B2:B5)

=average(C2:C5)

=average(B5:D5)

Read the spreadsheet formula below, then answer the question.

=SUM(C6:C9)

What does the : symbol in the formula do?

arranges the formula in the correct order of operations

selects all of the cells in the range C6 to C9

designates cell C6 as the last cell in the formula

triggers the use of the Input line to check work

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

Including AND in an IF statement means

more than one condition can be included in the statement.

exactly one condition can be included in the statement.

the result may be both true and false at the same time.

a new spreadsheet is generated using only data that meets the conditions in the statement.

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