Term
| A workbook with 12 worksheets would be saved as ________ file(s) |
|
Definition
|
|
Term
| The ________ is displayed in teh image below |
|
Definition
|
|
Term
| _______ can be one cell or a group of cells |
|
Definition
|
|
Term
| ______ are used to document specifics of cell content and are avilable as a frame of reference for users of a workbook |
|
Definition
|
|
Term
| What is the effect of typing F5+F6 into a cell without a beginning equal sign? |
|
Definition
| The entry will be treated as text entry and display F5+F6 in the cell |
|
|
Term
| The _________ is found in the bottom right hand corner of an active cell |
|
Definition
|
|
Term
| The types of cell referencing available in Excel are mixed, absolute, and: |
|
Definition
|
|
Term
| To copy a formula across a range of cells and have the formula automatically update the cell row and column, use the ____________ cell referencing |
|
Definition
|
|
Term
| To display cell formulas, click the ___________ + ~ Keys |
|
Definition
|
|
Term
| Parameters in an IF function can be _______, value, a formula, or a nested function |
|
Definition
|
|
Term
| To display similar data in a single column, with each series of data distinguished by a different color, use a: |
|
Definition
|
|
Term
| The ________ tab is where you will find options to change the source data of a chart |
|
Definition
|
|
Term
| The same data range is used as the basis for an embedded pie chart, as well as a column chart in a chart sheet. Which chart(s) will change if you change the values in a data range? |
|
Definition
| Both the pie chart and the column chart |
|
|
Term
| ____________ column and row headings enable you to view data easily in a large spreadsheet |
|
Definition
|
|
Term
| The command to hide and unhide columns and rows is round in the __________ groups in the Format menu |
|
Definition
|
|
Term
| Cells must be ______________ and the sheet protected to prevent edits being made to the data |
|
Definition
|
|
Term
| To add a second level to a sort, use the ______ option in the sort dialog box. |
|
Definition
|
|
Term
| Which of the following statements about the Autofilter command is true? |
|
Definition
| If two criteria are entered, records must meet both conditions to be selecteD |
|
|
Term
| Clickable text or objects that can be used to connect documents on the WWW are: |
|
Definition
|
|
Term
| The ____________ view is in Sharepoint designer 2007 can be used to manage the flow of a web site. |
|
Definition
|
|
Term
| The ______ view in Sharepoint Designer 2007 can be used to synchronize files with those created on your local slide |
|
Definition
|
|
Term
|
Definition
| a file that launches when a hyperlink is clicked |
|
|
Term
| the remote website view can be used to publish |
|
Definition
|
|
Term
| the process of coordinating changes made on a local site witha remote site so that the two are identical is known as: |
|
Definition
|
|
Term
| The ________ report contains comprehensive information about a Web site, such as unlinked files and slow pages |
|
Definition
|
|
Term
| In Sharepoint designer 2007 report that displays links targeting unavailable files is the _______ report |
|
Definition
|
|
Term
| Access permissions can be used to perform which of the following task? |
|
Definition
| All user roles can be assigned except that of administrator |
|
|
Term
| The page banner displays the web page _______ as they appear in Navigation view |
|
Definition
|
|
Term
| To add a marquee to a web page |
|
Definition
| click dynamic effects in the insert web component diaglog |
|
|
Term
| An advanced control that in normally used by Web designers to add animation and music is a(n): |
|
Definition
|
|
Term
| A software application that gives a browser additional multimedia capability is a(n) |
|
Definition
|
|
Term
| A streaming video file displays a _________ set of images |
|
Definition
|
|
Term
| ________ files are NOT used as animated images in sharepoint designer |
|
Definition
|
|
Term
| _________ files DO NOT support transparent colors |
|
Definition
| joint photographic experts group |
|
|
Term
| Use the ____________ task pane to search a comprehensive collection of media files |
|
Definition
|
|
Term
| The crop button can be used if |
|
Definition
| you want to remove a portion of the picture |
|
|
Term
| Which statement best describes what happens after editing and saving a data record? |
|
Definition
| Undo can be used only before advancing to a different record |
|
|
Term
| Data validation best refers to: |
|
Definition
| preventing duplicate records from being entered into a table |
|
|
Term
| Which statement best describe the following image? |
|
Definition
| one record displayed in a form |
|
|
Term
| Which statement best describe the following image? |
|
Definition
|
|
Term
| Fields are added, deleted, edited and defined through the: |
|
Definition
|
|
Term
| Which of the following would ensure that a value of 15 or greater is entered in a field? |
|
Definition
|
|
Term
| Which is NOT true of validation rules? |
|
Definition
| They protect from fraudulent practices |
|
|
Term
| Which is NOT true of a calculated field? |
|
Definition
| Calculated fields should be stored in a table |
|
|
Term
| Data that is organized and summarized in an easy to read view is known as a: |
|
Definition
|
|
Term
| From the following example, which does NOT apply to this view? |
|
Definition
| The design view of the table is displayed |
|
|
Term
| Which statement is NOT true of the following image display? |
|
Definition
| The display shows that data will definately be lost when the "Yes" button is clicked. |
|
|
Term
| Which statement is NOT true when referential integrity is enforced |
|
Definition
| Access checks the accuracy of spelling in the tables |
|
|
Term
| Which does NOT describe queries? |
|
Definition
| They are run from a table Datasheet view |
|
|
Term
| Which is an example of an expression that will return records that are from either of two states? |
|
Definition
|
|
Term
| Which is NOT true of birth date field? |
|
Definition
| Using an age field, which shows how old a person may be, is the same as a birth date field. |
|
|
Term
| In the following figure, which letter represents the option for slide layout? |
|
Definition
|
|
Term
| Which of the following are examples of special theme effects? |
|
Definition
|
|
Term
| What indicates a misspelled word? |
|
Definition
|
|
Term
| IN the following figure, which letter represents the tab used to place a table in a presentation? |
|
Definition
|
|
Term
| If you are creating a document that needs a diagram to illustrate a process, use |
|
Definition
|
|
Term
|
Definition
| A series of combined shapes |
|
|
Term
| To what does aspect ratio refer? |
|
Definition
|
|
Term
| When stacking objects, the last object |
|
Definition
| has the highest stacking order |
|
|
Term
| If a level is less important it should be |
|
Definition
|
|
Term
| When an outline is collapsed, only the ______ of the slides are displayed in the Outline View |
|
Definition
|
|
Term
| If you wish to move a slide in the OUtline View, you should |
|
Definition
| drag to the desired location |
|
|
Term
| Which of the following is a feature of the reuse slides task panes? |
|
Definition
|
|
Term
| If you crop an image and then try to enlarge the image: |
|
Definition
| it may appear as pixilated |
|
|
Term
| Which of the following options can be used to save a picture from the Internet? |
|
Definition
| Right-click on the image and choose save picture as |
|
|
Term
| Which of the following options can be used to savea a picture from the internet? |
|
Definition
| Right-click on the image and choose Save Picture as |
|
|
Term
| Which of the following is NOT true when photo albums are created: |
|
Definition
| They are time consuming to design |
|
|
Term
| Which area allows you to apply a frame to a photo album? |
|
Definition
|
|
Term
| When lines of text are straight on the left and right margins, such as most newspaper columns, the test is: |
|
Definition
|
|
Term
| To keep all lines of a paragraph together on the same page, use the _________ option |
|
Definition
|
|
Term
| In the following image, dragging the small recangle on the ruler bar will: |
|
Definition
|
|
Term
| Spacing before and after paragraphs is increased or decreased in |
|
Definition
|
|
Term
| Which of the following is NOT implemented at the section level? |
|
Definition
|
|
Term
|
Definition
|
|
Term
| When you press the Tab key from the last cell in a table, what happens? |
|
Definition
|
|
Term
| Use the __________ command on the layout tab to join two or more cells together? |
|
Definition
|
|
Term
| To divide a cell into different cells, use the __________ command |
|
Definition
|
|
Term
| One easy way to select a table is to click |
|
Definition
| select in the table group on the layout |
|
|
Term
| The _______________ pane shows all comments and editoral changes made to a document |
|
Definition
|
|
Term
| The show Markup feature enables you to |
|
Definition
| see all revisions in a document or just certain ones |
|
|
Term
| What feature monitors all additions, deletions, and formatting changes in a document? |
|
Definition
|
|
Term
| What happens when a revision is accepted or rejected? |
|
Definition
| The revision mark disappears |
|
|
Term
| The two option listed with the display for review are: |
|
Definition
|
|
Term
| You can insert footnotes and endnotes from the _________ tab |
|
Definition
|
|
Term
| Where is the status bar located in Office 2007? |
|
Definition
|
|
Term
| What do the shortcut keys Ctrl+S do? |
|
Definition
|
|
Term
| How can you save a file as a different type? |
|
Definition
| Use the save as version box |
|
|
Term
| What is the print preview command found? |
|
Definition
|
|
Term
| If you've spelled a client's name as Jamison and find out that it's Jammison, use the __________ feature to change the occurrences. |
|
Definition
|
|
Term
| Where is the Undo button found? |
|
Definition
| On the Quick Access Toolbar |
|
|
Term
| What HTML language is composed of special symbols called: |
|
Definition
|
|
Term
| Which of the following is a network in which computers are located physically close together, often in the same buidling? |
|
Definition
|
|
Term
| Which protocol is used to upload and download files from Web servers? |
|
Definition
|
|
Term
| What is a single document on the web called? |
|
Definition
|
|
Term
| Which is a place on the screen you can click to navigate to another web page? |
|
Definition
|
|
Term
| In Windows Vista, a window arrangement where open windows are placed on top of each other, with only a small segment of the background window showing is called: |
|
Definition
|
|
Term
| The Windows Vista program that is used for creating and managing folders is |
|
Definition
|
|
Term
|
Definition
| contains files deleted from the hard drive |
|
|
Term
| Each window contains control buttons. They are: |
|
Definition
| Minimize, Maximinze, Restore, Close |
|
|
Term
| Small pictures on the desktop representing programs, files, folders, or shorcuts are called: |
|
Definition
|
|
