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 w​idest 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