How can we help?

You can also find more resources in our Help Center.

68 terms

True or False Excel Questions

STUDY
PLAY
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.
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.
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.
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.
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.
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.
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.
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.
true
Excel's NOW function returns the date and time, which it retrieves from the computer's clock
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
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 =.
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.
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.
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.
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.
false
According to Excel's order of operations, addition and subtraction are done before
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.
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.
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.
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.
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