WorksheetsComputer Apps Final
Total questions: 85
Worksheet time: 43mins
Name
Class
Date
1.
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)
function
b)
absolute
c)
autosum
d)
relative
2.
Which button would you use to copy your formatting?
a)
Option 1
b)
Option 2
c)
Option 3
d)
Option 4
3.
Which of the following examples makes use of a range?
a)
=A1+B1
b)
AZ102
c)
=B6+C6
d)
=SUM(D2:R2)
4.
What option is used to make sure that there is no page number on any other pages but the first page of a report?
a)
different first page
b)
different odd & even pages
c)
Remove Page Number
d)
Page Number
5.
When you see ###### in a cell, this means __.
a)
you used the wrong type of cell reference
b)
the formula entered is incorrect
c)
the column is not wide enough
6.
A __ keeps you from being able to enter the same record twice in that field.
a)
record
b)
query
c)
primary key
d)
autonumber
7.
In order to have different margins on different pages of a report, you have to use a __.
a)
page break
b)
column break
c)
section break
d)
nothing, just change the top margin on each page that should be different.
8.
Which of the following symbols is required before all formulas?
a)
+
b)
/
c)
=
d)
^
9.
The word "default" refers to __.
a)
settings that you cannot change in a program
b)
settings are automatic in a program.
c)
settings that are the same in all programs
10.
If you wanted to search a real estate database for all houses that have 1-2 bathrooms, you would create a __ query.
a)
and
b)
or
c)
wildcard
11.
The following picture is an example of __.
a)
a dot leader tab
b)
a right align tab
c)
a left tab
d)
a decimal tab
12.
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)
wildcard
b)
and
c)
or
13.
By default a formula is copied and pasted from one cell to another, Excel automatically changes the cell address to reflect the destination location. This is referred to as __.
a)
Absolute
b)
Relative
c)
Offset
d)
Static
14.
A group of cells is known as a __.
a)
selection
b)
range
c)
scroll bar
d)
cell
15.
This picture is showing __.
a)
an Outline
b)
SmartArt
c)
WordArt
d)
Clipart
16.
What feature is being used here?
a)
newsletter
b)
columns
c)
report
17.
The _________ determines the formatting characteristics of fonts and colors.
a)
slide
b)
layout
c)
theme
d)
placeholder
18.
The rule for documents that go to more than one page is __.
a)
You must change the top margin all pages except page 1.
b)
There are no special rules.
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 page and the top of a page. (You cannot split the paragraph among different pages.)
19.
To multiply you use the __ symbol.
a)
X
b)
*
c)
/
d)
( )
20.
Suppose a cell in your worksheet contains this formula: =B$7*.5. How would this formula change if it were copied to another cell?
a)
The column will change but the row will remain fixed at row 7.
b)
The column will remain fixed at column B, but the row will change.
c)
Neither the column nor the row will change.
d)
both the column and the row will change.
21.
Which of these areas would be used to change column width or row height of a table?
a)
Option 1
b)
Option 2
c)
Option 3
22.
Which function type will look at a group of cells with numbers in them and then tell how many there are?
a)
count
b)
autosum
c)
average
d)
min
e)
max
23.
Document _______ are the details about a file.
a)
themes
b)
properties
c)
facts
d)
fields
24.
A ________ is a built-in formula such as autosum.
a)
formula
b)
function
c)
template
d)
range
25.
Which view shows the header/footer on your spreadsheet?
a)
normal view
b)
page break view
c)
print preview
d)
page layout
26.
When a chart is placed in the same sheet as the spreadsheet data, it is said to be __.
a)
inserted
b)
copied
c)
embedded
d)
pasted
e)
moved
27.
If you wanted to search a database to find all people who live in a certain city, you would create a _______.
a)
form
b)
report
c)
query
d)
table
28.
Which of the following is used to name the axis for a 3D chart?
a)
x axis
b)
y axis
c)
legend
d)
z axis
29.
Which of the following is used to name the horizontal axis?
a)
x axis
b)
z axis
c)
y axis
d)
chart title
30.
The _______ is a box with a key to reading the chart.
a)
data markers
b)
axis title
c)
legend
d)
chart title
31.
I have a formula calculating dollars and cents. I want the decimal places in the results to be 2 so that it will calculate to the nearest penny. Which formula would be correct?
a)
=round(b5*c5, 2)
b)
=round(b5*c5, 0)
c)
=rounda(b5*c5, 2)
d)
=rounda(b5*c5, 0)
32.
Which of the following would be used to subtract G5 from G4?
a)
=G5-G4
b)
=G4-G5
c)
-G4-G5
d)
+G5-G4
33.
Which orientation allows you to print the information sideways (paper is 11 x 8.5)?
a)
landscape
b)
print preview
c)
page layout
d)
portrait
34.
Which cell reference type will change the row number or column letter when the formula is copied?
a)
relative
b)
function
c)
absolute
d)
autosum
35.
Which button is used to select data for a chart when the data to plot is not right next to each other? (Example: you need to select row 2 and row 4--how do you select it without highlighting row 3 too?
a)
control
b)
tab
c)
alt
d)
shift
36.
Look at the picture and tell which type of indentation is being used.
a)
half-inch
b)
block
c)
hanging
d)
justified
37.
You own a retail store and you have a great deal of inventory to keep track of. You have to update the file every time you purchase more or sell some of an item. Periodically, you also need to prepare nice looking reports for each inventory item. Which is the best application to use for this purpose and why?
a)
Use 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-Access so that you can keep your records current and print professionally-looking reports for various items in inventory.
c)
Use MS-Excel so you can update the list and filter it to search for the item and then print the data related to just that one item.
38.
Your friend is in design view for a table in Access. He is trying to add records to his table, but it won't allow that. What does you friend need to do?
a)
switch to datasheet view
b)
switch to table view
c)
You can't do this in Access. He/She needs to use Excel.
d)
save, exit, and reopen Access
39.
When a colon is used in a formula, the colon means __. Example: =Sum(A9:A15)
a)
to include all cells in between
b)
to disregard the cells in between the two cells listed
c)
to disregard the two cells listed and only use the ones in between.
40.
A group of worksheets combined into one file is known as a __.
a)
range
b)
mode indicator
c)
sheet tabs
d)
workbook
41.
Which function is used to find the highest number in a range of cells?
a)
highest
b)
min
c)
count
d)
max
42.
Which tab appears only when a chart is selected?
a)
Review
b)
Insert
c)
Page Layout
d)
Chart Design
43.
How do you make MS-Word count and number the pages of a report?
a)
choose different odd & even pages
b)
just type the page number you want
c)
use the page number feature in the header
44.
____ seeking assumes you can change the value of only one cell referenced directly or indirectly to reach a specific goal for another cell.
a)
Formula
b)
Option
c)
Function
d)
Goal
45.
The ____ function is useful when you want to assign a value to a cell based on a logical test.
a)
OR
b)
NOW
c)
IF
d)
AND
46.
__ view allows you to look at several slides at one time.
a)
Reading
b)
Review Sorter
c)
Slide show
d)
Slide Sorter
47.
Using Access data and MS-Word together allows you to create a(n) __.
a)
report
b)
embedded database
c)
web page
d)
mail merge
48.
I have created a spreadsheet and entered a formula, but the program is showing the math problem and not the answer. What did I do wrong?
a)
forgot to hit enter after entering formula
b)
used the wrong cell reference type
c)
forgot = sign in front of the formula
49.
Which chart type is used to compare values and is the default chart type in Excel?
a)
area
b)
combination
c)
pie
d)
column
e)
line
50.
You have two tables that contain data about the same category. Which application is the best to use for this and why?
a)
Use MS-Excel because you can have the information in a table and then put each table on a separate worksheet.
b)
Use MS-PowerPoint so that you can have a different slide with different tables on each.
c)
Use MS-Access so that you can build a relationship between the two tables that have a common data item.
51.
You are keeping track of runners and their time to run the mile. They run it each day and you enter their time. Now you want to put it on a graph. Which graph type would be best?
a)
pie
b)
column
c)
line
d)
bar
52.
In order to be able to move an image around in a Word document, you must change the __.
a)
tabs
b)
margins
c)
columns
d)
text wrap
53.
Look at the newsletter below and tell which type of text alignment is being used.
a)
right
b)
left
c)
center
d)
justify
54.
The function used to count how many words are in a range of cells is the __.
a)
count
b)
round
c)
max
d)
counta
e)
min
55.
You have a data item asks for "Department" that an employee works in. There are a limited number of choices including: Accounting, Marketing, Human Resources, and Sales. You want the user to be able to choose from a list with only these choices. What is the best application to do this?
a)
Word
b)
PowerPoint
c)
Access
d)
Excel
56.
Which button do you use to resize a chart object?
a)
tab
b)
+
c)
I beam
d)
↓
57.
When the active cell contains a formula, dragging the fill handle causes Excel to __.
a)
Generate an error message
b)
Copy the value produced by the formula into the destination cells
c)
Copy the formula but keep the cell references exactly the same
d)
Copy the formula and change the cell references relative to each destination
58.
I have a formula entered. I want to change the row reference in one of the cells when the formula is copied. I do not want to change the column reference. I entered it as C$14. This is known as a __ reference.
a)
function
b)
absolute
c)
relative
d)
mixed
59.
Which chart type is used to show parts of a whole?
a)
column
b)
line
c)
bar
d)
area
e)
pie
60.
The faded FBLA logo in the background of this page was created using __.
a)
Clip art
b)
WordArt
c)
a watermark
d)
SmartArt
61.
To change the increments on a chart, you have to change the __.
a)
major unit
b)
tick marks
c)
legend
d)
minor unit
62.
You have data on three different divisions of your company and what their sales are. You want to compare the amount of sales for each division and how it relates to the total company's sales. Which chart type would be best?
a)
pie
b)
column
c)
scatter
d)
line
63.
The ƒx button next to the formula bar is used to enter a __.
a)
complex formula
b)
min
c)
autosum
d)
function
e)
average
64.
Which chart type plots individual points and charts data over time?
a)
bar
b)
pie
c)
column
d)
line
65.
Excel features built-in, pre-programmed formulas called __.
a)
Wizards
b)
functions
c)
exponentiations
d)
operators
66.
__ allow you to control how objects enter, move on and exit slides.
a)
visual effects
b)
animation effects
c)
audio effects
d)
playback effects
67.
Which cell reference type uses $ signs?
a)
absolute
b)
relative
c)
function
d)
autosum
68.
You entered a formula in Excel but instead of getting the answer to the equation, it just shows the formula you typed. What is wrong?
a)
You forgot the symbol in front of the formula
b)
One of the cells you referenced in the formula has a word instead of a number in it.
c)
The formula has an error.
d)
One of the cells you referenced in the formula is blank
69.
Which application would be best suited for a car dealership who is wanting to present a new marketing strategy and train salespeople on the new sales procedure?
a)
PowerPoint
b)
Excel
c)
Access
d)
Word
70.
Which of the following would best be completed using MS-Word?
a)
calculating net sales
b)
writing a letter of complaint to a restaurant manager
c)
tracking weight loss
d)
creating a table with data that can be sorted and searched
71.
You are keeping track of a fundraiser for a school club. You have data showing the two types of items sold. You want to compare which item type had the best sales. Which type of chart would be best?
a)
column
b)
pie
c)
scatter
d)
line
72.
__ includes special visual and sound effects applied to text or other content.
a)
Audio Control
b)
Playback control
c)
Animation
d)
Visual effects
73.
When creating a multi-level list such as an outline, if you want to promote a level, what button do you use? (I want the next item in the list to be number 2.)
Example:
a)
press Shift+Tab
b)
just type a 2
c)
use a numbered list
d)
press tab
74.
Which file name is valid?
a)
press Research Notes*2015*02*08
b)
Resume_CISposition
c)
Cover/Letter/1
d)
Chapter 7. Assignment: 1
75.
Low saturation produces vivid colors.
a)
True
b)
False
76.
The person who created this used __ to get the text to go around the picture.
a)
multilevel list
b)
drop cap
c)
text wrap
d)
format painter
77.
If you were editing a database for others to use and you needed a simple way for the users to add records to it, you would create a __.
a)
table
b)
form
c)
report
d)
query
78.
A(n) ____ chart provides a simple way to show trends and variations in a range of data within a single cell.
a)
exploding pie chart
b)
line
c)
sparkline
d)
section
e)
clustered column chart
79.
MS-Access would best be suited for which of the following tasks?
a)
creating a flyer for a sales promotion
b)
keeping track of inventory: cars sold and purchased, options on each car
c)
report calculating commissions for sales people
d)
creating a letter to send to all of our recent customers
80.
Which of the following formulas will add b3 and b4 and then divide the answer by 2.
a)
b4/2+b3
b)
=b3+(b4/2)
c)
=(b3+b4)/2
d)
=b3+b4/2
81.
Which application allows you to use forms to enter and edit data?
a)
Access
b)
Excel
c)
Word
d)
PowerPoint
82.
Which of the following buttons would be used to create an outline with multiple levels?
a)
Option 1
b)
Option 2
c)
Option 3
83.
In a multilevel bulleted list slide, creating a lower-level paragraph is called ____ the text.
a)
promoting
b)
demoting
c)
increasing
d)
decreasing
84.
To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
a)
SQL
b)
Open
c)
Query Window
d)
Design View
85.
The __ allows you to customize the Office applications for your own use and make you more efficient. Add buttons that you will use often.
a)
Quick Access Toolbar
b)
Title Bar
c)
Navigation Pane
d)
Status Bar
100 %
