BTA Final Study Guide

Created by HorizonGurl 

Upgrade to
remove ads

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

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set