Advertisement

68 terms

The user can add and delete commands on the Quick Access Toolbar.

true

A toggle value is one that is used by a program unless the user changes it.

false

Clicking a command that is followed by an ellipsis will cause a dialog box to display

true

Formatting marks represent certain keystrokes in a document, but do not display when the

document is printed.

document is printed.

true

In Excel, numbers are used as column headings

false

Scaling allows the user to indicate the maximum number of pages to be used when printing a

worksheet.

worksheet.

true

Cell contents are either values or formulas.

true

A range can be made up two or more nonadjacent areas on a worksheet.

true

When printing a worksheet, the orientation can be changed either on the Page Layout tab or in

Print Preview.

Print Preview.

true

The first step in entering data by range is to select the desired range.

true

The only kinds of values that can be entered into a cell are text values and number values.

false

When you add or delete rows or columns in a worksheet, Excel automatically adjusts all of the

formulas.

formulas.

true

All Excel formulas begin with the equal sign (=).

true

A group of cells that Excel treats as a single unit is called a range.

true

ou must delete the current value in a cell before you can begin entering a new value.

false

Text values usually are used to provide information about the numbers displayed in worksheet

cells.

cells.

true

Excel does not provide a spelling checker.

false

Data that is displayed in a cell is called the underlying value

false

The result of a function is displayed in a cell, and the underlying formula is displayed in the

Formula Bar.

Formula Bar.

true

The terms worksheet and spreadsheet are interchangeable

true

Each data point is represented in a chart by a legend.

false

A chart layout may include a number of chart elements such as title, legend, and labels for the

columns.

columns.

true

Absolute cell references are indicated by the $ symbol.

true

Excel's Paste Options gallery does not include Live Preview.

false

Data within a cell can be displayed rotated to draw attention to the data.

true

Using conditional formatting allows the user to have a cell formatted in different ways

depending on the value stored in that cell.

depending on the value stored in that cell.

true

Excel's NOW function returns the date and time, which it retrieves from the computer's clock

and calendar.

and calendar.

true

>, >=, and = are examples of conditional operators

false

IF is an example of a statistical function

false

Entering the year portion of a date as 40 will be interpreted as the year 2040.

false

The Excel user can move from one worksheet to another by clicking the data bar

false

A value or expression that can be evaluated as true or false is called a logical test.

true

The IF function returns one value if a logical test is false and a different value if the logical test is

true.

true.

true

Once a pie chart is created, it cannot be rotated.

false

Formula AutoComplete displays the names of functions that begin with the letter or letters you

have typed in after the =.

have typed in after the =.

true

A pie chart can only be based on one data series.

true

Graphics cannot be placed in a text box.

false

A negative number that is displayed using the Accounting Number Format is shown with a

negative sign, such as -5 or -6.

negative sign, such as -5 or -6.

false

Using Comma Style causes a negative number to be displayed inside parentheses.

true

Workbook-level buttons are found along the lower border of the Excel window and identify

each worksheet.

each worksheet.

false

By default, text values entered into a cell are right justified.

false

Excel's Formula Bar displays the underlying value of the active cell

true

The word pixel is short for picture element.

true

MIN and MAX are examples of statistical functions.

true

Logical functions are used to test for specific conditions.

true

Detail sheets display and summarize totals from other worksheets.

false

The target destination for data that has been cut or copied using the Office Clipboard is called

the paste area.

the paste area.

true

The data in an Excel table can only be sorted into ascending order.

false

The MEDIAN function adds a group of values and then divides the sum by the number of items

in the group.

in the group.

false

According to Excel's order of operations, addition and subtraction are done before

exponentiation.

exponentiation.

false

If a value is changed in a cell, Excel recalculates all formulas that reference that cell.

true

The sizes of pie slices are automatically adjusted when the underlying data values are changed.

true

Page Layout view is available for chart sheets.

false

AutoComplete generates and extends a series of values based on the values of other cells.

false

In Excel, column headings are made up of a letter and a digit, such as A2.

false

One way a user can enter a formula is to use the point and click method.

true

Excel allows the user to delete the formatting of a cell without deleting the contents of the cell

true

A summary sheet is used to provide a visual cue about the value of a cell in relationship to other

cells.

cells.

false

The data in an Excel table is managed independently from the other data in the worksheet.

true

Excel's Number format leaves a space at the right of the number for a closing parenthesis in case

the value is negative.

the value is negative.

false

By default, the plot area and the chart area are filled with different colors.

false

A relative cell reference refers to a cell by its fixed position within the worksheet and is not

adjusted when the formula is copied.

adjusted when the formula is copied.

false

The COUNTIF function takes three arguments.

false

The AutoFill feature will continue a series based on the values placed in two or more

consecutive cells.

consecutive cells.

true

An Excel worksheet is made up of one or more workbooks.

false

A function is a predefined formula.

true

Deleting the contents of a cell also removes the format that has been applied to the cell.

false

Number values are often called labels.

false