Bim Final
Before you insert an outline into a presentation, you need to determine where you want the new slides to be placed.
. T
A(n) __________________ object provides an easy-to-use data entry screen.
ACESS FORM
The cell in which you are working is called the ____________________ cell
ACTIVE
A(n) ____________________ field automatically assigns a new number each time you add a record.
AUTONUMBER
Clicking the ____________________ button sums the adjacent cell range above or to the left.
AUTOSUM
A(n) ____________________ can be used to insert text or objects such as clip art, tables, or charts.
CONTENT PLACEHOLDER
___________________ View is a spreadsheet-like view of the data in a table.
DATASHEET
. In an electronic spreadsheet, you need to manually recalculate when you change the entries
F
A(n) Entrance animation causes an object visible on the slide to have an effect.
F
Charts are updated automatically in Excel whenever data changes
F
The Spell Checker checks the text in inserted pictures or objects.
F
You can create an individual text box by clicking the Data button in the Text group on the INSERT tab of the Ribbon.
F
____________________ is an exception to copyright and permits the public to use copyrighted material for certain purposes without obtaining prior consent from the owner.
FAIR USE
A(n) ____________________ is an equation in a worksheet
FORMULA
Referring to the accompanying figure, the page on the left is showing a(n) ____ page.
HANDOUT
If you use ___________________ View to design your table before starting the data entry process, you will probably avoid some common data entry errors.
LAYOUT
The primary view that is used to write, edit, and design a presentation is ____________________ view.
NORMAL
A(n) ___________________ relationship describes when a record from one table is related to several records in another table.
ONE TO MANY
A(n) ____________________ key field contains unique data for each record.
PRIMARY
24. A(n) __________________ object allows a user to select a subset of data from one or more tables.
QUERY
A named range can begin with a letter or number
T
Every slide in a PowerPoint presentation has a background, the area behind the text and graphics
T
The Entrance and Exit animations cause an object to enter or exit the slide with a(n) effect
T
When you import a Microsoft Word or a Rich Text Format document into a presentation, PowerPoint creates an outline structure based on the styles in the document.
T
A(n) ___________________ is a fundamental building block of a relational database because this object stores all of the data.
TABLE_
The SmartArt text styles and effects include text shadows, reflections, glows, bevels, 3D rotations, and transformations.
__________F_______________
The Excel operator for division is ____.
a. /
. As shown in the accompanying figure, item ____ points to the Name box.
a. 1
In a datasheet, which mode assumes that you are trying to change the value of a particular field?
a. Edit mode
To review a printout of a table before printing, on the ____ tab, click Print, and then click Print Preview.
a. FILE
Which two properties are required for every field?
a. Field Name and Data Type
To open the Insert Picture dialog box, click the ____ tab on the Ribbon and then click the Pictures button in the Images group.
a. INSERT
To begin checking the spelling in your presentation, click the ____ tab on the Ribbon and then click the Spelling button in the Proofing group.
a. REVIEW
____ View provides the most options for defining fields.
a. Table Design
Cells in the first or top row of a chart are ____ names and provide further information about the data.
a. category
. Use ____ colors for slide background and text to make the text readable.
a. contrasting
In the accompanying figure, the entry in cell B4 is a ____.
a. label
Animation tags identify the ____ in which objects are animated during slide show
a. order
In the accompanying figure, the leftmost TourSales is a ____ tab.
a. query
A group of related fields, such as all the demographic information for one customer, is called a(n) ____.
a. record
In the accompanying figure, the rightmost TourSales tab is a ____ tab.
a. report
. As shown in the accompanying figure, item 3 points to the ____.
a. sheet tab
In Excel, a worksheet is contained in a file called a ____.
a. workbook
. As shown in the accompanying figure, item ____ points to the cell pointer, which outlines the active cell.
b. 2
In ____ view, you have the option of saving your presentation to your computer or SkyDrive.
b. Backstage
Which of the following is NOT a data type?
b. Formula
The New Slide button is in the Slides group on the ____ tab.
b. HOME
Which data type stores Web addresses
b. Hyperlink
The pane on the left-hand side in the accompanying figure is the ____ pane.
b. Miniature
The Forms and Reports at the left side of the Access window in the accompanying figure are contained in the ____.
b. Navigation Pane
The ____ button resets slide placeholders to their default position, size, and text formatting.
b. Reset
____ view displays your presentation on the whole computer screen.
b. Slide Show
The accompanying figure shows a PowerPoint presentation in ____ view.
b. Slide Sorter
You can use the ____ slider on the status bar to enlarge your view of specific areas of your worksheet
b. Zoom
Entrance and Exit are ____.
b. animation categories
Which Access object provides an easy-to-use data entry screen?
b. form
In the accompanying figure, the entry in cell B15 is a ____.
b. formula
A(n) ____ is a built-in formula that uses arguments to calculate information.
b. function
Tables, queries, and forms are examples of Access ____.
b. objects
In the accompanying figure, the text "Click to add title" is the title ____.
b. placeholder
Possible paper orientations for printing a worksheet are landscape and ____.
b. portrait
Which of the following is NOT available to you as you start Access?
b. recalibrating an existing database
An electronic ____ is an application you use to perform numeric calculations and to analyze and present numeric data.
b. spreadsheet
In the accompanying figure, the numbers that appear under each of the slides are the ____ timings.
b. transition
In Presenter view, the next slide in the presentation appears in the ____ corner of the screen
b. upper-right
As shown in the accompanying figure, item ____ points to the formula bar.
c. 3
____ operators perform mathematical calculations such as adding and subtracting.
c. Arithmetic
Themes are found on the ____ tab.
c. DESIGN
PowerPoint uses ____ to create numerical charts.
c. Excel
You can preview the look of a design theme before committing to it using ____.
c. Live Preview
The presentation shown in the accompanying figure is in ____ view.
c. Normal
The ____ option helps fit the data on a single page without making changes to individual margins
c. Page Break View
Which is NOT true about Access
c. Reporting is limited to 20 saved reports.
Which data type stores only one of two values?
c. Yes/No
. Doug is looking to make sure that he can prioritize the points on his slides visually. What should he use to do this?
c. bulleted lists
Microsoft Access can best be described as ____ software.
c. database
All Excel formulas begin with the ____.
c. equal sign (=)
A specific category of data such as a customer's name, city, state, or phone number is called a(n) ____.
c. field
In the accompanying figure, CustomerRoster is a ____ tab
c. form
. As shown in the accompanying figure, item 2 points to the ____.
c. mode indicator
On the Ribbon, each set of primary commands is identified by a(n) ____.
c. tab
In the accompanying figure, Customers is a ____ tab.
c. table
Which Access object contains all of the raw data within the database
c. table
. What is the smallest font size Doug should use in the text on his slides?
d. 30 points
Excel recognizes an entry as a value if it is a number or it begins with ____.
d. All of the above.
With PowerPoint, you can import text, photographs, numerical data, and facts from files created in such programs as ____.
d. All of the above.
As shown in the accompanying figure, item 4 points to the ____.
d. New sheet button
Based on the chart in the accompanying figure, what data marker represents the smallest data point?
d. Quarter 1 - India
The ____ is fully customizable
d. Quick Access toolbar
The ____ organizes all of PowerPoint's primary commands.
d. Ribbon
____ below the worksheet grid let you switch from sheet to sheet in a workbook.
d. Sheet tabs
Which of the following keys will help you delete unwanted data in Edit mode?
d. [Backspace]
The Excel operator for exponent is ____.
d. ^
A content placeholder can be used to insert all of the following EXCEPT ____.
d. apps
Which is NOT a feature of Access reports?
d. easy-to-use data entry screen
In the accompanying figure, what chart item explains which color represents each quarter?
d. legend
. As shown in the accompanying figure, item 1 points to the ____.
d. sheet tab scrolling button
It is a good idea to limit each slide to six words per line and ____ lines per slid.
d. six
In the accompanying figure, the entry in cell B5 is a ____.
d. value
In Excel, the electronic spreadsheet you work in is called a ____.
d. worksheet