NEW
Font size
S
M
L
XL
WorksheetsComputer Apps Final
Total questions: 70
Worksheet time: 53mins
Name
Class
Date
1.
The function used to count how many words are in a range of cells
a)
count
b)
max
c)
round
d)
counta
2.
The __ allows you to customize the Office Applications for your own use and make you more efficient. You can add buttons to it for the operations you will use most often. It is in the top left corner of each application.
a)
Quick Access Toolbar
b)
Status Bar
c)
Navigation Pane
d)
Title Bar
3.
The __ is a box with a key to reading a chart.
a)
chart title
b)
axis title
c)
legend
d)
data markers
4.
Which tab appears only when a chart is selected?
a)
Review
b)
Chart Tools Format
c)
Insert
d)
Page Layout
5.
__ allows you to control how objects enter, move on, and exit on PowerPoint slides.
a)
animation effects
b)
visual effects
c)
playback effects
d)
audio effects
6.
The rule for documents that go to more than one page is __.
a)
There are no special rules.
b)
You must change the top margin on all pages except page 1.
c)
You must keep at least two lines of text together at the top of a page and at the bottom of a page.
d)
You must keep an entire paragraph on the bottom of the page and at the top of a page. (You cannot split the paragraph among different pages.
7.
Which of the following is a benefit of using Access database applications?
a)
You don't have to type any data in.
b)
Your forms automatically update for you.
c)
It is a relational database so when there is a change in one table, the other table is automatically updated.
8.
Which cell reference type will change the row number or column letter when a formula is copied?
a)
absolute
b)
relative
c)
function
d)
mixed
9.
A _ is applied to a field in a database that does not allow anyone to enter the same item twice.
a)
primary key
b)
absolute reference
c)
lookup field
d)
multivalue field
10.
Which chart type is used to compare values and is the default chart type in Excel?
a)
combination
b)
pie
c)
column
d)
area
11.
A(n) __ chart provides a simple way to show trends and variations in a range of data within a SINGLE CELL.
a)
line
b)
exploding pie
c)
clustered column
d)
sparkline
12.
Which application is best for keeping track of a great deal of data that must be updated constantly. You also have to run professionally-looking reports. (Examples: inventory items, customers, employees, patient information)
a)
US MS-Word to create a table that you can sort and then type a report with information you need for the inventory items.
b)
Use MS-Excel so that you can update the list and filter it to search for the item and then print the data related to just that one item
c)
Use MS-Access so that you can keep records current and print professional reports based on certain requirements.
13.
Using Access data and Word together allows you to create a(n) __.
a)
mail merge
b)
report
c)
embedded database
d)
web page
14.
Which view shows the header/footer on your spreadsheet?
a)
page layout
b)
print preview
c)
normal view
d)
page break view
15.
The purpose of the paintbrush (format painter) is to
a)
copy/paste data
b)
copy the formatting you have used to another area
c)
copy the text or cell style
d)
change the heading style
16.
Which of the following would be a likely application of MS-Word?
a)
tracking your weight loss
b)
creating a table of data that is sorted and searched
c)
calculating net profit for a company
d)
writing a letter of complaint to a company
17.
A __ is part of a database and is a category of information. (Examples: Last Name, Address, Social Security Number, Age)
a)
field
b)
record
c)
query
d)
database
18.
You are now on the track team. Everyday you run a mile and track your time and enter this in a spreadsheet. You want to create a graph that shows your changes (increases and decreases) in your time each day. Which chart type is best?
a)
column
b)
bar
c)
pie
d)
line
19.
Which filename is valid?
a)
Chapter 7, Assignment: 1
b)
Cover/Letter/1
c)
Resume_JobInterview
d)
Research Notes*2015*02*08
20.
Which of the following is used to name the horizontal axis?
a)
y axis
b)
x axis
c)
chart title
d)
z axis
21.
The __ function is useful when you want to assign a value to a cell based on a logical test.
a)
AND
b)
IF
c)
OR
22.
Which type of query calculates a statistic for data that is grouped by two different types of information?
a)
parameter
b)
update
c)
calculated
d)
crosstab
23.
Which of the following formulas will add C10 and C14 and then multiply the answer by 2.
a)
=(C10+C14)*2
b)
=C10+C14*2
c)
=2/C10+C14
d)
=2/(C10+C14)
24.
Which application allows you to use forms to enter and edit data?
a)
Word
b)
Excel
c)
Access
d)
PowerPoint
25.
A group of worksheets combined into one file is known as a(n) __.
a)
mode indicator
b)
workbook
c)
worksheet
d)
sheet tabs
26.
Which orientation allows you to print the information sideways (paper is 11 x 8.5)?
a)
print preview
b)
portrait
c)
landscape
d)
print preview
27.
A group of cells is known as a(n) __.
a)
range
b)
cell
c)
selection
d)
scroll bar
28.
Document __ are the details about a file.
a)
themes
b)
facts
c)
properties
d)
fields
29.
If you wanted to search a database to find all employees who are full-time employees, but you want the employee to enter their employment status (Full Time or Part time), you would create a
a)
update query
b)
and query
c)
or query
d)
parameter query
30.
A __ keeps you from being able to enter the same record twice in that field.
a)
primary key
b)
record
c)
query
d)
autonumber
31.
Which button do you use to resize a chart object?
a)
I beam
b)
+
c)
down arrow
d)
tab
32.
Which of the following is used to name the axis for a 3D chart?
a)
legend
b)
z axis
c)
y axis
d)
x axis
33.
In order to have different margins on different pages of a report, you have to use a __.
a)
page break
b)
column break
c)
nothing, just change the top margin on each page that needs to be different
d)
section break
34.
MS-Access would be bet suited for which of the following tasks?
a)
creating a flyer for to advertise a yard sale
b)
history report
c)
keep track of all the baseball cards you have as well as the ones you bought and sold each year
d)
create a letter to send to colleges
35.
__ view allows you to look at several slides at one time.
a)
Reading
b)
Review Sorter
c)
Slide Show
d)
Slide sorter
36.
If I enter a formula and I want Excel to use the same cell over and over in the calculation, (when I copy the formula), which cell reference type do I need to use?
a)
autosum
b)
absolute
c)
function
d)
relative
37.
I have a database set up for a real estate company. I want to be able to search it for a house on a certain street. The house address (number) does not matter. Which query type would be needed?
a)
AND
b)
OR
c)
Parameter
d)
Wildcard
38.
Excel has built-in pre-programmed formulas called __.
a)
functions
b)
wizards
c)
operators
d)
queries
39.
Which button is used to select data for a chart when the data is not right next to each other (adjacent)? Example: you need to select row 8 and row 12
a)
tab
b)
control
c)
alt
d)
shift
40.
A __ query allows you to search in a field even though you only know part of the data you are looking for.
a)
AND
b)
OR
c)
update
d)
wildcard
41.
Which of the following would be used to subtract K19 FROM K20
a)
=K20-K19
b)
=K19-K20
c)
=SUB(K20:K19)
d)
-K19-K20
42.
To multiply you use the __ symbol.
a)
*
b)
X
c)
/
d)
( )
43.
The ƒx button next to the formula bar is used to enter a __.
a)
autosum
b)
function
c)
average
d)
complex formula
44.
If you needed to end a line at the right margin and you wanted dots to go across the page, you would use a
a)
right align tab
b)
tab across the page
c)
type the period til you reach the right margin
d)
dot leader tab
45.
####### in a cell means
a)
your column is not wide enough
b)
your formula is wrong
c)
you need larger margins
d)
you have a
46.
Which feature do you use to get text to go around a picture?
a)
drop cap
b)
mutli-level list
c)
text wrap
d)
format painter
47.
A company wants to go over some new company policies and procedures with their sales staff. Which application would be best suited for this?
a)
Word
b)
Excel
c)
Access
d)
PowerPoint
48.
If you are editing a database in Access for someone else to use and you wanted an easy way for them to enter records, you should create a __.
a)
table
b)
query
c)
form
d)
report
49.
If you are editing a database in Access for someone else to use and you wanted an easy way for them to enter records, you should create a __.
a)
query
b)
table
c)
report
d)
form
50.
Which of the following makes use of a range?
a)
=A1+B1
b)
AZ102
c)
=C9+D9
d)
=SUM(D2:G2)
51.
To change a query, you must open it in __ view.
a)
Design
b)
Datasheet
c)
Form
d)
Report
52.
You have this formula in your worksheet:
=B$7*.5
How will this formula change if it gets copied to another cell?
=B$7*.5
How will this formula change if it gets copied to another cell?
a)
both the column and the row will change
b)
the column will stay fixed at B but the row number will change
c)
the column will change but the row number will be fixed at row 7
d)
neither the column nor the row will change.
53.
You are keeping track of sales for a company. They want to compare two types of items sold. You want to see which item type sells best. Which is the best type of chart to use?
a)
column
b)
scatter
c)
line
d)
pie
54.
When Excel automatically changes the cell address in a formula when it is copied, this is referred to as __.
a)
relative
b)
offset
c)
static
d)
absolute
55.
When a chart is placed on the same sheet as the spreadsheet, this is known as __.
a)
embedded
b)
copied
c)
pasted
d)
moved
56.
Which chart type plots individual points and charts data over time?
a)
line
b)
bar
c)
column
d)
pie
57.
When a colon is used in a formula, the colon means __.
a)
to disregard cell in between two cells
b)
to disregard the two cells listed and only use the ones in between
c)
through--include everything in between the two cells listed.
58.
If you enter a formula but the Excel shows the formula instead of the answer, what happened?
a)
You used the wrong cell reference type.
b)
You forgot to press enter after you typed the formula.
c)
You forgot to put the equal sign in front of the formula
59.
The presentation __ determines the formatting characteristics of fonts and colors.
a)
slide
b)
layout
c)
placeholder
d)
theme
60.
If you are entering records in an Access table, you must be in __ view.
a)
datasheet
b)
design
c)
query design
61.
Which function will look at a group of cells with numbers in them and tell how many there are?
a)
min
b)
count
c)
average
d)
max
62.
If you wanted to perform an Access search where two conditions had to be true you would use the __ query.
a)
AND
b)
OR
c)
Wildcard
d)
Parameter
63.
__ assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
a)
Option
b)
Formula
c)
Function
d)
Goal Seek
64.
To change the increments for an Excel chart, you have to change the __.
a)
major unit
b)
minor unit
c)
tick marks
d)
legend
65.
How do you make Word count and number the pages of a report?
a)
use the page number feature in the header
b)
just type the page numbers you want on each page
c)
choose different odd and even pages
66.
You want to compare the amount of money being spent on employee's pay for each department in the entire company.
a)
line
b)
bar
c)
column
d)
pie
67.
Default means
a)
settings that are the same in all programs
b)
settings that are automatic in a program
c)
setting you cannot change in a program
68.
Special visual and sound effects applied to text or other content are
a)
visual effects
b)
audio control
c)
playback control
d)
animation
69.
When using MS-Word there are different types of indentations that can be used. Which one is used when the first line of a paragraph begins at the left margin but all the lines below it are indented.
a)
half-inch
b)
hanging
c)
justified
d)
block
70.
Which chart type shows parts of a whole?
a)
area
b)
bar
c)
column
d)
pie
Reset
