Free Printable BIM1/PREP SPRING FINAL

1.

Workplace etiquette is defined as the expectations of social behavior at work

a)

True

b)

False

2.

Which of these is not a workplace Etiquette tip we talked about in class

a)

Be on time

b)

Use your personal electronics all the time

c)

Dress appropriately

d)

Be Respectful and courteous at all times

3.

When using social media you should pause before posting.

a)

True

b)

False

4.

Which of the following is not a good way have good attendance and punctuality in the workplace.

a)

take off work when you feel like it

b)

Be on time and ready to start

c)

call if you can not keep your appointment

d)

only take off work if necessary

5.

speaking clearly and avoiding slang demonstrates effective oral communication.

a)

True

b)

False

6.

according to the presentation which is not a reason customer service is important?

a)

Customer service is often the only contact a customer has with a business

b)

Excellent customer service will bring repeat customers

c)

Customer service is representative of an employer’s values

d)

customers actually don't care how they are treated, so long as they get a high price on goods and services.

7.

Your email signature should include

a)

Important contact information

b)

a picture

c)

A GIF

d)

a joke

8.

Which is important when it relates to telephone voice

a)

Volume and energy

b)

Speed

c)

pitch

d)

all answers listed

9.

What information should be given when leaving a phone message

a)

State your name and where you are calling from

b)

give the full name of the person you are leaving the message for

c)

let them know that you will call back or if they should call you back

d)

all answers listed

10.

when taking a message you should

a)

give as many details about where a person is

b)

do not write anything down, try to memorize the information instead

c)

Keep a memo pad for messages

d)

all answers listed

11.

You need to have a picture on your resume?

a)

True

b)

False

12.

The only work experience that counts on a resume is work that you are paid to do.

a)

True

b)

False

13.

You should have someone else look at your resume before you finalize it.

a)

True

b)

False

14.

A resume is a snapshot of you.

a)

True

b)

False

15.

A resume should have what on it?

a)

Work experience

b)

Contact Information

c)

Both

d)

None of these

16.

What section should your certificates be listed.

a)

personal information

b)

Work experience

c)

Education

d)

None of these

17.

As a student who would be a good reference you list

a)

Mom

b)

Dad

c)

Grandma

d)

Teacher

18.

It is a good idea to write a rough draft of your resume.

a)

True

b)

False

19.

You should use multiple colors and fonts when writing your resume

a)

True

b)

False

20.

All resumes should look the same, no matter what job you are applying for.

a)

True

b)

False

21.

which is not a question for finding the answer

a)

What is the problem?

b)

What are signs of the problem?

c)

What are possible causes of the problem?

d)

What is needed for a good solution?

e)

How can I blame the other person?

22.

How do people Resolve conflict?

a)

Fight

b)

Flee

c)

Give in

d)

Reasoning and compromise

23.

What is defining the problem

a)

Think about your problem and write a brief description of what it is, who is involved, why is it a problem, and when and where is it happening.

b)

How severe is the problem? If you could solve the problem would it make your life better? Do you have control over any part of the problem?

c)

Follow through with your solution. If your solution solved the problem congratulations! However if your solution is not working as planned, implement the alternative you identified in step three. Remember, not all problems have solutions that are within you control and ability to solve.

d)

Think about whether you can realistically solve the problem. Where are the consequences of solving the problem both positive and negative? Anticipate issues or problems that may occur with your solution and think through alternative options.

24.

What does it mean to evaluate the problem.

a)

Think about your problem and write a brief description of what it is, who is involved, why is it a problem, and when and where is it happening.

b)

Did your problem get solved? Did you get the desired results? If not, what could you do differently next time? How do you feel about the way the problem was solved?

c)

How severe is the problem? If you could solve the problem would it make your life better? Do you have control over any part of the problem?

d)

Think about whether you can realistically solve the problem. Where are the consequences of solving the problem both positive and negative? Anticipate issues or problems that may occur with your solution and think through alternative options.

25.

Develop a solution means what

a)

Think about your problem and write a brief description of what it is, who is involved, why is it a problem, and when and where is it happening.

b)

Did your problem get solved? Did you get the desired results? If not, what could you do differently next time? How do you feel about the way the problem was solved?

c)

Follow through with your solution. If your solution solved the problem congratulations! However if your solution is not working as planned, implement the alternative you identified in step three. Remember, not all problems have solutions that are within you control and ability to solve.

d)

Think about whether you can realistically solve the problem. Where are the consequences of solving the problem both positive and negative? Anticipate issues or problems that may occur with your solution and think through alternative options.

26.

Implement the solution means what?

a)

Follow through with your solution. If your solution solved the problem congratulations! However if your solution is not working as planned, implement the alternative you identified in step three. Remember, not all problems have solutions that are within you control and ability to solve.

b)

Did your problem get solved? Did you get the desired results? If not, what could you do differently next time? How do you feel about the way the problem was solved?

c)

Think about your problem and write a brief description of what it is, who is involved, why is it a problem, and when and where is it happening.

d)

Think about whether you can realistically solve the problem. Where are the consequences of solving the problem both positive and negative? Anticipate issues or problems that may occur with your solution and think through alternative options.

27.

Reflect your results means what?

a)

How severe is the problem? If you could solve the problem would it make your life better? Do you have control over any part of the problem?

b)

Did your problem get solved? Did you get the desired results? If not, what could you do differently next time? How do you feel about the way the problem was solved?

c)

Follow through with your solution. If your solution solved the problem congratulations! However if your solution is not working as planned, implement the alternative you identified in step three. Remember, not all problems have solutions that are within you control and ability to solve.

d)

Think about your problem and write a brief description of what it is, who is involved, why is it a problem, and when and where is it happening.

28.

_____ is the default name for a new table in an Access database.

a)

Table1

b)

NewTable

c)

Table

d)

TableA

29.

_____ view is a spreadsheet-like view of the data in a table.

a)

Design

b)

Layout

c)

Form

d)

Datasheet

30.

_____ view provides the most options for dening elds.

a)

Field Create

b)

Field Dene

c)

Table Create

d)

Table Design

31.

A _____ is a grid that displays fields as columns and records as rows.

a)

query

b)

datasheet

c)

logical table

d)

report

32.

A category of data such as a customer's name, city, state, or phone number is called a _____.

a)

record

b)

table

c)

data type

d)

field

33.

A group of related fields, such as all the demographic information for one customer, is called a _____.

a)

table

b)

record

c)

query

d)

field

34.

An Access web app is a special type of Access database _____.

a)

that any user can access on the web

b)

stored on a SharePoint server

c)

that contains mostly Hyperlink fields

d)

designed to compare prices for online services

35.

At what point does Access save the data in a database?

a)

when you close the database

b)

when you finish entering or editing a record

c)

when you click the Save button

d)

when you close a table

36.

Besides reducing le size, what other benet does compacting an Access database provide?

a)

sorting the records in the database

b)

repairing the database

c)

saving the database

d)

relating tables in the database

37.

Each item on a form is called a _____.

a)

control

b)

field

c)

layout

d)

format

38.

Each row in a table datasheet displays a _____.

a)

data type

b)

property

c)

field

d)

record

39.

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

a)

To erase the cell value from the clipboard

b)

To paste the value's number formatting only.

c)

To paste all items on the clipboard.

d)

To compute the results of a function.

40.

How many actions does the Undo button let you reverse?

a)

24

b)

50

c)

75

d)

100

41.

If you discover an error immediately after you have confirmed a cell entry, what of the following would you use next?

a)

The Undo button on the Quick Access toolbar

b)

The Cancel button on the Formula bar

c)

The Enter button on the Formula bar

d)

The Save button on the Quick Access toolbar

42.

In a complex formula, how does Excel determine which calculation to perform first?

a)

It calculates the leftmost formulas first.

b)

It calculates operations outside parentheses first.

c)

It follows the order of operations.

d)

It calculates functions rst.

43.

In the formula =A8*$A$1, which of the following describes A8?

a)

Relative cell reference

b)

Absolute cell reference

c)

Function

d)

AutoSum

44.

In the formula =B6*$B$2, which of the following describes $B$2?

a)

Relative cell reference

b)

Absolute cell reference

c)

Function

d)

Average

45.

In the formula =SUM(A6:A9), which of the following best describes A6:A9?

a)

argument

b)

function

c)

label

d)

active cell

46.

The Clipboard task pane shows the contents of the _____.

a)

Office Clipboard

b)

Table Styles gallery

c)

Quick Analysis tool

d)

Recently-Used Add-Ins

47.

To enter a range of text based on examples that are already in your worksheet, which of the following can you use?

a)

Business Intelligence

b)

Flash fill

c)

Quick Analysis tools

d)

What-if analysis

48.

To have Excel enter the lowest price from a range of prices, which of the following would you use?

a)

MAX function

b)

COUNT function

c)

MIN function

d)

COUNTA function

49.

To paste a data range so that column data appears in rows and row data appears in columns, you can _____ the data using the Paste list arrow

a)

reverse

b)

transpose

c)

fill

d)

merge

50.

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

a)

Leave the workbook closed.

b)

Open the workbook, change the rst worksheet, and save it using the Save command.

c)

Open the workbook, make changes, and then save it using the same name.

d)

Open the workbook, make changes, and then save it using a different name

BIM1/PREP SPRING FINAL

Total questions: 50

Worksheet time: 25mins

Similar Resources on Wayground