Excel 1810 Final
When you print in portrait orientation, the page is wider than it is tall. true or false?
False
A(n) _____ is descriptive text that appears next to a chart's horizontal or vertical axis. major tick mark axis title data label display units
axis title
How can you reverse your most recent action in Excel? Click the Redo button. Click the Escape button. Click the Undo button. Click the Reverse button.
click the undo button
To format a range so that all values greater than $500 appear in red, which of the following can you use? Quick Access toolbar cell styles cell formatting conditional formatting
conditional formatting
To retrieve a return value from a vertical lookup table, you use the VTABLE function. True False
false
When you change cell contents to italics, you are changing the cell's alignment. False True
false
You receive a worksheet in which the rows are numbered 1, 2, 3, 5,6. This means that row 4 is _____. deleted cut hidden conditionally formatted
hidden
Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C. hide edit delete conditionally format
hide
Before inserting sparklines into cells, make sure the cells are blank because sparklines replace cell contents. True False
true
Column sparklines show a general trend without a legend, title, or gridlines. True False
true
Currency is an example of a number format. True False
true
Flash Fill enters text based on patterns it finds in the data. True False
true
Which of the following elements can you add to a chart to display a line representing the general direction in a data series? Trendline Axes Gridlines Legend
Trendline
To preserve an exact cell address in a copied formula, you can use a relative cell reference. False True
false
When you click a cell to insert a cell reference in a formula, you must type a(n) number to lock the cell reference in the formula. True False
false
When you copy cell contents, the data is removed from its original location and placed on the Clipboard. True False
false
When you select a cell range, the cells must be adjacent to each other. False True
false
You can insert a formula by selecting a range of values, clicking the Quick Analysis button, and then clicking Tables. True False
false
You should move a chart to a chart sheet when you want the source data to appear with the chart. True False
false
A combination chart combines two chart types and can plot data on primary and secondary axes. True False
true
A good practice is to move the most important worksheets to the end of the workbook. true or false?
False
When you enter a number, date, or time in a cell, it is left-aligned by default. true or false?
False
Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply. Format Cells dialog box Insert tab Home tab Mini toolbar
Format Cells dialog box Home tab Mini toolbar
To copy a cell's formatting to another cell, which of the following can you use? Format Painter Quick Analysis Tool Format Cells dialog box Format as Table
Format Painter
Which of the following conditional formatting options can you use to highlight the top 10 values in a range of cells? Data Bars Icon Sets Highlight Cells Rules Color Scales
Highlight Cells Rules
Nathan wants a formula to return "Yes" if the value in cell A1 is less than the value in cell B1, and to return "No" otherwise. Which of the following functions should he use? IF RAND IFERROR VLOOKUP
IF
Which of the following is a type of logical function? VLOOKUP AVERAGE IF ROUND
IF
Which of the following is a built-in formula that helps you perform complex calculations? function named range mode indicator clipboard
function
If a worksheet contains data that is not of interest to the user and is better summarized in another part of the workbook, consider _____ the worksheet. moving renaming deleting hiding
hiding
You can add data marks to sparklines to highlight which of the following values? Select all the options that apply. high values negative values ending values low values
high values negative values ending values low values
To apply a cell style, you would use the Cell Styles command on the _____ tab. Layout View Insert Home
home
Which of the following options can you set when you create or edit a data bar conditional formatting rule? Select all the options that apply. how to display negative values fill color of the data bars font color of the text value used for the longest data bar
how to display negative values fill color of the data bars value used for the longest data bar
Which of the following views shows how a worksheet will appear when printed? Page Break Preview Page Layout view Normal view Reading view
normal view
What does the third argument (3) refer to in the following formula: VLOOKUP(10005, A1:C6, 3, FALSE)? location of the lookup table cell with the lookup value number of the column containing the return value whether to return a value only when an exact match is found
number of the column containing the return value
Bree added data labels to a pie chart, where they appear on each slice. She wants the data labels to appear outside of the pie chart but close to each slice. Which Label Position option should she select for the data labels? Inside End Outside End Center Overlay
outside end
Which of the following tabs lets you set worksheet print options? Preview View Home Page Layout
page layout
When you _____ a formula, Excel retrieves the formula from the Clipboard and places it into the selected cell. cut copy move paste
paste
You double-click the Format Painter button when you want to _____. paste the same format multiple times copy a cell's data to another cell paste conditional formatting only clear a cell's formatting
paste the same format multiple times
Which of the following are functions you can use to calculate measures of central tendency? Select all the options that apply. MAX MEDIAN AVERAGE SUM
MEDIAN AVERAGE
To have Excel enter the lowest price from a range of prices, which of the following would you use? COUNTA function MIN function COUNT function MAX function
MIN function
To combine multiple cells into one combined cell, which of the following do you use? Increase Indent button Merge and Center button Column Width command Center button
Merge and Center button
The _____ displays the cell reference of the active cell. formula bar Name box worksheet title status bar
Name box
Which of the following lets you extend any data pattern involving dates, times, numbers, or text? Paste Options button AutoFill Options button Quick Analysis AutoSum list
AutoFill Options button
When Valerie used AutoFill to copy a formula, Excel copied the format and removed shading from some cells. What can she do to prevent the formatting change? Click the Paste Options button and then click Undo. Click the AutoFill Options button and then click Fill Without Formatting. Click the AutoFill Options button and then click Fill Formatting Only. Click the Quick Analysis button and then click Fill Without Formatting.
Click the AutoFill Options button and then click Fill Without Formatting.
Which of the following lets you edit the contents of a cell? Click the cell and click in the status bar. Double-click the cell or click in the formula bar. Click the cell, click the status bar, and press Enter. Double-click the cell, click in the status bar, or just start typing.
Double-click the cell or click in the formula bar.
To change conditional formatting that applies a red fill color to one that applies a green fill color, which of the following can you do? Edit the conditional formatting rule. Format the range in the Font dialog box. Delete the conditional formatting rule. Format the range as a table
Edit the conditional formatting rule.
You have selected a cell with a formula. Which of the following can you use to copy that formula to an adjacent cell? Page Break Preview Fill handle mode indicator scroll bar
Fill handle
Which Excel features can you use to extend a formula into a range with AutoFill? Select all the options that apply. Fill handle Fill button in the Editing group AutoSum button in the Editing group Quick Analysis tool
Fill handle Fill button in the Editing group
Maddie entered customer first names in column A and last names in column B. What feature can she use to enter the full names in column C? What-if analysis Quick Analysis tools Business Intelligence Flash fill
Flash fill
Which of the following Excel tools displays the syntax for a selected function? Insert Function dialog box Insert dialog box Function Library Formula bar
Insert Function dialog box
Your worksheet appears with a reduced view of each page and blue dividers where new pages begin. What view are you in? Page Break Preview Print Preview Normal view Page Layout view
Page Break Preview
You can edit a worksheet footer in _____. Print Preview Page Layout view Normal view Page Break Preview
Page Layout view
Which of the following statements is true about COUNT functions? Using the COUNT function is useful for computing the average of a cell range. The COUNT function returns the number of cells in a range that contain numeric data. The COUNT function returns the number of calls in a range that are not blank. The COUNT function returns the number of calls in a range that contain any data at all.
The COUNT function returns the number of cells in a range that contain numeric data.
Niki wants to insert a Line sparkline in Excel. To do this, she can click on the cell she wants to insert a Sparkline, then click Insert tab, select Line Sparkline from the Sparklines group and then OK. True False
true
To change a chart title, you click the chart title, type the new title, and then press ENTER. False True
true
To format the cell value 44.54 as 44.540, you can use the Increase Decimal button. True False
true
To move a worksheet, you can drag its sheet tab to the left or right. True False
true
To paste only a copied cell's formats, use the Paste Special command. False True
true
To print a worksheet, you begin by going to Backstage view. true or false?
true
The default worksheet text is _____-point Calibri. 11 14 12 10
11
Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so? =SUM(B1:B20) =COUNTIF(B1:B20) =CALCULATE(B1:B20) =COUNT(B1:B20)
=COUNT(B1:B20)
Your worksheet contains a price in cell A5, and many formulas refer to that price. How would you refer to that price in the formulas? A5 $A$5 A$5 $A5
$A$5
Which of the following formulas adds 25 and 10, and then multiplies the result by 50? 50*25+10 =25+10*50 (25+10)*50 25/(10*50)
(25+10)*50
A student is given the task of counting the number of nonblank cells in the range of cells B1 to B20. Which of the following formulas should he use to do so? =COUNT(B1:B20) =COUNTA(B1:B20) =COUNTIF(B1:B20) =DCOUNTA(B1:B20)
=COUNTA(B1:B20)
The score of a student is inserted in cell B2. The passing score for the subject is 60. Which of the following functions should you insert in cell C2 to check whether the student has passed or failed? =IF(B2 < 60, "Pass", "Fail") =IFERROR(IF((B2 >= 60, "Pass", "Fail")) =IF(B2 = 60, "Pass", "Fail") =IF(B2>=60, "Pass", "Fail")
=IF(B2>=60, "Pass", "Fail")
Jason wants to average the sales in the range C3:C50, and then round the result to the nearest integer. Which of the following formulas should he use? AVERAGE(ROUND(C3:C50),0) =ROUND(AVERAGE(C3:C50),0) =ROUND(C3:C50) =AVERAGE((C3:C50), ROUND, 0))
=ROUND(AVERAGE(C3:C50),0)
The IF function can use which of the following comparison operators? Select all the options that apply. > (greater than) = (equal) * (multiplication) <> (not equal)
> (greater than) = (equal) <> (not equal)
When you paste formula cells using the Paste button in the Clipboard group, which of the following is true? Pointing to the destination cell displays a preview of the cell contents. The formula is copied with cell references you must adjust to avoid worksheet errors. The Auto Fill Options button appears. A button appears near the selected cells with options for pasting formulas and values.
A button appears near the selected cells with options for pasting formulas and values.
Which of the following functions would you use to calculate the arithmetic mean of a price list? SUM MAX COUNT AVERAGE
AVERAGE
In the formula =B6*$B$2, which of the following describes $B$2? Absolute cell reference Relative cell reference Function Average
Absolute cell reference
When you double-click the right border of a column heading, which of the following occurs? AutoFit resizes the column to the widest cell entry. The column is deleted. AutoFit resizes the column to 8.43 characters wide. A column is added to the right of the current column.
AutoFit resizes the column to the widest cell entry.
Louis has entered a column of expense values. What feature can he use to insert the total expenses at the end of the column? reference operator AutoSum button absolute reference mode indicator
AutoSum button
You have cut the range A1:A5, and want to paste it to C1:C5. Which of the following statements is true? Before you paste it, you need to select C1:C5. After you paste it, the information is deleted from the Clipboard. After you paste it, the information is deleted from the original location. Before you paste it, you only need to select cell C1.
Before you paste it, you only need to select cell C1. After you paste it, the information is deleted from the original location.
What can you do to make data series easier to distinguish from one another? Change the color of the data series. Increase the size of the data series. Apply additional text styles. Change the chart type.
Change the color of the data series.
While working in Page Layout view, how can you enter your name so it appears in the lower-right corner of the printout? Click the footer section on the right and type your name. Click a cell in the lower-right part of the worksheet and type your name. Open the Footer dialog box and click the Name button. Switch to Print Preview and type your name in the lower-right corner of the preview.
Click the footer section on the right and type your name.
In a complex formula, how does Excel determine which calculation to perform first? It calculates functions first. It calculates operations outside parentheses first. It follows the order of operations. It calculates the leftmost formulas first.
It follows the order of operations.
In column D of a worksheet, Cal lists the number of hours each employee works. What function should he use to find the employee who worked the most hours? INT MIN MAX MEDIAN
MAX
To paste copied cell contents with values only, not including formatting, which of the following can you use? Select all the options that apply . Paste button Paste Options button Paste Special Paste pane
Paste Options button Paste Special
Eleanor wants to repeat the first row of the worksheet on each printed page of a four-page worksheet. Which of the following options should she use in the Page Setup dialog box? Print titles Row and column headings Gridlines Print area
Print titles
You can create conditional cell formats using either the Home tab or the _____. Cell Styles dialog box Font formatting buttons on the Home tab Quick Analysis tool Number formatting buttons on the Home tab
Quick Analysis tool
If you want to change all occurrences of "Radio" to "TV" in a worksheet, you can use the _____ command . Find Paste Replace Select
Replace
Which of the following functions inserts the total of a range? ROUND AVERAGE SUM AUTOSUM
SUM
Which of the following formulas totals the cells B6, B7, B8, B9, and B10 most efficiently? The formula =TOTAL(B6-B10) The formula =SUM(B6:B10) The formula +SUM(B6-B10) The formula =B6+B7+B8+B9+B10.
The formula =SUM(B6:B10)
Which of the following is true about deleting a worksheet row? You cannot delete a row if it contains data. Deleting a row and clearing a row have the same results After you delete a row, the rows below it shift down one row. To delete a row, you can select the row, and then click the Delete button in the Cells group.
To delete a row, you can select the row, and then click the Delete button in the Cells group.
When you use the Windows Start menu to start Excel, it opens in Backstage view. true or false?
True
Which of the following is true about moving cell contents? You cannot move cells from one worksheet to another. You can move cells using the drag-and-drop feature. When you move cell contents, they remain in their original location. You can move cells using the Copy command.
You can move cells using the drag-and-drop feature.
When you underline cell content, you are using _____. a centering style an indent setting a font style an orientation setting
a font style
In the formula =SUM(A6:A9), which of the following best describes A6:A9? label function argument active cell
argument
Which of the following indicates the column and row where a cell is located? column heading active cell formula bar cell reference
cell reference
To select a single worksheet cell so you can work with it, which of the following would you do? Click the cell. Click the Name box. Click the status bar. Move the cell pointer over the cell.
click the cell
Which of the following is the temporary storage area that holds selections you copy or cut? Backstage Worksheet window Clipboard Name box
clipboard
To help you easily identify sheets in a workbook, you can add _____ to the sheet tab. Styles Alignment Color Fonts
color
Which type of conditional formatting rule would you create to add a horizontal bar to a cell background, where the length of the bar reflects the value in the cell? Color Scales Top Values Icon Sets Data Bar
data bar
If you see a cells with blue fills of varying lengths representing the values, the cells most likely have ________ applied to them. cell styles themes data bars icon sets
data bars
A predesigned combination of formats, such as font size and color, is called a cell default. True False
false
A(n) trendline is a line that extends from the chart's horizontal or vertical axis into the plot area, making it easier to identify the values in the chart. True False
false
Changing a worksheet window to Normal view changes the contents of the worksheet. True False
false
Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5. True False
false
If you want to paste values and number formatting only, click the Paste Numbers button that appears below the pasted cell. True False
false
In formulas, calculations in square brackets are calculated first. True False
false
The Comma Style format adds a comma and a dollar sign to a cell value. False True
false
To enter a typed number into a cell, you can press Tab or Backspace. true or false?
false
To find the largest value in a cell range, use the MIN function. True False
false
To increase the magnification of a worksheet from 100% to 120%, you use the Magnification slider. true or false?
false
To insert only the current date in cell B1, use the NOW function in cell B1. False True
false
To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it. False True
false
To change the color of cell content, you use the ________ color list arrow. Font Pattern Text Cell
font
To which of the following chart types can you not add axis titles? Pie chart Line chart Column chart Area chart
pie chart
If you want to print only part of a worksheet, you can set a _____. scaling option print area print title page break
print area
Which of the following chart types show how two numeric data series are related to each other? Pie Scatter Bar Line
scatter
Kathy wants to add the numbers entered in a range of selected cells. To do this, which tab will she click on the menu that appears after clicking on Totals in the Quick Analysis option? Sum %Total Average Count
sum
A constant is a term in an equation whose value does not change. False True
true
A theme is a predefined coordinated set of colors, fonts, graphical effects, and other formats. False True
true
Alicia created a chart that shows months in rows and prices in columns. She can switch the rows and columns to show prices in rows and months in columns. True False
true
When you insert a worksheet row, a row is inserted above the cell pointer and the sheet contents move downward. True False
true
You can add data markers to sparklines to indicate the high and low points in the chart. True False
true
You can edit cell contents in the formula bar or in the cell itself. true or false?
true
You can set a scaling option to resize a worksheet to fit within a single page. true or false?
true
You use conditional formatting to format a cell based on its value. False True
true
The Percent style formats numbers as percentages with _____ decimal places by default. two three zero one
zero
