Term
| Which does NOT reflect an item that the designer must verify PRIOR to creating the database? |
|
Definition
| Colors or design elements to include |
|
|
Term
| If an object's property sheet is NOT visible in the object's design view, the method to open it requires: |
|
Definition
| Clicking the Property Sheet Command on the object's design tab. |
|
|
Term
| When entering data into a table which is NOT a method to correct typing errors? |
|
Definition
| Delete the entire record, by clicking the record selector and choosing the delete command |
|
|
Term
| Which is NOT a file type that may be imported into Microsoft Access 2010? |
|
Definition
| Microsoft Publisher files (.pub) |
|
|
Term
| What provides a printable map of how database tables are related? |
|
Definition
|
|
Term
| Which is NOT a comparison operator used to evaluate a field value to determine if a specific criterion is met? |
|
Definition
|
|
Term
| The command that creates a Microsoft Access 2010 report without predefined labels and fields is called a: |
|
Definition
|
|
Term
| What is NOT a modification that is applied to a report's layout? |
|
Definition
| Setting up the report to print in landscape format. |
|
|
Term
| Which view in Access 2010 contains the command to create a new database? |
|
Definition
|
|
Term
| What is the purpose of creating and saving a database before it is completed? |
|
Definition
| To enable Access to automatically save data as changes are made |
|
|
Term
| What appears at the top of the Access work area to indicate objects that are open? |
|
Definition
|
|
Term
| In Access 2010, which area provides indicators and buttons based on information you type or tasks that are performed? |
|
Definition
|
|
Term
| Which of the following is considered the control center for Access 2010 and provides easy, central access to the commands needed to perform various tasks? |
|
Definition
|
|
Term
| Which Access 2010 feature provides on-screen notes containing the name of the command, available keyboard shortcuts, a description of the command, and directions for getting help using the command? |
|
Definition
|
|
Term
| What is the name of the small arrow in the lower right corner of a Ribbon group that provides access to additional options for the group? |
|
Definition
|
|
Term
| When a user of Access 2010 right clicks on an object, what is the name of the list of frequently used commands that displays? |
|
Definition
|
|
Term
| Which key on the keyboard is used to display KeyTip in Access 2010? |
|
Definition
|
|
Term
| In a table, what contains a specific piece of information within a row? |
|
Definition
|
|
Term
| In a table, which is a way of exclusively identifying each record in the database? |
|
Definition
|
|
Term
| In a table, which of the following contains information about a given person, product, or event? |
|
Definition
|
|
Term
| Which of the following is a table data type that contains only monetary data? |
|
Definition
|
|
Term
| Which term refers to storing the same field in more than one location in a database? |
|
Definition
|
|
Term
| Which view displays the area used to create a table or modify the structure of a table? |
|
Definition
|
|
Term
| Which is a mandatory selection when adding new fields to a table? |
|
Definition
|
|
Term
| After designing a table, what must a user do before exiting the table? |
|
Definition
|
|
Term
| In the table design view, which area contains commands for designating a specific field size? |
|
Definition
|
|
Term
| Where is the command to undo your most recent change in Access 2010 located? |
|
Definition
|
|
Term
| When operating an Access 2010 Database, why would a security warning appear below the Ribbon area? |
|
Definition
| To notify you that some content is disabled due to your computer's security settings |
|
|
Term
| Which print orientation displays the printout across the 11 inch width of the page? |
|
Definition
|
|
Term
| Which feature of Access 2010 corrects common mistakes when entering text into a cell? |
|
Definition
|
|
Term
| In a database, where is the command for creating a new table from Table Design View located? |
|
Definition
|
|
Term
| What are questions asked of a database in which the answers are given through the data in the database called? |
|
Definition
|
|
Term
| What type of Query is used when no restrictions, calculations, or special order must be applied to the data? |
|
Definition
|
|
Term
| In a Query, what condition must the records that are included satisfy? |
|
Definition
|
|
Term
| How is a Query stored after it is created and saved? |
|
Definition
|
|
Term
| Which view is used to preview a Report on screen but prevents changes to the Report from being made? |
|
Definition
|
|
Term
| Which view is used to preview a Report on screen and allows changes to be made to the Report? |
|
Definition
|
|
Term
| Which Ribbon contains the commands to remove, add, or resize columns in a Report? |
|
Definition
| Report Layout Tools Design |
|
|
Term
| Which Group on the Report Layout Tools Design Ribbon contains the command to include an automatic calculation on a Report? |
|
Definition
|
|
Term
| What are details about a file that are used to help organize and identify the database called? |
|
Definition
|
|
Term
| What is the process of returning a damaged or failed database to its correct state called? |
|
Definition
|
|
Term
| Which term describes the process of periodically making a copy of a database to protect it in the event of failure or damage? |
|
Definition
|
|
Term
| What are symbols that represent any character or combination of characters and are commonly used to specify the criterion in a Query called? |
|
Definition
|
|
Term
| Which view allows a user to specify fields, criteria, sorting, and calculations when creating a Query? |
|
Definition
|
|
Term
| In Microsoft Excel 2010, what is the area that contains gridlines and is made up of row and columns called? |
|
Definition
|
|
Term
| Which area of the Microsoft Excel 2010 window displays the name of the workbook that is active? |
|
Definition
|
|
Term
| When saving a file in Microsoft Excel 2010, which symbol is NOT to be used in the file name? |
|
Definition
|
|
Term
| When entering data into a cell, which keyboard key is used to move characters to the right of the insertion point? |
|
Definition
|
|
Term
| Which button appears when cells are filled with data in a series? |
|
Definition
|
|
Term
| In Microsoft Excel 2010, what is the name of the pop-ups that appear near the active cell? |
|
Definition
|
|
Term
| What is the proper method for adding (inserting) columns into a worksheet? |
|
Definition
| Click the Insert button on the Home ribbon and choose the Insert Column option |
|
|
Term
| What method is used in conjunction with the mouse to change the height of a column in Microsoft Excel 2010? |
|
Definition
| Click and drag the boundary line between rows |
|
|
Term
| Which number format button does NOT appear in the Format group on the Home ribbon? |
|
Definition
|
|
Term
| On multi-page worksheets, what page layout option should you choose in order to have information repeated along the top of each page and make the data easily readable? |
|
Definition
| Rows to repeat at the top |
|
|
Term
| The command on the Page Layout ribbon that refers to data printed on the top of each worksheet page is the: |
|
Definition
|
|
Term
| What command on the Home ribbon allows the user to search for AND replace specific text in a worksheet are? |
|
Definition
|
|
Term
| Which command appears in the lower right corner of pasted cells and enables the user to specify how to past the information? |
|
Definition
|
|
Term
| Which feature is a temporary storage location for items that have been copied or cut from a worksheet? |
|
Definition
|
|
Term
| What is the proper procedure for deleting an unwanted worksheet from a workbook? |
|
Definition
| Right-click the unwanted sheet tab and choose Delete from the shortcut menu |
|
|
Term
| Which command in the Print tab backstage view must be selected to print all sheets in a workbook? |
|
Definition
|
|
Term
| Where is the command to create a new folder in the user's storage device for Microsoft Excel 2010 files located? |
|
Definition
|
|
Term
| In Microsoft Excel 2010, which is a graphical representation of data that is created from information in a workbook? |
|
Definition
|
|
Term
| Since cells in a chart are linked to the data in the worksheet, how would you update data on a chart? |
|
Definition
| Change the data on the corresponding worksheet, and the chart will automatically be updated. |
|
|
Term
| Which built-in Microsoft Excel 2010 feature ensures that data entered into a cell range of cells is within limits? |
|
Definition
|
|
Term
| In Microsoft Excel 2010, a single character, word, or phrase is referred to as the: |
|
Definition
|
|
Term
| Which Query type is flexible and prompts the user for input whenever it is used? |
|
Definition
|
|
Term
| Which type of operator enables a user to equate two values in a Query criterion? |
|
Definition
|
|
Term
| Which operator must be used for a compound criterion to be true if either criterion provided is true? |
|
Definition
|
|
Term
| Which term refers to a field that can be computed from other fields in a database? |
|
Definition
|
|
Term
| Which dialog box accessed through Query Design View is used to manually enter an expression for a field? |
|
Definition
|
|
Term
| Which command on the Home Ribbon is used to search for records that satisfy a specific criterion? |
|
Definition
|
|
Term
| Which command on the Home Ribbon is used to search a field for a collection of selected characters? |
|
Definition
|
|
Term
| Which command on the Access 2010 Home Ribbon is used to change the display between filtered and unfiltered records in a table? |
|
Definition
|
|
Term
| What occurs when a user violates a rule while entering data in a table? |
|
Definition
|
|
Term
| What are the rules that a user must follow when entering data into a table? |
|
Definition
|
|
Term
| What is a quick, step-by-step process for creating a report in Access 2010? |
|
Definition
|
|
Term
| Which of the following is divided into various sections to help clarify the presentation of the data from the database? |
|
Definition
|
|
Term
| Which ribbon displays commands for modifying settings on how a report prints? |
|
Definition
| Report Design Tools Page Setup Ribbon |
|
|
Term
| Which view enables a user to manually create single or multiple-table reports? |
|
Definition
|
|
Term
| Which of the following is a guide that aligns controls to give a form a uniform appearance? |
|
Definition
|
|
Term
| Which layout arranges controls vertically with labels to the left of the control? |
|
Definition
|
|
Term
| What type of field is created when an image needs to be included in a table? |
|
Definition
|
|
Term
| In a form, how does a user prevent a control from being selected by tabbing? |
|
Definition
|
|
Term
| When using external data in an Access 2010 database, which option allows data to remain connected to its original source? |
|
Definition
|
|
Term
| When viewing a table in Datasheet view, whcih area shows the total number of records in the table? |
|
Definition
|
|
Term
| In datasheet view, what type of field displays the last part of the data first? |
|
Definition
|
|
Term
| Which button is used to display or hide the navigation pane in the Access 2010 window? |
|
Definition
| Open/Close button on the Shutter Bar |
|
|
Term
| When working in Access 2010, what is a quick method for viewing the database files that were last worked on? |
|
Definition
|
|
Term
| Which window displays information about an active cell and allows formulas to be edited? |
|
Definition
|
|
Term
| The area of the Microsoft Excel that contains the view and zoom buttons is known as the: |
|
Definition
|
|
Term
| What are the lines, veritical and horizontal, in a worksheet called? |
|
Definition
|
|
Term
| What is the area with a thick black border in a worksheet called? |
|
Definition
|
|
Term
| What helps in navigating a worksheet? |
|
Definition
|
|
Term
| What is the process for selecting all information in a worksheet? |
|
Definition
| Click Select All button in the upper left corner of the worksheet or use the keyboard combination of CTRL + A. |
|
|
Term
| How do you place a cursor in a cell and edit the text? |
|
Definition
|
|
Term
| Where is the command to save a workbook? |
|
Definition
|
|
Term
| Which Microsoft Excel 2010 feature automatically inserts data into a cell begins with the same characters as a previous entry? |
|
Definition
|
|
Term
| Which feature automatically corrects common typographical errors? |
|
Definition
|
|
Term
| Which symbol must be keyed in first to signify that a formula is being typed into an active cell? |
|
Definition
|
|
Term
| How do you use the mouse to change the width of a column in worksheets? |
|
Definition
| Click and drag the boundary line between columns |
|
|
Term
| What key will allow the user to select non-adjacent cells? |
|
Definition
|
|
Term
| What adds a range of cells together and divides them by the number of entries? |
|
Definition
|
|
Term
| What part of the formula is entered directly as a value? |
|
Definition
|
|
Term
| Which function will find the minimum value in a selected area? |
|
Definition
|
|
Term
| What function finds the maximum value in a range? |
|
Definition
|
|
Term
| If the data is too large for the cell and is typed into the adjacent cells where data is already located, what happens to the data? |
|
Definition
| The overlapping data is truncated. |
|
|
Term
| Aligning data within a cell is completed by clicking on which group on the Home ribbon? |
|
Definition
|
|
Term
| How do you add a border to worksheet cells? |
|
Definition
| Select cells and choose the Border command from the Home ribbon |
|
|
Term
| How do you cancel out the last action in a worksheet? |
|
Definition
|
|
Term
| How do you copy formatting to different locations in the worksheet? |
|
Definition
|
|
Term
| What allows the user to control the amount of space between the data and the edge of the paper? |
|
Definition
|
|
Term
| What controls the landscape or portrait print function? |
|
Definition
|
|
Term
| The command on the Page Layout ribbon that refers to data printed on the top of each worksheet page is the: |
|
Definition
|
|
Term
| What is the data printed on the bottom of each worksheet page? |
|
Definition
|
|
Term
| What command looks for specific text in a worksheet? |
|
Definition
|
|
Term
| The commond that checks for incorrect spelled words is: |
|
Definition
|
|
Term
| Which method is used to select non-adjacent worksheet tabs? |
|
Definition
| Click first tab, hold down SHIFT key and click next tab |
|
|
Term
| Where are the command buttons to cut, copy, or paste items in Microsoft Excel 2010 located? |
|
Definition
|
|
Term
| What allows the user to organize multiple workbook windows so that all are visible? |
|
Definition
|
|
Term
| What is the data connection between workbooks called that maintains control over critical data? |
|
Definition
|
|
Term
| Why do users want to modify an existing style? |
|
Definition
| Once modified, all cells formatted with that style will be automatically updated |
|
|
Term
| What is the process for creating a hyperlink to an existing web page in Microsoft Excel 2010? |
|
Definition
| Type in the web address and by default automatic hyperlink formatting is turned on. |
|
|
Term
| Which ribbon will the user click to open a workbook? |
|
Definition
|
|
Term
| Which ribbon is available when a chart is selected and attempting to delete chart labels? |
|
Definition
|
|
Term
| Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data? |
|
Definition
|
|
Term
| What area of Access Options is used to remove personal information from file properties when saving the database file? |
|
Definition
|
|
Term
| When referring to the name of a stored database file, what is the term for the storage drive letter and a colon used to identify the storage device then the file name? |
|
Definition
|
|
Term
| Which command on the Create Ribbon automatically creates or inserts portions of a database? |
|
Definition
|
|
Term
| How would a user hide a row or column from view without permanently deleting the information? |
|
Definition
| Choose the Hide command on the Shortcut menu |
|
|
Term
| Which command on the Create Ribbon automatically creates a form based on a selected table? |
|
Definition
|
|
Term
| Which group on the Create Ribbon provides a wizard for creating standard or customized labels? |
|
Definition
|
|
Term
| What command on the Create Ribbon enables a user to determine the location of tabs on a form? |
|
Definition
|
|
Term
| What form type is selected if a user wants to manually format, design, and arrange controls on the form? |
|
Definition
|
|
Term
| What type of form contains more than one page of information and has tab controls to provide access to additional pages in the form? |
|
Definition
|
|
Term
| Which command enables a user to print a table definition showing field names, field types, and descriptions in a selected table? |
|
Definition
|
|
Term
| Which command enables a user to copy formats from one selection and apply them to another selection? |
|
Definition
|
|
Term
| What is an object added to a form where there is an action subsequently taken when the object is called? |
|
Definition
|
|
Term
| Which term refers to a series of recorded actions that direct Access 2010 to perform when a particular event occurs? |
|
Definition
|
|
Term
| What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook? |
|
Definition
|
|
Term
| Which function key quickly opens the Microsoft Office Excel 2010 Online Help window? |
|
Definition
|
|
Term
| What command totals related data in several rows by inserting totals for selected cells? |
|
Definition
|
|
Term
| What command specifies complex criteria to limit which records are included in the result set of a query? |
|
Definition
|
|
Term
| Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet? |
|
Definition
|
|
Term
| Which command creates decorative text in a worksheet? |
|
Definition
|
|
Term
| Which file contains data fields separated by a special character such as a comma? |
|
Definition
|
|
Term
| What is the process of bringing data containing text fields separated by commas into Excel called? |
|
Definition
|
|
Term
| Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets? |
|
Definition
|
|
Term
| What is the process of viewing a PivotTable report for a subset that meets the criterion only? |
|
Definition
|
|
Term
| Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable? |
|
Definition
|
|
Term
| What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts? |
|
Definition
|
|
Term
| Which is the name of an interactive graphical representation of data that allows a user to change the groupings? |
|
Definition
|
|
Term
| When sorting data in a table, which fields are selected as fields to sort by? |
|
Definition
|
|
Term
| Which technique uses the table column heading arrows to narrow data in a table to show only specific items meeting a desired criterion? |
|
Definition
|
|
Term
| Which dialog box allows a user to select the first row as the table's header row? |
|
Definition
|
|
Term
| Which ribbon includes the commands to apply a quick table style to a range of cells? |
|
Definition
|
|
Term
| What is a range that spans two or more sheets in a workbook? |
|
Definition
|
|
Term
| Which term describes the process of creating a formula that refers to a cell in the same location but on separate sheets in a workbook? |
|
Definition
|
|
Term
| Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened? |
|
Definition
|
|
Term
| Which command do you use to remove manual page breaks from a worksheet area? |
|
Definition
| Select Remove Page Break from the Breaks drop-down area |
|
|
Term
| What is the name of the dialog box that contains the commands to center a worksheet on the page both vertically and horizontally? |
|
Definition
|
|
Term
| What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page? |
|
Definition
|
|
Term
| How do you move from one worksheet to another within the same workbook? |
|
Definition
|
|
Term
| What command do you use to copy cell formatting from one cell to another in a worksheet? |
|
Definition
|
|
Term
| Which Chart Tools Ribbon tab enables a user to add pictures, shapes, or textboxes to a chart area? |
|
Definition
|
|
Term
| Which is a graphical representation used in statistical or scientific data to show the degree of uncertainty relative to each data marker in a series? |
|
Definition
|
|
Term
| Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles? |
|
Definition
|
|
Term
| What can you use to easily filter pivot tables and cube functions interactively in a worksheet? |
|
Definition
|
|
Term
| What ribbon contains the commands for creating charts in Excel 2010? |
|
Definition
|
|
Term
| What two options are offered when a user elects to move a chart? |
|
Definition
|
|
Term
| What term refers to an Excel Chart with offset pieces? |
|
Definition
|
|
Term
| Which command on the Page Layout Ribbon enables a user to mark the exact area of the worksheet to print? |
|
Definition
|
|
Term
| Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings? |
|
Definition
|
|
Term
| What command will tile Excel 2010 windows and all other open program windows so that they appear side by side on the screen? |
|
Definition
|
|
Term
| Which command creates a new view of the current document in a separate window? |
|
Definition
|
|
Term
| Which function do you use along with logical operators such as AND, OR, and NOT to make decisions based upon a condition? |
|
Definition
|
|
