True or False Excel Questions
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