Study Guide
D . Rename Field
MC: To change the name of a field, press and hold or right-click the column heading for the field, tap or click ____ on the shortcut menu, and then type the desired field name. A . Change Column B . Rename Column C . Change Field D . Rename Field
C . programs
MC: Office 365 is a collection of ____ and services. A . clouds B . databases C . programs D . accounts
A . Click-to-Run
MC: Office 365 uses a quick-start installation technology, called ____, that downloads and installs the basics within minutes. A . Click-to-Run B . Office on Demand C . Click-to-Install D . Install on Demand
A . title of the source
MC: On the works cited page, list works by each author's last name or, if the author's name is not available, by the _____. A . title of the source B . publisher C . date of the source D . MLA citation number
A . RIGHT ARROW
MC: Pressing the ____ key to complete an entry activates the adjacent cell to the right. A . RIGHT ARROW B . LEFT ARROW C . UP ARROW D . DOWN ARROW
D . brown, gold, and yellow
MC: Sepia changes picture colors into ____. A . black, white, and gray B . red, blue, and green C . orange, yellow, and blue D . brown, gold, and yellow
D . all of the above
MC: The Word Count dialog box displays the number of words as well as the number of _____ in the current document. A . lines B . characters C . paragraphs D . all of the above
D . Auto Fill Options
MC: The ____ button allows you to choose whether you want to copy the values from the source area to the destination area with formatting. A . Copy Options B . Replace Options C . Formatting Options D . Auto Fill Options
B . AutoCorrect
MC: The ____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry. A . AutoComplete B . AutoCorrect C . AutoFormat D . AutoTyping
A . Color
MC: The ____ gallery has a wide variety of preset formatting combinations for coloring pictures. A . Color B . Design C . Style D . Format
C . insertion point
MC: The ____ is a blinking vertical line that indicates where the next typed character will appear. A . scroll box B . sheet tab C . insertion point D . split bar
C . fill handle
MC: The ____ is the small black square located in the lower-right corner of the heavy border around the active cell. A . selection handle B . sizing handle C . fill handle D . copy handle
True
Mod. T/F: Examples of how you can modify or format text include changing its shape, size, color, and position on the slide. _________________________
False, no spacing
Mod. T/F: The Normal style defines line spacing as single and does not insert any additional blank space between lines when you press the ENTER key.
False, totals
Mod. T/F: To display the Total row in a datasheet, tap or click the Sum button on the ribbon. ____________________
False, asterisk *
Mod. T/F: To include all fields in the design grid, double-click the question mark (?) in the field list. ____________________
False, Search
Mod. T/F: To restrict the objects that appear on the Navigation Pane use the Retrieval Bar. ____________________
False, Superscript
Mod. T/F: Typing an ordinal followed by a space or a hyphen makes part of the ordinal into a(n) subscript . _________________________
tab
SA: Each _________________________ contains a collection of groups.
End of cell mark
SA: Each cell in a Word table has a(n) ____________________, which is a formatting mark that assists with selecting and formatting cells.
#reference!
SA: Excel displays the error message ____________________ in cells to indicate a cell reference error in a formula.
5
SA: For each theme, PowerPoint provides 30 preset gradient fills with ____________________ designs for each of the six major theme colors
D . equal sign (=)
MC: The ____ preceding a formula alerts Excel that you are entering a formula or function and not text. A . quotation mark (") B . colon (:) C . plus (+) D . equal sign (=)
C . CTRL+SPACEBAR
MC: The ____ shortcut keys remove character formatting. A . CTRL+0 (zero) B . CTRL+I C . CTRL+SPACEBAR D . CTRL+U
C . CTRL+SHIFT+W
MC: The ____ shortcut keys underline words, and not spaces. A . CTRL+U B . CTRL+W C . CTRL+SHIFT+W D . CTRL+SHIFT+PLUS SIGN
B . AutoCorrect
MC: The _____ feature automatically corrects typing, spelling, capitalization, or grammar errors as you type them. A . AutoEntry B . AutoCorrect C . AutoAdd D . AutoSpell
B . New (blank)
MC: To add a record to a table, tap or click the ____ record button. A . Add New B . New (blank) C . Last D . Insert (New)
Flase
T/F: A thin red border indicates the active cell.
True
T/F: Both the Cancel box and the Enter box appear on the formula bar when you begin typing in a cell.
True
T/F: Each Office app has its own Help home page.
True
T/F: Graphics in documents help clarify and emphasize details so they appeal to audience members with different backgrounds.
True
T/F: If you want to move a table to a new location, point to the upper-right corner of the table until the table move handle appears, point to the table move handle, and then drag it to move the entire table to a new location.
False
T/F: It is not possible to use keywords to search for themes.
True
T/F: One method of changing the size of a window is to drag the window borders.
True
T/F: One way to distribute a document is to post it on cloud storage such as SkyDrive.
False
T/F: PowerPoint displays a few themes that are similar to one another
False
T/F: The NETWORKDAYS function checks a formula for correctness.
True
T/F: The asterisk (*) wildcard represents any collection of characters.
True
T/F: The path to the Logical button is (FORMULAS tab | Function Library group).
False
T/F: The question mark (?) wildcard represents any collection of characters.
True
T/F: The range of entries that identifies the major groups for a clustered column chart are called the category names.
True
T/F: The text in the accompanying figure shows shapes inserted and formatted.
True
T/F: To delete the contents of a cell, select the cell contents and then press the DELETE or BACKSPACE key.
True
T/F: When Excel cannot calculate a formula, it displays an error message in a cell.
False
T/F: You can use the asterisk (*) wildcard in a filter but not the question mark (?) wildcard.
False
T/F: You cannot preview the data to be updated in an update query before actually performing the update
D . CTRL+SHIFT+>
30. MC: To decrease a font size, use the ____ shortcut keys. A . CTRL+< B . CTRL+SHIFT+< C . CTRL+< D . CTRL+SHIFT+>
A . left-aligned
35. MC: By default, text is ____ in a cell. A . left-aligned B . centered C . justified D . right-aligned
D . CTRL+END
64. MC: To move to the end of the document, press the ____ key(s). A . DOWN ARROW B . END C . CTRL+DOWN ARROW D . CTRL+END
A . one
MC: The rule when using MLA style is to press the SPACEBAR ____ time(s) after periods, colons, and other punctuation marks. A . one B . two C . three D . either A or B
Slide indicator
SA: When you drag the scroll box, the _________________________ shows the number and title of the slide you are about to display.
True
T/F: A lookup field allows the user to select from a list of values when updating the contents of a field.
True
T/F: A nested IF function is one in which the action to be taken for the true or false case includes yet another IF function.
True
T/F: A requirements document includes a needs statement, source of data, summary of calculations, and any other special requirements for a worksheet.
False
T/F: When you create a calculated field, users can update the field.
False
T/F: When you enter text data in a criterion, you must enclose the text in quotation marks.
True
T/F: When you move a file, it no longer appears in the original folder.
False
T/F: When you tap or click the Enter box to complete an entry in a cell, the active cell moves down to the next cell in the same column.
False
T/F: Worksheet titles and subtitles should be as wordy as possible.
False
T/F: You can convert a Number field to a Currency field but you cannot convert a Currency field to a Number field.
D . CTRL+E
28. MC: The shortcut keys used to center a paragraph are ____. A . CTRL+T B . CTRL+M C . CTRL+SHIFT+T D . CTRL+E
B . Quick Access Toolbar
If you do not want to keep a change automatically made by Word and you immediately notice the automatic correction, you can undo the change by clicking the Undo button on the ____. A . Office Button menu B . Quick Access Toolbar C . ribbon D . any of the above
B . relative
MC: A ____ reference is an adjusted cell reference in a copied and pasted formula. A . revised B . relative C . recycled D . retained
A . offsets
MC: A background feature called _____ allows you to move the background from the slide borders in varying distances by a percentage. A . offsets B . onsets C . reduction D . expansion
D . footnote
MC: A note reference mark signals that an explanatory note exists at the bottom of the page as a(n) ____, as shown in the accompanying figure. A . keynote B . citation C . endnote D . footnote
A. Citation
MC: A tag name is an identifier that links a(n) ____ to a source. A . citation B . index C . attribute D . field
D . indirect
MC: A(n) ____ circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell. A . contiguous B . indexed C . direct D . indirect
F, Sub datasheet
Mod. T/F: When the Book Rep table is related to the Customer table, it is possible to view the customers of a given book rep when you are viewing the datasheet for the Book Rep table. The customers for the book rep will appear below the book rep in a split form . ____________________
True
Mod. T/F: Wildcards are symbols that represent any character or combination of characters. ____________________
Table
SA: A Word ____________________ is a collection of rows and columns.
Tab Stop
SA: A(n) ____________________ is a location on the horizontal ruler that tells Word where to position the insertion point when you press the TAB key on the keyboard.
Incline
SA: A(n) ____________________ object is an object that is part of a paragraph.
Bullet list
SA: A(n) _________________________ is a list of paragraphs, each of which is preceded by a bullet.
Satus bar
SA: As shown in the accompanying figure, the _________________________ shows the current page followed by the total number of pages in the document, the number of words in the document, and an icon to check spelling and grammar.
Selected
SA: Dashed lines around the border of a placeholder indicate that the placeholder is _________________________, as shown in the accompanying figure.
D . cloud
MC: Microsoft Office 365 uses the ____ to deliver a subscription-based service offering the newest Office suite and much more. A . app B . tile C . operating system D . cloud
D . >
MC: All of the following are valid Excel arithmetic operators EXCEPT ____. A . | B . * C . % D . >
D. Horizontal Ruler
MC: Although you can use a dialog box to indent paragraphs, Word provides a quicker way through the ____. A . Quick Access Toolbar B . Office Button menu C . vertical ruler D . horizontal ruler
C . Enter
MC: Clicking the ____ box completes an entry. A . Cancel B . Formula C . Enter D . Tab
C . saturation
MC: Color ____ changes the intensity of colors. A . tone B . density C . saturation D . brightness
A . cast
MC: Color ____ indicates that one color is dominating a picture. A . cast B . tone C . saturation D . hue
D . single-spaced, left-aligned, and a smaller font size than the text in the research paper
MC: Footnote text is _____. A . double-spaced, right-aligned, and a smaller font size than the text in the research paper B . double-spaced, left-aligned, and the same font size as the text in the research paper C . double-spaced, left-aligned, and a smaller font size than the text in the research paper D . single-spaced, left-aligned, and a smaller font size than the text in the research paper
D . all of the above
MC: 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
A . Exactly
MC: If the top of a set of characters is chopped off, the problem may be that the line spacing is set to ____. A . Exactly B . Cut C . About D . Near
B . Design view
MC: In the accompanying figure, the Book Rep table displays in ____. A . Structure view B . Design view C . Layout view D . Table view
D . primary key
MC: In the accompanying figure, the key symbol that appears in the row selector for the Book Rep Number field indicates that Book Rep Number is the ____ for the table. A . principal key B . foreign key C . main key D . primary key
A . row selector
MC: In the accompanying figure, the small box or bar to the left of each field is called the ____. A . row selector B . field selector C . field bar D . current field bar
B . Delete Field
MC: To delete a field in a table, press and hold or right-click the column heading for the field, and then tap or click ____ on the shortcut menu. A . Remove Field B . Delete Field C . Delete Column D . Remove Column
B . Insert Field
MC: To insert a field between existing fields, press and hold or right-click the column heading for the field that will follow the new field, and then tap or click ____ on the shortcut menu. A . Insert Column B . Insert Field C . Add Column D . Add Field
C . Replace
MC: To instruct PowerPoint to confirm each change, click the Find Next button in the ____ dialog box. A . Update B . Relocate C . Replace D . Find
B . CTRL+DOWN ARROW
MC: To move down one paragraph, press the ____ key(s). A . ALT+DOWN ARROW B . CTRL+DOWN ARROW C . DOWN ARROW D . F1
C . HOME
MC: To move to the beginning of a line with the keyboard, press the ____ key(s). A . LEFT ARROW B . CTRL+HOME C . HOME D . PAGE UP
A . ALT+CTRL+PAGE DOWN
MC: To move to the bottom of a document window, press the ____ key(s). A . ALT+CTRL+PAGE DOWN B . CTRL+PAGE DOWN C . ALT+PAGE DOWN D . PAGE DOWN
C . CTRL+RIGHT ARROW
MC: To move to the right one word, press the ____ key(s). A . ALT+RIGHT ARROW B . F1 C . CTRL+RIGHT ARROW D . RIGHT ARROW
B . ALT+CTRL+PAGE UP
MC: To move to the top of a document window, press the ____ key(s). A . CTRL+PAGE UP B . ALT+CTRL+PAGE UP C . PAGE UP D . ALT+PAGE UP
D . CTRL+UP ARROW
MC: To move up one paragraph, press the ____ key(s). A . F1 B . ALT+UP ARROW C . UP ARROW D . CTRL+UP ARROW
D . Design View
MC: To open a table in Design view, press and hold or right-click the table in the Navigation Pane and then tap or click ____ on the shortcut menu A . Table Design B . Layout View C . Structure View D . Design View
B . Format
MC: To show the symbol for the Euro instead of the dollar sign, change the ____ property for the field whose data type is Currency. A . Field Size B . Format C . Caption D . Description
C . ALT+ENTER
MC: To start a new line in a cell, press the ____ keys. A . CTRL+ENTER B . TAB+ENTER C . ALT+ENTER D . SHIFT+ENTER
A . 20xx
MC: When you enter a two-digit year that is less than 30, Excel changes the year to ____. A . 20xx B . 30xx C . 18xx D . 19xx
A . =23%
MC: Which of the following calculations multiplies 23 by 0.01? A . =23% B . =23 C . =23+.01 D . =24-.01
C . format
MC: You ____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand. A . save B . print C . format D . clear
A . F2
MC: You can place an insertion point by tapping or clicking in the field or by pressing ____. A . F2 B . F3 C . F4 D . F5
C . tiling
MC: You can use _____options to repeat a background image many times vertically and horizontally on a slide. A . formatting B . duplicating C . tiling D . arranging
B . Pattern fill
MC: ____ adds designs that repeat in rows across a slide. A . Solid fill B . Pattern fill C . Gradient fill D . Texture fill
A . Cloud computing
MC: ____ can help businesses be more efficient and save them money by shifting usage and the consumption of resources, such as servers and programs, from a local environment to the Internet. A . Cloud computing B . Operating systems C . Applications D . Databases
B . Grayscale
MC: ____ changes picture color into black, white, and shades of gray. A . Blackscale B . Grayscale C . Whitescale D . Colorscale
A . Recolor
MC: ____ effects convert colors in a picture to a wide variety of hues. A . Recolor B . Redesign C . Reorganize D . Repair
C . Office 2013
MC: ____ is the name of the perpetual software package that includes individual applications that can be installed on a single computer. A . Office 365 B . Microsoft Exchange C . Office 2013 D . Microsoft Office Web
A,B,C,D
MR: In addition to the core desktop Office suite, Office 365 provides access to ____. A. email B. calendars C. conferencing D. file sharing
A,B,C
MR: Office 365 website creation tools include those for adding ____. A. a theme B. graphics C. fonts D. a storage device
True
Mod. T/F: A crosstab query calculates a statistic for data that is grouped by two different types of information. ____________________
True
Mod. T/F: A default value is a value that Access will display on the screen in a particular field before the user begins adding a record. ____________________
False, its foreign
Mod. T/F: A secondary key is a field in one table whose values are required to match the primary key of another table. ____________________
False, aggregate
Mod. T/F: A summary function is a function that performs some mathematical function against a group of records. ____________________
False, theme
Mod. T/F: Each document format determines the color scheme, font set, and layout of a presentation. _________________________
Building block
SA: If the same text or graphic is used frequently, you can store the text or graphic as a(n) ____________________ and then insert the stored entry in the open document, as well as in future documents.
Multi-value
SA: If you plan to move your data to SQL Server at a later date, do not use ____________________ fields.
sections
SA: In OneNote, the pages are grouped into _________________________.
Clear Formatting
SA: In Word, the term, ____________________, refers to returning the formatting to the Normal style.
Worksheets
SA: Inside a workbook in Excel are sheets, each of which is called a(n) _________________________.
Reconstruction the database
SA: Maintenance of a database can involve the need to _________________________ periodically; that is, to change the database structure.
Oral
SA: One of the more common uses of a presentation is to enhance a(n) _________________________ presentation.
Shift+>
SA: One way to increase font size is to press CTRL+ _________________________.
Wrep
SA: PowerPoint 2013 does not allow you to _________________________ text around a picture or other graphic.
Left
SA: PowerPoint inserts text to the _________________________ of the insertion point.
Thesaurus
SA: PowerPoint provides a(n) ____________________, a list of synonyms and antonyms, to help you find replacement words.
Nonbreaking Hyphen
SA: Press CTRL+SHIFT+HYPHEN to enter a(n) ____________________, which is a special type of hyphen that prevents two words separated by a hyphen from splitting at the end of a line.
Shift+Tab
SA: Press the ____________________ key(s) to select the previous cell from the one in which the insertion point appears.
Ignore
SA: Pressing the _________________________ button when a word is highlighted on the Spelling pane causes PowerPoint to flag that word again if it appears later in the document.
F5
SA: Pressing the _________________________ function key runs the slide show starting with the first slide
CTRL+P
SA: Pressing the _________________________ keyboard shortcut keys displays the Print tab in Backstage view.
Find and replace
SA: The ____________________ feature automatically locates specific text and then replaces it with desired text.
Fill months
SA: The ____________________ option on the Auto Fill Options menu fills the destination area with a series of
Quick access tool bar
SA: The _________________________ provides convenient, one-tap or one-click access to frequently used commands.
Drag & Drop
SA: The process of sliding or dragging and then dropping a thumbnail in a new location is called _________________________.
Keyboard shortcut
SA: When the Paste Options button is visible, you can use ____________________ to access the paste commands available in the Paste Options gallery.
In the center
SA: When you insert a clip on a slide without a clip content placeholder, the clip is inserted ________________________ of the slide, as shown in the accompanying figure.
Tilling percent
SA: With tiling options, the smaller the ____________________, the greater the number of times an image is repeated.
Custom
SA: You can create your own ____________________ fill sequences for use with the fill handle
Row boundary
SA: You can drag a(n) ____________________, which is the border at the bottom of a row, until the row is the desired height.
Low from query
SA: You can restore filter settings that you previously saved in a query by using the ____________________ command on the Advanced menu.
Transparency
SA: You can tap or click the up or down arrows in the Transparency box to move the ____________________ slider in the Format Background dialog box in one-percent increments.
work error
SA: You work on objects such as tables, forms, and reports in the Access _________________________.
offset
SA: ____________________ is a background feature that allows you to move the background from the slide borders in varying distances by percentages.
Fill series
SA: ____________________ is the default option that Excel uses to fill an area with the Auto Fill Options menu.
Floating
SA: ____________________ objects give you more flexibility because you can position them anywhere on the page.
Printing
SA: _________________________ a presentation enables you to distribute the document to others in a form that can be read or viewed but typically not edited.
Navigation
SA: _________________________ is the process of finding a location on a storage device.