Font size
S
M
L
XL
WorksheetsExcel/Access EOC Review
Total questions: 100
Worksheet time: 56mins
Name
Class
Date
1.
What is an active cell?
a)
The first cell in a database.
b)
The cell currently selected.
c)
The cell that all the data goes to.
d)
The cell that you typed in last.
2.
A bar graph compares multiple values.
a)
True
b)
False
3.
When you create a graph, you...
a)
select all the data.
b)
select what you want to affect.
c)
select the first cell only.
d)
select the entire spreadsheet.
4.
What allows one to enter numbers to be calculated?
a)
cells
b)
formulas
c)
functions
d)
active cells
5.
Where do you configure the field properties of a Table?
a)
Design View
b)
Datasheet View
c)
Access View
d)
Window View
6.
Where do you see the results of a Query?
a)
Query Design View
b)
Query Datasheet View
c)
Query DataSet Review
d)
Table Design View
7.
You want to enter a series of dates down a column. What would be the best tool for the job?
a)
Cut and Paste
b)
Spelling Checker
c)
Autofill
d)
Find and Replace
8.
What term refers to mathematical equations used in Excel to perform calculations?
a)
Formal
b)
Cell
c)
Formulas
d)
Summations
9.
What symbol is used to designate an absolute cell reference?
a)
#
b)
!
c)
$
d)
@
10.
In Excel, all formulas must begin with what symbol?
a)
!
b)
#
c)
$
d)
=
11.
What function can be used to find the largest number in a range of numbers?
a)
=MIN
b)
=MAX
c)
=AVERAGE
d)
=SUM
12.
Which ribbon would you go to in order to change the width and the height of a cell?
a)
Page Layout Tab
b)
Page Setup
c)
Scale to Fit
d)
Sheet Options
13.
Portrait and Landscape are two types of what?
a)
Arrangements
b)
Orientation
c)
Margins
d)
Page Breakas
14.
Are you able to print from Page Layout View?
a)
Yes
b)
No
15.
Which of the following is an example of how a business would use a spreadsheet?
a)
Payroll
b)
calculating student grades
c)
household budgets
16.
Cell is a individual location on a spreadsheet
a)
True
b)
False
17.
The part of a speadsheet identified by letters of the alphabet (vertical):
a)
cell
b)
column
c)
row
18.
The part of a spreadsheet identified by numbers (horizontal)
a)
cell
b)
column
c)
row
19.
An example of a cell address is:
a)
4A
b)
A4
c)
A16:A29
20.
The math operatiors for multiplication and division are:
a)
+ and -
b)
/ and *
c)
* and /
21.
When two or more cells must be combined use:
a)
merge
b)
wrap text
c)
default alignment
22.
Which of the following might appear in the spreadsheet's header or footer?
a)
Title of company
b)
=(A2:A10)
c)
graph
23.
Left, right, or center ____________is also used to format cell data.
a)
Justification
b)
function
c)
collection
24.
In the days before computers data was stored ____________.
a)
in cabinets
b)
in files
c)
on paper
d)
in warehouses
25.
What was the major disadvantage of storing data on paper?
a)
papers could get lost
b)
papers always had errors
c)
it was expensive to store information on paper
d)
it was time consuming to sort through
26.
Tables are used to ____________.
a)
organize data
b)
store data
c)
print out data
d)
display data on the screen
27.
Queries are used to ____________.
a)
organize data
b)
store data
c)
print out data
d)
display data on the screen
28.
Forms are used to _____________.
a)
organize data
b)
store data
c)
print out data
d)
display data on the screen
29.
Reports are used to _____________.
a)
organize data
b)
display data on the screen
c)
print out data
d)
store data
30.
What is the cell in the worksheet in which you can type data?
a)
Main Cell
b)
Open Cell
c)
Active Cell
d)
Absolute Cell
31.
=A1+5
a)
Formula
b)
Function
32.
=Sum(A5:A10)
a)
Formula
b)
Function
33.
Which of the following lists is in ascending order?
a)
5 6 8 9 7 8 4 3 1 45
b)
1 5 10 15 10 5 1
c)
e g b d f
d)
1 2 3 4 5 6 7 8 9 10 11
34.
$B$1
a)
Absolute Cell Reference
b)
Mixed Cell Reference
35.
B$1
a)
Mixed Cell Reference
b)
Absolute Cell Reference
36.
What is the tool used to keep a range of selected rows or columns visible as the rest of the worksheet scrolls?
a)
Freeze Pane
b)
Peek-a-book
c)
Show/Hide
d)
Reveal Cells
37.
This option allows you to determine when excel calculates the formulas in a worksheet.
a)
Alt Equals
b)
Calculate freeze
c)
Manual Calculation
d)
Manly Calculation
38.
Displaying a subset of data that meets certain criteria and temporarily hiding data that does not meet that criteria.
a)
Sort
b)
Find
c)
Filter
d)
Fill
39.
A group of selected cells.
a)
Actives Cell
b)
Range
c)
Row
d)
Field
40.
____________ is the process of finding and correcting errors in a worksheet.
a)
Debugging
b)
Fixing
c)
Checking
d)
Editing
41.
When Excel automatically sets the width of a column based on the widest entry in the column, it is called ____________.
a)
custom fit
b)
choice fit
c)
best fit
d)
don't fit
42.
The AVERAGE function sums the numbers in the specified range and then divides the sum by the number cells with numeric values in the range.
a)
True
b)
False
43.
Correct or incorrect formula?
avg=(A1:A9)
avg=(A1:A9)
a)
Correct
b)
Incorrect
44.
Text in Excel is automatically aligned ____.
a)
Right
b)
Left
c)
Center
d)
Justify
45.
Numbers in Excel is automatically aligned ____.
a)
Right
b)
Left
c)
Center
d)
Justify
46.
Which of the following is a type of chart?
a)
Pie
b)
Column
c)
Line
d)
All are charts
47.
John would lilke to change the order of the worksheets in his workbook. Which option would he choose?
a)
Insert
b)
Delete
c)
Copy
d)
Move
48.
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next text?
a)
Average
b)
Max
c)
Min
d)
Sum
49.
What function adds all of the numbers in a range of cells?
a)
Calculate
b)
Sum
c)
Compute
d)
Add
50.
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1?
a)
COUNT
b)
IF
c)
NOW
d)
TODAY
51.
John's workbooks includes 3 workbooks. Which option should he choose to print them?
a)
Print Selection
b)
Print active sheet
c)
Print entire workboo
d)
Fit to one page
52.
Details about a file
a)
word properties
b)
database properties
c)
microsoft properties
d)
data properties
53.
Software that allows you to use a computer to create a database
a)
database management system
b)
software applications
54.
Data type where the field can contain any character is "_____".
a)
text
b)
autonumber
c)
currency
d)
decimal
55.
Way of uniquely identifying each record in the database known as "_____" identifier.
a)
unique
b)
young
c)
field
d)
none of the choices
56.
Which toolbar contains most of the commands that you'll need in Excel 2013?
a)
Menu bar
b)
Ribbon
c)
Title Bar
d)
Format Bar
57.
A predesigned workbook you can use to create a new project quickly is called a(n) ________.
a)
cookie cutter
b)
template
c)
autofill
d)
menu
58.
If you want to display a date in a certain way (such as Wednesday, March 25, 2015), you can adjust the ________.
a)
Number Format
b)
autofill
c)
font
d)
cell color
59.
What is the file extension for an Excel file?
a)
.jpg
b)
.excl
c)
.doc
d)
.xlsx
60.
What can Excel NOT do?
a)
calculate
b)
use words and numbers
c)
show videos
d)
show pictures
61.
Which of the following are NOT found in the Excel program?
a)
animations
b)
columns
c)
formulas
d)
cells
62.
What does Excel use to make calculations?
a)
words
b)
formulas
c)
formatting
d)
pictures
63.
Which button will add a column of numbers?
a)
merge and center
b)
Esc
c)
Autosum
d)
Ctrl
64.
What is the name of this cell?
a)
B10
b)
5B
c)
B5
d)
you cannot know the name from this picture
65.
Which of the following is a correctly written Excel FORMULA?
a)
B3+G4=H5
b)
34*6=
c)
=B3+G4
d)
(G2*Monday!=
66.
Group that allows a user to create names for cells to use in a formula
a)
Name Box
b)
Defined Names
c)
Dialog Box
d)
Name Manager
67.
Where can you find the insert function button in Excel?
a)
Formulas Dialog Box
b)
View Tab
c)
Status Bar
d)
Formulas Bar
68.
Command that reduces the margin between the border and text in an indented cell
a)
Decrease Indent
b)
Increase Indent
c)
Increase Margin
d)
Decrease Margin
69.
Columns in the table
a)
field columns
b)
fields
c)
columns
d)
none of the answers
70.
Details about a file
a)
word properties
b)
database properties
c)
microsoft properties
d)
data properties
71.
If you want to put your data into alphabetical order by last name, you could use the __________ command.
a)
Shift
b)
Font
c)
autofill
d)
Sort
72.
Which function should be used to calculate the smallest number in a range of cells?
a)
max
b)
sum
c)
avg
d)
min
73.
Which type of reference changes as the formula is copied?
a)
cell reference
b)
relative
c)
absolute
d)
mixed
74.
What is a function?
a)
sum
b)
average
c)
minimum and maximum
d)
all the choices
75.
What is a value?
a)
data that has the potential to be used in calculations
b)
data that has the potential to be used in paragraphs
c)
data that has the potential to be used in a mailing list
d)
data that has the potential to be used in formulas
76.
If you see "####" in a cell, what does that mean?
a)
Formula Error
b)
Function Error
c)
The column is too narrow
d)
Formatting error
77.
To outline the cell range, what formatting style could you select?
a)
Shading
b)
Fill Color
c)
Gridlines
d)
Borders
78.
If you delete a database table,
a)
you cannot undo the action.
b)
click Undo to restore the table.
c)
it is still available in the Navigation Pane.
d)
the data is transferred to the Clipboard.
79.
To rename a table or other database object, first
a)
save it.
b)
close it.
c)
edit it.
d)
open it.
80.
A complete list of field properties is available in
a)
the Navigation Pane.
b)
Datasheet view.
c)
Design view.
d)
all of the above.
81.
Which field property requires users to enter data in a specific format?
a)
Validation Text
b)
Default Value
c)
Required
d)
Input Mask
82.
The Default Value property can be used for which field?
a)
Short Text
b)
Number
c)
Currency
d)
All of the above
83.
Which function will result in the total number of entries in the cell range B5 to B14?
a)
Count
b)
Max
c)
MIn
d)
Sum
84.
In Access, a template is
a)
a database to manage contacts.
b)
where a database is stored.
c)
two tables linked together.
d)
a ready-to-use database.
85.
When you create a new blank database, Access opens a database that contains
a)
one of each type of database object.
b)
a table.
c)
sample data.
d)
a template.
86.
To save a database file in a location other than the default, click the
a)
folder icon.
b)
blank database icon.
c)
file name button.
d)
Help button.
87.
The table structure is created when you
a)
format the data.
b)
enter data.
c)
query the data.
d)
create forms.
88.
After you have created a table or other database object, you should
a)
save it with a descriptive name.
b)
copy it to create a backup.
c)
link it to an external data source.
d)
insert a blank column at the end.
89.
When you quit the program, Access automatically
a)
creates a link between all tables.
b)
leaves the Navigation Pane open.
c)
saves the data.
d)
renames the file.
90.
Which of the following notebook-like features organizes the sheets for use in Excel
a)
Workbook
b)
Worksheet
c)
Notepad
d)
Floder
91.
IF, AND, OR and NOT are all part of which category of functions?
a)
Math & Trig
b)
Text
c)
Logical
d)
Lookup & reference
92.
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
a)
Word
b)
Publisher
c)
Excel
d)
PowerPoint
93.
which one of these are not a graph/chart in Excel?
a)
Bar
b)
Combo
c)
column
d)
spline
94.
A unique identifier used in creating a table that assures there will be no duplicate data.
a)
Primary Key
b)
Query
c)
Data Type
d)
Object
95.
Alicia needs to move the data in cell B5 to E5. Which command would she select?
a)
Clear
b)
Copy
c)
Cut
d)
Format Painter
96.
Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?
a)
Hyperlink
b)
Web link
97.
Alicia needs to delete the data in cell B5. Which command would she select?
a)
Clear
b)
Copy
98.
Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the cells in that range that contain 100. What function should he use?
a)
SUMIF
b)
AVERAGEIF
c)
TOTALIF
d)
COUNTIF
99.
Jack would like the data in Row 10 not to display on his spreadsheet. Which option he select?
a)
Freeze
b)
Header
c)
Hide
d)
Scale
100.
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
a)
Form
b)
Boilerplate
c)
Smart Sheet
d)
Template
Reset
