Excel Exam - 1-5
The_____option in the Find and Replace dialog box replaces only the highlighted occurrence of the search string. A) Replace B) Replace All C) Find All D) Find Next
A) Replace
The _____group on the Page Layout tab includes options for adjusting worksheet column width and worksheet row height to fit a maximum number of pages. A) Scale to Fit B) Sheet Options C) Page Setup D) Arrange
A) Scale to Fit
The ____tab in the Page Setup dialog box has options for keeping rows at the top of, and columns at the left of, each printed page of a large worksheet. A) Sheet B) Header/Footer C) Margins D) Page
A) Sheet
The COUNT function is in the _____category of the More Functions option in the Function Library group of the Formulas tab A) Statistical B) Information C) Engineering D) Cube
A) Statistical
When the Total style is applied to a group of worksheets, ____ A) all worksheets in the group receive the Total style B) only the first worksheet in the group receives the Total style C) only the last worksheet in the group receives the Total style D) none of these worksheets receive the Total style because styles cannot be applied to grouped worksheets
A) all worksheets in the group receive the Total style
When the Sort Smallest to Largest option is selected from the Filter gallery, the Filter button displays _______ A) another up-arrow icon B) another down-arrow icon C) in red D) in green
A) another up-arrow icon
In a function, the range in parentheses is the______ A) argument B) variable C) underlying value D) display value
A) argument
A(n) _____the line that borders the chart plot border area, is used as a frame of reference for measurement. A) axis B)chart border C) gridline D) category border
A) axis
Clicking the Paste button places the______in the destination cells A) cell content and cell formatting B) cell content only C) cell formatting only D) cell content, cell formatting, and column width
A) cell content and cell formatting
A_________screen is a picture of a portion of the computer screen that can be inserted into a worksheet A) clipping B) shot C) snap D) illustration
A) clipping
A_____chart is useful in comparing values across categories A) clustered bar B) scatter C) line D) pie
A) clustered bar
12) Which symbol inserted between two cell addresses indicates a range? A) colon B) semi-colon C) period D) Comma
A) colon
18) The letter that displays at the top of a column is the ______ A)column heading B) row heading C) named range D) cell reference
A) column heading
Tabular data formatted as ______can be converted into columns using the Convert Text to Columns Wizard A) comma-separated values B) special characters C) delimiters D) metadata
A) comma-separated values
The Logical test in the function IF function must contain a(n) ______operator A) comparison B) precedence C) reference D) arithmetic
A) comparison
A cell _____color is also known as the background color A) fill B) style C) grid D) shading
A) fill
The number of decimals places and the appearance commas, dollar signs, or other symbols are features of number____ A) format B) style C) layout D) alignment
A) format
AZ) The bar, located below the Ribbon, that displays the active cell's content is the _______bar A) formula B) display C) data D) name
A) formula
The horizontal and vertical lines that intersect to create cells are called _____ A) gridlines B) cell margins C) cell borders D) headers
A) gridlines
______classify a range of data into three to five categories and display small graphics in each cell depending on that cell's value. A) icon sets B) themes C) fonts D) styles
A) icon sets
When multiple worksheets are grouped, inserting a row_______ A) inserts it into all of the worksheets in the group B) inserts it only into the first worksheet in the group C) displays an error message D) fails to insert a row into any of the worksheets in the group
A) inserts it into all of the worksheets in the group
The Freeze Panes command is useful in working with______ A) large worksheets B) short worksheets C) multiple worksheets D) multiple workbooks
A) large worksheets
31) Headers and footers are visible in the ______view A)Page Layout B) Page Break Preview C) Normal D) Web Layout
A) page layout
To compare the relationship of parts to a whole, use a _______chart. A)pie B) line C) column D) bar
A) pie
When Print is clicked from the File tab. the right side of the Print pane is a _____ A) preview of the page to be printed B) review of document properties C) list of possible printers D) list of Page Setup settings
A) preview of the page to be printed
10) Two or more adjacent cells in a worksheet are a(n) A) range B) array C) group D) unit
A) range
A 7) The ____outlines all the cells referenced in a formula A) range finder B) error value C) error indicator D) range detector
A) range finder
The percentage that is paid for the use of the borrowed money is the______ A) rate B) principal C) future value D) present value
A) rate
Double-clicking a worksheet tab will ____ A) select the tab's name B) move the tab to the beginning of the Tab group C) move the tab to the end of the Tab group D) make cell A1 the active cell
A) select the tab's name
A worksheet that only contains a chart is called a chart ______ A) sheet B) page C) format D) style
A) sheet
The ______command divides the Excel window into separate panes so that each pane can be scrolled individually A) split window B) freeze panes C) unfreeze panes D) split panes
A) split window
3) In Excel, the term worksheet and mean the same A) spreadsheet B) datasheet C) reference sheet D) workbook
A) spreadsheet
A____is a worksheet that displays and summarizes totals from other worksheets. A) summary sheet B) detail sheet C) synopsis sheet D) review sheet
A) summary sheet
16) When a cell is part of an active function, it is ______ A) surrounded by a moving border B) preceded by an Options button C) highlighted D)surrounded by a solid border
A) surrounded by a moving border
When Clear Content is selected from the Clear button options, only the____ is removed from the cell. A) text B) fill C) comment D) hyperlink
A) text
A _______is a group of formatting choices that can be applied in a single step A) theme B) font C) format D) style
A) theme
When a Total row summary function is inserted at the bottom of a table column and the summary function COUNT is selected, the displayed value of the COUNT function represents the number of A) visible cells in the column that contain a number value B) cells in the entire table C) cells in the column that contain a text value D) rows in the entire table
A) visible cells in the column that contain a number value
Options to rotate and angle text appear when the ______button in the Alignment group on the Home tab is clicked. A) Orientation B) Wrap Text C) Merge & Center D) Cell Styles
A)Orientation
What values does the user need to input or confirm in the Format as Table dialog box? A) cell range and worksheet tab name B) cell range and "My table has headers" option C) worksheet tab name and range of cells comtaining table headers D) range of table column headers and range of table row headers
B) cell range and "My table has headers" option
19) Themed Cell Styles is an option in the _______ gallery A) Conditional formatting B) Cell Styles C) Format as Table D) Format
B) cell styles
Each cell in the blue range finder is represented by a ______which can be a column, a bar, a dot, a slice of pie, or other appropriate symbol A) legend character B) data marker C) data symbol D) data point
B) data marker
A _____is a worksheet with cells referred to by summary sheet formulas A) total sheet B) detail sheet C) cover sheet D) properties sheet
B) detail sheet
Tab scrolling buttons are used to_____ A) scroll up and down through the active worksheet B) display worksheet tabs that are not in view C) scroll left and right through the active worksheet D) zoom in and out on the active worksheet
B) display worksheet tabs that are not in view
To determine a monthly rate in the PMT function, ______ A) multiply the interest by 12 B) divide the interest by 12 C) add 12 to the interest D) subtract 12 from the interest
B) divide the interest by 12
When the Function AutoComplete list is used to enter the MAX function into an active cell, ______ A) single-click on the name of the function in the list B) double-click on the name of the function in the list C) right-click on the name of the function and click Insert D) click and drag the name of the function into the active cell
B) double-click on the name of the function in the list
The _____button is the arrow to the right of a header row label in a table. A) edit B) filter C) analyze D) sort
B) filter
To compare more than one set of values or trends over time, use a ______chart A) pie B) line C) column D) bar
B) line
When an embedded chart is selected and the worksheet is printed,____ A) both the source data and the chart are printed B) only the chart is printed C) only the source data are printed D) nothing is printed
B) only the chart is printed
According to the rules of operator precedence, expressions using______ are calculated first. A) multiplication B) parentheses C) division D) addition or subtraction
B) parenthesis
24) Which term is used to refer to automatic adjustment of cell references in a copied formula? A) absolute cell reference B) relative cell reference C) positional cell reference D) associative cell reference
B) relative cell reference
The Select All Sheets option appears when the user______ A) double-clicks on the tab scrolling buttons B) right-clicks on a sheet tab C) double-clicks on a sheet tab D) right-clicks on the tab scrolling buttons
B) right-clicks on a sheet tab
Clicking a row heading____ A) deletes the row B) selects the row C) inserts a row above the clicked row D) bolds the content of the entire row
B) selects the row
A screen______ is an image of the computer screen. A) clipping B) shot C) snap D) illustration
B) shot
A chart ______is a prebuilt chart format that applies an overall visual look to a chart. A) design B) style C) layout D) template
B) style.
13) When a range is selected, the name box displays the cell address of ______ A) all cells in the range B) the first cell in the range C) the last cell in the range D) none of the cells in the range
B) the first cell in the range
That Freeze Panes is being used in a worksheet is indicated by______ A) an error indicator B) the line along the border C) the range finder D) sizing handles
B) the line along the border
The axis on a chart that displays the numeric data from the worksheet is the______ A) category label B) value axis C) category axis D) value labels
B) value axis
32) Placeholders for predefined headers and footers begin with_____ A) @ B) # C) & D) S
C) &
A(n) ______chart appears to have the length, width, and depth dimensions A) alternative B) 2-D C) 3-D D) accessibility-enabled
C) 3-D
Which of the following formulas would be used to apply conditional formatting if the value in K10 is more than 5000? A) =K10>=5000 B) =K10<5000 C) =K10>5000 D) =K10<=5000
C) =K10>5000
The ______Excel formula accurately displays the use of a cell from another worksheet. A) =B6! B) =B6 C) =May!B6 D) =B6!May
C) =May!B6
11) Which cells are included in the notation A1:D1? A) A1, B1, and C1 B) 81, C1, and D1 C) A1, B1, C1, and D1 D) A1 and D1
C) A1, B1, C1, and D,1
The_____function is a statistical function that adds a group of values and then divides the result by the number of values in the group. A) MAX B) SUM C) AVERAGE D) MIN
C) AVERAGE
Options in the Themes group on the Page Layout tab include all of the following EXCEPT ______ A) Colors B) Fonts C) Alignment D) Effects
C) Alignment
21) The _____ button inserts a function that sums selected cells A) AutoAdd B) AutoCalculate C) AutoSum D) Fil
C) AutoSum
All of the following are options of the Clear button EXCEPT _______ A) Clear All B) Clear Formats C) Clear Error Value D) Clear Contents
C) Clear Error Value
33) When formulas are displayed in a worksheet, what happens? A) Top and bottom margins are decreased. B) Left and right margins are decreased. C) Column width is increased. D) Row height is increased.
C) Column width is increased.
27) Which number format adds commas where appropriate and displays two decimals? A) General B) Currency C) Comma D) Percentage
C) Comma
29) Non-adjacent cells can be selected in a worksheet by holding down the _____key A) Shift B) Alt C) Ctrl D) Home
C) Ctrl
9) The keyboard shortcut to insert the current date, obtained from your computer, is ______ A) Ctrl + * B) Ctrl + / C) Ctrl + ; D) Ctrl + ,
C) Ctrl + ;
23) Which cells are included in the sum calculated by the function-SUM(D5:GS)? A) E5, F5, and G5 B) ES and FS C) D5, E5, F5, and G5 D) D5, E5, and F5
C) D5, E5, F5, and G5
The TODAY and NOW functions are in the ______category in the Function Library group of the Formulas tab. A) Lookup & Reference B) Math & Trig C) Date & Time D) More Functions
C) Date & Time
The Unfreeze Panes option appears when the _______button is clicked. A) Arrange All B) New Window C) Freeze Panes D) Full Screen
C) Freeze Panes
The_____dialog box is where the user enters cell addresses, cell ranges, or constants to complete a function. A) Parameter B) Data C) Function Arguments D) Input
C) Function Arguments
The Insert WordArt button is on the ______tab of the Ribbon. A) Page Layout B) View C) Insert D) Home
C) Insert
To find the biggest value in a list of numbers, use the_____ function A) SUM B)AVERAGE C) MAX D) MIN
C) MAX
Clicking the Paste arrow opens the_______gallery A) Cut/Paste B) Clipboard C) Paste Options D) Copy/Paste
C) Paste Options
34) When you set a print area, the range of selected cells is named ______ A) Print Selection B) Selection C) Print Area D) Page_Setup
C) Print Area
In the PMT function, the ________argument indicates the total number of payments for a loan. A) rate B) Pv C) Nper D) Fv
C) Pv
The small toolbar that contains buttons for commonly used tasks is the ______Toolbar A) Task Access B) Common Reference C) Quick Access D) Quick Reference
C) Quick Access
Which is NOT a text rotation or angle option in the Orientation list? A) Angle Clockwise B) Angle Counterclockwise C) Reverse Vertical Text D) Vertical Text
C) Reverse Vertical Text
Which is NOT a Total row summary function? A) AVERAGE B) SUM C) TODAY D) COUNT
C) TODAY
The _____function is a lookup function. A) COUNT B) TODAY C) TRANSPOSE D) IF
C) TRANSPOSE
The_____ key can be used to move from one input box to another in a dialog box. A) Enter B) F4 C) Tab D) PgDn
C) Tab
When the Markers option in the Design contextual tab is checked, ______ A) marks for the first and last data values are placed on the sparklines B) a mark for only the low data value is placed on the sparklines C) a mark for each data value is placed on the sparklines D) a mark for only the high data value is placed on the sparklines
C) a mark for each data value is placed on the sparklines
5)A cell that is outlined in green and has data typed in it is the _______ cell A) home B) fill C) active D) selected
C) active
A worksheet inserted into a workbook using the New Sheet button is inserted A) at the beginning of the Tab group B) in the middle of the Tab group C) at the end of the Tab group D) in the location designated by the user in the dialog box that appears
C) at the end of the Tab group
A _______chart compares individual items or categories of items where the categories are displayed on the vertical axis, and the values are displayed on the horizontal axis A) line B) column C) bar D) scatter
C) bar
Chart buttons are displayed when the ______\ of the chart is clicked A) data marker B) legend C) border D) caption
C) border
A) worksheet B) grid C) cell D) workbook
C) cell
The specific design of the way data is either displayed or compared in a chart is a ______ A) chart type B) template C) chart style D) pattern
C) chart style
16) A ______chart is used to illustrate comparisons of related numbers A) scatter B) line C) column D) pie
C) column
22) A calculated __________is an Excel table feature that takes a formula in a column and automatically adjusts cell references for each row in the table. A) total B) row C) column D) Summary
C) column
When creating a chart, each cell in the blue range finder is a(n) _____ A) data marker B) legend C) data point D) axis
C) data point
The character used to separate columns of text in a data table is called a __________ A) comma-separated value B) gridline C) delimiter D) symbol
C) delimiter
After typing the new name of a worksheet tab, press the _____key to accept the name change. A) right arrow B) left arrow C) Enter D) Esc
C) enter
9) A message that appears in a cell when a formula cannot perform the specified calculations is alpl A) error indicator B) edit message C) error value D) failure messaage
C) error value
When a formula is in an active cell, the underlying formula is visible in the ________ A) status bar B) worksheet C) formula bar D) name box
C) formula bar
5) Which symbol is the error indicator that appears in a cell having a formula that has broken a rule? A) green square B) red exclamation point C) green triangle D) yellow caution sign
C) green triangle
A font theme consists of two fonts for_____ A) title and text B) title and cells C) heading and text D) numbers and text
C) heading and text
To remove columns from a worksheet, click Delete Sheet Columns after clicking the Delete arrow _______ A) in the Cells group on the Data tab. B) in the Editing group on the Data tab. C) in the Cells group on the Home tab. D) in the Editing group on the Home tab.
C) in the Cells group on the Home tab.
When a worksheet is inactive, _______ A) its tab is moved to the end of the Tab group B) its tab has no color C)its entire tab is filled with the selected color D) a gradient of its selected color fills its tab
C) its entire tab is filled with the selected color
A unique color or pattern identifying data markers that belong to the same data series is displayed in the chart A) caption B) title C) legend D) category label
C) legend
A(n) _____function applies a logical test to see if a specific condition is met A) statistical B) engineering C) logical D) text
C) logical
According to operator precedence, the correct order of mathematical aperations is ______ A) addition or subtraction; multiplication or division; parentheses B) parentheses; addition or subtraction; multiplication or division C) parentheses; multiplication or division; addition or subtraction D) multiplication or division, addition or subtraction; parentheses
C) parentheses; multiplication or division; addition or subtraction
A____ is a group of numbers, text, dates, or time periods that come in succession A) chain B) sequence C) series D) succession
C) series
Sheet tab grouping can be canceled by______ A) clicking the word Group on the title bar B) right-clicking the word Group on the title bar and selecting Ungroup C) single-clicking on any worksheet tab D) right-clicking on the tab scrolling buttons and selecting Ungroup
C) single-clicking on any worksheet tab
In a table with manual or conditional formatting, a column can be sorted only by ____ A) style B) color C) smallest to largest value D) largest to smallest value
C) smallest to largest value
A ________is a character not found on a standard keyboard. A) cell style B) format character C) symbol D) custom format
C) symbol
36) A(n) _____can be used so you do not have to start with a blank workbook. A) style B) pattern C) template D) format
C) template
15) The ______ displays a list of functions that match the first letter typed. A) formula bar B) Quick Access Toolbar C)the Formula AutoComplete D) edit feature
C) the Formula AutoComplete
4) The displayed value of a cell is replaced with a series of # symbols when___ A) a cell in the underlying formula has no value B) there is an error in the underlying formula C) the column is too narrow to display the entire value D) the name of a function is misspelled
C) the column is too narrow to display the entire value
The IF function can have a maximum of _____argument(s). A) one B) four C) three D) two
C) three
9) If content exists in cell B1, and a long text value is entered into cell A1, the A1 display is A) deleted B) wrapped C) truncated D) hidden
C) truncated
When pasting a range of cells, you only need to select the ______corner of the paste area A) upper right B) lower right C) upper left D) lower left
C) upper left
Select All Sheets is an option that appears when a(n) ____is right-clicked. A) row heading B) active cell C) worksheet tab D) column heading
C) worksheet tab
When a watermark is inserted into a worksheet, the field displays as _____ A) l&]Picture B) [&Picture] C)&[Picture] D) [Picture]
C)&[Picture]
2) Pages in a workbook are referred to as ______ A) subworkbooks B) gridsheets C) worksheets D) pages
C. Worksheets
20) Which is an example of an Excel function? A)=D7/D20 B)=D6+ D7 + D8 C)=D5*100 D)=SUM(D6:D8)
D) =SUM(D6:D8)
______data between Microsoft applications makes it easy to reuse data without having to retype the data A) Referencing B) Cutting C) Formatting D) Copying
D) Copying
From the Info view on the File tab, you can access the _____dialog box that allows you to search for and remove comments, metadata, and other hidden elements A) Document Properties B) Metadata Inspector C) Manage Workbook D) Document Inspector
D) Document Inspector
In addition to using the options in the Format Cells dialog box, you can apply borders to cells by using the ______pointer. A) Outline B) Presets C) Fill Border D) Draw Borders
D) Draw Borders
To find the smallest value in a list of numbers, use the _____function. A) SUM B) AVERAGE C) MAX D) MIN
D) MIN
The______ function returns the serial number of the current date and time. A) TODAY B) COUNT C) DATE D) NOW
D) NOW
The _____format shows text on multiple lines within a cell A) Merge& Center B) truncated C) Word wrap D) Text wrap
D) Text Wrap
14) An underlying value that does mathematical calculations on numeric values in a worksheet is A) a cell address B) a text value C) the Formula AutoComplete D) a formula
D) a formula
8) A cell that remains the same when it is copied or filled to other cells is a(n) A) relative cell reference B) constant cell reference C) fixed cell reference D) absolute cell reference
D) absolute cell reference
One way to rename a worksheet tab is by_____ A) entering the new name in cell A1 of the worksheet B) entering the new name in the Name Box C) entering the new name in the formula bar D) clicking the Rename Sheet option of the Format button in the Cells group on the Home tab
D) clicking the Rename Sheet option of the Format button in the Cells group on the Home tab
Arguments in a function are separated by a(n) _____ A) colon B) semi-colon C) exclamation point D) comma
D) comma
An example of a(n) ______is http://www.microsoft.com A) reference B)clipping C) operator D) hyperlink
D) hyperlink
When a range of cells are deleted, by default the remaining cells are shifted ____ A) up B) down C) right D) left
D) left
The _______ chart type is NOT a sparkline option A) column B) line C) win/loss D) pie
D) pie
37) Details that describe an Excel file, such as the author title, are called the document_____ A) references B) labels C) values D) properties
D) properties
When a selection has been made and the cut button or copy button is clicked, the selection is _____ A) surrounded by a green solid border B) surrounded by a red solid border C) highlighted D) surrounded by a moving border
D) surrounded by a moving border
If the year is not entered when typing a date into a cell, ___ A) the year 2000 will be automatically inserted B) the year 1900 will be automatically inserted C) the year will stay blank D) the current year will inserted
D) the current year will be inserted
34) Technologies that are used to help nonvisual users view content are ______technologies A) checker B) alternative C) accessibility D) three-dimensional
D) three-dimensional
The cell content shown in the formula bar is referrer to as the ____ value A) hidden B) actual C) displayed D) underlying
D) underlying
1) When Excel opens, a new _______ is displayed. A) presentation B) database C) document D) workbook
D. Workbook
26) Which is NOT an option in the Auto Fill Options menu? A) Paste Cells B) Fill Format Only C) Fill Series D) Copy Cells
A) Paste Cells
A cell _____is a line that can be used to emphasize or group cells. A) fill B) border C) background D) style
B) border
On a chart, a(n) _____identifies the categories of data A) category label B)category axis C) embedded labe D) style
B) category axis
If a date is typed as 7-5-17, Excel will complete it as A) 7/5/2017 B) Jul-17 C) 5-Jul-17 D) Jul-5-17
A) 7/5/2017
3) The Excel feature used to automatically adjust column width to the longest column entry is ____ A) AutoFit B) AutoComplete C) AutoAdjust D) AutoFill
A) AutoFit
The Chart Elements button displays options for all of these EXCEPT _____ A) Chart Caption B) Data Labels C) Chart Title D) Legend
A) Chart Caption
To generate a report of potential accessibility issues use the Accessibility ______ A) Checker B) Function C) Value D) Tool
A) Checker
What is applied to a cell when the value of the cell meets a specified condition? A) Conditional formatting B) Logical formatting C) Criteria formatting D) Provisional formatting
A) Conditional formatting
35) ______can be used to recognize a pattern in data and then automatically have the data entered for you. A) Flash Fill B) Text value C) Underlying value D) AutoComplete
A) Flash Fill
When multiple worksheet tabs are selected, the title bar displays the word ______after the name of the workbook A) Group B) Pivot C) Connected D) Linked
A) Group
Which date is assigned the serial number of 1? A) January 1, 1900 B) January 1, 2000 C) January 1, 1800 D) January 1, 1700
A) January 1, 1900
Excel evaluates the formula =4-2 *6/2+7 and performs______first A) Multiplication B) Subtraction C) Division D) Addition
A) Multiplication
28) Number formats can be adjusted with options in the Styles and ______ groups on the Home tab A)Number B) Font C) Cells D) Editing
A) Number
If a year is displayed as -2018- using a custom number format, the format used would be ______ A) [-year-] B) -yyyy- C)-year- D) #year#
B) -yyyy-
The custom number format Mm-Dd-yyyy would display the date 2/5/18 as _______ A) 2/5/18 B) 2/5/2018 C) 02/05/2018 D) 2/05/2018
B) 2/5/2018
25) After the fill handle is used to copy cell content, the _______button appears to the right of the selected cells A) Quick Copy Options B)Auto Fill Options C) Quick Fill Options D) Fill Handle Options
B) Auto Fill Options
The_______ function counts the number of cells that are in the entered range and contain numeric values. A) COUNTIF B) COUNT C) COUNTA D) NOW
B) COUNT
The default font face and size for text in Excel 2016 is _____ A) Arial, size 12 B) Calibri, size 11 C) Times New Roman, size 12 D) Cambria, size 11
B) Calibri, size 11
The cut and copy commands make use of temporary storage called the ______ A) Tablet B) Clipboard C) Pasteboard D) Cut/Copy board
B) Clipboard
Once you create a custom cell style, you can apply it to selected cells by clicking it in the _____ A) Cell Styles gallery B) Custom Styles gallery C) Format Cells dialog box D) This Workbook gallery
B) Custom Styles gallery
30) Options to insert a field, such as a filename, into a header or footer are in the group A) Header & Footer B) Header& Footer Elements C) Options D) Navigation
B) Header & Footer Elements
The ____dialog box is used to relocate a chart to a chartsheet. A) Insert Chart B) Move Chart C) Format Chart D) Chart Elements
B) Move Chart
The _____function calculates how much a payment will be based on constant payments and a constant interest rate. A) IF B) PMT C) PV D) FV
B) PMT
30) A worksheet tab can be removed from view by right-clicking the tab and selecting_______from the shortcut menu. A) Unhide B) Protect Sheet C) Tab Color D) Move or Copy
B) Protect Sheet
The principal of a loan is entered into the_____argument of the PMT function. A) rate B) Pv C) Nper D) Fv
B) Pv
The Text That Contains dialog box can be accessed by clicking the_____button A) Quick Access B) Quick Analysis C) Options D) Conditional Formatting
B) Quick Analysis
6) When a section of a worksheet displaying numeric values is selected, the appears; this is used to apply conditional formatting or to insert a chart or table based on the selected content. A) Quick Format button B)Quick Analysis button C) Quick Analysis contextual tab D) Quick Access button
B) Quick Analysis Button
The _____button on the Design tab displays the locations where a title and a legend can be positioned in a chart. A) Change Color B) Quick Layout C) Chart Style D) Add Chart Elements
B) Quick Layout
When a range of cells is converted to a table, the default setting in the Filter gallery is _____ A) Sort by Color B) Select All C) Sort Smallest to Largest D) Sort Largest to Smallest
B) Select All
6) When a cell is active, its column and row headings are A) bolded B) shaded C) flashing D) hidden
B) Shaded
A(n)______gives a visual representation of information that is used to effectively communicate ideas A) clustered bar chart B) SmartArt graphic C) organization chart D) screen clipping
B) SmartArt graphic
When the formula (4-2)*6/2+7 is evaluated in Excel, which will be the first mathematical operation performed? A) Multiplication B) Subtraction C) Division D) Addition
B) Subtraction
The______function will convert the name Chuck to CHUCK. A) LOWER B) UPPER C) TRANSPOSE D) IF
B) UPPER
Right-clicking a row heading displays____ A) a shortcut menu B) a shortcut menu and a mini toolbar C) a mini toolbar D) an Options button
B) a shortcut menu and a mini toolbar
22) When no cells are selected and the AutoSum button is clicked, Excel first looks ______the active cell for a suitable range to sum A) below B)above C) to the right of D) to the left of
B) above
Text that is used to provide a description on an object is _____text A) 3-D B) alternative C) accessibility D) embedded
B) alternative
