BIM Final

Which statement is true?

• An employee list can give the departments and job titles of employees.

• A product list can include names and addresses of buyers of the product.

• A medical record can include consumer buying behaviors of prescriptions.

• A market research report can give names of employees of a company.

The process of bringing data or a file from one program to another is called

• exporting.

• importing.

• querying.

• reporting.

In a high school with 3000 students, counselors are putting together a math tutoring program for the neighboring middle school. They plan to invite high school students with high average test scores to tutor middle school students, and they would like to offer gift cards to the student tutors. The counselors have a spreadsheet showing each student’s average test scores, and in order to find out how many gift cards they should purchase, the counselors need to count how many students would qualify to become tutors.

Which type of function would best help the counselors determine the number of eligible students?

• SUMIF

• ROUND

• COUNTIFS

• AVERAGEIFS

Lookup functions allow spreadsheet users to

• show quantities of distinct, discrete categories of data.

• present data that changes as a function of time.

• keep track of IF statements and nested IF statements.

• reduce the amount of manual searching and data entry.

What are the two parts of a cell reference?

• column intersection and row range

• column range and row intersection

• column letter and row number

• column number and row letter

If you want to copy the same formatting many times, _____.

a. right-click the formatted text and click Repeat

b. right-click the Format Painter and click Okay

c. double-click the Format Painter

d. open the Format dialog box and click Copy

 

• a

• b

• c

• d

If the pictures are not the same size when they are selected from a file,

• PowerPoint will use AutoCorrect so they are the same size. 

• the picture will be overcorrected. 

• these pictures will remain the size as in the file. 

• the layout should be fit to the slide.

The size of a video on the PowerPoint slide can be changed by adjusting

• the Corner key and Shift key. 

• changing the video style. 

• adjusting the design. 

• the Shift key and Playback key.

What is the best way to protect against the loss of important files?

• firewalls

• antivirus software

• backup files

• secure passwords

Which of the following functions is NOT on the Mini toolbar?

a. text color

b. alignment

c. undo typing

d. font sizing

• a

• b

• c

• d