Adv. computer applications excel
Which of the following format symbols displays text along with numbers entered in a cell?
" " (quotation marks)
Which of the following is the path to the Refresh All button?
(DATA tab | Connections group)
What is the path to the What-If Analysis button?
(DATA tab | Data Tools group)
Which of the following is the path to the 'Get Data From Text' button?
(DATA tab | Get External Data group)
Which of the following is the path to the Name Manager button?
(FORMULAS tab | Defined Names group)
Which of the following is the path to the 'Lookup & Reference' button?
(FORMULAS tab | Function Library group)
Which of the following is the path to the Insert Cells button?
(HOME tab | Cells group)
Which of the following is the path to the Fill button?
(HOME tab | Editing group)
Which of the following is the path to the Borders button?
(HOME tab | Font group)
The path to the Comma Style button is ____.
(HOME tab | Number group)
Which of the following is the path to the Format as Table button?
(HOME tab | Styles group)
The path to the Sum button is ____.
(Home tab | Editing group)
Which of the following is the path to the 'Insert a SmartArt Graphic' button?
(INSERT tab | Illustrations group)
Which of the following is the path to the Insert WordArt button?
(INSERT tab | Text group)
Which of the following is the path to the Protect Sheet button?
(REVIEW tab | Changes group)
To hide an entire workbook on an unattended computer, click the Hide button on the ____.
(VIEW tab | Window group)
Which of the following is the path to the Switch Windows button?
(VIEW tab | Window group)
The values ____ satisfy a custom filter criteria that displays records in which the Experience field contains a value greater than or equal to 3 and less than or equal to 5.
3, 4, 5
The general form of the VLOOKUP function is ____.
=VLOOKUP(lookup_value, lookup_table, col_index_num)
As you link workbooks, the cell reference inserted by Excel each time you tap or click a cell in a workbook results in a(n) ____ cell reference.
Absolute
Which of the following is the maximum number of active data tables per worksheet?
As many as you want
When you first create a table, Excel automatically enables ____.
AutoFilter
Why is the VLOOKUP function used more often than other lookup functions?
Because most tables are vertical
To create an exact copy of a formula without replication, hold down the ____ key while dragging the fill handle.
CTRL
You should hold down the ____ key to select the nonadjacent cells.
CTRL
To copy the contents of a cell to the cell directly below it, click the target cell and press ____.
CTRL+D
____ ensures that users do not change values inadvertently that are critical to the worksheet.
Cell protection
____ formatting allows you to create rules that change the formatting of a cell or range of cells based on the value of a particular cell.
Conditional
The process of summarizing data included on multiple worksheets on one worksheet like the one shown in the accompanying figure is called ____.
Consolidation
The comparison criteria in the ____ range determine the records that will pass the test when the Advanced Filter dialog box is used.
Criteria
You should click ____ in the Category list on the Number sheet in the Format Cells dialog box to select or create a format code.
Custom
When a template is created, dummy ____ isare used to verify the formulas in the template.
Data
The following sequence, Jan, Feb, Mar, etc., is an example of a ____ series.
Date
A ____ file contains data fields separated by a selected character.
Delimited
A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.
Draft quality
____ records allows you to pull data from a table so that you can analyze or manipulate the data further.
Extracting
Once you have selected a range to chart, you can press ____ to draw a chart on a worksheet.
F11
A table also is called a record.
False
By default, the cell that is active when a Web query is performed will become the lower-left cell of the imported range.
False
Data in descending sequence is sorted from lowest to highest, earlier to most recent, or alphabetically from A to Z.
False
If you are summing numbers on noncontiguous sheets, hold down the SHIFT key rather than the CTRL key when selecting the sheets.
False
It is not necessary to understand the layout of data you want to import; Excel automatically arranges each data element in the worksheet.
False
It is not possible to replicate formulas after completing an import, so be sure to complete the replication before the import.
False
Spreadsheet specialists usually format a worksheet before they enter any data.
False
The VLOOKUP and HLOOKUP functions provide greater flexibility than the MATCH and INDEX functions.
False
To locate a string in a worksheet, you can use the Locate command on the Locate and Select menu.
False
When a table is active, the FORMAT tab on the Ribbon provides powerful commands that allow you to alter the appearance and contents of a table quickly.
False
You can add only a maximum of five conditional formats to a range.
False
You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.
False
You should not credit the source of an image unless you can specifically name the image creator.
False
Each row of an Excel worksheet used to create a table can store a record, and each column can store a(n) ____.
Field
You can drill all of the following down through a workbook EXCEPT ____.
Groupings
Webpages use a file format called ____.
HTML
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.
Hide
A cell ____ often is created from column or row titles.
Name
You can display the ____ tab to specify page setup options.
PAGE LAYOUT
When you print a worksheet or use the Page Setup dialog box, Excel inserts ____ breaks that show the boundaries of what will print on each page.
Page
You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.
Page
To prevent round-off errors, use the ____ function.
ROUND
To select adjacent sheets, select the first sheet by clicking its tab and then hold down the ____ key and click the sheet tab at the other end of the list of adjacent sheet tabs.
SHIFT
Which of the following is the path to the 'Get Data From Text' button? (DATA tab | Get External Data group) The ____ function is useful when you want to add values in a range only if they meet criteria.
SUMIF
The ____ provides step-by-step instructions for importing data from a text file into an Excel worksheet.
Text Import Wizard
You can add text to a SmartArt graphic by using the ____.
Text Pane
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
The formula checker
A cell name often is created from column and row titles.
True
Database is the name most often assigned to a table.
True
Excel allows you to import data from webpages.
True
Excel automatically selects the Left column check box in the Create Names from Selection dialog box in order to determine which option to select automatically.
True
If added, a footer appears at the bottom of every printed worksheet page.
True
In some situations, you may find that a column of data imported from Word should be split into two columns.
True
The HLOOKUP and VLOOKUP functions can be inserted by tapping or clicking the 'Lookup & Reference' button (FORMULAS tab | Function Library group).
True
The Import Data dialog box allows you to choose in which cell to import the text from a text file and to specify properties of the imported text.
True
The Normal style is the format style that Excel initially assigns to all cells in a new workbook.
True
The result of an arithmetic operation, such as multiplication or division, is accurate to the factor with the least number of decimal places.
True
The system date might be displayed as a series of number signs if the date, as initially formatted by Excel, does not fit in the width of the cell.
True
When Range Finder is active, you can drag the outlines from one cell to another cell to change the cells referenced in the formula, provided the cells have not been named.
True
When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.
True
When a range is transposed, the first row of the selected range becomes the first column in the destination range, and so forth.
True
When you add a new shape to a SmartArt graphic, Excel rearranges the shapes in the graphic to fit in the same area.
True
When you create a new custom format code, Excel adds it to the bottom of the Type list in the Number sheet in the Format Cells dialog box to make it available for future use.
True
When you insert a new worksheet, Excel places the new sheet tab to the left of the active tab.
True
You can create and then assign a style to a cell, a range of cells, a worksheet, or a workbook.
True
You can tap or click the arrow to the right side of a cell in the total row to display a list of available statistical functions.
True
You can transpose directly from copied Word tables.
True
____ can describe any type of data.
XML
Names are ____ cell references.
absolute
A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.
amortization schedule
For the VLOOKUP function to work correctly, the table ____ must be in sequence from lowest to highest.
arguments
Data is in ____ sequence if it is in order from lowest to highest.
ascending
The following sequence, 1, 1, 1, etc., is an example of a(n) ____ series.
auto fill
Cell ____ can be used to distinguish the different functional parts of a worksheet.
borders
The arguments in ____ in the ScreenTip for a function are optional.
brackets
When a template is created, dummy ____ is are used to verify the formulas in the template.
data
Names are ____ to the workbook.
global
A ____ is a reference to a cell or range of cells in another workbook.
link
In the Sort dialog box, shown in the accompanying figure, the ____ is the Sort by field.
major sort key
You can delete a data table by selecting the data table and then ____.
pressing the DELETE key
In the accompanying figure, the Print area box accepts a name or a ____ to print.
range
Importing ____ provides greater flexibility to manipulate text in Excel.
raw data
The field or fields selected for sorting records are called ____ keys.
sort
