CIS 146 Final
Which of these cell references is an absolute reference?
$c$9
Identify the Pv argument in this formula: =PMT(B1/12,B2,-B3)
-B3
Formulas begin with which character?
=
The keyboard shortcut to open the Quick Analysis tool is ________.
CTRL+ Q
The keyboard shortcut to close a file is:
Ctrl + W
You can undo a record deletion.
False
You must manually save the record each time you enter data in a table or form
False
Which command would you use to copy and paste formatting from one object to another?
Format Painter command
Which of these dates uses the Long Date format?
Saturday, January 1, 2020
Which command aligns text along the upper edge of a text placeholder?
Top
The zoom slider is located ________.
at the lower right corner of the status bar
Grammatical errors in a document are represented by a ___
blue double underline
A _______ is the intersection of a column and a row.
cell
Selecting a cell and pressing Delete clears ________.
cell content only
A _______ is a contiguous group of cells.
cell range
Which command would you use to change the text from uppercase to having each word capitalized?
change case
When you cut or copy items, they are placed on the ________.
clipboard
Which tab do you click to display the backstage view?
file
Which command is used to copy the styles from one word to another?
format painter
To add a bulleted or numbered list to a slide, go to the _______ tab on the Ribbon.
home
Which of the following will add text that when clicked will take you to another place in the document?
hyperlink
To apply the Double Accounting underline format ________.
in the Font dialog, on the Font tab, expand the Underline list and select Double Accounting
Clicking _______ of a text placeholder will select it and prepare it for editing.
inside
The _______ lists all the named ranges used in your workbook.
name manager
One method to open the Insert Picture dialog is for you to click the _______ icon in the content placeholder.
pictures
Each slide contains _______ for you to add content to, such as text, tables, charts, or images.
placeholders
What does a red, wavy line under text represent?
possible misspelled word
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
The _______ command allows you to reverse the Undo command and restore the file to its previous state.
redo
A(n) _______ database is a group of tables related to one another by common fields.
relational
Normally in Access, _______ are the only database objects that are printed.
reports
When you close a file, the application _______.
stays open
Data markers are graphic representations of the values of data points in a chart.
true
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
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()
To add a line break within a cell, hold _______ while pressing Enter.
ALT
To count the number of cells that contain text or numerical values, but not blanks, use which function?
COUNTA
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
The keyboard shortcut for applying double spacing is _______.
Ctrl + 2
Press _______ to bypass the Backstage view and create a new blank file.
Ctrl + N
_______ is a spreadsheet program.
Excel
To rename a database object, double-click the name in the Navigation Pane and type the new name.
False
Each column in a table represents a specific data value called a ____
Field
Which command would you use to locate specific instances of text in your presentation?
Find
Which paste option pastes formulas and number formatting but none of the cell formatting?
Formulas & Number Formatting
AutoSum is located ________.
Home tab, editing group
Which of these functions returns the current date and time?
NOW
_______ converts the text string so that the first letter in each word is capitalized.
PROPER
What option allows you to hide the audio icon and play bar while playing the sound file automatically in a presentation?
Play in Background button
The _______ is located at the top of the application window, above the File tab, providing one-click access to common commands.
Quick Access Toolbar
Which of the following are visual diagrams containing graphic elements with text boxes in which you enter information?
Smart Art
All data entered into a form are stored in a underlying
Table
Text that includes predefined graphic styles, such as shadows, reflections, and glows, is known as ________.
Word art
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
Which of the following removes text to the left of the cursor?
backspace
Which key combination is used to select an entire document?
ctrl + A
To display the Open page in Backstage view, you can press _______.
ctrl + O
Microsoft Access is a powerful _______ program that allows you to enter, store, and organize large amounts of data.
database
You can adjust the amount of space that appears before and after paragraphs from the Design tab on the Ribbon.
false
Each column in a table represents a specific data value called a(n) _______.
field
_______ refers to the number of characters the field can hold in the database.
field size
The Save As dialog is accessed from the _______ tab
file
The _______ tab opens Backstage view.
file
The easiest way to use AutoFill is to use the _______ tool.
fill handle
A _______, or typeface, refers to a set of characters of a certain design.
font
A _______ is text or a graphic that, when clicked, opens another page or file.
hyperlink
To move a point down a level in a list, click the _______ button.
increase indent
Files that are opened in Protected View display a warning in the _______ at the top of the window, below the Ribbon.
message bar
A ScreenTip displays the _______ of the command when you rest your mouse over a button on the Ribbon.
name
You can create a slide show of photographs, including captions, using PowerPoint's _______ feature.
photo album
What is the final step in creating a presentation?
practice your presentation
Which tab stop displays the text to the left of the tab stop?
right tab
After clicking the New Slide button arrow, you will be asked to select a _______ from the New Slide gallery.
slide layout
A PowerPoint presentation is made up of a series of _______.
slides
You can control the order in which records appear in a table, query, or form by using the _______ feature.
sort
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
A ____________ is a graphic or text that appears as part of the page background and is usually faded in appearance.
watermark
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
An example of the AVERAGE function is _______.
=AVERAGE(B3:D3)
An accurate IF function is _______.
=IF(C2>D2,"no","yes")
Which of these tasks can you perform in Backstage view?
All of these; Create a new workbook from a template.; Enable Editing when a workbook is in Protected View.; Preview how a workbook will look when printed.
Which of the following functions counts the number of cells that are not blank within a specified range of cells.
COUNTA
What is the intersection of a row and column in a table called?
Cell
You can remove conditional formatting using the ________.
Clear Rules from Selected Cells command
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
When creating slides from a Word outline, text with which style applied to it will become the title text for each slide?
Copy
One method to save a file is to press _______ on the keyboard.
Ctrl + S
What is the keyboard shortcut for reversing the last action you performed?
Ctrl + Z
Which of these is not an acceptable name for a named range?
Current Inventory
The keyboard shortcut to begin the spelling checker is _______.
F7
Creating a backup of the database removes unnecessary file space and hidden, temporary objects from your database.
False
Which of these methods can you use to enter a formula using the AVERAGE function?
Formula AutoComplete; Function Arguments dialog; AutoSum; all of these
When creating slides from a Word outline, text with which style applied to it will become the title text for each slide?
Heading 1
Which of the following are added to a document as an SVG image?
Icons
Which commands hides the sound icon and play an audio file across the entire presentation?
Play in back ground
You can export Access data to which of the following file formats?
PowerPoint
Each row in a table contains all the data for a single______
Record
You can collapse or expand the Navigation Pane by clicking the _______ button.
Shutter Bar Open/Close
Which view would you use to view the presentation as your audience will see it?
Slide Show view
______ are the basic building blocks of a database.
Tables
To highlight cells with values in the top 10% of the select range, use ________ conditional formatting.
Top/Bottom Rules
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
Most functions require you to provide input called the _______.
arguments
A(n) _______ pulls the current date from the computer's system clock and displays the date in the document.
automatic date stamp
Access opens to _______ where you can select an existing database to open or begin a new one.
backstage view
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
When you wish to present your Excel worksheet data as a graphic, create a(n) _______.
chart
The _______ command removes any formatting that has been applied to text, including character formatting, text effects, and styles, and leaves only plain text.
clear all formatting
A _______ is a group of predefined colors that work well together in a document.
color theme
_______ formatting applies formatting to cells based on their values.
conditional
The _______ placeholder 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
Tables open in _______ where you can enter, sort, and filter data.
datasheet view
To clear the contents of a cell while leaving the cell formatting, you can click the _______ key.
delete
A(n) ________ is the cell containing a formula that references the value or formula in the selected cell.
dependent
Which tab can you use to apply a theme to a document?
design
_______ is used to modify the structure of the database object.
design view
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
#DIV/0 is an example of a worksheet _______ that can display in a cell.
error
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
What is the term for text that appears at the bottom of every page?
footer
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
Displaying the _______ allows you to easily see if there are extra line breaks.
formatting marks
When you select a cell that contains a formula, the formula bar displays the _______.
formula
The _______ is the data entry area directly below the Ribbon and above the worksheet grid.
formula bar
The text that appears at the top of every page, just below the top margin is known as what?
header
To look up more information about a command, you can look it up using the ______________.
help task pane
Identify the Value_if_true argument in this formula: =IF(A2>100,"high","low")
high
The Slide Layout button is located in the _______ tab of 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
Properties are listed at the far right of the _______ page in Backstage view.
info
To add a sound to your presentation, click the _______ button on the Insert tab.
insert audio
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 copied text?
keep source formatting
_______ are keys or combinations of keys that you press to execute a command.
keyboard shortcuts
Forms and Reports also offer _______ where you can modify some (but not all) structural elements.
layout view
Click the tab selector at the _______ of the horizontal ruler to change the type of tab stop.
left
When inserting slides from a Word outline, each Heading 2 style becomes the _______ on the slide.
main text
What are the blank spaces at the top, bottom, left, and right of a page known as?
margins
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
_______ can be printed along with your slides to hand out to your audience. They do not appear when you are playing your presentation.
notes
Which would you use to display items in a list in a particular order?
number list
Dates from January 1, 1900 through December 31, 9999 are stored as _______.
numbers
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
When resizing by dragging, be sure to use one of the resize handles _______ of the picture to maintain the aspect ratio of the picture.
on the four corners
How many worksheets does a new Excel workbook have?
one
The _______ displays the text from your slides in an outline.
outline view
_______ refers to how text is aligned with regard to the left and right margins.
paragraph alignment
Text placeholders are _______ in slide layouts where you enter text.
predefined areas
A _______ program enables you to create robust multimedia presentations.
presentation
_______ key fields are identified with a key icon next to the field name.
primary
If you do not want to print an entire worksheet you can set a _______, which is a range of cells that you designate as the default print selection.
print area
Reports include _______, which shows how the report will look when printed.
print preview
A _______ is an element you can add to your document to save time entering the same information over and over again.
property control
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
_______ extract data from a table or related tables and can include actions such as updating data values or deleting data.
queries
Use this view when you want to review a document in an easy-to-read format.
read mode
_______ databases allow you to relate tables and databases to one another.
relational
Objects in Access are related to one another through _______ defined by common fields between tables.
relationships
A(n) _______ reference is a cell reference that adjusts to the new location in the worksheet when the formula is copied.
relative
Closing a file _______ it from your computer screen and stores the last saved version for future use.
removes
The _______ command in Word allows you to locate specific instances of text in your document and replace them with different text.
replace
_______ display database information for printing or viewing on-screen.
reports
The _______ is located across the top of the application window and organizes common features and commands into tabs.
ribbon
Which part of the office interface is located across the top of the application window and organizes common features and commands into tabs?
ribbon
To display a shortcut menu ___________ an area of the file
right-click
The first time you save a file, the _______ page in Backstage view will display.
save as
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
Which type of font has an embellishment at the end of each stroke to lead the eye from one character to the next?
serif
Which type of font has an embellishment at the end of each stroke?
serif
A(n) _______ is a drawing object that you can quickly add to your presentation.
shape
To display formatting marks in a document, click the _______ button.
show/hide
Which command displays hidden formatting marks in a document, including paragraph and spacing marks?
show/hide
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 _______ bar appears at the bottom of the Excel window and displays information about the current worksheet.
status
Opening a file retrieves it from _______ and displays it on your computer screen.
storage
A(n) ____________ changes the font and paragraph formatting for an entire document based on styles.
style set
Complex formatting, including font, color, size, and spacing that can be applied to text are called _______.
styles
Pressing _______ on the keyboard after entering text will move the cursor to the right one cell.
tab
To clear a(n) _______, drag the tab marker down from the horizontal ruler to remove it.
tab stop
When you have entered all the data for a new record, press _______ or _______ to start another new record.
tab; enter
Deleting a record in a form will also delete it from the underlying ________.
table
Access _______ are the essential building blocks of the database.
tables
To add keywords to a file, click the text box next to _______ and type keywords that describe the file, separating each word with a comma.
tags
The __________ feature offers a quick way to access commands.
tell me
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 file with predefined settings that you can use as a base to create a new database of your own.
template
If you start with a _______, your presentation may include several slides ready to add content.
template
Which command would you use to call attention to text by coloring the background behind the text?
text highlight color
Which are predefined areas in slide layouts where you enter text?
text placeholders
Word processing software allows you to create _______ documents.
text-based
The cell C4 refers to the cell at ________.
the intersection of column C and row 4
In a PMT function, what is the Pv argument?
the present value of the loan
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
Styles ensure parts of your document, such as headings, all use the same formatting.
true
When you are entering data in a new record in a form, the Undo command will ___
undo the entire record at once
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
When you cut and paste a cell containing a formula with relative references, Excel ________.
updates the cell references to the new location
If the ruler is not displayed, click the _______ tab and select the Ruler check box in the Show group.
view
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
Which feature in Word automatically places text on the next line when the right margin of the document has been reached?
word wrap
Which would you use to magnify the text on-screen, making the text appear larger?
zoom-in-button
