Microsoft Excel & Acces Exam Review
Which area displays and enables the use of database objects such as tables, forms, and reports in the Access 2010 program?
Access work area
Which term describes a Ribbon tab that appears in a lighter color with its associated Ribbon visible?
Active Ribbon
What command specifies complex criteria to limit which records are included in the result set of a query?
Advanced Filter
Which command on the Create Ribbon automatically creates or inserts portions of a database?
Application Parts
Which technique uses the table column heading arrows to narrow data in a table to show only specific items meeting a desired criterion?
AutoFilter
Which of the following is NOT a Freeze Panes option A- Freeze Panes B- Freeze current area C- Freeze top row D- Freeze first column
B
Which keyboard key is used to remove incorrect characters while keying data into a database table?
Backspace
In Access 2010, what is the process of converting an unbound control into a bound control called?
Binding
What form type is selected if a user wants to manually format, design, and arrange controls on the form?
Blank Form
Which of the following is NOT an appropriate worksheet tab name? A- Employees B- Staff Information C- Employee and Staff Information Sheet D- Employee Information
C
On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called?
Calculated field
Which command on the Formulas Ribbon enables a user to specify when a formula is computed?
Calculation
What is an example of an acceptable database file name?
Car_Truck database.accdb
If you want to hide a row or column from view without permanently deleting the information, what would you do?
Choose hide command on shortcut menu
How do you select non-adjacent cells in a worksheet?
Click first tab, hold down CTRL tab, then click other tab
How do you select non-adjacent worksheet cells?
Click first tab, hold down CTRL, click next tab
Which area of Access Options is used to set the default database theme for a new Access 2010 database?
Client Settings
Which Command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
Clip Art
What is the name of the temporary storage location for text that is cut or copied from a database?
Clipboard
What is the purpose of the +/- buttons that appear across the categories on a PivotTable?
Collapse/Expand
Which form control is a combination of a text box & list box?
Combo box
What is an object added to a form where there is an action subsequently taken when the object is called?
Command button
What is the process of combining two or more text/data items into a single expression in a Report called?
Concatenation
Which is a method of creating a report contained within another report?
Creating a subreport
What keyboard shortcut automatically saves a worksheet with the current name & in the current location?
Ctrl+S
What keyboard shortcut will undo the last action in a worksheet?
Ctrl+Z
Which command enables a user to print a table definition showing field names, field types, & descriptions in a selected table?
Data document
What type of software enables a user to create a database, add, change, and delete data in the database, query the database, and present the result of the database?
Database Management Software
If you want to reduce the margin between the border & text in a cell, you would use what command?
Decrease indent
If you want to reduce the margin between the border and the text in a cell, what command would be used?
Decrease indent
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Defined Names
Which file contains data fields separated by a special character such as a comma?
Delimited File
Which ribbon is visible when a PivotTable is selected, & allows a user to apply various styles to the Pivot Table?
Design
Which ribbon is visible when a PivotTable is selected, & allows a user to apply various styles to the PivotTable?
Design
Which tab on the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
Design
Print area is defined as:
Determines part of worksheet that prints
Print area is defined as..
Determines what part of a worksheet prints
Which keyboard key is used if a user appears to be "stuck" on a record so that Access will not allow movement to another record or allow the user to close the table?
Escape
Which function key quickly opens the Microsoft Office Excel 2010 Online Help window?
F1
Footers will be printed immediately below the last line of data on the worksheet
False
Hiding worksheet data will delete the data
False
Once a new sheet is inserted into a workbook, it must remain in the location where it was inserted.
False
Once a page break is inserted, it cannot be removed
False
The only way to copy a worksheet in a workbook is to use the copy command on the shortcut menu
False
What are the individual data items that make up a record in a table called?
Field
When creating a PivotTable, which are drawn in columns in the worksheet data?
Fields
Which tab do you use to display the area that contains the print command?
File
What is the process of viewing a PivotTable report for the subset that meets the criterion only?
Filtering
_____ temporarily hides records that do not meet a specific criterion
Filtering Data
What does a form control have when it becomes active?
Focus
Which command on the Create Ribbon automatically creates a form based on a selected table?
Form
On the Home Ribbon, which command would you select to format row height & column width, organize sheets, and protect or hide cells in a worksheet?
Format
Which command enables a user to copy formats from one selection & apply them to another section?
Format Painter
Which dialog box allows a user to select the first row as the table's header row?
Format as table
Which group on the Formulas Ribbon contains the command that checks for common errors in a formula?
Formula Auditing
Which command group on the Formulas Ribbon allows a user to choose from various catagories of functions to use in a worksheet?
Function Library
Which command on the Home Ribbon enables a user to quickly navigate to the last record in an active table?
Go To
To create a link to a web page, picture, email address or program in a worksheet, what command do you use?
HYPERLINK
What method is used to remove data from a worksheet without permanently deleting the data
Hide
Which Ribbon contains the command for setting each row in a table with an alternating color?
Home
Which ribbon includes the commands to apply a quick table style to a range of cells?
Home
Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in the worksheet?
Hyperlink
What default unique identifier name and data type are used when a table is created in Datasheet View?
ID, AutoNumber
What is the process of bringing data containing text fields separated by commas into Excel called?
Importing Data
When entering data into a database, which keyboard key is used to switch to the Overtype typing mode?
Insert
Which form control enables a user to select from multiple options?
List box
Which term refers to a series of recorded actions that direct Access 2010 to perform when a particular event occurs?
Macro
The ____ is the space between the page content and the edges of the paper.
Margin
Which command on the Home Ribbon enables a user to increase the row height of a record in a table?
More
What type of form contains more than one page of information & has tab controls to provide access to additional pages in the form?
Multipage form
What command on the Create Ribbon enables a user to determine the location of tabs on a form?
Navigation
If you want to cause data to start on a new page when printing, what do you insert?
Page Break
Page breaks may be manually inserted using the breaks command on the ____ ribbon.
Page Layout
Which view do you use to create or modify a worksheet while seeing how it will look in printed format?
Page layout
Name the dialog box that contains the commands to center a worksheet on the page vertically & horizontally
Page setup
Which command is used to copy and add records to an existing table?
Paste Append
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?
Path
Which command on the Insert Ribbon inserts a graphic from a file into a worksheet?
Picture
Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
PivotChart
In order to directly report the data, what must a PivotChart always be associated with?
PivotTable
Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data?
PivotTable
The ____ command allows information to repeat on each printed page
Print Titles
What command do you select on the Page Layout Ribbon to enable you to specify rows or columns to repeat on each printed page of the worksheet?
Print titles
What command do you select on the Page Layout to enable you to specify rows or columns to repeat on each page of a printed workbook?
Print titles`
What command prevents unwanted changes to data in a worksheet by specifying exactly what information may be changed?
Protect Sheet
What command limits structural changes, such as adding, deleting or moving sheets, that can be made in a workbook?
Protect workbook
Which is a way to qualify data by specifying a matching condition or asking a question of the data?
Query
What form property identifies the object from which data is retrieved?
Record Source
What command on the Database Tools Ribbon defines how data in database tables are correlated?
Relationship
What command is selected to automatically create a basic report for the currently selected table or query?
Report
Which group on the Create Ribbon provides a wizard for creating standard or customized labels?
Reports
Which ribbon contains commands to add a comment about a selected cell in a worksheet?
Review
How do you create an exact copy of a worksheet within the same workbook?
Right click sheet tab, choose move or copy from shortcut menu.
What would you do to delete an unwanted worksheet from a workbook?
Right click the unwanted sheet tab & choose delete from the shortcut menu
How do you quickly modify a table style to meet user preferences?
Right-click on a style & choose Duplicate
The process you would use to copy a worksheet in on workbook to paste into another workbook is..
Right-click the sheet tab to choose move or copy from the shortcut menu & choose the destination workbook from the drop down list.
Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
Rotate
Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
Screen Clipping
Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
Screenshot
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
Sheet Options
An entire worksheet may be hidden by choosing hide on the ____ .
Sheet tab shortcut menu
What appears at the bottom of a spreadsheet to distinguish individual worksheets?
Sheet tabs `
The quickest method to hide a column or row in a worksheet is to select the coumn or row and choose hide from ____.
Shortcut Menu
Which group on the view ribbon enables you to show or hide the ruler, gridlines, formula bar, or headings?
Show
What are graphical objects that contain buttons a user can click to filter the data in PivotTables & PivotCharts?
Slicers
When sorting numerical data in ascending order, how will the data be sorted?
Smallest # to largest #
Which command on the Insert Ribbon creates a graphic that communicates information to the user?
SmartArt
What is the process of ordering records in reverse alphabetical order called?
Sort Descending
When sorting data in a table, which fields are selected as fields to sort by?
Sort Keys
To separate a worksheet window into four individual panes, which command do you use?
Split
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
String
What command totals related data in several rows by inserting totals for selected cells?
Subtotals
Which of the following is the default method for summarizing data in a PivotTable?
Sum
What is an organized collection of data called?
Table or database
What type of database provides assistance through commonly used database designs?
Template
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
Template
What default data type is used when a new field is created in a table?
Text
In a worksheet which command suggests other words with a similar meaning that can be used?
Thesaurus
When the insert worksheet command is selected, where is the new sheet inserted?
To the right of all sheets
What is a visual way to show how two variables relate to each other in a table?
Trendline
By default all areas of the worksheet will print
True
Freezing areas in a worksheet is only used to enhance the readability of the worksheet data.
True
Print titles are an excellent way to include titles or column headings on all pages that are printed
True
The quickest way to insert a new worksheet into a workbook is to use the insert worksheet tab located to the right of the sheet tabs
True
Worksheet names may not exceed 31 characters.
True
How do you move from one tab to another in a workbook?
Use the sheet tabs
What technique selects data from the Internet to add to an Excel worksheet?
Web query
Which area on the title bar contains a command that will save a workbook with changes and close the Excel Program Window?
Window Control Buttons
Which command creates decorative text in a worksheet?
WordArt
What allows a window to be frozen & allows edits to be made with other windows open?
freeze panes
What command do you use to insert information into a worksheet that will display at the top & bottom edges of the printed page?
header & footer
What is the default text field size for a new field in a database table?
225
What is a range that spans two or more sheets in a workbook
3-D Range
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?
3D reference