NEW
Font size
WorksheetsBIM FINAL
Total questions: 40
Worksheet time: 20mins
The keyboard shortcut for pasting items into a document is which of the following?
Control V
Control S
Control P
Control F
Which of the following is the keyboard shortcut for saving a document?
Control P
Control S
Control W
Control V
The Ribbon is a common app feature that consists of:
Tabs
Groups
Commands
All of the Above
A mouse is considered an output device.
TRUE
FALSE
You should always make your password easy and use the same password for multiple accounts.
True
False
Long Horizontal bar typically located at the bottom of the screen.
Subfolder
Icon
Taskbar
Shortcut menu
Which of the following is a complete set of characters used in text in a specific face, style and
size?
Style
Transitions
Font
Animations
Which of the following is a relative cell reference?
A1
$C1
B$1
$D$2
Which of the following is a temporary storage area where all cut and copied items are stored?
Formula bar
Name box
Clipboard
Workbook
Which group on the Home tab contains the command for changing the fill color of a cell?
File
Font
Alignment
Editing
Joe wants to copy the formatting of cells A1 through C1 in his workbook to use in another location. Which of the following commands should he use?
Cut Painter
Copy Painter
Paste Painter
Format Painter
All formulas must begin with which of the following symbols?
Equals sign (=)
Ampersand (&)
Plus sign (+)
Period (.)
Justin wants to create a formula which adds the values in cells A1 and B1 together and then multiplies the sum by 10. Which of the following formulas should he enter?
+A1+B1*10
.A1+B1*10
=(A1+B1)*10
&(A1+B1)*10
Which of the following types of cell references should you use if you want the cell references in the formula to change to reflect the position of its copied location relative to its original location?
Absolute
Mixed
Relative
Stationary
José notices cell A5 of his worksheet contains the railroad tracks (#####) formula error. What should he do?
Delete the formula and just enter the value he wants in the cell
Resize the cell to fit the contents
Clear the formatting on the cell
Filter the cell
Which of the following adds the values in cells A1 through A10?
=SUM(A1:A10)
=SUM(A1,A10)
=SUM(A1!A10)
=SUM(A1A10)
Alex wants to find the highest value in a range of cells. Which of the following functions should he use?
=MIN( )
=AVERAGE( )
=MAX( )
=MEDIAN( )
Alex wants to find the lowest value in a range of cells. Which of the following functions should he use?
=MIN( )
=Max( )
=AVERAGE( )
=MEDIAN( )
Which of the following is a type of equation which returns a value such as TRUE or FALSE?
Argument
Expression
Nest
Control
ability to scroll through multiple spreadsheets at the same time
Keyboard Shortcuts
File Type
Synchronous Scrolling
File Extension
Which of the following tabs on the Ribbon contains the commands to import data
from an Excel spreadsheet?
Home
Create
Database Tools
External Data
Which of the following groups contains the command to import a report from an
Access database?
Import & Link
Export
Create
Design
Which of the following is NOT an option when importing data?
removing the data from the original source
Importing the source data into a new table
Appending a copy of the records to an existing table
Linking to the data source by creating a linked table
Which of the following is specified during the Import Spreadsheet Wizard
process?
Font for the data text
Gridline location in the table
Field properties
Tables, queries, forms and reports from other Microsoft® Access databases can
be imported into another database.
True
False
Microsoft® Access manages which the following types of files?
Presentations
Texts
Databases
Images
Which of the following tabs on the Ribbon holds the command for developing
queries and tables?
Home
External Data
Create
Database Tools
Which of the following is a single piece of information related to the person, place,
object, event or idea it describes?
Field
Table
Database
Record
Which of the following is a field whose value uniquely identifies each record in a
table?
Main key
Primary key
Element key
Value key
Which of the following is NOT correct concerning database design?
Identify all fields needed to produce the required information
Organize each piece of data into its largest useful part
Group related fields into tables
Determine each table’s primary key
Which of the following displays only records matching certain criteria?
Sort
Filter
Form
Conditional Formatting
Which of the following icons in the Sort and Filter group, when clicked, opens a
menu which holds the command to Filter by Form?
Filter
Selection
Advanced
Refresh
To save filter results as a query, which of the following must occur?
A report must be created based on the data
Filter criteria must be identified in the Filter by Form screen
Filter criteria must be identified in a query
A form must have been made for data entry
Sara would like to arrange the records of her table alphabetically by last name.
Which of the following should she apply?
Descending sort
Ascending sort
Filter by selection
Filter by multiple values
Which of the following groups on the Home tab contain the commands for finding
and replacing data?
Find
Views
Sort & Filter
Records
Which of the following sections in Backstage View contains the command to view
database properties?
Info
New
Open
Save As
Which of the following is NOT a reason to back up a database?
Help prevent data loss
Restore an entire database
Restore a database object
Decrease file size
Which of the following sections in Backstage View contains the command to back
up a database?
Info
New
Open
Save As
Shelby would like to remove unused space in her database. Which of the following
should she do?
Edit database properties
Compact and repair the database
Delete all filters in the database
Delete all macros in the database
Which of the following sections in Backstage View contains the command to
compact and repair a database?
Info
New
Open
Save As
