BIM A

Creating a stacked list of items in a word processing program can easily be accomplished by using the _____ functionality.

bullet

When Ri finished typing a research paper using word processing software, he realized it had too many pages. He also observed that there was a lot of space on the sides of the document. By changing the _____, he decreased the amount of white space and reduced the total number of pages.

margins

The purpose of paragraph styles in word processing software is to add a predefined style to _____.

one or more lines

A spreadsheet can generally be defined as a _____.

row-and-column arrangement of data

John is responsible for the Magic Club's database. When he is asked to sort a database, what would he be expected to do?

Arrange the data in a certain order.

Lamont is the captain of the debate team at his school. At new student orientation, he wants to leave a computer on a table for interested students to enter their contact information without seeing other peoples' information. What is the BEST way for Lamont to do this?

Create a form for potential members to enter their information.

Suppose your boss asks you to create a three-column newsletter using word processing software. You format the document for three columns and then enter the text for the first column. The text does not take up the entire first column, but you want to move to the second column. Which action should you take?

Create a hard column break.

Casey created a basic report from a data table he received from his client. After giving his client the report, Casey was told the information was too vague, the report was incomplete, and the report lacked relevant information. Which of the following would allow Casey to design a more complete report?

Create a new table with more fields of relevance.

Tracy has a large inventory of electric motors in a database table. His boss asked him to send a report of all 50-horsepower motors that can also be used as generators. How can Tracy produce this report?

Create a query, then a report.

In which of the following situations would a PowerPoint presentation be MOST effective?

Delivering a presentation to potential investors about a new business plan.

Which of the following is an example of a network operating system?

Mac OS X

Which of the following features of word processing software is the LEAST likely to be used to complete a product presentation chart?

Mail Merge

In which of the following situations would PowerPoint NOT be an appropriate software choice?

Manipulating and analyzing large amounts of sales data

All of the following are data types in Access EXCEPT _____.

Name

When Kelsey checked her email, she found a birthday invitation from a friend. She noticed that some of the text was sparkling. What did her friend do to make the text appear to sparkle?

She added a text effect to the text.

What is the difference between sorting and filtering records?

Sorting only changes the order of records. Filtering only reduces the number of records being viewed.

As treasurer of the Prom Committee, Maria must prepare a budget for prom expenses. To handle this task efficiently, Maria will use formulas in a spreadsheet program to calculate the totals. Which symbol below should she ALWAYS use to start her formulas?

c. =

Tables

contain data (information) about one subject arranged in rows (records) and columns (fields). Tables can be used for editing data.

Computer operating systems organize files with a system of _____.

folders

To control the appearance of a spreadsheet document, the user manipulates _____ commands.

formatting

A mathematical equation that is used to calculate values in a spreadsheet program is called a _____.

formula

=SUM (B6...B10) is an example of a preset formula, or _____.

function

In a spreadsheet program, when a formula or function is copied and pasted to other cells, the cell references in the formula or function change to reflect the formula's new location. This process is called _____ cell referencing.

relative

The main reason that many new offices connect their employees' computers to a local area network (LAN) is because it allows the devices to

share information

A data warehouse is _____.

a single database with data from multiple sources

Queries

used to select particular records from the data.

Which of the following is a correctly formatted absolute cell reference for both column and row in Microsoft Excel?

=$M$3

In Microsoft Excel, which of the following is the correct method to subtract values in two different cells?

=C10-B9

Stefano wants to purchase a new car. He opens his spreadsheet and keys in a function to compute the total loan payment. Which function will allow Stefano to accomplish this task?

=PMT(rate, nper, pv, fv, type)

Which formula correctly adds the contents of two cells, and then multiplies the result by 5%?

=SUM(A2+B4)*5%

The table below shows test scores for a science class. Which formula is correct to calculate Mei's test average? A B C D E 1 Name 1 2 3 Ave 2 Mei 89 90 89 3 Mike 90 80 60 4 Sue 70 90 70 5 Ramon 80 70 80

=SUM(B2:D2)/3

What role does a database play in the Mail Merge process?

A word processing program produces letters and labels based on data in the database.

What kind of program do you need to make sure your files can be recovered in the event of a virus?

Backup

_____ are text symbols, such as small circles or checkmarks, that are used to introduce items in a list.

Bullets

What is the default way data is organized in a spreadsheet?

By rows and columns

Dana needs to create a database of all the patients in a clinic, which includes their health information and medical requirements. She must also create an alphabetized copy of this extensive information for each of her coworkers. What steps should Dana take to complete this task?

Create the table, enter data, sort, create a report, and print the report.

What is a MAIN reason many companies choose to store their customer payment information in databases instead of spreadsheets?

Databases are more secure than spreadsheets—using them helps protect customer information.

When modifying an information database, what modification is MOST risky in terms of potentially losing data?

Deleting a field.

The RATE function is what type of function?

Financial

Cristina created a research manuscript using word processing software. After printing the document, she realized that she didn't like the look of it. The area inside the page that displays the text was too narrow. What should she change to increase the amount of text space in the paper?

Margins

Abby creates a table with three rows and four columns. She wants to use the first row for a title, but wants it to be only one column instead of four. How can she create that title row?

Merge the cells in the top row.

Jacek has just started a new job as a sales clerk, and his first task is to create a new sales invoice. Which Microsoft software is a quick and easy tool for creating a basic invoice?

Microsoft Excel

Juan is reviewing a long Microsoft Word document. Rather than scrolling up and down to find the key topics he needs to edit, he is saving time by viewing the _____ pane of the document.

Outline view

When David inserted a graphic into a document, it showed up much smaller than the original. How can he correct this?

Resize the graphic.

Shortly after graduating from college, Sanjay began looking for a job. He quickly received two offers. The salary for each job was the same; however, the commission rates and cost of benefits were different. In order to determine the job that had higher compensation, which formula is BEST for helping Sanjay predict his estimated salary with sales projections?

Salary + (Sales ⋅ Commission) - Cost of Benefits

What spreadsheet criteria would you use to analyze survey results?

Statistical functions

Angelique needs to find a way to keep her company's computers updated, and to protect them against vulnerability. She wants to make sure that employees have the supplies they need, and that their computers function correctly. What is her BEST solution?

Stock supplies in advance, maintain computer hardware, and run current virus protection regularly.

Which of the following allows you to increase or decrease the viewing size of a word processing document?

The Zoom slider

What is the function of the primary key in a database?

To identify records and relate two or more tables.

What is the purpose of the Thesaurus tool?

To provide alternative words with similar meanings for a word you enter

What is it called when you move from one PowerPoint page to the next in a presentation?

Transitioning

Dan keyed data into a cell, and it has run over into the next cell. He cannot make his spreadsheet any wider without creating a second page. What is the easiest way for him to correct this problem?

Wrap the text.

Do you know every single one of these? Do you got this?

Yes and yes! Believe in yourself

In _____ cell referencing, the formula does not change when it is copied and pasted to other cells.

absolute

When you place your cursor between two words in a word processing document, the blinking vertical line you see is called _____.

an insertion point

Kendra just created a style for her word processing document, and she wants to use Format Painter to apply this style to other portions of the document. By using the Format Painter button, she will be able to _____.

apply the format to multiple selections

After a database has been created, the fundamental arrangement _____.

can be adapted as needed

In a data set each _____ represents a variable and each _____ represents a member of the data set.

column ; row

Forms

come in various formats and screens for entering, editing, or viewing data.

When integrating a regularly maintained information system for all employees, Carissa decides to schedule computer system backups. In order to use an online computer backup service, what does Carissa need?

d. A computer, a network connection, and backup system software

Reports

organize and group the data and allow user-customized printing of the data.

A device that optically examines an image, printed text, handwriting, or an object and then converts it to a digital image is called a _____.

scanner

The university has computers connected to a local area network (LAN), which is NOT intended for _____.

sending email to friends

Microsoft Access is a program that can easily produce all of the following EXCEPT _____.

slideshows

When using PowerPoint, it is sometimes useful to use the Outline view because it includes the _____ of each individual slide.

text

what does : mean in excel

through

When Chantal typed a customer reply letter in word processing software, the last paragraph continued onto a second page. What could she do to move the entire paragraph to the second page without changing any of the other page settings?

Add a page break before the final paragraph.

Which of the following word processing program functions would LEAST likely be used in completing a population growth chart?

An outline template

Sheridan has a large spreadsheet detailing several inventories. She wants to view and print ONLY the inventory information for MP3 players, while hiding the other data. She can accomplish this task by using _____.

Auto Filter

Which choice BEST describes the meaning of the formula =avg(c1:c10)?

Average of values in cells C1 through C10

Allison is editing her school's newsletter, which was created using word processing software. She doesn't like the look of the jagged and uneven text on the right side of the document. What can she do to change this formatting?

Change the alignment to justified.

Suppose you found some useful information on the Internet that you would like to use in a word processing document. Which command will allow you to capture that text to use in your document?

Copy

Julie has been keeping name and address information in a spreadsheet file, but she cannot get the spreadsheet program to function. What is another way to display the data using a word processing program?

Create a table in Word, enter the data, and then use a chart to visually display the data.

Cassandra is working on a new spreadsheet that her co-worker created for her. There are several formulas that she must copy to other cells without changing any of the cell references. How can she accomplish this task?

Create an absolute reference that contains a $ in the formula.

Which of the following is a common environmental factor that can negatively impact the usefulness and lifespan of a computer?

Heat

Which commands can be used to add rows and columns to an existing spreadsheet?

Insert row ; Insert column

_____ is a setting that causes a PowerPoint to continuously repeat itself.

Loop continuously

While proofreading a co-worker's report, you notice the font in one paragraph is serif (elaborate) and the font in another is sans-serif (simple). What should you suggest be changed?

Make sure you use the same font style in each paragraph.

Using a word processing program, Raymond typed a story for the school's literary contest. He realized that he left out a very important paragraph. Which of the following would be the MOST efficient way to add the paragraph?

Place the cursor where the paragraph belongs and type the needed text.

Marissa keys in the daily inventory for EverythingUnderTheSun.com in a spreadsheet program. Today, she noticed number signs appearing in three columns. She quickly fixed the issue. What did she do?

She widened the cells to show all the data.

Jacques typed an internal document using Microsoft Word. When proofreading, he notices a couple of misspelled words in the document and wants to make sure there are no others. Instead of using a dictionary, what tool could Jacques use to locate and correct the misspelled words?

Spelling and grammar

You are proofreading a friend's document, and you notice the text in one paragraph is larger than the text in another paragraph. What should you suggest be changed?

The font size

Kristof wants to use a business letter to emphasize six selling points of a new robotic vacuum cleaner. What is the BEST way for him to emphasize those six points?

Use a bulleted list.

As a sales director, it is your job to report monthly sales activity. You need to complete a monthly report that shows the data in a visual way. How can you BEST organize the data for a visual presentation?

Use a chart.

Destiny decides to close her bakery. She needs to send a letter to customers letting them know of the last day of business. How can she produce several letters quickly that have the same content but different addresses and greetings?

Use a mail merge document.

Jeremy is pitching a new product to the design board at his company. He has multiple charts and photographs of the product. Is PowerPoint a good option for Jeremy's product pitch?

Yes, it would allow him to organize his presentation and allow him to show the board his charts and images.

Tina learned how to copy programs on her home computer. A supervisor asked her to copy a program for his home use. Which of the following would be the MOST ethical response she could give?

b. "I can't copy it because it will break copyright laws."

When Jan wanted to enhance her PowerPoint presentation, she decided to add animation effects. These effects will allow her to _____.

control animation on an object-by-object basis

A mobile computer that has features and performance very similar to a personal computer is called a _____.

laptop computer

Ted volunteers to produce a large quantity of black and white leaflets for a charity organization. He has access to a printer with a high duty cycle and low operating costs. What type of printer is this?

laser printer

An arrangement of computers within the same building or site would be considered a _____.

local area network

=IF is an example of a _____ function.

logical

You have been asked to write a report for your school's soccer club, but you are not sure how to format the Microsoft® Word document. You decide to use a pre-designed document called a _____, which will enable you to speed up document creation.

template

In a spreadsheet program, a collection of worksheets saved in a single spreadsheet file is called a _____.

workbook

Harrison wants to apply for a summer job as an intern reporter at the local newspaper. What type of document should he send along with his résumé in order to request an interview?

A cover letter

Alfonso has hundreds of data points and wants to use software that will allow him to easily use formulas and functions to manipulate the data. Should he use a database or spreadsheet program?

A database program—it is the easiest program for using formulas and functions

Which type of software would BEST help Karalla to create a human resource training session at the office and one off-site location?

A presentation program

What is the major difference between a template and a wizard in word processing software?

A wizard prompts the user to answer questions and then creates a document; a template provides a static document with preset formats as a starting place.

What type of computer program is commonly used to combine and manipulate text and images to create attractive documents that might be used in developing a business project?

A word processing program

Which of the following is NOT a method for opening an existing document?

Close the task pane.

What is the correct punctuation after the greeting in a mixed-punctuation business letter?

Colon

Yelena needs to create a place to store information from thousands of online sales. She wants to include information about the product, customer, and payment type. Which type of software would BEST suit her needs?

Database

Which of the following BEST describes the standard format of a business letter?

Date, recipient's address, salutation, body, closing, enclosure, and typist's initials

Due to your continuous use of the Internet and email, your computer has become infected with a computer virus. What software utility should you obtain to correct the errors and protect your computer in the future?

Firewall software

Jae created a menu for a new pizza restaurant using Microsoft Word. He's frustrated because when the menu prints, parts of the document are not showing. The height should be longer than the width. What does Jae need to do to correct the problem?

Go to Page Setup and change to Portrait orientation.

Robin is creating a report for his psychology class. The document must be a minimum of 300 words and must be double-spaced. What is the easiest way to make sure all the paragraphs appear correctly?

Go to the Paragraph down-tab and select "Line Spacing, Double."

What is the difference between templates and themes in PowerPoint?

Only templates include text in placeholders and subject-specific content, whereas themes contain formatting such as coordinated font color and background.

There are several tasks in the operating system process that protect a computer. What is a task that should be done weekly to keep data safe?

Run a computer virus scan.

Which of the following is the BEST software for creating a document that will contain text and numerical information, and perform complex mathematical calculations?

Spreadsheet software

Kyle was hired by the government to forecast the weather each day. Large amounts of data are required to complete this task. To complete this task, what does the government most likely use?

Supercomputer

What is accomplished when James applies a report format to a simple Word document?

The page layout of the document is changed.

The Crunchy Crisp sales report must show monthly, quarterly, and annual sales figures for products. What is the BEST way to display this data numerically?

Use a table

Kim is writing a research paper using the MLA style guidelines. Her paper contains several quotations, and she must identify the specific sources of each. How should she reference the quotations to avoid plagiarizing?

Use endnotes.

Michelle has created a slideshow with timed transitions. What can she do to make sure the transitions are the appropriate length before she delivers the presentation?

Use the Rehearse Timing feature in the Slideshow menu.

Suppose one of your responsibilities as sales director is to report monthly sales activity. You need to keep the data current, so you want the summations and totals to update automatically. You also want to show the data in a visual way. Which of the following is NOT one of the reasons you chose a spreadsheet program to accomplish these tasks?

You can add image files to enhance the data.

Numbers, text, dates, or times of day that you type into a cell in a spreadsheet are called _____.

constant values

Your assignment is to create a poster using word processing software. To ensure that it is readable and attractive, you may want to use a _____, which is a set of colors, fonts, lines, and fill effects that are pre-designed to create a well-coordinated look.

theme

Suppose you receive a file called Practice.doc. Looking at the filename extension, you can tell that the file will be opened in a _____ program.

word processing