Excel Exam - 1-5

¡Supera tus tareas y exámenes ahora con Quizwiz!

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


Conjuntos de estudio relacionados

Right to refuse medical treatment

View Set

International Film History Review Ch. 1-3

View Set