Computer Apps Final Review
Pressing the ____ key on the keyboard displays a Key Tip badge.
(a) ALT
Each time the _____ key is pressed, the paragraph formatting in the previous paragraph is carried forward to the next paragraph.
(a) ENTER
The ______ toolbar contains commands related to changing the appearance of text in a document.
(a) Mini
The ________ is the control center in Word.
(a) Ribbon
______ are a collection of worksheets.
(a) Workbooks
An _______ chart is drawn on the same worksheet as the data.
(a) embedded
A saved database is referred to as a _____.
(a) file
The ______, or typeface, defines the appearance and shape of letters, numbers, and special characters.
(a) font
Combining two or more cells together is called ________ cells.
(a) merging
The small squares and circles around a selected graphic are called _______ handles.
(a) sizing
When the same word is used in multiple locations or a word is used that was not quite appropriate, a thesaurus can be used to look up a _____, or a word similar in meaning.
(a) synonym
When you create a new database, the name of the database appears on the ____ bar.
(a) title
If a field has a Number data type, you can change the ____ property to Fixed to set a fixed number of decimal places.
(b Format
By default, the Normal style inserts a vertical space equal to ___ lines between each line of text.
(b) 1.15
How many chart types does Excel offer?
(b) 11
On most computers, the default font size in Word is ___.
(b) 11
In Access, table and field names can be up to ___ characters in length.
(b) 64
Word displays, by default, the ____ most recently opened document file names in its Recent Documents list.
(b) 9
To decrease a font size, use the _____ shortcut keys.
(b) CTRL + SHIFT + <
To move left one word with the keyboard, press ____.
(b) CTRL+ left arrow
The ____ is a temporary Windows storage area.
(b) Clipboard
One way to create a table is to click ____ on the Ribbon and then click the Table button.
(b) Create
Which is true of insert mode?
(b) It moves all characters to the right of the typed character one position to the right.
To select a command using the keyboard, press its displayed code letter, or _____.
(b) Key Tip
If you prefer using the keyboard, instead of the mouse, you can press the ALT key on the keyboard to display a ________.
(b) Key Tip badge
The ______ provides easy access to frequently used commands.
(b) Quick Access Toolbar
The number of worksheets that a workbook can contain is ___________.
(b) limited by computer memory
A ____ contains information about a given person, product, or event.
(b) record
According to the MLA style, the ________ is a list of sources that are referenced directly in a research paper.
(b) works cited page
The shortcut keys used to left-align a paragraph are ___.
(c) CTRL + L
To right align a paragraph, use the ____ shortcut keys.
(c) CTRL + R
What effect does the Comma Style format have on the selected cells?
(c) Causes the cells to display with two decimal places and commas as thousands separators
To create a report using the Report Wizard, click ____ on the Ribbon and then click the Report Wizard button.
(c) Create
To enter a blank line into a document, press the _____ key without typing any text on the line.
(c) ENTER
The paragraph mark is a formatting mark that indicates where the _______ was pressed.
(c) ENTER key
To move to the beginning of a line with the keyboard, press ____.
(c) HOME
The ____ tab contains the more frequently used commands.
(c) Home
To change the print orientation from portrait to landscape, click the ____ button on the Print Preview tab.
(c) Landscape
_____ is the process of copying an item from the Clipboard into the document at the location of the insertion point.
(c) Pasting
To save the changes to the structure of a table by clicking the Save button on the _____.
(c) Quick Access Toolbar
The scroll box on the vertical scroll bar indicates the ______.
(c) current relative location of the document portion displayed in the window
In Access, a ____ consists of a collection of tables, each of which contains information on a specific subject.
(c) database
Footnote text is ________.
(c) double-spaced, left-aligned, and a smaller font size than the text in the research paper
Changing the font type, changing the font style to bold, increasing the font size, and changing the font color is called ________.
(c) formatting
The key symbol that appears in the row selector for the Client Number field (mostly the 1st field) indicates that it is the _____ for the table.
(c) primary key
When Word flags a possible spelling or grammar error, it also changes the spelling and Grammar Check icon to a ______.
(c) red X
The shortcut keys for the _____ character formatting are CTRL + SHIFT + plus sign.
(c) superscript
What is the title of the blank workbook that opens when you first start Excel from the Windows Start menu?
(d) Book1
To move to the end of the document, press the ____ keys.
(d) CTRL + END
To increase paragraph indent, use the _____ shortcut keys.
(d) CTRL + M
To quit Access, click the ____ button on the right side of the Access title bar.
(d) Close
You can only delete a primary key in ____ view.
(d) Design
To preview and then print a table, select the table, click the Office Button, point to the Print command arrow to display the Print submenu, and then click ______ on the Print submenu.
(d) Print Preview
To save an existing document with a different file name, use __________.
(d) Save As on the Office Button menu
A file name can have a maximum of 255 characters, including spaces. The only characters not allowed are: a. < > | b. * ? " c. \ / : d. all of the above
(d) all of the above
Headers and footers can include text and graphics, as well as the: a. current date b. page number c. current time d. all of the above
(d) all of the above
In Excel, a number can contain the characters: a. 0123456789 b. + - ( ) , / c. . $ % E e d. all of the above
(d) all of the above
The intersection of each column and row is called a ____.
(d) cell
Access is a ________.
(d) database management system
Microsoft Office Word is a ____________.
(d) full featured word processing program that allows you to create professional-looking documents
A _____ is a set of choices, often graphical, arranged in a grid or in a list.
(d) gallery
The ________ is a blinking vertical bar that indicates where text, graphics, and other items will be inserted.
(d) insertion point
A _______ is a book of synonyms.
(d) thesaurus
True or False: A raised dot shows where the ENTER key was pressed.
False
True or False: As you enter text in the Word document window, you must press the ENTER key at the end of each line.
False
True or False: Database Design Language (DBDL) is a programming language.
False
True or False: In Access, table names can be up to 128 characters in length.
False
True or False: In Word, a paragraph can be both left-aligned and right-aligned at the same time.
False
True or False: The MLA style uses the term bibliographical references for works cited.
False
True or False: The Monetary data type is used for fields that contain only monetary data.
False
True or False: To delete the ID field that Access creates automatically for a new table, the table must appear in Layout view rather than Datasheet view.
False
True or False: To follow the MLA style, single-space text on all pages with one and a half-inch top and bottom margins, and one-inch left and right margins.
False
True or False: To quit Word, click the Restore button on the right side of the title bar.
False
True or False: When an item is pasted into a document, the contents of the Office Clipboard are erased.
False
True or False: When the 25th item is copied to the Office Clipboard, Word deletes the last item to make room for the new item.
False
True or False: Word never moves or adjusts automatic page breaks; however, Word adjusts manual page breaks that follow an automatic page break.
False
True or False: Wordwrap forces you to stop typing words and press the ENTER key at the end of each line.
False
True or False: A selected graphic can be resized using the Shape Height and Shape Width text boxes in the Size group on the Format tab in the Picture Tools tab.
True
True or False: A unique identifier is also called a primary key.
True
True or False: According to the MLA style, the first line of each entry in the works cited page begins at the left margin.
True
True or False: Although many different styles of documentation exist for report preparation, each style requires the same basic information.
True
True or False: Each time the ENTER key is pressed, Word creates a new paragraph.
True
True or False: Either the mouse or the keyboard can be used to scroll to a different location in a document.
True
True or False: Enhanced Screen Tips are more detailed than a typical ScreenTip, which usually only displays the name of the command.
True
True or False: File names can be a maximum of 260 characters including the file extension.
True
True or False: If you add text, delete text, or modify text on a page, Word recomputes the location of automatic page breaks and adjusts them accordingly.
True
True or False: In addition to the basic solid underline, Word has many decorative underlines that are available through the Underline gallery.
True
True or False: Some compound words should not be divided at the end of a line.
True
True or False: The Redo button allows previous actions to be repeated.
True
True or False: The mouse pointer becomes different shapes depending on the task being performed in Word and the pointer's location on the screen.
True
True or False: To remove a border from a paragraph, position the insertion point in the paragraph, click the Border button arrow on the Home tab, and then click the No Border button in the Border gallery.
True
True or False: To use Click and Type, you double-click a blank area of the document window.
True
True or False: When a custom tab stop is set, the tab marker on the ruler reflects the alignment of the characters at the location of the tab stop.
True
True or False: When you drag the Hanging Indent marker, the Left Indent marker moves with it.
True
True or False: When you first create a table it is left-aligned; that is, flush with the left margin.
True
True or False: Word provides an Undo button that can be used to cancel the most recent command or action.
True
Saving the workbook frequently is important because ________.
(c) if you lose power, the worksheet could be lost
When a cell entry is positioned at the far left in the cell, it is considered ______.
(c) left-aligned
The shortcut keys used to center a paragraph are ____.
(d) CTRL + E
True or False: While plagiarism is unethical, it is not considered an academic crime.
False