Exam

the column is not wide enough

##### appearing in a cell indicates that _____.

memo

Christine wants to send a quick communication to all department managers. She should send a _____.

Row 4

In this spreadsheet, what is highlighted?

newsletter

Lorene is a director of a preschool. She would like to communicate to parents about upcoming events. She should send a _____.

a key ethical issue

Sometimes people are not aware that their personal information is being gathered. This is _____. the purpose of data analysis

understand the task or need

The first step in the five-step process for problem solving is to ____.

place the cursor after the first "t" in "important" and press Delete

The following sentence has a mistake. It is very importtant to proofread all documents carefully. To fix this mistake, you should _____.

SUM function

To add a long list of numbers, use the _____.

• MS-DOS • Windows 2000 • Mac OS X

Which of the operating systems listed below are proprietary?

Mario's book, The Money Market, went on sale September 5, 2008.

Which sentence follows all punctuation and capitalization rules?

column

A vertical set of data in a spreadsheet is called a _____.

defragmentation

Amber's computer is running slower than it used to. To improve its efficiency, she will run this type of utility program that will move data around so that the pieces of files can be stored next to each other on her computer disk.

hardware

An electrician uses a device called a volt meter. The volt meter is an example of _____.

mouse

An example of hardware is a _____.

clustering

Ann Marie would like to test her hypothesis. To do that, she needs to show groups of data that are similar in some way. Which data-mining techniques should she use?

sort in descending order

April would like the part numbers to be in order with the highest number at the top of the table. She should _____.

CAD software

Corey is an architect. What software does he most likely use to design houses?

She forgot to use the spell check, take time to carefully read over the paper, ask several coworkers to review, and fix all mistakes.

Emma finished typing a long project proposal. She quickly sent the document, and the audience found many mistakes. What did Emma forget to do?

computer network

Grace works at a company that has many computers that are interconnected for sharing documents and backing up work. This is an example of a _____.

True

If you create a graph and later notice a mistake in the data, you can update the data and the graph will automatically update.

> January 1, 2008

If you have a database of books in the library and you would like to find all books published after January 1, 2008, what criteria would you enter?

click anywhere in column D and insert a column

If you need to add more data between column C and column D, you should _____.

33*3

If you wanted to use the numeric key pad to multiply 33 by 3, you would type _____.

False

In a database, you are unable to change any formatting such as font.

brackets

In the order of math operations, what will a spreadsheet calculate first?

1. software used to work with numbers and financial information 2. a statement you submit to get paid for a product or service 3. a horizontal set of data in a spreadsheet 4. information that is stored 5. a built-in formula in a spreadsheet

Match the term with the appropriate definition. 1. spreadsheet 2. invoice 3. row 4. data 5. function

1. image-editing software 2. word processor 3. presentation software 4. spreadsheet 5. database

Match the terms with the appropriate definition. 1. software used to enhance photographs 2. software used to type, edit, save, and print text 3. software used to create a slide-show presentation 4. software used to make calculations 5. software that organizes a collection of data

L can be modified by users L created by unpaid developers M introduced the first GUI W most commonly used OS M wide use among graphic designers L open source

Read the statements below. Select "L" if the statement describes the Linux OS. Select "M" if the statement describes the Mac® OS. Select "W" if the statement describes the Windows® OS.

numeric keypad on the right side of the keyboard

Sally is an accountant. She needs to type many numbers. She should use the _____.

=B3*.8

Some products in Mariah's store are marked down 20 percent. She wants to calculate the new price in a spreadsheet. She enters the original price in cell B3. What should the formula look like?

February

The results of data mining appear in the graph below. When will the company most likely have the least sales in 2012?

The Finder

What feature sets Macs apart from other operating systems?

All open windows would be minimized.

What would happen if you clicked on the Show Desktop icon on your computer screen?

40

What would the spreadsheet calculate for =D2+D3+D4/3?

datasheet (table) view

When you want to add records to a database, which view should you have open?

• Click on the Save icon. • Name the file.

You have drafted a new report that you will be saving for the first time. Select the steps you will take to save your file.

use AutoFill

You type a complex formula into cell A20. You would like to make the same calculation in cells B20 through H20. To be efficient, you should _____.

graphic software

Martha wants to create an image for her Web site. Martha should use _____.

1. a sequence of screens where the user makes choices in order to complete a task 2. rows and columns that are used for organizing data 3. a field with a unique identifier 4. a generic letter containing personal information and sent in mass mailings 5. an action performed that only allows data that matches a certain condition to pass through 6. to ask a question about data

Match the term to the correct definition. 1. wizard 2. table 3. primary key 4. form letter 5. filter 6. query

ask the coworker to export the data to a text file and then import the data into his own database

Collin would like to use the data a coworker has entered into a database. The problem is the coworker's database software is different from Collin's. Collin should _____.

Proven ability to manage office functions while meeting challenging deadlines

Compare the two summary of qualifications taken from a resumé. Which summary is better?

clicking on Find will display a dialog box

Find... The ellipse (three dots) following Find in a menu indicates that _____.

update the records

Jacob's manager has asked him to put new addresses in the database for several clients who have moved to a new location. Jacob should _____.

John should conduct a query that asks for data in the Machine field that meets the criteria =A100.

John needs to find all records in a database that have parts that fit the Machine A100. What should John do?

a spreadsheet

Lydia used software and numerical data to create bar graphs. What software did she use?

database

Madison would like to store all past sales transactions so that she can retrieve them easily. She should use a(n) _____.

He should enter the test results from each week into a spreadsheet and create a line graph.

Manny is a personal trainer. He gives his client an endurance test each week. He would like to illustrate how much the client has improved his endurance. What should he do?

spreadsheet

Manuel owns a small business. He needs to calculate the amount each employee owes in Federal taxes. Manuel should use a(n) _____.

Data mining is a technique in data analysis that allows users to determine faster and one of the strategic business intelligence techniques. Data mining enables users to analyze large amounts of data and to identify hidden links within data not known otherwise. For example, data mining might reveal that a consumer buying product X is ten times as likely to buy the product. Data mining can be useful if unforeseen business issues whose sources are hard to identify are being studied.

Many business professionals use data mining. In three to four sentences, describe how one type of business professional would use data mining and why it is important.

print the presentation and give each person a hard copy

Melissa and Sue want to show a presentation to twenty employees, using a projector. They learn that the projector is not working. They should _____.

• move data into alphabetical order • find unusual data • print address labels • import data from a different type of file • query the data for certain records • merge data into a word-processing document • uncover patterns in data

Select all actions you can perform using a database.

Preventive maintenance

_____ is work done to keep equipment in good working order.

send her resumé

Kate hears about a new job opening. To obtain an interview, she should _____.

1. the main board in the body of the computer 2. the central processing unit 3. software that helps run the computer hardware 4. a device that gives you directions to a certain location 5. a small mobile computer 6. instructions for the computer written in a programming language

Match the term with the appropriate definition. 1. motherboard 2. CPU 3. system software 4. GPS 5. laptop 6. program

• keeping your fingers curved and relaxed • returning your hands to the keys a s d f j k l ; after each keystroke • aiming to make no mistakes • sitting up straight

Select all examples of good keyboarding technique.

• identify the intended audience • make sure there are no mistakes • use a font, size, and style that is easy to read • write clearly and concisely

Select the tips you should follow when writing any type of business document.

application software

The type of software used widely in businesses to complete specific tasks is _____.

• security • file management • accessibility • communication

What are the most common types of tasks performed by utility programs?