CIS 146 Final

Lakukan tugas rumah & ujian kamu dengan baik sekarang menggunakan Quizwiz!

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


Set pelajaran terkait

Central limit for Sample means, t-tests

View Set

Sexually Transmitted Infections (STIs)

View Set

Anatomy and Physiology Ch. 2 (Exam 1)

View Set

personal financial literacy: "Spending"

View Set

Indigenous Law IND - CHAPTER 1 - FILL IN

View Set