BIM review
What does this image show? Clip art image of 5 computers. One is at the center, and connected to the four others by cords a. A mainframe b. A laptop computer c. A computer network d. A desktop computer system
A computer network
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. a. tabs b. indents c. borders d. margins
margins
The purpose of paragraph styles in word processing software is to add a predefined style to _____. a. a single word b. a single sentence c. one or more lines d. one or more paragraphs
one or more lines
John is responsible for the Magic Club's database. When he is asked to sort a database, what would he be expected to do? a. Find a professional who can take a computer apart. b. Identify the fields and records. c. Arrange the data in a certain order. d. Divide the database into different folders.
Arrange the data in a certain order.
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? a. Cut b. Copy c. Clear d. Paste
Copy
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? a. Create a new page. b. Create a page break. c. Create a hard column break. d. Hold the space bar down until it moves to the next column.
Create a hard column break.
When modifying an information database, what modification is MOST risky in terms of potentially losing data? a. Adding a field. b. Deleting a record. c. Decreasing the width of a field. d. Deleting a field.
Deleting a field.
Which commands can be used to add rows and columns to an existing spreadsheet? a. Add row ; Add column b. Insert row ; Insert column c. Attach row ; Attach column d. Append row ; Append column
Insert row ; Insert column
Which of the following is a common environmental factor that can negatively impact the usefulness and lifespan of a computer? a. Too many different users b. Heat c. Improper use d. Scheduled maintenance
Heat
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? a. The font size b. The font style c. The font color d. The background size
The font size
When Jan wanted to enhance her PowerPoint presentation, she decided to add animation effects. These effects will allow her to _____. a. add cartoon images b. control animation on a slide-by-slide basis c. control animation on an object-by-object basis d. set slide transitions
control animation on an object-by-object basis
A mathematical equation that is used to calculate values in a spreadsheet program is called a _____. a. macro b. routine c. formula d. function
formula
The main reason that many new offices connect their employees' computers to a local area network (LAN) is because it allows the devices to _____. a. run faster b. access the Internet c. share information d. send pictures to friends
share information
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. a. database b. spreadsheet c. presentation d. word processing
word processing
In a spreadsheet program, a collection of worksheets saved in a single spreadsheet file is called a _____. a. project b. workbook c. workstation d. document book
workbook
What is the default way data is organized in a spreadsheet? a. In lists b. In charts c. In graphs d. By rows and columns
By rows and columns
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? a. Power off the computer. b. Empty the email trash bin. c. Reboot peripheral devices. d. Run a computer virus scan.
Run a computer virus scan.
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? a. Write a memo. b. Cut and paste the correct information. c. Use document templates. d. Use a mail merge document.
Use a mail merge document.
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? a. Rotate the text. b. Indent the text. c. Center the text. d. Wrap the text.
Wrap the text.
Numbers, text, dates, or times of day that you type into a cell in a spreadsheet are called _____. a. data sets b. active cells c. cell references d. constant values
constant values
A mobile computer that has features and performance very similar to a personal computer is called a _____. a. workstation computer b. special-purpose computer c. laptop computer d. supercomputer
laptop computer
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. a. pure b. relative c. absolute d. dependent
relative
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. A database program b. A spreadsheet program c. A presentation program d. A word processing program
A word processing program
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? a. Go to Format and change to Portrait orientation. b. Go to Format and change to Landscape orientation. c. Go to Page Setup and change to Portrait orientation. d. Go to Page Setup and change to Landscape orientation.
Go to Page Setup and change to Portrait orientation.
When David inserted a graphic into a document, it showed up much smaller than the original. How can he correct this? a. Crop the graphic. b. Rotate the graphic. c. Resize the graphic. d. Delete the graphic and try again.
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? a. Salary - Cost of Benefits + Commission b. Commission + Salary + Cost of Benefits c. Salary + (Sales ⋅ Commission) ⋅ Cost of Benefits d. Salary + (Sales ⋅ Commission) - Cost of Benefits
Salary + (Sales ⋅ Commission) - Cost of Benefits
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? a. She used sparkling WordArt. b. She made changes and left a review note. c. She added a text effect to the text. d. She was able to achieve this effect with scrolling text.
She added a text effect to the 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? a. She sorted the data. b. She changed a formula. c. She corrected a data entry. d. She widened the cells to show all the data.
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? a. Thesaurus b. Hyphenation c. Track changes d. Spelling and grammar
Spelling and grammar
What spreadsheet criteria would you use to analyze survey results? a. Statistical functions b. The Function formula c. Mathematical functions d. Trigonometric functions
Statistical functions
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? a. Mainframe b. Supercomputer c. Minicomputer d. Professional workstation
Supercomputer
Which of the following allows you to increase or decrease the viewing size of a word processing document? a. Layout view b. The Access tool c. The Zoom slider d. The Preview icon
The Zoom slider
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. a. Thumbnails b. Bulleted list c. Outline view d. Numbered list
Thumbnails
What is it called when you move from one PowerPoint page to the next in a presentation? a. Flipping b. Skipping c. Page-turning d. Transitioning
Transitioning
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? a. Use color. b. Use a pie chart. c. Use a bulleted list. d. Change the font size.
Use a bulleted list.
A data warehouse is _____. a. a folder of multiple databases b. a single database with data from a single source c. a single database with data from multiple sources d. multiple databases with data from a single source
a single database with data from multiple sources
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. a. style b. chart c. template d. section break
template
When using PowerPoint, it is sometimes useful to use the Outline view because it includes the _____ of each individual slide. a. layout b. formats c. font d. text
text
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? a. "I'll copy it for you, but you can't copy it for anyone else." b. "I can't copy it because it will break copyright laws." c. "I'll copy it, but you have to promise not to tell anybody." d. "I don't know how to copy diskettes."
"I can't copy it because it will break copyright laws."
What is the function of the primary key in a database? a. To identify records and relate two or more tables. b. To identify fields and relate two or more tables. c. To identify tables and relate two or more tables. d. To identify records and relate two or more fields.
. To identify records and relate two or more tables.
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? a. / b. * c. = d. %
=
Which of the following is a correctly formatted absolute cell reference for both column and row in Microsoft Excel? a. $C5 b. =#A$7 c. =$M$3 d. =$89:$S
=$M$3
In Microsoft Excel, which of the following is the correct method to subtract values in two different cells? a. A - B b. B4*B6 c. =46x39 d. =C10-B9
=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? a. =NOW() b. =SUM(cells) c. =PMT(rate, nper, pv, fv, type) d. =IF(logical_test, value_if_true, value_if_false)
=PMT(rate, nper, pv, fv, type)
Which formula correctly adds the contents of two cells, and then multiplies the result by 5%? a. +SUMA2+B4)*5% b. =SUM(A2-B4)*5% c. =SUM(A2+B4)*5% d. =SUM((A2=B4))*5%
=SUM(A2+B4)*5%
Which type of software would BEST help Karalla to create a human resource training session at the office and one off-site location? a. A database program b. A spreadsheet program c. A presentation program d. A word processing program
A presentation program
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? a. Wizard b. Mail Merge c. Spell Check d. Tables and Borders
Add a page break before the final paragraph.
Jane Thomas needs to search her alumni class report in ascending order by last names. Which of the following is the BEST example of a sort in ascending order? a. Akers, Davis, Campbell, Barnes b. Barnes, Akers, Campbell, Davis c. Akers, Barnes, Campbell, Davis d. Davis, Campbell, Barnes, Akers
Akers, Barnes, Campbell, Davis
Thomasina needs to search her senior class report in descending order by seniors' last names. Which of the following is the BEST example of a sort in ascending order? a. Austin, Davis, Campbell, Barnes b. Barnes, Austin, Campbell, Davis c. Austin, Barnes, Campbell, Davis d. Davis, Campbell, Barnes, Austin
Austin, Barnes, Campbell, Davis
What kind of program do you need to make sure your files can be recovered in the event of a virus? a. Encryption b. Network c. Backup d. Uninstall
Backup
_____ are text symbols, such as small circles or checkmarks, that are used to introduce items in a list. a. Fonts b. Bullets c. Spin boxes d. Text effects
Bullets
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? a. Add a hanging indent. b. Increase the size of the font. c. Increase the size of the margins. d. Change the alignment to justified.
Change the alignment to justified.
Which of the following is NOT a method for opening an existing document? a. Use "Recent Documents" after clicking the Office icon. b. Choose "Open" after clicking the Office icon. c. Click the "Open" button. d. Close the task pane.
Close the task pane
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? a. Open a database in Design View. b. Open a database in Layout View. c. Create a form for potential members to enter their information. d. Lock the database from editing so someone can not see other peoples' information when they enter their own information.
Create a form for potential members to enter their information.
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? a. Create a report, then a table. b. Create a query, then a report. c. Create a table, then a query. d. Create a table, then a report.
Create a query, then a report.
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? a. Create a fill handle within the cell. b. Create an absolute reference that contains a $ in the formula. c. Create a relative reference within the cell. d. Create a relative reference that contains a $ in the formula.
Create an absolute reference that contains a $ in the formula.
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? a. Create the table, enter data, sort, create a report, and print the report. b. Enter data, create a report, and print the report. c. Create the report structure, sort, and print the report. d. Create the table structure, create the report, enter data, and print the report.
Create the table, enter data, sort, create a report, and print the report.
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? a. PDF reader b. Word processing c. Database d. Presentation
Database
What is a MAIN reason many companies choose to store their customer payment information in databases instead of spreadsheets a. Databases are more secure than spreadsheets—using them helps protect customer information. b. Databases allow companies to use formulas and functions to tabulate the data. c. Databases can make charts and graphs, whereas spreadsheets can only record data in a table. d. There are only 100 rows in a spreadsheet, so companies need to use a database if they have more than 100 customers.
Databases are more secure than spreadsheets—using them helps protect customer information.
The RATE function is what type of function? a. Logical b. Date/Time c. Financial d. Text
Financial
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? a. CD-burning software b. Antivirus software c. Data decryption software d. Firewall software
Firewall software
Which of the following is an example of a network operating system? a. Novell GroupWise b. Office 2010 c. Home Office d. Mac OS X
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? a. Wizard b. Mail Merge c. Spell Check d. Tables and Borders
Mail Merge
All of the following are data types in Access EXCEPT _____. a. Number b. Text c. Name d. Date/Time
Name
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? a. Place the cursor where the paragraph belongs and type the needed text. b. Type the needed text in a new document and use the Copy command to place the paragraph at the proper location. c. Type the needed text at the end of the paper and use the Move command to place the paragraph at the proper location. d. Place the cursor at the beginning of the story, type the needed text, and use the Move command to place the paragraph at the proper location.
Place the cursor where the paragraph belongs and type the needed text.
Which of the following is the BEST software for creating a document that will contain text and numerical information, and perform complex mathematical calculations? a. Database software b. Spreadsheet software c. Word processing software d. Presentation graphics software
Spreadsheet software
What is accomplished when James applies a report format to a simple Word document? a. The paragraph indentation of the document is changed. b. The page layout of the document is changed. c. The text spacing of the document is changed. d. The color scheme of the document is changed.
The page layout of the document is changed.
What is the purpose of the Thesaurus tool? a. To check the spelling of a word or phrase b. To decrease the number of words you use c. To increase the total number of words you can use d. To provide alternative words with similar meanings for a word you enter
To provide alternative words with similar meanings for a word you enter
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? a. Use a chart. b. Use columns. c. Use paragraphs. d. Use an organizational chart.
Use a chart.
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? a. View the slideshow in outline view to see how long it is. b. Use the Rehearse Timing feature in the Slideshow menu. c. Use sections to divide the presentation. d. Change the setting on the Slideshow menu to Loop Continuously.
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? a. You can add image files to enhance the data. b. You can use formulas to perform automatic calculations. c. You can create a chart from the data and import it into business reports. d. You can use a pre-defined table format to make the data look attractive.
You can add image files to enhance the data
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 _____. a. open the Styles toolbox b. insert text wherever she wants c. AutoFormat the entire document d. apply the format to multiple selections
apply the format to multiple selections
Creating a stacked list of items in a word processing program can easily be accomplished by using the _____ functionality. a. list b. items c. bullet d. underline
bullet
An arrangement of computers within the same building or site would be considered a _____. a. group network link b. wide area network c. network connection company d. local area network
local area network
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? a. Press the Enter key after every line. b. Go to the Paragraph down-tab and select "Line Spacing, Double." c. Go to the Font down-tab and select "Character Spacing, Expanded." d. Go to the Style down-tab and select "Normal Style."
Go to the Paragraph down-tab and select "Line Spacing, Double."
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 Student Name Test 1 Test 2 Test 3 Test Average 2 Mei 89 90 89 3 Mike 90 80 60 4 Sue 70 90 70 5 Ramon 80 70 80 a. =SUM(B2:D2)/3 b. =SUM(B2+C2+D2)/3 c. SUM(B2+C2+D2)/3 d. =SUM(C2+D2+E2)*3
=SUM(B2+C2+D2)/3
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? . a. A network connection b. A network connection, a printer, and a computer c. A computer, a network connection, and a CD-ROM drive d. A computer, a network connection, and backup system software
A computer, a network connection, and backup system software
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. A newsletter b. A cover letter c. A memorandum d. A formal business letter
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. A database program—a spreadsheet program works only with small amounts of data b. A database program—it is the easiest program for using formulas and functions c. A spreadsheet program—a database program works only with small amounts of data d. A spreadsheet program—it is the easiest program for using formulas and functions
A database program—it is the easiest program for using formulas and functions
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? a. Create a new table with more fields of relevance. b. Create a new query with more information. c. Create a new report and remove some unnecessary fields. d. Create a new report with all of the fields from the original table.
Create a new report with all of the fields from the original table
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? a. Create a table in Word, enter the data, and then use a chart to visually display the data. b. Create columns in Word, enter the data, and then use a chart to visually display the data. c. Create a list in Word, enter the data, and then use a chart to visually display the data. d. Create a graph in Word, enter the data, and then use a chart to visually display the data.
Create a table in Word, enter the data, and then use a chart to visually display the data.
Which of the following word processing program functions would LEAST likely be used in completing a population growth chart? a. Spell checker b. The table wizard c. An outline template d. Tables and borders
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 _____. a. Save As b. Auto Filter c. Page Setup d. Print Preview
Auto Filter
Which choice BEST describes the meaning of the formula =avg(c1:c10)? a. Average of values in cells C1 through C10 b. Average of values in cells C1 and C10 only c. Average of all cells in columns 1 through 10 d. Average of column C, excluding values in cell C1 and C10
Average of values in cells C1 through C10
Below is a time card with Miguel's information for Week 1 at his job. Based on the data, what spreadsheet formula was used to calculate his daily pay? Hours Pay Rate Daily Pay Monday 7 $7.00 $49.00 Tuesday 8 $7.00 $56.00 Wednesday 6 $7.00 $42.00 Thursday 8 $7.00 $56.00 Friday 8 $7.00 $56.00 Total Pay $259.00 a. Hours ⋅ Pay Rate b. Hours + Pay Rate c. Hours ⋅ Daily Pay d. Hours + Daily Pay
Hours ⋅ Pay Rate
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? a. Laser printer b. Label printer c. Inkjet printer d. LCD/LED matrix printer
Laser printer
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? a. Make sure the fonts are all the same size. b. Make sure you use the same font style in each paragraph. c. Make sure you use the same font color in each paragraph. d. Make sure the spacing between fonts and paragraphs is uniform.
Make sure you use the same font style in each paragraph.
In which of the following situations would PowerPoint NOT be an appropriate software choice? a. Pitching a new marketing strategy at a board meeting b. Making a family photo album or scrap book c. Manipulating and analyzing large amounts of sales data d. A company policy presentation for new employees
Manipulating and analyzing large amounts of sales data
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? a. Tabs b. Indents c. Borders d. Margins
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? a. Insert another row. b. Split the cells in the top row. c. Merge the cells in the top row. d. Insert a row with only two cells.
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? a. Microsoft Word b. Microsoft Excel c. Microsoft Access d. Microsoft PowerPoint
Microsoft Word
What is the difference between templates and themes in PowerPoint a. Only themes include animations, transitions, and sample text, whereas templates only change slide color and font. b. Themes must be opened from the Home menu before designing a presentation, whereas templates can be applied at an time to an existing presentation. c. Only templates include text in placeholders and subject-specific content, whereas themes contain formatting such as coordinated font color and background. d. There is no difference between templates and themes.
Only templates include text in placeholders and subject-specific content, whereas themes contain formatting such as coordinated font color and background.
Given the pie chart below, what is the second most popular plan under the new insurance program? A pie chart with four pieces labeled. Beginning at the top and moving clockwise; Plan A 9 percent; Plan B 16 percent; Plan C 29 percent; Plan D 46 percent. a. Plan A b. Plan B c. Plan C d. Plan D
Plan C
To illustrate their advertising revenue trends, the Union Outdoor Billboard Company used the chart below. What could be predicted about the summer sales of 2014? Line graph. First line represents 2012 and has data points at $140,000 for spring, $125,000 for summer, $45,000 for fall, $40,000 for winter. Second line represents 2013 and has data points at $145,000 for spring, $140,000 for summer, $60,000 for fall, $58,000 for winter. Last line represents 2014 and has a data point at $160,000 for spring. a. Sales will increase. b. Sales will increase and then decrease. c. Sales will decrease. d. Sales will stay the same.
Sales will decrease
What is the difference between sorting and filtering records? a. Sorting reduces the number of records being viewed. Filtering only changes the order of records. b. Sorting only changes the order of records. Filtering only reduces the number of records being viewed. c. Sorting changes the order of records. Filtering creates a new word processing document containing the selected data. d. Sorting and filtering records performs the same function.
Sorting only changes the order of records. Filtering only reduces the number of records being viewed.
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? a. Buy new computers yearly with the highest quality supplies and software. b. Leave maintenance and purchasing responsibilities to each individual employee. c. Purchase supplies when they run out, and purchase the most updated word processing programs. d. Stock supplies in advance, maintain computer hardware, and run current virus protection regularly.
Stock supplies in advance, maintain computer hardware, and run current virus protection regularly.
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? a. Use wingdings b. Use autoshapes c. Use a table d. Use a chart
Use a table
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? a. Yes, it would allow him to organize his presentation and allow him to show the board his charts and images. b. No, PowerPoint is not designed to include charts. c. No, PowerPoint will not allow Jeremy to focus on the product presentation because he will be required to manually switch between slides. d. No, Jeremy should use Excel to design his presentation.
Yes, it would allow him to organize his presentation and allow him to show the board his charts and images.
In _____ cell referencing, the formula does not change when it is copied and pasted to other cells. a. pure b. relative c. absolute d. dependent
absolute
When you place your cursor between two words in a word processing document, the blinking vertical line you see is called _____. a. a cell b. the line count c. a vertical dash d. an insertion point
an insertion point
After a database has been created, the fundamental arrangement _____. a. cannot be changed once you input the data b. is automatically modified to the type of data entered c. can be adapted as needed d. is created depending on whether data is textual or numeric
can be adapted as needed
In a data set each _____ represents a variable and each _____ represents a member of the data set. a. column ; row b. row ; column c. query ; report d. report ; query
column ; row
An Access database would be appropriate for all of the following tasks EXCEPT _____. a. organizing customer contact information b. keeping data on potential contributors to a charitable organization c. delivering an oral presentation for potential investors d. tracking and studying data about the population of a city
delivering an oral presentation for potential investors
Computer operating systems organize files with a system of _____. a. classes b. groups c. folders d. networks
folders
To control the appearance of a spreadsheet document, the user manipulates _____ commands. a. fashion b. dimension c. proportion d. formatting
formatting
=SUM (B6...B10) is an example of a preset formula, or _____. a. graph b. macro c. routine d. function
function
=IF is an example of a _____ function. a. logical b. database c. financial d. calculation
logical
A spreadsheet can generally be defined as a _____. a. row-and-column arrangement of data b. chart that can be used to prepare business reports c. grid arrangement of data used by modern calculators to solve equations d. worksheet used by mathematicians and engineers to help solve problems
row-and-column arrangement of 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 _____. a. scanner b. projector c. LED printer d. digital camera
scanner
The university has computers connected to a local area network (LAN), which is NOT intended for _____. a. sharing important information with colleagues b. accessing the Internet for needed information c. running much faster d. sending email to friends
sending email to friends
Microsoft Access is a program that can easily produce all of the following EXCEPT _____. a. slideshows b. reports c. queries d. forms for data entry
slideshows
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. a. link b. style c. theme d. format
theme
What is the major difference between a template and a wizard in word processing software? a. A template provides a document with unchangeable formats; a wizard provides a changeable document. b. A wizard provides a document with unchangeable formats; a template provides a changeable document. c. A template prompts the user to answer questions and then creates a document; a wizard provides a static document with preset formats as a starting place. d. 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.
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 role does a database play in the Mail Merge process? a. The database produces letters and labels based on data in Excel. b. A word processing program produces letters and labels based on data in the database. c. A presentation program produces letters and labels based on data in the database. d. Databases are not used in the Mail Merge process. Mail Merge is done with a spreadsheet and a word processing program.
A word processing program produces letters and labels based on data in the database.
The spreadsheet below shows magazine sales for Mrs. Weinstein's kiosk. How was the Total Amount calculated? 1 Magazine Number Sold Subscription Rate Total Amount 2 Time 1 $23.00 $23.00 3 Newsweek 4 $26.00 $104.00 4 TV Guide 6 $32.00 $192.00 5 Redbook 8 $40.00 $320.00 a. By dividing the number sold by the subscription rate b. By adding the number sold to the subscription amount c. By subtracting the total amount from the subscription rate d. By multiplying the number sold times the subscription rate
By multiplying the number sold times the subscription rate
What is the correct punctuation after the greeting in a mixed-punctuation business letter? a. Dash b. Colon c. Comma d. Period
Colon
Which of the following BEST describes the standard format of a business letter? a. Date, recipient's address, salutation, body, closing, inserts, and typist's initials b. Date, sender's address, salutation, body, closing, enclosure, and typist's initials c. Date, recipient's address, salutation, body, ending, enclosure, and typist's initials d. Date, recipient's address, salutation, body, closing, enclosure, and typist's initials
Date, sender's address, salutation, body, closing, enclosure, and typist's initials
In which of the following situations would a PowerPoint presentation be MOST effective? a. Compiling large amounts of data and creating charts based on that data. b. Designing and printing brochures for a travel agency. c. Delivering a presentation to potential investors about a new business plan. d. Writing and editing a lengthy paper for class.
Delivering a presentation to potential investors about a new business plan.
_____ is a setting that causes a PowerPoint to continuously repeat itself. a. Wipe b. Appear c. Rehearse d. Loop continuously
Loop continuously
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? a. Use captions. b. Use endnotes. c. Use cross-references. d. Use a table of figures.
Use endnotes.