Excel prac true or false exam
A bar chart and column chart are equivalent chart types in Excel.
False
A cell reference that does not change when it is copied is called a(n) relative cell reference. _________________________
False
A chart must be located in a specific cell or at a specific address range.
False
A named range can begin with a letter or number.
False
According to the order of precedence for arithmetic operators, operations contained within parentheses are performed last.
False
After you use the fill handle to copy cell contents, the Quick Copy Options button appears, which can be used to fill the cells with only specific elements of the copied cell, if you wish. _________________________
False
An Excel 2016 workbook has the file extension .xml.
False
An absolute cell reference changes the cell references when the formula is copied to a new location.
False
Arguments are Excel's built-in formulas.
False
Cell and range names can use uppercase and lowercase letters, digits, and spaces.
False
Cell templates are sets of cell formats based on themes; they are automatically updated if you change a theme. _________________________
False
Chart annotations are labels that further describe your data. ____________________
False
Clicking the Minimize button minimizes the Function Arguments dialog box so you can select cells in a worksheet. _________________________
False
Double-clicking the right edge of a column heading activates the AutoSize feature which automatically resizes the column to accommodate the widest entry in the column. ____________________
False
Dragging a chart object to a new location on the worksheet will change the data in the worksheet.
False
Excel includes three kinds of 3-D chart types. ____________________
False
Field names should be similar to cell addresses, such as G2.
False
If a value in a formula is not available, the error value #VALUE! will display in the cell.
False
If you change the way data is displayed in a PivotTable, the summarized data always remains in the same cell reference.
False
In a pie chart, you can emphasize one data point by plotting, or pulling that slice away from, the pie chart. _________________________
False
In an electronic spreadsheet, you need to manually recalculate when you change the entries.
False
It is acceptable for dates to have a currency format.
False
Labels are numbers, formulas, and functions that can be used in calculations.
False
Office Lite includes simplified version of the apps found in the Office 2016 suite. ____________________
False
Records are columns in a table that describe a characteristic about a field, such as a customer's last name or street address.
False
Reference operators compare values for the purpose of true/false results.
False
Sub gridlines show the values between the tick marks in a chart. _________________________
False
Table styles are organized in four categories: Black & White, Light, Medium, and Dark.
False
The COUNT function in Excel returns the number of all cells in a range that contain any type of data.
False
The COUNTA function returns the number of cells in a range that contain numeric data.
False
The Format Painter button copies both the cell's content and formatting.
False
The Increase Decimal button automatically adds dollar signs and two decimal places to your data.
False
The Match case option in the Find and Replace dialog box is used to search for duplicate records.
False
The Quick Chart tool recommends charts based on the selected data. ____________________
False
The Visual Analysis tool allows you to easily create charts and other elements that help you visualized how data is distributed.
False
The Wildcard dialog box helps you find records in a table.
False
The area inside the horizontal and vertical axes is the legend. _________________________
False
The font size is measured in units called pixels. _________________________
False
The horizontal axis is also called the value axis.
False
The parts of an IF function are separated by parentheses.
False
The symbol < > stands for "equal to."
False
The wildcard asterisk (*) always represents one single character.
False
Tick marks appear on the horizontal axis of a chart. ____________________
False
To add an image to a worksheet, click Pictures in the Illustrations group on the Home tab. _________________________
False
To insert the AVERAGE function into a cell, click the cell, click the Function Options list arrow in the Editing group on the Home tab, and then click Average. _________________________
False
Using the order of precedence for arithmetic operators, these two formulas will calculate the same result: =22/2*5 =22/(2*5).
False
When pasting an item from the Office Clipboard or Clipboard into a worksheet, you only need to specify the lower-right cell of the range where you want to paste the selection. _________________________
False
When the paper orientation is portrait, the contents will print across the length of the page instead of across the width. _______________________
False
When using the Insert Function button or the AutoSum list arrow, it is necessary to type the equal sign.
False
When you insert a new column, the contents of the worksheet shift to the left from the point of the new column.
False
You can add new rows to a table by typing data directly below the last row, and then pressing [Tab].
False
You can change header and footer information using the Margins Design tab that opens on the Ribbon when a header or footer is active.
False
You can change the resulting values in a PivotTable by editing individual cells in the PivotTable.
False
You can edit data directly in a PivotTable.
False
You can insert and delete rows in a PivotTable.
False
You can move cells directly in a PivotTable.
False
You can use an ordinary cell reference when you want to reference a PivotTable cell in another worksheet.
False
You cannot select multiple values on a slicer.
False
You cannot use the fill handle to copy a formula with an external reference indicator.
False
You must apply borders to all the cells in a worksheet; you cannot apply them only to selected cells.
False
=D8+E8*0.5 is a complex formula.
True
A PivotTable will support more than one field in the Rows area.
True
A chart sheet is a sheet in a workbook that contains only a chart, which is linked to the workbook data.
True
A delimiter is a data separator.
True
A(n) mixed reference means that either the column or row reference in the formula is absolute, but not both. _________________________
True
According to the order of precedence, the formula =(25*2)/5 would calculate the result of 10. _________________________
True
After inserting or deleting rows or columns in a worksheet, be sure to proof formulas that contain relative cell references. _________________________
True
An Excel complex formula uses more than one arithmetic operator.
True
Any data changed in the worksheet is automatically updated in the chart.
True
Charts are updated automatically in Excel whenever data changes.
True
Dragging the fill handle across a range of cells copies the contents of the first cell into the other cells in the range. ____________________
True
Excel includes a(n) Scenario Manager where you can name and save different what-if versions of your worksheet. ____________________
True
Excel's Formula AutoComplete feature suggests functions depending on the letters typed by the user. _________________________
True
If a number is divided by zero, the error value #DIV/0! will display in the cell.
True
If there are invalid cell references in a formula, the error value #REF! will display in the cell.
True
In this formula, =(A6*A8)+$D$1, the cell references A6 and A8 are relative cell references. _________________________
True
Inserting extra spaces at the beginning of a cell entry in a table can affect sorting and finding data later.
True
Linking to a workbook means that any changes to the original values are automatically reflected in the consolidation sheet as well.
True
Moving a chart to a different sheet in the workbook will not change the original data reflected in the chart.
True
Names that you assign to cells and cell ranges can be used in formulas.
True
Normally, you don't need to adjust row heights manually because row heights adjust automatically to accommodate font size changes.
True
Once you have formatted a range as a table, you can use Live Preview to view the table in other styles. ____________________
True
One of the ways to change your view of the worksheet window is by using the View tab on the Ribbon. ______________________
True
Predefined formulas in Excel are called functions and can be accessed using the Insert Function button.
True
Printing gridlines makes data easier to read.
True
Symbols, such as less than (<), greater than (>), and equal to (=), are all examples of comparison operators.
True
Tables are organized into records which are composed of fields.
True
The Chart Elements button makes it easy to add, remove, and modify individual chart objects.
True
The Find and Replace dialog box can be opened by clicking the Find & Select button in the Editing group.
True
The default layout for a PivotTable is the compact form.
True
The first step in planning and designing a PivotTable is to review your information to gain an understanding of the scope and structure.
True
The layout of your PivotTable is crucial to delivering your intended message.
True
The purpose of a PivotTable is to explore relationships within your data and to display your findings in an easy-to-understand format.
True
The question mark (?) wildcard stands for any single character.
True
The z-axis of 3-D charts is used for comparing data across both categories and values. _________________________
True
To base a chart on data in nonadjacent ranges, press and hold [Ctrl] while selecting each range.
True
To check the spelling in more than one sheet of a multiple-sheet workbook, you need to display each sheet and run the spelling checker again.
True
To delete a table row, place the cursor in any cell in the row you wish to delete, then click Delete Table Rows from the Delete list arrow in the Cells group.
True
To open an Excel file, click Open Other Workbooks on the navigation bar, click This PC, and then click Browse to open the Open dialog box.
True
To print the formulas in a worksheet, click the Formulas tab, then click the Show Formulas button in the Formula Auditing group.
True
Using the Cut command completely removes data from its original location, while the Copy command leaves information in its original location.
True
Using the mouse, you can drag or double-click the right edge of a column heading to change the column width. _________________________
True
When you change a theme, cell styles are automatically updated.
True
When you create a table, Excel automatically applies a default table style.
True
With Auto Fill, dragging the fill handle on a cell copies the cell's contents or continues a series of data into adjacent cells.
True
With Excel, you can adjust the width of one or more columns by using the mouse.
True
WordArt can be created using the Chart Tools Format tab.
True
You are in Edit mode any time you are entering or changing the contents of a cell.
True
You can add calculated fields to a PivotTable.
True
You can add new rows and columns to a data table by dragging the sizing handle in the table's lower-right corner.
True
You can add words to the dictionary of the spelling checker.
True
You can apply formatting before or after you enter data in a cell or range.
True
You can change the font and font size of any cell or range using the Mini toolbar.
True
You can close the Office Clipboard pane by clicking the dialog box launcher in the Clipboard group. _________________________
True
You can create multiple charts based on the same worksheet data. ____________________
True
You can format the text in a chart object using the Home tab or the Mini toolbar.
True
You can print a chart by itself or as part of the worksheet.
True
You can resize a chart to improve its appearance by dragging its sizing handles. _________________________
True
You can sort PivotTable data.
True
You can use a named range instead of a cell address in a formula.
True
You can use buttons on the Insert tab of the Ribbon to create a chart.
True
You can use the Quick Analysis tool to create a sparkline.
True
You should not have any blank columns or rows in your table.
True
You use formulas in Excel to perform calculations such as adding, multiplying, and averaging.
True