Microcomputer Applications Final Review
Which of these cell references is an absolute reference? none of these C9 C$9 $C$9
$C$9
Identify the Pv argument in this formula: =PMT(B1/12,B2,-B3)
-B3
The Clipboard can store up to _______ items for use in the current document or any other Office application.
24
Which of the following graphic objects can be rotated along three different axes?
3D models
What would you type in the Pages box on the Print page to print only the fourth and seventh page in a document?
4,7
Which of these tasks can you perform in Backstage view?
All of these
When retrieving a file and you don't see the folder containing the file, click the _________ button.
Browse
Which command would you use to change the text from uppercase to having each word capitalized?
Change Case
You can remove conditional formatting using the ________.
Clear Rules from Selected Cells command
What is the keyboard shortcut for reversing the last action you performed?
Ctrl + Z
The keyboard shortcut for applying double spacing is _______.
Ctrl+2
The keyboard shortcut to close a file is:
Ctrl+W
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
The keyboard shortcut to begin the spelling checker is _______.
F7
To rename a database object, double-click the name in the Navigation Pane and type the new name. T/F
False
Users can enter and edit data in an AutoNumber field. T/F
False
You can adjust the amount of space that appears before and after paragraphs from the Design tab on the Ribbon. T/F
False
You can undo a record deletion. T/F
False
The _______ tab opens Backstage view.
File
Which command would you use to locate specific instances of text in your presentation?
Find
______ allow users to input data through a friendly interface.
Forms
The _______ is the data entry area directly below the Ribbon and above the worksheet grid.
Formula bar
Which paste option pastes formulas and number formatting but none of the cell formatting?
Formulas & Number Formatting
To look up more information about a command, you can look it up using the ______________.
Help task pane
Each application includes a _______ tab that contains the most commonly used commands for that application.
Home
Use the _______ tab when you add WordArt to a slide.
Insert
_______ is a spreadsheet program.
Microsoft Excel
If you want to insert a picture from a file into PowerPoint, use the _______ button on the Insert tab.
Pictures
One method to open the Insert Picture dialog is for you to click the _______ icon in the content placeholder.
Pictures
Which view would you use to view the presentation as your audience will see it?
Slide Show view
The _______ allows you to quickly search the Internet about any word or phrase in a document, spreadsheet, or presentation.
Smart Lookup tool
You can control the order in which records appear in a table, query, or form by using the _______ feature.
Sort
________ are the basic building blocks of a database.
Tables
Splitting a cell back into the original cells uses a method called _______.
Unmerge Cells
Which of these methods can you use to enter a formula using the AVERAGE function? AutoSum all of these Function Arguments dialog Formula AutoComplete
all of these
The zoom slider is located ________.
at the lower right corner of the status bar
Using the Fill Color button changes the _______ color in cells.
background
A piece of content that is reusable in any document, such as a cover page or a watermark, is known as a ____________.
building block
Which kind of list would you use for instructions that do not need to be performed in a certain order?
bulleted list
What is the intersection of a row and column in a table called?
cell
Selecting a cell and pressing Delete clears ________.
cell content only
A _______ is a contiguous group of cells.
cell range
A cell's address, its position in the workbook, is referred to as a _______ when it is used in a formula.
cell reference
The _______ placeholder is a special type of placeholder that gives you a quick way to add a variety of material to your presentations.
content
Which of the following is a special type of placeholder that gives you a quick way to add a variety of material to your presentations?
content
What term is used for the blinking vertical line that indicates the place on the page where text will appear when you begin typing?
cursor
When you cut and paste a cell containing a formula with relative references, Excel ________.
does not update the cell references to the new location
If you want to change all the text in a placeholder, click the _______ of the placeholder and then select a new font or font size.
edge
Each column in a table represents a specific data value called a ________.
field
Each column in a table represents a specific data value called a(n) _______.
field
A _______, or typeface, refers to a set of characters of a certain design.
font
An input mask _______________.
forces users to input data in a consistent format
Displaying the _______ allows you to easily see if there are extra line breaks.
formatting marks
Formula AutoComplete is a shortcut for entering _______.
functions
From the View tab you can display _______ in the Slide pane, giving you visual markers for aligning placeholders and images.
gridlines
A _______ is text or a graphic that, when clicked, opens another page or file.
hyperlink
Which of the following will add text that when clicked will take you to another place in the document?
hyperlink
Which of the following are added to a document as an SVG image?
icons
To apply the Double Accounting underline format ________.
in the Font dialog, on the Font tab, expand the Underline list and select Double Accounting
A ScreenTip displays the _______ of the command when you rest your mouse over a button on the Ribbon.
name
AutoSum is located ________.
on the Home tab, in the Editing group
When you enter a formula with more than one mathematical operation, the formula is not necessarily calculated left to right because Excel calculations follow the mathematical rules called the _______.
order of operations
What is the final step in creating a presentation?
practice your presentation
Text placeholders are _______ in slide layouts where you enter text.
predefined areas
Microsoft Office PowerPoint enables you to create robust multimedia _______.
presentations
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
Each row in a table contains all the data for a single ________.
record
Using the same font style on the title for each slide is an example of which design principle?
recurrence
A(n) _______ reference is a cell reference that adjusts to the new location in the worksheet when the formula is copied.
relative
Normally in Access, _______ are the only database objects that are printed.
reports
Which type of font has an embellishment at the end of each stroke to lead the eye from one character to the next?
serif
A(n) _______ is a drawing object that you can quickly add to your presentation.
shape
When you close a file, the application _______.
stays open
A well-designed database ___________. repeats important data in multiple tables uses the AutoNumber data type for primary key fields stores each unique piece of data in only one table both b and c
stores each unique piece of data in only one table
A(n) ____________ changes the font and paragraph formatting for an entire document based on styles.
style set
To clear a(n) _______, drag the tab marker down from the horizontal ruler to remove it.
tab stop
All data entered into a form are stored in the underlying ________.
table
Access _______ are the essential building blocks of the database.
tables
The database ________ store all the data.
tables
A(n) _______ is a file with predefined settings that you can use as a base to create a new database of your own.
template
The cell C4 refers to the cell at ________.
the intersection of column C and row 4
Clicking the Borders button on the Ribbon applies which border style?
the most recently used border style
In addition to the number of words in a document, the Word Count dialog also displays
the number of pages
In a PMT function, what is the Pv argument?
the present value of the loan
A group of formatting options that you apply to an entire document is called a(n) _______.
theme
A ____________ is a graphic or text that appears as part of the page background and is usually faded in appearance.
watermark
Microsoft Office Word is a _______ program that enables you to create many types of documents.
word processing
Which feature in Word automatically places text on the next line when the right margin of the document has been reached?
word wrap
A _______ is an electronic ledger in which you enter data.
worksheet
To split a cell into two cells _________.
you cannot split a cell into two cells; you can only unmerge merged cells
Formulas begin with which character?
=
In the Editor pane, which command will prevent the word from being marked as a misspelling in all the Office applications, not just Word?
Add to Dictionary
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
When you cut or copy items, they are placed on the ________.
Clipboard
The _______ displays the text from your slides in an outline.
Outline view
Which command aligns text along the upper edge of a text placeholder?
Top
The text that appears at the top of every page, just below the top margin is known as what?
header
Identify the Value_if_true argument in this formula: =IF(A2>100,"high","low")
high
A PowerPoint presentation is made up of a series of _______.
slides
When you are entering data in a new record in a form, the Undo command will ________.
undo the entire record at once
An example of the AVERAGE function is _______.
=AVERAGE(B3:D3)
A formula to display the value of cell A5 on the Inventory worksheet looks like this:
=Inventory!A5
A formula using the TODAY function looks like _______.
=TODAY()
Which data type should be used to include an image file with each record in a table? Memo Photo Hyperlink Attachment
Attachment
Which of the following removes text to the left of the cursor?
Backspace
The number of words and the number of pages in the document are displayed as part of the document properties available from the Info tab in the _______ view.
Backstage
Access opens to _______ where you can select an existing database to open or begin a new one.
Backstage view
To change the Office theme you make the selection from the Account page of the _______.
Backstage view
To count the number of cells that contain text or numerical values, but not blanks, use which function?
COUNTA
Which of the following functions counts the number of cells that are not blank within a specified range of cells.
COUNTA
The keyboard shortcut to open the Quick Analysis tool is ________.
CTRL+ Q
If a list includes more items than will easily fit vertically on a slide, you should use the command to display the items side by side.
Columns
_______ formatting applies formatting to cells based on their values.
Conditional
_______ contain commands specific to the type of object selected and are only visible when the commands might be useful.
Contextual tabs
The _______ command is used to duplicate content in a document.
Copy
Which command would you use to copy text to the Clipboard and not remove it from the presentation?
Copy
Which key combination is used to select an entire document?
Ctrl+A
Press _______ to bypass the Backstage view and create a new blank file.
Ctrl+N
Which of these is not an acceptable name for a named range?
Current Inventory
Which command would you use to copy text to the Clipboard and remove it from the document?
Cut
Which tab can you use to apply a theme to a document?
Design
The AutoSum button is found on the Home tab, in the _______ group and enters the SUM function arguments using the most likely range of cells based on the structure of the worksheet.
Editing
When you open a database for the first time, Access may display a security warning in the Message Bar. If you trust the source of the database, click the _______ button in the Message Bar.
Enable Content
Pressing _______ on the keyboard after entering text will move the cursor down one cell.
Enter
Creating a backup of the database removes unnecessary file space and hidden, temporary objects from your database. T/F
False
The Currency field format is the same as the Currency data type. T/F
False
You must manually save the record each time you enter data in a table or form. T/F
False
The easiest way to use AutoFill is to use the _______ tool.
Fill Handle
To perform a complex search in your document, such as finding an exact match, searching for whole words only, or finding formatting in your document, use the _____ command.
Find and Replace
Forms open in _______ view, which provides a user-friendly interface for entering data.
Form
After adding a sound to a slide, the Audio Tools _______ tab will allow you to apply artistic effects and Quick Styles to your sound icon.
Format
The _______ tool allows you to copy formatting styles that have been applied to text.
Format Painter
Which command is used to copy the styles from one word to another?
Format Painter
Which command would you use to copy and paste formatting from one object to another?
Format Painter command
_______ are preprogrammed shortcuts for calculating complex equations, such as the monthly payment amount for a loan.
Functions
When creating slides from a Word outline, text with which style applied to it will become the title text for each slide?
Heading 1
The Slide Layout button is located in the _______ tab of the Ribbon.
Home
To add a bulleted or numbered list to a slide, go to the _______ tab on the Ribbon.
Home
To add a slide to a presentation, click the New Slide button arrow in the _______ tab of the Ribbon.
Home
You can delete a table or other database object by selecting it in the Navigation Pane, and then on the _______ tab, in the Records group, click the Delete button.
Home
The _______ logical function returns one value if a condition is true and another value if the condition is false.
IF
To move a point down a level in a list, click the _______ button.
Increase Indent
Properties are listed at the far right of the _______ page in Backstage view.
Info
To add a header or footer to a document, start by clicking the _______ tab.
Insert
_______ alignment evenly spaces the words, aligning the text on the right and left sides of the printed page.
Justified
To evenly space words, aligning the text on the right and left sides of the printed page, use the ________ command.
Justify
Which paste option pastes the text with the original formatting of the copied text?
Keep Source Formatting
Files that are opened in Protected View display a warning in the _______ at the top of the window, below the Ribbon.
Message Bar
Which of these functions returns the current date and time? DATE NOW TIME TODAY
NOW
The _______ displays the address of the selected cell and can be used to navigate to a specific cell in the worksheet by typing the cell address.
Name box
All of the database objects are organized in the _______ Pane, which is docked at the left side of the screen.
Navigation
The primary method for finding text in a document is to use the .
Navigation pane
To insert slides from a Word outline, click the arrow below the _______ button and select the Slides from Outline option.
New Slide
The _______ allows you to create new files without exiting and reopening the program.
New command
_______ can be printed along with your slides to hand out to your audience. They do not appear when you are playing your presentation.
Notes
_______ is Microsoft's free cloud storage where you can save documents, workbooks, presentations, videos, pictures, and other files and be able to access the files from any computer or share the files with others.
OneDrive
_______ converts the text string so that the first letter in each word is capitalized.
PROPER
You can create a slide show of photographs, including captions, using PowerPoint's _______ feature.
Photo Album
Which commands hides the sound icon and play an audio file across the entire presentation? Play in Background button Volume button Hide During Show check box No Style
Play in Background button No Style
What does a red, wavy line under text represent?
Possible misspelled word
_______ key fields are identified with a key icon next to the field name.
Primary
Reports include _______, which shows how the report will look when printed.
Print Preview
_______ extract data from a table or related tables and can include actions such as updating data values or deleting data.
Queries
The _______ is located at the top of the application window, above the File tab, providing one-click access to common commands.
Quick Access Toolbar
Use this view when you want to review a document in an easy-to-read format.
Read Mode
The _______ command allows you to reverse the Undo command and restore the file to its previous state.
Redo
_______ databases allow you to relate tables and databases to one another.
Relational
The _______ command in Word allows you to locate specific instances of text in your document and replace them with different text.
Replace
Which command would you use to replace all instances of a word with another word?
Replace All
The _______ is located across the top of the application window and organizes common features and commands into tabs.
Ribbon
Which tab stop displays the text to the left of the tab stop?
Right Tab
_______ fonts, such as Calibri and Arial, do not have an embellishment at the end of each stroke.
Sans serif
Which of these dates uses the Long Date format? 01/01/2020 1/1/2020 Saturday, January 1, 2020 January 1, 2020
Saturday, January 1, 2020
_______ are menus of commands that display when you right-click an area of the application window.
Shortcut menus
Which command displays hidden formatting marks in a document, including paragraph and spacing marks?
Show/Hide
You can collapse or expand the Navigation Pane by clicking the _______ button.
Shutter Bar Open/Close
Which of the following are visual diagrams containing graphic elements with text boxes in which you enter information?
SmartArt
When you launch Office applications you are first taken to the ________ page which gives you quick access to recently opened files and templates.
Start
The _______ appears at the bottom of the worksheet grid and displays information about the selected data, including the number of cells selected that contain data and the average and sum of the selected values.
Status bar
When you have entered all the data for a new record, press _______ or _______ to start another new record.
Tab; Enter
The __________ feature offers a quick way to access commands.
Tell Me
Which command would you use to call attention to text by coloring the background behind the text?
Text Highlight Color
To highlight cells with values in the top 10% of the select range, use ________ conditional formatting.
Top/Bottom Rules
Data markers are graphic representations of the values of data points in a chart. T/F
True
Moving a field in Design view also changes the field order in Datasheet view. T/F
True
Styles ensure parts of your document, such as headings, all use the same formatting. T/F
True
To open one of the Office applications using Windows 10, click the _________ Start button, All Apps, and then find the application in the list and click on the one you want to open.
Windows
Text that includes predefined graphic styles, such as shadows, reflections, and glows, is known as ________.
WordArt
Which would you use to magnify the text on-screen, making the text appear larger?
Zoom In button
A(n) _______ reference is a cell reference whose location remains constant when the formula is copied.
absolute
There are several different design principles to consider when creating a presentation, and they include:
balance, flow, distinction, and recurrence
A table's primary key must _________.
be unique for every record in the table.
Grammatical errors in a document are represented by a
blue double underline
To pick up where you left off in a document or presentation, open the document or presentation and click the _______ to navigate to the location.
bookmark tag
If two tables have referential integrity enforced, ___________. both a and b you cannot add a record to the secondary table without an associated record in the primary table you cannot make changes to the primary table that would cause records in the secondary table to become unmat none of these
both a and b
To rename a field, ________. both b and c click the column header, and type the new field name double-click the column header, and type the new field name right-click the column header, select Rename Field, and type the new field name
both b and c
A _______ is a group of predefined colors that work well together in a document.
color theme
Adding _______ to placeholders allows for more flexibility of displaying lists across a slide.
columns
Microsoft Access is a powerful _______ program that allows you to enter, store, and organize large amounts of data.
database
A(n) ________ is the cell containing a formula that references the value or formula in the selected cell.
dependent
When sorting a datasheet on more than one field, apply the _________ first.
innermost sort
The MAX (maximum) statistical function will give you the _______ value in a range of values.
largest
Click the tab selector at the _______ of the horizontal ruler to change the type of tab stop.
left
What are the blank spaces at the top, bottom, left, and right of a page known as?
margins
Which would you use to display items in a list in a particular order?
numbered list
Although you create and work with a single Access database file, inside the file, there are multiple _______.
objects
Where is the Set Print Area command located?
on the Page Layout tab, in the Page Setup group
How many worksheets does a new Excel workbook have?
one
After clicking the Format Painter button, your cursor transforms into a _______.
paint brush
Which of the following would you use to add your company's name over and over again in a document without typing it every time?
property control
A(n) _______ database is a group of tables related to one another by common fields.
relational
Which type of font does not have an embellishment at the end of each stroke?
sans serif
What would you use to force text on to a new page that will have its own settings separate from the rest of the document?
section break
After clicking the New Slide button arrow, you will be asked to select a _______ from the New Slide gallery.
slide layout
The _______ bar appears at the bottom of the Excel window and displays information about the current worksheet.
status
Styles and Themes Table Formatting include:
table styles and shading
A _____ is a file with predefined settings that you can use as a pattern to create a new presentation of your own.
template
Which are predefined areas in slide layouts where you enter text?
text placeholders
To control the number of characters a user can enter into a table field, use __________.
the Field Size property
Which of the following is a group of formatting elements you apply to a document?
theme
What is the definition of concatenate?
to link items together
Which of the following actions is used to select a paragraph of text?
triple-click the paragraph
The NOW and TODAY functions are termed volatile, in that they _______ the current date or date and time each time the workbook is opened.
update