CIS 050 Microcomputer Applications SIMnet
To find records that meet more than one condition in the same field, enter both criteria separated by the word _______ in the Criteria row.
And
A(n) _______ field can include images, Word documents, or almost any other type of data file.
Attachment
Which of the following removes text to the left of the cursor?
Backspace
Which of the following functions counts the number of cells that are not blank within a specified range of cells.
COUNTA
What is the keyboard shortcut for inserting a hard page break?
Ctrl+Enter
Use _______, the keyboard shortcut, to paste text or objects into a Word document.
Ctrl+V
Tables open in _______ where you can enter, sort, and filter data.
Datasheet view
The _______ property allows you to add a preset value to a field.
Default Value
Which of the following removes text to the right of the cursor?
Delete
Select _______ to resize all the rows in a table so they have the same height.
Distribute Rows
Pressing _______ on the keyboard after entering text will move the cursor down one cell.
Enter
The _______ allows you to select any color from your screen and apply it to an object.
Eyedropper
In Design view, the bottom pane is the _______ pane which displays details about the selected field.
Field Properties
The Animation Painter works similarly to the _______.
Format Painter
If your worksheet has both a header row and a column of labels in the first column use the _______ option to freeze the worksheet at the selected cell, so the rows above the cell and the columns to the left of the cell are always visible.
Freeze Panes
The _______ logical function returns one value if a condition is true and another value if the condition is false.
IF
The _______ property ensures that users enter data in a particular format. For example, a field for social security numbers can force users to enter numbers in the format 123-45-6789.
Input Mask
To add a sound to your presentation, click the _______ button on the Insert tab.
Insert Audio
To add a video to your presentation, click the _______ button on the Insert tab.
Insert Video
_______ alignment evenly spaces the words, aligning the text on the right and left sides of the printed page.
Justified
Forms and Reports also offer _______ where you can modify some (but not all) structural elements.
Layout view
_______ is the white space between lines of text.
Line spacing
_______ cells entails combining multiple cells into one.
Merging
All of the database objects are organized in the _______ Pane, which is docked at the left side of the screen.
Navigation
To remove an animation, on the Animations tab, in the Animations group, click the _______ option in the gallery.
None
The _______ option will print a copy of the slide with its associated note, if there is one.
Notes Pages
_______ converts the text string so that the first letter in each word is capitalized.
PROPER
PowerPoint's _______ feature allows you to copy and package all the elements of your presentation to a folder.
Package for CD
One method to open the Insert Picture dialog is for you to click the _______ icon in the content placeholder.
Pictures
If you want to include a field in your query, but do not want that field to show in Datasheet view, click the _______ box to remove the checkmark for the field you want to hide.
Show
To display formatting marks in a document, click the _______ button.
Show/Hide
To hide slides, click the Hide Slide button on the _______ tab of the Ribbon.
Slide Show
_______ view displays thumbnail pictures of the slides in your presentation and is useful in rearranging the order of slides in a presentation.
Slide Sorter
Clicking a thumbnail in the Thumbnails pane will make that slide appear in the _______.
Slide pane
A _______ form combines the convenience of a continuous Datasheet form with the usability of a Single Record form displaying one record at a time.
Split
A quick way to insert a new row at the end of a table is to place the cursor in the last cell in the last row and then press the _______ key(s). A new row is automatically added to the table.
Tab
Pressing _______ on the keyboard after entering text will move the cursor to the right one cell.
Tab
The _______ displays thumbnails of all the slides in the presentation.
Thumbnails pane
One way to start a new form is to begin with a blank form and _______ fields from tables and queries manually.
add
Most functions require you to provide input called the _______.
arguments
To change the order of your slides, select a thumbnail and _______ until the slide appears where you want it in the slide order.
click and drag
When you edit a formula, any referenced cells are highlighted in the same _______ as the cell reference in the formula.
color
To print individual pages, type each page number you want to print separated by a _______.
comma or semicolon
The Fill Handle tool is located at the upper left of the selected cell.
false
Each column in a table represents a specific data value called a(n) _______.
field
By applying a(n) ________ to a database object, you display a subset of records that meet your criteria.
filter
A(n) _______ is text that appears at the bottom of every page, just below the bottom margin.
footer
A _______ displays data from an underlying table and allows database users to enter, edit, and delete data in a user-friendly format.
form
A _______ is an equation used to calculate a value.
formula
When you select a cell that contains a formula, the formula bar displays the _______.
formula
A(n) _______ is a printout of your presentation with anywhere from one to nine slides per page and with areas for taking notes.
handout
You can manually force text to a new page by inserting a _______.
hard page break
When you _______ a row or column, the data still remain in your workbook, but they are no longer displayed on-screen and are not part of the printed workbook.
hide
A _______ is text or a graphic that, when clicked, opens another page or file.
hyperlink
You should add transitions to a presentation only where they will _______ your presentation.
improve
When you first add a picture to your document, Word inserts the picture at the _______ point and displays the picture in line with the text.
insertion
What chart element identifies which data point or data series is represented by each color in the chart?
legend
The _______ is the field that contains data unique to that record.
primary key
Each row in a table contains all the data for a single _______.
record
A(n) _______ database is a group of tables related to one another by common fields.
relational
When you add text to placeholders, PowerPoint will automatically _______ the text to fit within the placeholder.
resize
If you want to adjust the width of a column manually, move your mouse over the _______ column boundary and click and drag until the column is the size you want.
right
When you type text in a cell, the text will appear to continue to the __________ as far as it can until there is another cell that contains data.
right
A(n) _______ appears behind selected text.
shaded background
After clicking the New Slide button arrow, you will be asked to select a _______ from the New Slide gallery.
slide layout
When text or graphics have filled a page, Word inserts a _______ and goes on to a new page.
soft page break
The _______ bar appears at the bottom of the Excel window and displays information about the current worksheet.
status
A _____, which is organized by rows and columns, helps you organize information for effective display.
table
When you use a form to enter data, you are actually adding data to the underlying _______.
table
A _____ is a file with predefined settings that you can use as a pattern to create a new presentation of your own.
template
A(n) _______ is a group of formatting options that you apply to a presentation.
theme
As you roll over the list of fonts, the Live Preview feature in Word gives you a preview of how your document text will look with the new font applied.
true
In Excel, you can use the CONCAT function to combine the text values of cells or cell ranges.
true
The _______ feature places text on the next line when the right margin of the page has been reached.
word wrap
Each Excel _______ is made up of rows and columns of data on which you can perform calculations.
worksheet
To enter a formula, the first step after selecting the cell is to enter a(n) _______.
=
To align objects on a slide, select more than one object and then click the _______ button in the Arrange group on the Picture Tools Format tab.
Align
_______ refers to how text and numbers are positioned within the cell both horizontally and vertically.
Alignment