question

Access is a

answer

database management system.

question

A _____ contains information about a given person, product, or event.

answer

record

question

Database _____ refers to the arrangement of data into tables and fields

answer

design

question

_____ words are words that have a special meaning to Access and cannot be used for the names of fields.

answer

reserved

question

In Access, table and field names can be up to ____ characters in length.

answer

64

question

A field whose data type is ____ characters in length.

answer

text

question

A(n) ____ data type can store a variable amount of text or combination of text and numbers where the total number of characters may exceed 255.

answer

Memo

question

A field with the ____ data type can store a unique sequential number that Access assigns to a recored. Access will increment the number by 1 as each new record is added.

answer

AutoNumber

question

A field with 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.

answer

Attachment

question

A field whose data type is ____ can store an OLE object, which is an object linked to or embedded in the table.

answer

OLE Object

question

In Access, all the tables, reports, forms, and queries that are created are stored in a single file called a

answer

database

question

One way to create a table, is to click ___ on the Ribbon and then click the Table button.

answer

Create

question

When you create a table in Datasheet view, Access automatically adds a field called ___ as the first field in the table.

answer

ID

question

To define an additional field in Datasheet view, click the ___ column heading.

answer

Click to Add

question

To undo the most recent change to a table structure, click the ___ button on the Quick Access Toolbar.

answer

Undo

question

To delete a field in a table, right-click the column heading for the field, and then click ___ on the shortcut menu, and then type the desired field name.

answer

Delete Field

question

To change the name of a field, right-click the column heading for the field, click ___ on the shortcut menu, and then type the desired field name.

answer

Rename Field

question

To show the symbol for the Euro instead of the dollra sign, change the ___ property for the field whose data type is Currency.

answer

Format

question

To insert a field between existing fields, right-click the column heading for the field that will follow the field, and then click ___ on the shortcut menu.

answer

Insert Field

question

To open a table in Design view, right-click the table in the Navigation Pane and then click ___ on the shortcut menu.

answer

Design View

question

To add a record to a table, click the ___ record button.

answer

New (blank)

question

You can place an insertion point by clicking in the field or by pressing

answer

F2

question

To delete a record, click the record selector for the record, and then press the ___ key(s).

answer

DELETE

question

To change the print orientation from portrait to landscape, click the ___ button on the Print Preview tab.

answer

Landscape

question

To specify AutoCorrect rules and exceptions to the rules, click File to open the Backstage view, click ___, and then click Proofing in the dialog box that displays.

answer

Options

question

To import data to a table, click the ___ tab on the Ribbon.

answer

External Data

question

To save the changes to the layout of a table, click the Save button on the

answer

Quick Access Toolbar

question

To open the Navigation Pane, click the ___ Button.

answer

Shutter Bar Open/Close

question

To create a query using the Query Wizard, click ___ on the Ribbon and then click the Query Wizard button.

answer

Create

question

To view the results of a saved query, right-click the query in the Navigation Pane and click ___ on the shortcut menu.

answer

Open

question

To change the design of a query, right-click the query in the Navigation Pane and then click ___ on the shortcut menu.

answer

Design View

question

To create an initial report that can be modified in Layout view, click ___ on the Create tab.

answer

Report

question

To quit Access, click the ___ button on the right side of the title bar.

answer

Close

question

To compact and repair a database, click the ___ button in the Information gallery in the Backstage view.

answer

Compact and Repair

question

To back up a database, use the Back Up Database command on the ___ tab in the Backstage view.

answer

Save & Publish

question

To delete a a database object, right-click the object in the Navigation Pane and then click ___ on the shortcut menu.

answer

Delete

question

To rename a database object, right-click the object in the Navigation Pane and then click ___ on the shortcut menu.

answer

Rename

question

An Excel ___ allows data easily to be summarized and charted.

answer

worksheet

question

The person or persons requesting the worksheet should supply their requirements in a ____ document.

answer

requirements

question

The first step in creating an effective worksheet is to make sure you

answer

understand what is required

question

To enter data in a cell, you must first select or activate the

answer

Cell

question

____ is/are used to add worksheet, column, and row titles on a worksheet.

answer

Text

question

To cancel an entire entry before entering it into the cell, press the ____ key.

answer

ESC

question

Clicking the ___ box completes an entry.

answer

Enter

question

The ____ is a blinking vertical line that indicates where the next typed character will appear.

answer

insertion point

question

The ___ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.

answer

AutoCorrect

question

Pressing the ___ key to complete an entry activates the adjacent cell to the right.

answer

RIGHT ARROW

question

By default, text is ___ in a cell.

answer

left-aligned

question

In Excell, a number can contain the characters

answer

0 1 2 3 4 5 6 7 8 9; . $ % E e; + - ( ) , / (all of the above)

question

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or you can type

answer

6E15

question

You can enter the correct range in a function by typing the beginning and ending cell references seperated by a

answer

colon (:)

question

To enter a number as text, precede it with a(n)

answer

apostrophe (')

question

The cell being copied is called the source area (or copy area). The range of cells receiving the copy is called the

answer

destination area (or paste area)

question

A ___ reference is an adjusted cell reference in a copied and pasted formula.

answer

relative

question

The ___ is the small black square located in the lower-right corner of the heavy border around the active cell.

answer

fill handle

question

The ___ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting.

answer

Auto Fill Options

question

You ___ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.

answer

format

question

In general, use no more than ___ font types in a worksheet.

answer

two

question

You can apply the Bold font style by pressing the ___ keyboard shortcut keys.

answer

CTRL+B

question

Combining two or more selected cells into one cell is called ____ cells.

answer

merging

question

Which of the following is the Ribbon path to the Cell Styles button?

answer

(Home tab | Styles group)

question

What effect does the Accounting Numbe Fomat have on the selected cells?

answer

Displays cell contents with two decimal places that align vertically

question

What effect does the Comma Style fomat have on the selected cells?

answer

Displays cell contents with two decimal places and commas as thousands separators.

question

Pressing the ____ keyboard shortcut key(s) selects cell A1.

answer

CTRL+HOME

question

How many chart types does Excel offer?

answer

11

question

A(n) ___ chart is drawn on the same worksheet as the data.

answer

embedded

question

____ properties are associated with all Microsoft Office documents and include author, title, and subject.

answer

Standard

question

The ___ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.

answer

AutoCalculate

question

Which of the following keys is an alternative to double-clicking the cell to edit it?

answer

F2

question

Which of the following keys toggles between Insert mod and Overtype mode?

answer

INSERT

question

Which of the following keys moves the inertion point to the beginning of data in a cell?

answer

HOME

question

Which of the following keys moves the insertion point to the end of data in a cell?

answer

END

question

Excel remembers the last ___ actions you have completed.

answer

100

question

To remove an embedded chart, you should ____ it and press the DELETE key.

answer

click

question

___ conveys meaning and is useful to one or more people.

answer

Information

question

The processor, memory, and storage devices are housed in a box-like case called the

answer

system unit

question

A ___ is a small metal or plastic device that looks like a ballpoint pen, but uses pressure instead of ink to write, draw, or make selections.

answer

Stylus

question

One kilobye (K or KB) equals approximately ___ memory locations.

answer

1,000

question

Which kind of monitor uses a liquid crystal display to produce images on the screen?

answer

LCD

question

A ___ is a duplicate of a file, program, or disk that you can use in case the original is lost, damaged, or destroyed.

answer

backup

question

A ___ is an erasable optical disc you can write on multiple times.

answer

CD-RW (compact disc-reqriteable)

question

A(n) ___ is system software.

answer

operating system

question

A URL consists of a ___, a domain name, sometimes the path to a specific Web page or location in a Web page, and the Web page name.

answer

protocol

question

A ___ is a program that hides in a computer and allows someone from a remote locations to take full control of the computer.

answer

rootkit

question

___ computers are a good option if you work mostly in one place and have plenty of space in your work area.

answer

Desktop

question

Plan to buy a computer that will last you for ___ year(s)

answer

two to three

question

The lightest notebook computers, which weigh less than 3 pounds, are equipped with a(n) ___-inch display.

answer

12.1

question

If you spend a lot of time attending lectures or meetings, then then slate ___ is ideal.

answer

Tablet PC

question

Windows 7 is used to run ___ software.

answer

application

question

To display the Start menu, press

answer

CTRL+ESC

question

If you are required to log on to the computer, the ___ screen is displayed, which shows the user names on the computer.

answer

Welcome

question

The ___ command waits for Windows 7 to save your work and then turns off the computer fans and hard disk.

answer

Sleep

question

A(n) ___ is a named unit of storage.

answer

file

question

Microsoft Office programs use ___ dialog boxes for performing actions such as opening and saving files.

answer

common

question

Which of the following applications is included with Microsoft Office Standard 2010?

answer

OneNote

question

Which of the following applications is included with Microsoft Office Home and Student 2010?

answer

Excel

question

___ is a full-featured word processing program that allows you to create many types of personal and business documents.

answer

Word

question

A(n) ___ is an area of a window that displays related content.

answer

pane

question

A ___ is a list of related items, including folers, programs, and commands.

answer

menu

question

A(n) ___ on a menu performs a specific action, such as saving a file.

answer

command

question

___ view shows the document on a mock sheet of paper in the document window.

answer

Print Layout

question

One method of displaying the entire contents of a window is to ___ it.

answer

maximize

question

When you ___ a scroll bar, a shortcut menu appears with commands related to the scroll bar.

answer

right-click

question

Which of the following buttons are contained on the Quick Access Toolbar by default?

answer

Save, Redo, Undo (All of the above)

question

A ___ consists of a drive letter and colon, to identify the storage device, and one or more foler names.

answer

path

question

Which of the following is a valid folder name?

answer

folder!

question

Which of the following is a valid folder name?

answer

COM

question

A ___ is an icon on the desktop that provides a user with immediate access to a program or file.

answer

shortcut

question

The ___ bar contains five buttons used to accomplish various tasks on the computer related to organizing and managing the contents of the open window.

answer

Command

question

A ___ helps you manage multiple folders and files stored in various locations on a computer.

answer

library

question

A(n) ___ window is an open window hidden from view but that can be displayed quickly by clicking the window's program button on the taskbar.

answer

minimized

question

Screen resolution indicates the number of ___ that the computer uses to display the letters, numbers, graphics, and background you see on the screen.

answer

pixels

question

A ___ is an object that allows users to choose from multiple predetermined options.

answer

slider

question

A ___ in Excel is like a notebook.

answer

workbook

question

A cell is referred to by its cell

answer

reference

question

The ___ cell on the worksheet is the one into which you can enter data.

answer

active

question

As you type, Excel displays the entry in the ___ bar.

answer

formula

question

___ is a powerful communications and scheduling program that helps you communicate with others, amon other things.

answer

Outlook

question

___ is a powerful DTP program that assists you in designing and producing professional-quality documents that combine text, graphics, illustrations, and photos.

answer

Publisher

question

A PowerPoints ____ can help you deliver a dynamic, professional-looking message to an audience.

answer

presentation

question

All of the following are PowerPoint content used to customize slides except

answer

databases

question

PowerPoint ___ should reinforce the speaker's message and help the audience retain the information presented.

answer

slides

question

The best starting point to developing a presentation is to

answer

establish why the presentation is needed

question

All of the following are general project guidelines for a new presentation except

answer

add clip to every slide

question

A ___ provides consistency in design and color throughout the entire presentation.

answer

document theme

question

The default document theme is the

answer

Office Theme

question

The Themes gallery is located on the ___ Ribbon tab.

answer

Design

question

The box on a slide that has a dotted or hatch-marked border and that contains the insertion point is a text

answer

placeholder

question

When you open a new presentation, a slide with the default ____ layout appears.

answer

Title Slide

question

By deafult, slides in a new presentation are in ___ orientation.

answer

landscape

question

The Undo button is located on the

answer

Quick Access Toolbar

question

When you type the wrong character, you can press the ____ key to erase all the characters back to and including the one that is incorrect.

answer

BACKSPACE

question

Pressing the ___ key when entering title text in a placeholder creates a new paragraph.

answer

ENTER

question

Which of the following is not a design guideline for formatting text?

answer

Avoid text with a font size greater than 30 point

question

Text ___ defines the appearance and shape of letters, numbers, punctuation marks, and symbols.

answer

font

question

A point is ___ of an inch in height.

answer

1/72

question

___ text has slanted appearance.

answer

Italicized

question

The Italic button is located on the

answer

Mini toolbar

question

When selecting text color, try to limit using

answer

red

question

When you add a new slide folowing the title slide, PowerPoint uses the ___ slide layout for the new slide.

answer

Title and Content

question

You can insert a new slide by pressing the ___ keyboard shortcut keys.

answer

CTRL+M

question

PowerPoint assumes every new slide, except for a blank slide, has

answer

a title

question

You can move the insertion point into the next text placeholder by pressing the ___ keyboard shortcut keys.

answer

CTRL+ENTER

question

In a multi-level bulleted list slide, creating a lower-level paragraph is called ___ the text.

answer

demoting

question

What is the correct path to the Bold button?

answer

(Home tab | Font group)

question

To change the font size of selected text, click the Decrease Font Size or Increase Font Size buttons located

answer

on the Mini toolbar

question

Using the ___, you can choose the arrangement of placeholders on a new slide.

answer

Layout gallery

question

You can type comments to yourself in the ___ for a specific slide while working in Normal view.

answer

Notes pane

question

The default PowerPoint view is ___ view.

answer

Normal

question

___ is a collection of drawings, photographs, sounds, videos, and other media files shared among Microsoft Office applications.

answer

The Microsoft Clip Organizer

question

You can search for media clips using the

answer

Clip Art task pane

question

The process of moving a slide object to a new locations using the mouse pointer is called

answer

drag and drop

question

A slide ___ is a special animation effect used to progress from one slide to the next slide in a slide show.

answer

transition

question

Document ___ are the details about a file.

answer

properties

question

Which of the following is not a standard document property?

answer

date the presentation file was created or changed

question

Which of the following keys can you press to run a slide show starting with slide 1?

answer

F5

question

Sending electronic documents is a way to contribute to ___ computing.

answer

green

question

The default view in Word is

answer

Print Layout view

question

To enter a blank line into a document,m press the ___ key without typing any text on the line.

answer

ENTER

question

Press the ENTER key in all of the following circumstances EXCEPT

answer

when the insertion point reaches the right margin

question

When Word flags a possible spelling or grammar error, it also changes the Spelling and Grammar Check icon to a

answer

red X

question

If a flagged word is spelled correctly, right-click it and then click ___ on the shortcut menu to instruct Word not to flag future occurences of the same word in this document.

answer

Ignore All

question

To move left one word with the keyboard, press the ___ key(s).

answer

CTRL+LEFT ARROW

question

To move to the beginning of a line with the keyboard, press the ___ key(s).

answer

HOME

question

To move to the end of the document, press the ___ key(s).

answer

CTRL+END

question

To move to the right one word, press the ____ key(s).

answer

CTRL+RIGHT ARROW

question

To move up one paragraph, press the ___ key(s).

answer

CTRL+UP ARROW

question

To move down one paragraph, press the ___ key(s).

answer

CTRL+DOWN ARROW

question

To move to the bottom of a document window, press the ____ key(s).

answer

ALT+CTRL+PAGE DOWN

question

To move to the top of a document window, press the ___ key(s).

answer

ALT+CTRL+PAGE UP

question

When you use the keyboard to scroll to a different position in the document, the ___ automatically moves when your press the desired keys.

answer

insertion point

question

Word includes a variety of document ___ to assist you with coordinating these visual elements in a document.

answer

themes

question

___ formatting is the proccess of changing the way letters, numbers, punctuation marks, and symbols appear on the screen in print.

answer

Character

question

The ___, or typeface, defines the appearance and shape of letters, numbers, and special characters.

answer

font

question

On most computers, the default font size in Word is

answer

11

question

A(n) ___ paragraph is a paragraph that begins with a dot or other symbol.

answer

bulleted

question

The file type ___ is a Word 2010 document.

answer

.docx

question

To select nonadjacent items, select the first item as usual, press and hold down the ___ key, and then while holdinmg down the key select the additional items.

answer

CTRL

question

Which of the following colors suggests neutrality?

answer

gray

question

With more than ___ predefined color schemes, Word provides a simple way to select colors that work well together.

answer

20

question

You can select characters by using the ___ key(s).

answer

SHIFT+RIGHT ARROW

question

You can select a document by using the ___ key(s).

answer

CTRL+A

question

You can select a paragraph by using the ___ key(s).

answer

SHIFT+END

question

You can select multiple paragraphs by using the ___ key(s) repeatedly.

answer

CTRL+SHIFT+DOWN ARROW

question

You can select a word by using the ___ key(s).

answer

CTRL+SHIFT+LEFT ARROW

question

You can select multiple words by using the ___ key(s) repeatedly.

answer

CTRL+SHIFT+RIGHT ARROW

question

To center a page's contents vertically between the top and bottom margins, click the Page Setup Dialog Box Launcher, click the ___ tab, click the vertical alignment box arrow, click Center in the list, and then click the OK button.

answer

Layout

question

___ are types of changes that occur when text has been ommited from a document and must be inserted later.

answer

Additions

question

To delete an incorrect character in a document, simply click next to the incorrect character and then press the ___ key(s) to erase to the left of the insertion point.

answer

BACKSPACE

question

To delete an incorrect character in a document, simply click next to the incorrect character and then press the ___ key(s) to erase to the right of the insertion point.

answer

DELETE

question

___ are words or phrases that describe a document.

answer

Keywords

question

___ is another term for document properties.

answer

Metadata

question

To close the ___ view, click File on the Ribbon or click the preview of the document in the Info gallery to return to the document window.

answer

Backstage

question

In Word, you can create electronic image files through the ___ tab in the Backstage view.

answer

Print

MCIS FINAL EXAM :D – Flashcards

Unlock all answers in this set

Haven't found what you were looking for?

Search for samples, answers to your questions and flashcards