WorksheetsTest Review II
Total questions: 55
Worksheet time: 28mins
Name
Class
Date
1.
When evaluating secondary computing devices for the workplace, the main concern should be weighing the benefit against the ________of the technology.
a)
size
b)
cost
c)
value
d)
depreciation
2.
A small company of 50 employees needs to predict how many hats to make for next August. Their sales for the last twelve months are (in no particular order) 319, 420,169,648,327,485,295,555, 303, 214, 401 and 211 hats. If August typically sees sales that are four fifths of 12 month average, how many hats should the company make next August? (Solve by adding all numbers then divide by 12. Then 4/5 * the answer you got)
a)
145
b)
290
c)
362
d)
444
3.
If a worker joins a team tasked to perform a formal audit, the core component of that task would be
a)
correcting the mistakes before anyone finds out
b)
validating results produced by another team or group
c)
working non-stop until a mistake or error or some kind is found
d)
accepting that data provided by management is accurate
4.
From the following list, when sorting in descending order, the first record would be
a)
Wisconsin
b)
Wyoming
c)
Arkansas
d)
Arizona
5.
Creating reports is a convenient way to summarize a data set and present findings to co-workers and management. Before presenting or releasing any report, the most important thing to do is
a)
recheck all facts and calculations for accuracy
b)
review the reports to make sure the author's name is on it
c)
make the report as exciting and intresting as possible
d)
show the report to management first to get credit for completing the task
6.
The process of comparing the data to set of rules or values determine if the data is accurate is called
a)
formatting
b)
validation
c)
IGO
d)
fixing
7.
Forecasting relies on trends and produces results that are
a)
generally unusable
b)
prediction based
c)
statistically integrated
d)
completely reliable
8.
The biggest advantage of using accounting software is that
a)
calculate income tax
b)
is inexpensive
c)
takes time to learn
d)
helps analyze the business
9.
Batch processing is defined as collecting data for a period of time and processing all transactions
a)
as a group one at a time
b)
with simple interactiveproblem solving
c)
over telephone lines
d)
indivudually at different times
10.
What type of chart would best show trends over a period of time
a)
scatter
b)
x-y
c)
line
d)
pie
11.
The procedure that permits the tracing of data from source to output is called the
a)
information speech
b)
system conversion
c)
audit trail
d)
unitest
12.
Which of the following instruments best shows the relationships of parts to a whole?
a)
bar graph
b)
pie chart
c)
line graph
d)
area chart
13.
Combining a file that contains address data with a form letter is called
a)
publishing
b)
personalizing
c)
merging
d)
addressing
14.
Word wrap
a)
makes an information from the left margin
b)
replaces misspelled words from the built in dictionary
c)
moves text automatically to the next line when it reaches the right margin
d)
arranges records in specific order
15.
A file sent with an email message is called a/an
a)
header
b)
contact
c)
attatchment
d)
extension
16.
When a graphic is imported from the Web and placed into a document it
a)
can be resized
b)
must be placed in a table
c)
must be centered
d)
can only be placed on the first page
17.
The process of adding all the numbers in a range of cells can be performed by using a
a)
database program
b)
math problem
c)
sorting method
d)
sum function
18.
Electronic messages containing text can be sent from a computer using the ____________ system
a)
office management
b)
email
c)
office vision
d)
groupware
19.
The computer's clipboard is
a)
a place in the memory to aid in cutting, copying, and pasting
b)
hardware used to hold papers and other documentation
c)
a new word processor
d)
used with the delete key
e)
Option 5
20.
If a user wants to store the name and address of a customer with email software, which of the following folders would be used?
a)
contacts
b)
calander
c)
personal
d)
tasks
21.
What software would be the best choice to produce high quality sophisticated documents such as marketing literature, brochures, or catalogs?
a)
CAD
b)
presentation graphics
c)
word processing
d)
desktop publishing
22.
In an electronic spreadsheet the intersection of a row and a column is called
a)
pigeon hole
b)
cell
c)
coordinate
d)
slot
23.
A sales manager planning to introduce a new product line to the sales staff would probably use _________ software
a)
presentation
b)
spreadsheet
c)
photo
d)
graphics
24.
Such design elements as drop capitals and graphics embedded with watermarks, are both forms of ________within using desktop publishing
a)
special effects
b)
text boxes
c)
hyperlink features
d)
reverse techniques
25.
Which of the following commands would be used in a database application to find all the records for employees who work in the accounting department
a)
merge
b)
sort
c)
query
d)
copy
26.
Preset, margins, tabs, line, spacing, and fonts are called _______settings.
a)
ordinary
b)
standard
c)
default
d)
current
27.
Preparing layout, which is a feature of desktop publishing software is the process of
a)
editing a frame of video. which is called a page
b)
recieving dictation for each page from the author of a novel
c)
arranging text and graphics in a document on a page by page basis
d)
depicting data in a graphical form on a page by page basis
28.
To produce an electronic slideshow a _________ software application would be used.
a)
communication
b)
word processing
c)
presentation
d)
graphic
29.
An approach that combines visual audio and interactive technologies is called
a)
WYSIWYG
b)
multimedia
c)
resolution
d)
GUI
30.
A font is best described as
a)
the length of a print line
b)
a set of characters of a specific style
c)
the number of characters on a display line
d)
the number of characters used
31.
The y-axis scale of a 3-D chart is derived from
a)
Values in the worksheet
b)
totals in the total column
c)
row headings in the worksheet
d)
column headings in the worksheet
32.
When a database contains the names and addresses of customers, information about a single customer is known as
a)
word
b)
record
c)
field
d)
file
33.
A column of options representing various functions within an application is called a
a)
menu
b)
list
c)
set
d)
button
34.
To access online services for news, weather, financial, and travel information, use ___________ software.
a)
word processing
b)
electronic mail
c)
communications
d)
database
35.
Creating a graph from data found in a spreadsheet can be accomplished by highlighting
a)
data found on the internet
b)
numbers entered in rows and columns
c)
a word processing problem
d)
information from business math problems
36.
A collection of related information that can be organized in different ways is a
a)
schema
b)
data system
c)
logical record
d)
database
37.
Creating an advertising flyer using techniques such as importing, positioning, and resizing of graphics along with the wrapping of text around images is part of
a)
data processing
b)
scanning documents
c)
graphic organizers
d)
desktop publishing
38.
Web conferencing with screens showing participants is called _________conferencing
a)
camera
b)
desktop
c)
video
d)
personal
39.
The automatic updating of a formula when it is copied to a new location is called
a)
absolute
b)
what-if
c)
mixed
d)
relative
40.
A trial balance can be used to check that all debit entries equal credit entries
a)
show the changes that occured over time
b)
find wheter a bill was passed
c)
check that all the bills are paid
d)
check that all the debt entries equal credit entries
41.
A Business borrowed $3,500 for two years to finance expansion. At the end of two years $4,760 was repaid. What was the annual simple interest percentage rate that the company paid? (Solve by 4760-3500 =1260. Then 1260/7000= you get the 7000 by 3500*2. Answer 18%
a)
13 percent
b)
15 percent
c)
17.5 percent
d)
18 percent
42.
Upon review of the cash flow receipts, the auditor determined that 1/4 were cash deposits, 3/5 were credit card receipts and 3/20 were checks. The total number of deposits for that period amounted to $62,520,.80 How much of the money was in the form of cash, credit card, and checks? (Solve by 1/4 *62,520.80. 3/5 *62.520.80. 3/20 * 62,520.80
a)
Cash = $15,630.20 Credit card = $37,512.48 Checks =$9,378.12
b)
Cash = $9,378.12 Credit card = $15,630.20 Checks =$37,512.48
c)
Cash = $37,512.48 Credit card = $9,378.12 Checks =$15,630.20
d)
Cash = $37,502.48 Credit card = $15,630.20 Checks =$9,378.12
43.
During a sales week a sales person commissions were $247.85 on Monday $104. 83 on Tuesday; $207.16 on Wednesday; $385.67 on Thursday; $358.76 on Friday; and $ 401.61 on Saturday. What was the average daily commission for the sales person? (Solve by add up all the number then divide by 6 because there was six work days) Answer 284.31
a)
$243.70
b)
$284.31
c)
$341.18
d)
$1,705.88
44.
An electronic stapler was purchased for $15.98 and a box of staples for $4.98. The sales tax is 6 percent what is the final cost? (Solve by adding both numbers multiply by 0.06 Then adding 20.96 + 1.26=22.22
a)
$16.26
b)
$20.96
c)
$22.21
d)
$22.22
45.
A company imports wicker products from China. The average unit cost is $550 With new excise taxes a 12.5 percent increase in the average cost is expected. This means the company will have to mark up the average cost by 1/4 of the current amount. What will the new average unit cost be? Answer 756.25
a)
$562.50
b)
$618.75
c)
$687.50
d)
$756.25
46.
Pedro submitted his time card, which showed 36 regular hours for Monday-Friday He also listed 4 hours of over time for working on Sunday, which by policy is calculated 1-1/2 times his regular pay rate. His hourly rate is $2.00 per hour When he received his check the gross amount was $800. Pedro went to the manger to complain that the gross amount was incorrect. Why would he claim that fact? Answer is over time is time and a half after 40 hours
a)
The 36 hours are paid $20.00 per hour while Sunday hours (4) are paid $30.00 per hour.
b)
A pay raise was due and Pedro's gross amount did not reflect the raise
c)
Over time is time and a half after 40 hours, and he worked 40 total hours
d)
It is not incorrect 40 hours times $20 equals $800.
47.
The advertising budget for the year is estimated at $2,250,000. During budget meetings the company decided that the advertising budget would face an 18 percent cut. Determine the amount of the advertising budget cut. (Solve by 2,250,000 * 18%) =405,000
a)
$125,000
b)
$225,018
c)
$305,000
d)
$405,000
48.
The Account balance is the
a)
credit of an account record
b)
debits divided by the credit
c)
debit of an account record
d)
difference between debits and credits
49.
Wooten's Widgets Inc is a small business that makes weekly deposits. This week's deposit totaled $7,231.57. The total checks written for the week equaled $5317.76. The previous balance last week was $5,042.43. The service charge fir each week is 0.1 percent of the previous weeks balance. What is the new balance this week? (5,042.43 * 0.001 = 5.04. 5,042.43 +7,231.57 =12,274.00...... 5,517.76 +5.04=5322.80..... 12,274.00-5,322.80 =6,951.20
a)
$1,913.81
b)
$6,951.20
c)
$6,956.24
d)
$12,274.00
50.
Kayla, a senior in high school deposits her entire paycheck directly into her account each week. This weeks paycheck includes a net raise of $24.20 that she received as a job promotion. Kayla has a total deposit of $203.50 Based on her average of 22 hours, what was the percent increase of Kayla's hourly raise? Answer 13.5 Percent
a)
10.1 percent
b)
11.9 percent
c)
13.5 percent
d)
100 percent
51.
A decrease in value of a tangible asset because of use and passage in time is called
a)
amortization
b)
depreciation
c)
prorating
d)
costing
52.
The arrangement of data in order either numerically or alphabetically is called?
a)
classifying
b)
grouping
c)
ordering
d)
sorting
53.
A firm owes Barnstable videos $1,500 at the beginning of February. On February 10 the firm buys an additional $300 worth of merchandise on credit from Barnstable's. On February 14 the firm returns $175 of the merchandise to Barstable. How much does the firm owe Barstable on February 28? 1500 + 300 = 1800. Then 1800 -175 =1,625
a)
$1,500
b)
$1,625
c)
$1,800
d)
$1,975
54.
If $5,000 was borrowed from the bank for 3 years at 9.5 percent per year. What is the total amount needed to repay at the end of the loan? Answer 6,425
a)
$1,425.00
b)
$1,578.95
c)
$5,142.50
d)
$6,425.00
55.
Expenses for a business to set up an online store include credit card expenses. The credit card service fee is $49 per month. there was 205 transactions at $0.25 per transaction. The total transaction fee this month would be Answer 100.25
a)
$49.25
b)
$51.25
c)
$54.25
d)
$100.25
100 %
