Microsoft IT Academy - Excel Final Exam Practice Questions

A(n) __________ is a predefined set of colors, fonts, and effects that can be applied to an entire workbook.

theme

Which of the following statements is not true? a. You can change both the height and width of a chart with commands on the Format tab. b. You can use the sizing handles to change the height and width of a chart. c. You must delete an existing chart in order to have the data displayed in a different chart type. d. When a chart sheet is created, the chart no longer appears on the worksheet containing the data series.

c. You must delete and existing chart in order to have the data displayed in a different chart type.

Which of the following is an example of an absolute cell reference? a. A9 b. A$9 c. $A$9 d. A9:E9

c.$A$9

The identifying letter at the top of a column is called the __________.

column header

To render twice the normal amount of worksheet displayed for any given area of the screen, which of the following settings would you need to change the Zoom to? a. 200% b. 120% c. 75% d. 50%

d. 50%

If you want to move a shape up one level within a stack of overlapping graphics, which of the following buttons should be clicked? a. Restack b. Bring to Front c. Rearrange d. Bring Forward

d. Bring Forward

Which of the following functions joins two or more text strings into a single text string? a. AND b. MID c. TRIM d. CONCATENATE

d. CONCATENATE

Which of the following can you not copy using Format Painter? a. Font color b. Bold c. Font size d. Cell content

d. Cell content

Which of the following procedures is not a way to filter a table by the contents of one column? a. Click the criterion button on the slicer. b. Right-click the cell whose contents you want for the criterion and click Filter in the menu. c. Click the Filter button in the Sort & Filter group of the Data tab. d. Click the AutoFilter button in the total row at the bottom.

d. Click the AutoFilter button in the total row at the bottom.

In Excel, a password can not be required for which of the following? a. Opening a file b. Formatting cells, columns, and rows on a worksheet c. Adding a new worksheet, deleting a worksheet d. Deleting a file

d. Deleting a file

A(n) __________ is a line of text that appears at the top of each page of a printed worksheet.

header

Which of the following procedures is not a way to delete one or more worksheets from a workbook? a. Right-click a worksheet tab and click Delete. b. Press Ctrl+A to select all cells in the worksheet and then press Delete. c. Click the Delete down arrow on the Home tab and click Delete Sheet. d. Select a group of worksheets, right-click the group, and click Delete.

b. Press Ctrl+A to select all cells in the worksheet and then press Delete.

Which of the following can be customized for quicker access to your most commonly used commands? a. Print Preview b. Quick Access Toolbar c. Printer setup d. Workbook

b. Quick Access Toolbar

Which of the following functions allows you to have Excel place a random number between 10000 and 99999 in a cell? a. RAND() b. RANDBETWEEN(10000,99999) c. BYCHANCE(10000,99999) d. RANDOM(10000,99999)

b. RANDBETWEEN(10000,99999)

Adding, deleting, and viewing comments are performed from the commands on which ribbon tab? a. Comments b. Review c. File d. View

b. Review

The Protect Workbook button is on which ribbon tab? a. Comments b. Review c. File d. View

b. Review

In the formula =SUMIFS(C5:C16, F5:F16, "<=60", B5:B16, ">200000"), which of the following is the range of cells to be added? a. = C5:C16 b. = F5:F16 c. = B5:B16 d. = C5:F16

a. = C5:C16

An arrow in the lower-right corner of a group on the ribbon tells you that which of the following is available? a. A dialog box or task pane b. An additional workbook c. A list of worksheets d. An additional part of the current range

a. A dialog box or task pane

Which of the following functions returns a value if all conditions are met? a. AND b. OR c. IF d. SUM

a. AND

Which of the following is where you can save, select a template, change document properties, and close or exit Excel? a. Backstage b. Print c. Edit d. Windows

a. Backstage

Which of the following functions automatically counts cells that meet a specific condition? a. COUNTIF b. COUNT c. COUNTIFS d. SUMIFS

a. COUNTIF

Which part of a chart do you click when you want to select the entire chart? a. Chart area b. Plot area c. Chart title d. Legend

a. Chart area

When you want to print only the chart in a worksheet, which of the following steps should be taken before printing? a. Click the chart to select it and then print. b. Select the Print chart only option in the Page Setup dialog box. c. Move the chart to a new sheet by itself and then print that sheet. d. You cannot print only the chart if it is part of a larger worksheet.

a. Click the chart to select it and then print.

If you want to use a workbook in another kind of document, you have the option to save using which of the following? a. File format b. Worksheet c. File sheet d. File range

a. File format

A bar chart represents values as which of the following? a. Horizontal bars b. Vertical bars c. Horizontal lines d. Vertical lines

a. Horizontal bars

Which of the following buttons gives you access to Bing Image Search? a. Online Pictures b. Pictures c. Shapes d. SmartArt

a. Online Pictures

Which feature enables you to preview headers and footers, page breaks, and other features that will print? a. Page Layout b. Print Layout c. Synchronous Scrolling d. ScreenTips

a. Page Layout

Which command is used to insert a cut or copied selection to a cell or range of cells? a. Paste b. Document properties c. Copy d. Range

a. Paste

Which of the following buttons is clicked to apply a shadow to a shape or line? a. Shape Effects b. Picture Effects c. Artistic Effects d. 3D Effects

a. Shape Effects

Which of the following keyboard shortcuts can be used to add a note to a cell? a. Shift+F2 b. Ctrl+N c. Alt+Shift+C d. Ctrl+F9

a. Shift+F2

Which of the following statements describes how to change the color of a worksheet tab? a. On the Page Layout tab, in the Themes group, select Colors. b. Right-click the tab and select Tab Color. c. Use the Fill Color tool on the Home tab. d. You cannot change the color of a worksheet tab.

b. Right-click the tab and select Tab Color.

Which of the following commands is used to insert a cell into a worksheet? a. The Insert command in the Cells group on the Home tab b. The Format command in the Cells group on the Home tab c. The Format Painter command in the Clipboard group on the Home tab d. The Format command in the shortcut menu when you right-click a cell

a. The Insert command in the Cells group on the Home tab

What does criteria range in a formula refer to? a. The worksheet data to be included in the formula's results b. The range containing a condition that must be met in order for data to be included in the result c. The type of formula being used for the calculation d. The type of data contained in the cells to be included in the formula

b. The range containing a condition that must be met in order for data to be included in the result

Which of the following steps should be performed to move a chart from a worksheet to a chart sheet? a. Use the move handles and drag it to the new location. b. Use the Move Chart button on the Design tab. c. Cut the chart from the worksheet and paste it to a new workbook sheet. d. You cannot move the chart after it has been created.

b. Use the Move Chart button on the Design tab.

Which of the following functions searches for a value in the first column of Table_array and returns a value in the same row from Col_index_num? a. AVERAGEIF b. VLOOKUP c. MID d. HLOOKUP

b. VLOOKUP

A column chart represents values as which of the following? a. Horizontal bars b. Vertical bars c. Horizontal lines d. Vertical lines

b. Vertical bars

Which of the following actions can not be performed with comments? a. You can format the text using a different color. b. You can change the background comment box color. c. You can prevent the disclosure of the name of the user who made the comment. d. You can hide the comment.

b. You can change the background comment box color.

The COUNT and MIN functions are examples of which category of functions? a. text b. statistical c. financial d. logical

b. statistical

Which of the following is an acceptable name for a named range? a. C7 b. subtotal_west c. subtotal west d. subtotal/west

b. subtotal_west

When you modify the ribbon, which of the following is created? a. command b. tab c. button d. worksheet

b. tab

The __________ is the line between rows or columns.

boundary

Which of the following is not on the Review tab? a. Track Changes button b. Share Workbook button c. Protect Cells button d. Protect and Share Workbook button

c. Protect Cells button

Which of the following steps is a method for hiding a single worksheet in a multi-sheet workbook? a. On the View tab, in the Window group, click Hide. b. Select the visible area of the worksheet. c. Right-click the worksheet's tab and click Hide. d. Enter the name of the worksheet in the Hide dialog box.

c. Right-click the worksheet's tab and click Hide.

Which of the following is the first step that should be taken when creating a chart? a. Providing a name for the chart b. Selecting the chart type c. Selecting the range of cells that contain the data the chart will use d. Choosing the data labels that will be used in the chart

c. Selecting the range of cells that contain the data the cart will use

Which of the following can not be used to turn on track changes? a. The Track Changes button b. The Share Workbook button c. The Protect Sheet button d. The Protect and Share Workbook button

c. The Protect

Which of the following starts off with Save, Undo, and Redo and can be customized to contain the commands you use most frequently? a. A worksheet b. The Help window c. The Quick Access Toolbar d. The ribbon

c. The Quick Access Toolbar

Which of the following happens to a chart when the source data is deleted? a. Nothing. b. The chart will move to the area where the data was located. c. The data in the chart is deleted. d. You will be asked if you want the chart deleted.

c. The data in the cart is deleted.

Which of the following are valid reasons for converting a table to a range? a. To clear the sorting criteria and start over. b. To prepare for deleting a column. c. To prepare for importing new data from a non-Excel file. d. To prepare to change its conditional formatting.

c. To prepare for importing new data from a non-Excel file.

Which of the following is not an option in the Comments group? a. New Comment b. Delete c. Track Changes d. Edit Comment

c. Track Changes

If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width. True or False

False

The Quick Access Toolbar appears on the right side of the title bar, above the ribbon. True or False?

False

The columns in a worksheet are identified by numbers. True or False?

False

The formula bar is found at the bottom of the Excel window. True of False?

False

Using the Delete key removes both text and formats from a cell. True of False?

False

When you delete cells in a worksheet, you remove one or more cells, forcing other cells to move down or to the right. True or False

False

You can access Backstage view by pressing Ctrl+B. True or False

False

__________ is the top-to-bottom measurement of a row, measured in points.

Row height

__________ refers to shrinking or stretching printed output to a percentage of its actual size.

Scaling

Which of the following statements describes how to you unhide a hidden row or column? a. Select a range of cells in the row or column, right-click, and select Unhide. b. Use the Page Setup dialog box. c. Remove all page breaks. d. Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.

Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.

Which of the following statements describes the difference between an Auto Outlined worksheet and a worksheet with multiple groups? a. There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups. b. Only an Auto Outlined worksheet may contain total rows. c. An Auto Outlined worksheet contains only one button for collapsing and expanding. d. Only a multi-grouped worksheet can cluster rows and columns.

a. There is no difference between an Auto Outlined worksheet and a worksheet with multiple groups.

Which of the following is not found in the Illustrations group on the Insert tab? a. WordArt b. Shapes c. Online Pictures d. SmartArt

a. WordArt

Which of the following statements describes the reason you would want to record a macro with absolute references rather than relative? a. You want to preserve the integrity of any cells referenced by formulas in the macro. b. You want the values of any cells copied to the macro to be accurate. c. You want the results of any formulas produced by the macro to be accurate. d. You want the macro to reproduce its results in the same place each time.

a. You want to preserve the integrity of any cells referenced by formulas in the macro.

How many worksheets does a new Excel 2016 workbook open with? a. one b. two c. three d. four

a. one

Which of the following characters would not appear on an outline symbol or control for grouped or outlined data? a. + b. @ c. 2 d. -

b. @

Which of the following is an example of a mixed cell reference? a. A9 b. A$9 c. $A$9 d. A9:E9

b. A$9

When you create a copy of a worksheet named August, Excel gives that worksheet which of the following names? a. September b. August (2) c. Sheet2 d. July

b. August (2)

Which of the following calculates the total from the adjacent cell through the first nonnumeric cell by default, using the SUM function in its formula? a. AVERAGE b. AutoSum c. COUNT d. MAX

b. AutoSum

You want to add a range of cells and then divide by the number of cell entries, determining the mean value of all values in the range. Which function should be used? a. MIN b. AVERAGE c. COUNT d. MAX

b. Average

You want to calculate the number of nonblank cells in your worksheet. Which function should be used? a. SUM b. COUNTA c. MIN d. MAX

b. COUNTA

Which of the following procedures is not a way to sort a table by the contents of one column? a. Click the Sort button in the Sort & Filter group of the Data tab. b. Click an AutoFilter button in the total row. c. Click an AutoFilter button in the field names row. d. Click the Filter button in the Sort & Filter group of the Data tab.

b. Click an AutoFilter button in the total row.

Which of the following can you drag or double-click to change the width of a column? a. Cell pointer b. Column marker c. Fill handle d. Formula bar

b. Column marker

Which of the following consists of details that describe or identify a file, including the author? a. Paste b. Document properties c. Copy d. Range

b. Document properties

The Shape Styles group is found on which of the following tabs? a. Insert b. Drawing Tools Format c. Home d. Styles

b. Drawing Tools Format

Which chart type appears on a worksheet with other data? a. Chart sheet b. Embedded c. PivotChart d. Mixed

b. Embedded

Which of the following attributes is not a potential criterion for an AutoFilter sort? a. Font color b. Font style c. Cell color d. Cell icon

b. Font style

When drawing lines, which of the following statements accurately describes how to change line thickness? a. Right-click the line and choose Thickness. b. In the Shape Outline menu, select Weight. c. You must set the thickness before drawing the line. d. In the Shapes menu, select the Thicker Line option.

b. In the Shape Outline menu, select Weight

Which of the following statements describes a reason as to why you would need to copy a worksheet within a workbook? a. It's the easiest way to make a backup before making changes. b. It lets you reuse formats and formulas in a new sheet. c. It helps Excel learn where your data ranges are located. d. You should keep one worksheet hidden in case of an error.

b. It lets you reuse formats and formulas in a new sheet.

In which of the following locations does the Format Picture pane appear by default? a. As a free-floating pane b. On the right side of the workspace c. On the left side of the workspace d. Centered across the bottom of the workspace

b. On the right side of the workspace

Which of the following functions converts text from uppercase to title case? a. UPPER b. PROPER c. LOWER d. TRIM

b. PROPER

Which of the following dialog boxes is used to transpose rows and columns? a. Page Setup b. Paste Special c. Column Width d. Row Height

b. Paste Special

You can create a new range by selecting the cells and typing a name in the Name Box next to the formula bar. True or False

True

You cannot split a single worksheet cell that has not been merged. True or False

True

You must use the AutoSum button to enter a SUM function—you cannot type it manually in a cell. True or False

True

After you select a color and apply it to a cell's background, the Fill Color button takes on that color. True or False

True

In Excel, you can add your most commonly used commands to the Quick Access Toolbar. True or False

True

Page Layout view is useful when preparing your data for printing. True or False?

True

Regarding a named range, the scope of a name is the location within which Excel recognizes the name without qualification. True or False

True

Style attributes include fonts and font sizes, number formats, and borders and shading. True or False

True

The AVERAGE function returns the mean value in a range of selected cells. True or False

True

The COUNT function returns the total number of cells in the selected range that contain both text and numbers. True or False

True

The MAX function returns the total of all cells in the selected range. True or False

True

The MIN function returns the smallest value in a range of cells. True or False

True

The active cell in a worksheet is outlined by a bold rectangle. True or False?

True

The formula = 6 * 2 / 3 produces the same result as = 6 * (2 / 3). True or False

True

The order of operations determines which parts of a formula are calculated before other parts of the formula. True or False

True

To access an Excel template, you can click the File tab and then click New. True or False

True

To allow Excel to distinguish formulas from data, all formulas begin with an equal sign (=). True or False

True

Use the fill handle to create a natural series, such as the months of the year. True of False?

True

When you point to defined styles in the Cell Styles gallery, you can see the formatting that will be used when you apply each style. True or False

True

Workbooks can be saved as web pages, PDF files, and for use in previous versions of Excel. True of False?

True

You can assign keywords so that others can search for your documents online. True of False?

True

You can create a completely new ribbon tab as well as groups on that ribbon. True or False

True

Which of the following would is considered the strongest password? a. 02Feb2016 (your dog's birthdate) b. DenVer (the city in which you were born, with odd capitalization) c. 679KrDj! (the last three digits of your social security or social insurance number and first names of each of your siblings with an exclamation point) d. BruinsO6 (your high school mascot and year you graduated using the letter O for a zero)

c. 679KrDj! (the last three digits of your social security or social insurance number and first names of each of your siblings with an exclamation point)

Which of the following does Excel not provide features for importing data? a. An active database b. A Web page c. A Web search d. An XML file

c. A Web search

Which of the following statements about hidden and unhidden worksheets is correct? a. Unhidden worksheets cannot contain formulas that refer to hidden worksheets. b. When you click Find All, the Find and Replace dialog box will show matched contents within hidden worksheets as well as unhidden ones. c. A hidden worksheet cannot be inadvertently deleted. d. Excel creates a minimized window for each hidden worksheet.

c. A hidden worksheet cannot be inadvertently deleted.

Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table? a. There is no difference between an AutoFiltered range of records in a list and a table. b. A table maintains its sort order after you close and then open it again. c. A table given a title enables its field names to be used in formulas in place of cell references. d. A table enables special subtotal functions for total rows.

c. A table given a title enables its field names to be used in formulas in place of cell references.

When you click the New sheet (+) button on the tabs bar, where is a worksheet always inserted? a. At the beginning of the tabs sequence b. Before the active worksheet c. After the active worksheet d. At the end of the tabs sequence

c. After the active worksheet

Which of the following is a correct reference to the cell in the Total Sale column on the rightmost side of a table called Auction Items? a. Table[Auction Items(Total Sale)] b. Auction Items(Total Sale) c. Auction Items[#Totals] d. #Totals[Total Sale]

c. Auction Items[#Totals]

Which of the following statements accurately describes the default selection for AutoSum? a. You must make the selection before clicking AutoSum. b. By default, AutoSum totals all entries above the cell in which the formula is located, even if the cells contain a mix of numeric and nonnumeric content. c. By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell. d. AutoSum does not have a default selection.

c. By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.

Which of the following functions automatically counts cells that meet multiple conditions? a. COUNTIF b. COUNT c. COUNTIFS d. SUMIFS

c. COUNTIFS

You don't like the cell style you just applied. Which of the following is the least effective way to remove or replace the style? a. Apply another style to the cell. b. Use the Undo command. c. Clear the cell's content. d. Apply the Normal style to the cell.

c. Clear the cell's content.

Which of the following object resizing handles is used to resize a shape or picture proportionally? a. Top center b. Left or right side c. Corner d. Rotate

c. Corner

Which of the following statements describes how to increase or decrease a column's width? a. Right-click anywhere in the column and select Format Cells. b. Use the Page Setup dialog box. c. Drag the boundary next to the column heading. d. Select a Width setting in the Scale to Fit group on the Page Layout tab.

c. Drag the boundary next to the column heading.

Which is a small green square in the lower-right corner of a selected cell or range that you can use to copy one cell to adjacent cells or to create a series? a. Cell pointer b. Column marker c. Fill handle d. Formula bar

c. Fill handle

Which of the following functions returns one value if a condition is true and a different value when the condition is not true? a. AND b. OR c. IF d. SUM

c. IF

You want to format a cell so the text is spread evenly throughout the cell, wrapping automatically and adjusting the row height, if necessary. Which of the following alignment options should be used? a. Center b. Middle Align c. Justify d. Top Align

c. Justify

Which of the following steps is not a method for inserting a worksheet into a workbook? a. Click the Insert sheet (+) button to the right of the worksheet tabs. b. On the Home tab, click Insert and then click Insert Sheet. c. On the Insert tab, click Worksheet. d. In the Insert dialog box, click Worksheet and then click OK.

c. On the Insert tab, click Worksheet.

In which of the following locations are check boxes that you can select to view or print gridlines? a. In Print Preview b. On the Home tab, in the Cells group c. On the Page Layout tab, in the Sheet Options group d. On the Page Layout tab, in the Page Setup group

c. On the Page Layout tab, in the Sheet Options group

The Crop tool is found on which of the following ribbon tabs? a. Drawing Tools Format b. Insert c. Picture Tools Format d. Home

c. Picture Tools Format

To change printer, layout, or margin settings, you click the File tab and use which of the following options? a. Info b. Options c. Print d. Open

c. Print

In the formula =SUMIFS(C5:C16, F5:F16,"<=60", B5:B16, ">200000"), what does <=60 mean? a. If the value in C5:C16 is greater than or equal to 60, the value in C5:C16 will be included in the total. b. If the value in F5:F16 is greater than or equal to 60, the value in C5:C16 will be included in the total. c. If the value in B5:BF16 is less than or equal to 60, the value in C5:C16 will be included in the total. d. If the value in F5:F16 is less than or equal to 60, the value in C5:C16 will be included in the total.

d. If the value in F5:F16 is less than or equal to 60, the value in C5:C16 will be included in the total.

Which of the following is not useful for changing the font size? a. Font Size drop-down list b. Increase Font Size button c. Decrease Font Size button d. Increase Indent button

d. Increase Indent button

When you type text into a shape, which of the following paragraph alignments is applied by default? a. Center b. Full Justify c. Right d. Left

d. Left

Which chart type shows values as parts of a whole? a. Column b. Bar c. Area d. Pie

d. Pie

Which predesigned file already has a significant amount of formatting, text, and other features? a. Blank workbook b. Preset file c. Text file d. Template

d. Template

In order for you to freeze the first column of a worksheet into a frozen pane: a. The entire contents of the column must be visible. b. The first row of the column must be non-blank. c. Duplicate worksheets must also be able to have their first columns frozen. d. You can click Freeze First Column in the Freeze Panes menu.

d. You can click Freeze First Column in the Freeze Panes menu.

Which of the following is not an arithmetic operator? a. + b. − c. * d. ]

d. ]

Which of the following is the intersection of a row and column? a. range b. tab c. bar chart d. cell

d. cell

When you split a window, the window is divided into how many panes? a. two b. three c. four d. two or four

d. two or four

Per the order of operations, which of the following is calculated first? a. Addition (+) and subtraction (−) (left to right) b. Exponentiation (ˆ) c. Percent (%) d. Negative number (−)

d.Negative number