NEW
Font size
S
M
L
XL
WorksheetsExcel/Access 1
Total questions: 33
Worksheet time: 36mins
Name
Class
Date
1.
What type of database contains multiple collections of data that are related to one another?
a)
Joined
b)
Relational
c)
Flat
d)
Managed
2.
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
a)
Exit
b)
Open
c)
Save
d)
Save As
3.
Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the:
a)
Cell
b)
Column
c)
Range
d)
Row
4.
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
a)
Quick Access Toolbar
b)
Title bar
c)
Status bar
d)
Formula bar
5.
What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key?
a)
Quick Access Toolbar
b)
Hot keys
c)
Mini toolbar
d)
Key tips
6.
Which command do you use to close an open file and completely exit the Microsoft Excel program?
a)
Close
b)
Save As
c)
Exit
d)
Quit
7.
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet?
a)
Ctrl + Home
b)
Ctrl + End
c)
Ctrl + Up Arrow
Ctrl + 1
Ctrl + 1
8.
Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table?
a)
Entry
b)
Workbook
c)
Row
d)
Column
9.
Which tab do you use to display the area that contains the print command?
a)
Home
b)
Page Layout
c)
View
d)
File
10.
What occurs when the cursor is moved over a cell and a user clicks?
a)
The row is selected
b)
The cell is selected
c)
The column is selected
d)
The worksheet is selected
11.
Which area appears on the left side of Microsoft Access windows and displays a list of objects available in the database?
a)
Objects pane
b)
Database pane
c)
Navigation pane
d)
List pane
12.
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
13.
Which of the following notebook- like features organizes the sheets for use in Excel?
a)
Workbook
b)
Worksheet
c)
Notepad
d)
Folder
14.
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?
a)
Workbook views
b)
Show
c)
Zoom
d)
Window
15.
Which ribbon option opens a related dialog box?
a)
Ellipse
b)
Drop down arrow
c)
Launcher
d)
Slider
16.
What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility?
a)
Magnify area
b)
Enlarge selected area
c)
Amplify range
d)
Zoom to selection
17.
Which view is the default view used in Microsoft Excel?
a)
Page layout
b)
Print
c)
Normal
d)
Web
18.
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
a)
Workbook
b)
Worksheet
c)
Notepad
d)
Folder
19.
Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
a)
Cell box
b)
Address box
c)
Name box
d)
Formula box
20.
Individual entries in the FBLA address book would be entered into a:
a)
cells
b)
databases
c)
fields
d)
records
21.
What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
a)
Zoom to selection
b)
New window
c)
Arrange all
d)
Freeze panes
22.
Curt needs to finish a database project from yesterday. What action should he take in order to start working on the database?
a)
Close
b)
Create new
c)
Open from existing
d)
Save as
23.
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
a)
Page layout
b)
Print
c)
Normal
d)
Web
24.
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?
a)
Entry
b)
Workbook
c)
Row
d)
Column
25.
An address book containing all FBLA members would be an example of a:
a)
cells
b)
databases
c)
fields
d)
records
26.
Juan needs to view and access all parts of his database. Where can these objects be located most efficiently?
a)
Design view
b)
Form view
c)
Layout view
d)
Navigation view
27.
Which type of database consists of a collection of tables, each of which contains information on a specific subject?
a)
Relational
b)
Interactive
c)
Collaborative
d)
Independent
28.
You have been asked to develop an address book for the FBLA members. Last name and first name would be examples of:
a)
cells
b)
databases
c)
fields
d)
records
29.
Which software program is used to create a database on a computer, add, change, and delete data in the database, and create queries, forms, and reports using the data in the database?
a)
Microsoft Access
b)
Microsoft Excel
c)
Microsoft One Note
d)
Microsoft Outlook
30.
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
a)
Freeze panes
b)
Split
c)
Hide
d)
Unhide
31.
Which term refers to storing the same field in more than one location in a database?
a)
Redundancy
b)
Repetition
c)
Replication
d)
Recurrence
32.
When a database is created, what is defined when names and data types are assigned to all data fields in a table?
a)
Structure
b)
Definition
c)
Design
d)
Theme
33.
When saving a Microsoft Access database as another file type, which ribbon contains an area of centralized tasks that are related to file management known as the backstage?
a)
Home ribbon
b)
File tab
c)
External data ribbon
d)
Database tools ribbon
Reset
