True or False Excel Questions

Réussis tes devoirs et examens dès maintenant avec Quizwiz!

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

true

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

true

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

true

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

true

Formula AutoComplete displays the names of functions that begin with the letter or letters you have typed in after the =.

true

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

true

Logical functions are used to test for specific conditions.

true

MIN and MAX are examples of statistical functions.

true

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

true

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

true

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

true

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

true

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

true

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

true

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

true

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

true

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

true

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

true

The terms worksheet and spreadsheet are interchangeable

true

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

true

The word pixel is short for picture element.

true

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

true

Using conditional formatting allows the user to have a cell formatted in different ways depending on the value stored in that cell.

true

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

true

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

true

IF is an example of a statistical function

false

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

false

In Excel, numbers are used as column headings

false

Number values are often called labels.

false

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

false

Page Layout view is available for chart sheets.

false

The COUNTIF function takes three arguments.

false

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

false

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

false

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

false

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

false

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

false

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

false

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

true

A function is a predefined formula.

true

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

true

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

true

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

true

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

true

Absolute cell references are indicated by the $ symbol.

true

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

true

Cell contents are either values or formulas.

true

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

true

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

true

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

false

A negative number that is displayed using the Accounting Number Format is shown with a negative sign, such as -5 or -6.

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.

false

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

false

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

false

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

false

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

false

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

false

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

false

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

false

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

false

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

false

Detail sheets display and summarize totals from other worksheets.

false

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

false

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

false

Excel does not provide a spelling checker.

false

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

false

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

false

Graphics cannot be placed in a text box.

false


Ensembles d'études connexes

Unit 4: Cellular Respiration and Plant Structure

View Set

Bio 100 Chapter 3 Launchpad Questions

View Set

Ecosystem, Food Chains, Carbon Cycle, Trophic Level

View Set

MUSIC 007 Film Music Appreciation

View Set

Strategic Management - Chapter 10: Corporate-Level Strategy: Related and Unrelated Diversificationt

View Set