NEW
Font size
S
M
L
XL
WorksheetsExcel/Access 2016
Total questions: 64
Worksheet time: 1hrs 19mins
Name
Class
Date
1.
A reference to a specific cell or range regardless of where the formula is located in the worksheet
a)
Absolute cell reference
b)
Relative cell reference
c)
External reference
d)
Mixed cell reference
2.
A reference that identifies a cell's location in the worksheet based on its row number and column letter
a)
Cell reference
b)
Named range
c)
Operand
d)
Scope
3.
An equation that performs calculations such as addition, subtraction, multiplication, and division on values in a worksheet
a)
Formula
b)
Operand
c)
Scope
d)
Variable
4.
A group or cells and occasionally a single cell with a designated name
a)
Named range
b)
Value
c)
Variable
d)
Operand
5.
The rules Excel follows to calculate any formula that contains two or more operators
a)
Orders or operations
b)
Formulas
c)
Variables
d)
Constants
6.
A cell reference that adjusts the cell identifier automatically if you insert or delete column or row or if you copy the formula to another cell
a)
Relative cell reference
b)
Absolute cell reference
c)
Mixed cell reference
d)
External reference
7.
A number, a cell address, a date, text, or Boolean data in Excel
a)
Value
b)
Variable
c)
Constant
d)
Scope
8.
A formula that calculates the total adjacent cell through the first nonnumeric cell using the SUM function
a)
AutoSum
b)
MAXfunction
c)
SUMfunction
d)
COUNTfunction
9.
A function that calculates the total from the adjacent cell through the first non-numeric cell using SUM function in its formula
a)
AVERAGE function
b)
AutoSum
c)
COUNT function
d)
MIN function
10.
A predefined formula that performs a calculation
a)
Function
b)
AutoSum
c)
Value
d)
Variable
11.
A function that returns the largest values in a set of values
a)
MAX function
b)
AVERAGE function
c)
MIN function
d)
SUM function
12.
Two or more cells combined into a single cell
a)
Merge cells
b)
Variable
c)
Value
d)
AutoSum
13.
A function that determines the minimum value in a range of cells
a)
MIN function
b)
MAX function
c)
SUM function
d)
AVERAGE function
14.
A function that totals all of the cells in a range
a)
SUM function
b)
MIN function
c)
MAX function
d)
AVERAGE function
15.
Arrange in a line or bring into alignment
a)
Align
b)
Wrap
c)
Style
d)
Hyperlink
16.
An Excel feature that enables you to specify how cells that meet one or more given conditions should be displayed
a)
Conditional formatting
b)
Merged cells
c)
Paste special
d)
Rules manager
17.
A set of text properties that affects the typeface, size, and similar aspects of text
a)
Font
b)
Style
c)
Wrap
d)
Attribute
18.
A set of formatting attributes that you can apply to a cell or range of cell more easily than by setting each attribute individually
a)
Style
b)
Attribute
c)
Font
d)
Wrap
19.
To automatically display data on the next line when it is too long to display within the cell's width
a)
Wrap
b)
Align
c)
Style
d)
Attibute
20.
1. Filters can be used on query results
a)
True
b)
False
21.
2. A primary key field from one table appears in a second table. What is the field in the second table called?
a)
A. A linked key
b)
B. A relationship key
c)
C. A foreign key
d)
D. A primary key
22.
3. What is it called when you "ask the database a question"?
a)
Relationship
b)
Query
c)
Data Integrity
d)
Report
23.
4. What is the advantage of reports over queries?
a)
A. Reports can be formatted
b)
B. Reports can access more data
c)
C. Queries can be formatted
24.
5. Queries can only use data from one table at a time.
a)
True
b)
False
25.
6. A primary key field from one table appears in a second table. What can be said about these tables?
a)
A. The tables are subordinated
b)
B. The tables are queried
c)
C. The tables are in a duplication
d)
D. The tables are in a relationship
26.
7. Does Microsoft Access need to be told about relationships between tables?
a)
A. No, relationships are automatically detected
b)
B. No, relationships are not supported
c)
C. Yes, relationships need to be defined
d)
D. Yes, only when the fields have different names
27.
8. Sorting from A-Z is also called a descending sort.
a)
True
b)
False
28.
9. You cannot change the order of fields on a report.
a)
True
b)
False
29.
10. What is it called when you view some records and hide others?
a)
Report
b)
Sort
c)
Search
d)
Filter
30.
11. A query for a report can come from multiple tables.
a)
True
b)
False
31.
12. What is it called when you want to see database records in a certain order?
a)
Search
b)
Filter
c)
Sort
d)
Report
32.
13. Ascending means sorting from:
a)
A. Smallest to largest
b)
B. Largest to smallest
33.
14. Descending means sorting from:
a)
A. Smallest to largest
b)
B. Largest to smallest
34.
15. In the image to the left, where would you click to look for a name in the database?
a)
A
b)
B
c)
C
35.
16. Look at the information in the database table to the left. What field is being used to SORT the table?
a)
Name
b)
Phone
c)
Address
d)
City
36.
True or False: By default, Excel is set to print pages in landscape orientation.
a)
True
b)
False
37.
True or False:The drag-and-drop method is the slowest way to copy or move data short distances in a worksheet.
a)
False
b)
True
38.
True or False: Numbers that do not fit in the cell are shown as a series of question marks (??????).
a)
True
b)
False
39.
True or False:The cell in the worksheet in which you can type data is called the active cell.
a)
True
b)
False
40.
True or False:The contents of the active cell always appear in the Formula Bar.
a)
True
b)
False
41.
Formulas can include more than one operator.
a)
False
b)
True
42.
Each formula begins with a quotation mark (").
a)
False
b)
True
43.
Formulas can include more than one operator.
a)
False
b)
True
44.
True or False: A cell style is a collection of formatting characteristics you apply to a cell or range of data.
a)
False
b)
True
45.
True or false: Data moved or copied to a cell replaces any content already in that cell.
a)
True
b)
False
46.
True or False: Hiding permanently removes a row or column from view.
a)
False
b)
True
47.
True or False: All chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart.
a)
False
b)
True
48.
Where is the command for creating a new table from Table Design view?
a)
File tab
b)
Home Ribbon
c)
Create Ribbon
d)
Database Tools Ribbon
49.
Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. What data type should he use?
a)
Auto Number
b)
Currency
c)
Yes/No
d)
Hyperlink
50.
Johnny has planned his baseball card database and determined a logical arrangement. What is his next step?
a)
Determine what information to include
b)
Discuss the database with users
c)
Gather the information
d)
Input data
51.
Nick wants to design a database and wants Microsoft Access to automatically assign an ID number to each record. What is auto numbering an example of?
a)
Data Type
b)
Description
c)
Field name
d)
Properties
52.
Curt needs to create a backup to his existing database on an external hard drive. What action should he take?
a)
Close
b)
Create New
c)
Open from Existing
d)
Save As
53.
Matt needs to add his contacts to the Driver Education database. To do this quickly, what predefined object can he create?
a)
Application Parts
b)
Quick Start
c)
Sharepoint List
d)
Database Object
54.
What are three valid methods for saving a database in Microsoft Access?
a)
Alt + S, File tab Save command, Quick Access Toolbar Save command
b)
Alt + S, Home Ribbon Save command, Quick Access Save command
c)
Alt + S, File tab Save command, Shortcut Save command
d)
Ctrl + S, File tab Save command, Quick Access Save command
55.
Larry has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1?
a)
COUNT
b)
IF
c)
NOW
d)
TODAY
56.
Which are valid Microsoft Excel functions?
a)
AVERAGE, MAX, and NUM
b)
MAX, MIN, and WEEK
c)
AVERAGE, MAX, and MIN
d)
WEEKDAY, MAX, and CLOSE
57.
Which command on the Home Ribbon can be used to rotate text to a vertical or diagonal angle in a worksheet?
a)
font
b)
orientation
c)
wrap text
d)
merge & center
58.
Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
a)
center
b)
merge & center
c)
orientation
d)
wrap text
59.
SUMIF and SUMIFS are in which category of functions?
a)
Math & Trig
b)
Text
c)
Logical
d)
Lookup & Reference
60.
Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
a)
insert
b)
move
c)
rename
d)
tab coior
61.
Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
a)
align
b)
arrange
c)
group
d)
rotate
62.
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
63.
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
a)
function library
b)
defined names
c)
formula audting
d)
calculation
64.
Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this?
a)
share workbook
b)
protect workbook
c)
track changes
d)
export
Reset
