True or False Excel Questions
Order by
68 terms
Terms | Definitions |
|---|---|
 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 |
First Time Here?
Welcome to Quizlet, a fun, free place to study. Try these flashcards, find others to study, or make your own.