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