Computer final
You should press the SPACEBAR to clear a cell.
False
A(n) __ data type can store a variable amount fo text or combination of text and number where the total number of characters may exceed 255.
Long text
To save the changes to the layout of a table, tap or click the Save button on the ____.
Quick Access Toolbar
To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name.
Rename Field
A unique identifier is also called a primary key.
True
By default, PowerPoint ends a slide show with a black slide.
True
To select a number format, you can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers should appear.
True
Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.
True
A PowerPoint ____ can help you deliver a dynamic, professional-looking message to an audience.
presentation
____ words are words that have a special meaning to Access and cannot be used for the names of fields.
reserved
A field whose data type is ____ can contain any characters.
short text
PowerPoint ____ should reinforce the speaker's message and help the audience retain the information presented.
slides
___ properties are associated with all Microsoft office files and include author, title, and subject.
standard
Excels __ function, which adds all of the numbers in a range of cells, provides a convenient means to calculate a total.
sum
PowerPoint assumes every new slide, except for a blank slide, has ____.
title
____ is/are used to place worksheet, column, and row titles on a worksheet.
to text
An Excel ____ allows data to be summarized and charted easily.
worksheet
A field within the __ data type can store a unique sequential number that access assigns to a record. Access will increment the number by 1 as each new record is added.
AutoNumber
___ are boxes with border that are displayed when you create a new slide.
Placeholder
A(n) ___ contains information about a given person, product, or event.
Record
Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.
True
If each cell in a selected range is adjacent to a row of numbers. Excel assigns the SUM function to each cell when you click the Sum button.
True
Modifying the column widths usually is done last because other formatting changes may affect the size of data in the cells in the column.
True
When Access first creates a database, it automatically creates a table.
True
To undo the most recent change to a table structure, tap or click the ___ button on the Quick Access Toolbar.
Undo
A field within the ___ data type can store a unique sequential number that Access assigns to a record. Access will increment the number by 1 as each new record is added.
AutoNumber
Which of the following is the ribbon path to the cell styles button?
(HOME tab | Styles group)
Excel remembers the last ____ actions you have completed.
100
To define an additional field in Datasheet view, tap or click the ____ column heading.
Click to Add
To compact and repair a database, tap or click the ___ button in the Info gallery in the Backstage view.
Compact and Repair
To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu.
Delete Field
A pie chart with on or more slices offset is referred to as a(n) ____ pie chart.
Exploded
To import data to a table, tap or click the ___ tab on the ribbon.
External Data
The Notes pane is located above the Slide pane and is an area where you can type notes and additional information.
False
When making a presentation to an audience using PowerPoint, you use Notes Page view.
False
When you click the decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.
False
You cannot format an entire column at once.
False
A slideshow is another name for a PowerPoint presentation.
True
In a multilevel bulleted list, a lower -level paragraph is a subset of a higher-level paragraph.
True
Printing handouts is useful for reviewing a presentation.
True
A field with the ____ data type can contain an attached file, such as an image, document, chart, or spreadsheet.
attachment
The ___ function sums the numbers in the specified range and then divides the sum by the number of cells with numeric values in the range.
average
When you assign a(n) ____ to a field, Access will display the value you assign, rather than the field name, in datasheets and in forms.
caption
To enter data in a cell, you must first select the ____.
cell
The / arithmetic operator indicates ____
division
An accompanying ____ gives audience members reference notes and review material for your presentation.
handout
Which of the following keys moves the insertion point to the beginning of data in a cell?
home
A field whose data type is ____ can store text that can be used as a hyperlink address.
hyperlink
A _____ specifies the arrangement of placeholders on slide.
layout
The active cell reference appears in the ____________________ on the left side of the formula bar.
name box
The default PowerPoint view is ____ view.
normal
In a(n) ___ database such as those maintained by Access, a database consists of a collection of tables, each of which contains information on a specific subject.
relational
A ____ reference is an adjusted cell reference in a copied and pasted formula.
relative
The most common error when entering a formula is to reference the wrong cell in the formula.
True
The ____ is a blinking vertical line that indicates where the next typed character will appear.
insertion point
By default, slides in a new presentation are in ____ orientation.
landscape
All of the following are valid Excel arithmetic operators EXCEPT____.
>
Which of the following happens when you enter the formula =G15 into a cell?
Excel assigns the value in cell G15 to the active cell
Which of the following keys can you press to run a slide show starting with slide 1?
F5
An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.
False
Best fit means that the width of the column will be increased or decreased by a percentage you specify.
False
Fields that contain numbers but will not be used for arithmetic operations usually are assigned a data type of Memo.
False
In Access, the columns in a table are called records.
False
In data sheet view, a table is represented as a collection of rows and columns called a list.
False
Unlike clip art, you cannot resize a photograph using sizing handles.
False
To change the design of a query, press and hold or right-click the query in the Navigation Pane and then tap or click ____ on the shortcut menu.
Design View
What effect does the Comma Style format have in the selected cells?
Displays cell contents with two decimal places and commas as thousands separators
What effect does the Accounting Number Format have on the selected cells?
Displays cell contents with two decimal places that align vertically
A __ is a specific design with coordinating colors, fonts, and graphical effects.
Document theme
The ____ is a small square in the lower-right corner of the active cell or active range.
Fill handle
You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
Format
PowerPoint displays smart ___ automatically when a picture, shape, or other object is moved and is close to lining up with another slide element.
Guides
To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu.
Insert Field
The ___ function displays the highest value in a range.
Max
When you ___ cells, you combine multiple adjacent cells into one larger cell.
Merging
To add a record to a table, tap or click the ____ record button.
New (blank)
When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ____ that you use in algebra.
Operations
When you add a new slide following the title slide, PowerPoint uses the ____ slide layout for the new slide.
Title and Content
A level is a position within a structure, such as an outline, that indicates the magnitude of importance.
True
A paragraph is a segment of text with the same format that begins when you press the ENTER key and ends when you press the ENTER key again.
True
A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.
True
With Excel in Edit mode, you can edit cell contents directly in the cell.
True
You can advance slides during a slide show by pressing the PAGE DOWN key.
True
____ a slide can help you see slide elements more clearly so that you can position them precisely where desired.
Zooming
Access is a ___.
database management system
The process of sliding or dragging and then dropping a thumbnail in a new location is called ____
drag and drop