How can we help?

You can also find more resources in our Help Center.

100 terms

BTA Final Study Guide

STUDY
PLAY
true
to rename a worksheet, you can right-click its sheet tab, and then click Rename on the shortcut menu
false
Microsoft Office Excel 2007 is the presentation program in Microsoft Office2007
true
SmartArt graphics are often used for organizational charts, flowcharts, and decision trees
true
The Currency data type accepts monetary values and displays them with a dollar sign and decimal point
false
the formulas replace the formula results in the worksheet. If a cell does not contain a formula, the cell appears shaded out.
false
filtering rearranges the order of the data
false
saving a workbook means loading an existing workbook file from a disk into the program window
true
the contents of the active cell always appear in the Formula Bar
true
Embedded charts are useful when you want to print a chart next to the data the chart illustrates
false
a record is an incomplete set of data
true
text the is too long to fit within a cell is displayed in the next cell, if it is empty
false
by default, Excel is set to print pages in landscape orientation
false
the template includes all the parts of a workbook that constantly change, such as text, labels, formulas, and formatting
true
you can use shortcut keys to quickly cut, copy, and paste cells
false
if a function contains more than one argument, semicolons separate the arguments
false
Numbers that do not fit in the cell are shown as a series of question marks (??????).
false
the Save As command saves an existing workbook on a disk, using its current name and save location
false
the easiest way to change the active cell in a worksheet is to use to click Cell on the Ribbon and type in the cell's location
false
to make changes to an element's fill, border color, border style, shadow, 3-D format, alignment, and so forth, you need to open the Chart Elements dialog box
true
to print all of the worksheets in the workbook, click the Entire workbook option in the Print what section of the Print dialog box
false
the database object called Macro displays data from one or more tables or queries in a format similar in appearance to a paper form
true
if you select more than one row or column, the same number of rows or columns you selected is inserted in the worksheet
false
when you wrap text, the column width changes to accommodate the text
true
you designate the portion of the workbook to print in the Print what section of the Print dialog box
false
an operand is a symbol that indicates the type of calculation to perform, such as a plus sign (+) for additioin
true
a field property describes a field's contents beyond the field's basic data type, such as indicating the number of characters the field can store or the allowable values that you can enter in the field
false
deleting does not permanently remove a worksheet and all its contents from the workbook
true
to freeze panes, on the View tab of the Ribbon, in the Window group, click the Freeze Panes button, and then click Freeze panes
false
to make editing records easier, Access includes navigation buttons on the Ribbon at the bottom of the datasheet
false
in the IF function, the first argument sets a condition for comparison, called a relative test
false
When you sort data contained in columns of a worksheet, Excel includes the column headings
true
All images are protected by copyright law
false
each workbook opens with five worksheets
true
when you select the data source for a chart, you should also include the text you want to use as labels in the chart
false
the Description property in the design grid is a required field property that you use to describe what to enter in the field
true
when you open an existing database, the Navigation Pane opens on the left side of the screen
true
a field selector appears at the top of each column in a table and contains the field name
true
if data is formatted with different font or fill colors, you can sort the data by bolor
false
the drag-and-drop method is the slowest way to copy or move data short distances in a worksheet
true
A 3-D reference lists the worksheet range, an exclamation pint, and a cell or range
false
you can create a copy of a worksheet by pressing the Tab key as you drag and drop its sheet tab
false
all chart types are interchangeable. For example, data suitable for a pie chart will also always work as a scatter chart
true
until the worksheets are named, they are identified as Sheet1, Sheet2, and so on
true
when you use a template to create a database, the template creates the database with one or more objects that you use to enter and view data
false
after you delete a record, you can use the Undo command to restore it
true
Press the Ctrl+B keys to apply bold
false
a format is the design of text
true
formulas can include more than one operator
false
COUNT CELLS determine how many entries are included in the range
true
to resize a column, place the pointer on the right edge of the column heading until the pointer changes to a doubleheaded arrow. Click and drag to the right until the column expands to the width you want
true
the results of the calculation appear in the cell in which the formula is entered
true
to identify the fields, each field has a field name
true
you can reposition a worksheet by dragging its sheet tab to a new location
false
design view is helpful when you prepare a worksheet for printing
true
the Cut, Copy, and Paste commands in Access work the same way as they do in other Office programs
false
you must use double brackets to enclose the text you want the IF function to return in the second and thrid arguments
false
a chart template formats the chart based on the colors, fonts, and effects associated with the workbook's theme
true
you can use the SUM function to total the values stored in up to 255 non-adjacent cells or ranges
false
unless you specify otherwise, text you enter in a cell is lined up along the upper-right side of the cell
true
Data moved or copied to a cell replaces any content already in that cell
false
because excel includes so many functions, the best way to select a function is from the Excel Help
false
Logical functions can determine the average, standard deviation, or variance of a range of data
false
a cell theme is a collection of formatting characteristics you apply to a cell or range of data
false
you can split the worksheet window into horizontal or vertical panes, but not both
false
when you create a blank database, Access creates the first table for you and gives it the name Database1
true
The default number format is General, which displays numbers the way you type them
true
in Design view, you can add, delete, and make change to the way that fields store data
true
a database is a collection of objects
true
Scatter charts are sometimes referred to as XY charts because they place data points between an x- and y-axis
true
some mathematical operations, such as addition, subtraction, multiplication, and division, do not require functions
true
a chart sheet does not have worksheet cells and cannot contain data or formulas.
false
each formula begins with a quotation mark (")
false
a picture is anything that appears on the screen that you can select and work with as a whole, such as a shape, picture, or chart
true
the rounding operation requires two arguments, which are separated by a comma
false
a worksheet is a collection of workbooks
true
the Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access toolbar, the Office Button, the Ribbon, and the status bar
true
you can quickly change the look of any chart you created by applying a layout and style
true
any changes that you make in Design view are automatically updated in Datasheet view when you save the table
false
whenever you select a range, the Ribbon shows the results of common calculations for the selected cells
true
the worksheet cell is the hyperlink, not the contents entered in that ell
true
in a table, the primary key is the field that contains a unique field value for each record in the table
false
the cell in the worksheet in whcih you can type data is called the open cell
true
You can include cell references in a formula more quickly by using the point-and-click method to click each cell, rather than typing cell references
false
you use special chart text formatting tools to make changes to the fonts used in the chart
true
the Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value
false
Access is a DBBS program
false
you can delete a selected chart by pressing the F2 key
false
when formulas with mixed cell references are copied or moved, the row or column references preceded by a question mark do not change
false
Date and time functions are used to format and work with cell contents
false
left-aligned field values are usually Number fields
false
the Transfer command pastes a row of cells into a column, or a column of cells into a row
true
at times, you might need to remove, or clear, all the formatting applied to a cell or range of cells
true
when you click the shape you want to insert the pointer changes to a crosshair
true
a text function can be used to convert text in a cell to all uppercase or lowercase letters
true
although Excel checks that the formula has the correct structure, it does not check that the formula contains the correct values or cell references
false
a field's access type determines the kind of data that you can enter in the field, such as numbers or text, or a combination of numbers and text
true
if a cell is not long enough to display all the cell's contents, extra text extends into the next cells if there is room
true
to remove one or more rows or columns, right-click the selected rows or columns, and then click Delete on the shortcut menu
true
to clear the active cell, you can use the Ribbon, the keyboard, or the mouse
false
hiding permanently removes a row or column from view