Excel Final Review

You want to find the average for cells B4:B50 divided by 3, and you cannot use the AutoSum feature. Which formula would you use?

(B4:B50)/3

The first and last name of each customer are set in two different columns. Your boss wants you to put the names in one column. Which feature would you use to accomplish this task?

Concatenate

You want to sharpen an image by 50%. Which feature would accomplish this task?

Corrections

You want to change the Zoom to 150%. You also want this document to automatically open in 150% window view. Which feature would you use?

Custom View

You have five columns of data for years 2010, 2011, 2012, 2013, and 2014. You want to add Column Sparklines to compare the years. After selecting the Column Sparkline icon, which feature would you use to select the values?

Data Range

You want a column to only accept "Male" or "Female". Which feature would allow you to limit the text that is keyed into the column?

Data Validation

Your boss wants all decimals removed from column B. Which feature would you use to remove the decimal places?

Decrease decimal

Which feature would you select in order to define the name FICTION12 for the cell range B4:D25?

Define Name

You want a section set aside so that you can use it in a formula on a different worksheet. Which feature would you use to create the section?

Define Name

In order to access all of the features for a macro, which feature must be turned on?

Developer

You want to add a Simple White Frame to an image. Which feature must be turned on?

Developer

You want to add the word, "GMetrix," to your spell check so that Excel does not mark it as incorrect when you type the word. Which feature do you need to use to override the default setting?

Exceptions-Initial Caps

Your boss wants the final workbook to be published as a pdf file. Which feature would you use to make it a pdf file?

Export

Your teacher wants you to change the file type from 2007 to 2016 since she does not have 2007 at home. Which feature would you select?

Export

Which feature would you use to enumerate the days of the week from cell A3 to A8 starting with Monday?

Fill Handle

You have created a formula in B10. You want to copy that formula to cells C10:F10. Which feature should you use?

Fill Handle

Which feature would you use to copy Sparkline from cell F33 to F32:F8?

Fill Up

Which tool would you use to quickly locate the cell in an open spreadsheet that contains Conditional Formatting and will apply a Thick Box Border?

Find & Select

You want to change the height of a cell. Which feature would you use?

Format

You want to change the name of your worksheet from "Products" to "Customers". Which feature would be best to use?

Format

You want to change the sheet names to have all different colors. Which features would be best to use?

Format

You want to hide rows 6-10 in your worksheet since they are empty rows. Which feature would you use to hide the rows?

Format

Which feature would you select to add a table into your worksheet?

Format as Table

You want to copy only the formatting in cells A1:D45 to another worksheet. Which feature would be the best to use?

Formatting

How would you turn off the background error check function in your workbook?

Formula

You have a four page worksheet. You only have headings on the first page. Which feature would allow you to have the headings appear on every page?

Freeze Panes

Which feature will determine what interest rate you will need to secure in order to meet your loan goal?

Goal Seek

Which feature would you use to insert the author's name, date and page number in a workbook?

Header/Footer

Your boss wants you to add conditional formatting to all cells that show amounts that exceed $22,500. Which type of conditional formatting would you select?

Highlight Cell Rules

You want the title of your worksheet to link to the company website. Which feature would you select?

Hyperlinks

I want to create a formula that will find all of the scores that are equal to or greater than 90%. Which feature would be best to use?

If Statement

I want my workbook encrypted with a password so that no one can change my work. Which feature would I select to accomplish this task?

Info

I want to inspect my worksheets for issues so that I can remove them if there are any issues. Which feature would I select?

Info

You have completed your workbook and your boss wants you to finalize it. Which feature would you use to mark your workbook as final?

Info

You want to add a column to the right of Column E. You want it to include the same type of formatting. Which feature would be the best feature to use?

Insert Sheet Columns

You want to change the width of an image, but not the height. Which feature must be selected in order to stop the automatic formatting of an image?

Lock Aspect Ratio

You have a business logo that you use on all of your documents. Which feature would allow you to create a function that would allow you to insert it into every worksheet?

Macro

You have a heading that needs to be extended and centered across columns A1, B1 and C1. Which feature would you use to extend and center the text?

Merge & Center

Your boss likes the bar chart that you included in your worksheet. However, he feels that it would be more effective if you move it to a separate worksheet. Which feature should you use to create a worksheet for your chart?

Move Chart

You want to move the worksheet from one workbook to another using the Format feature. Which icon would you select?

Move or Copy Sheet

Your cursor is in A1. You want to find the cell, N55, so that you can add a formula in N55. Which feature would be the best feature to use to move you cursor from A1 to N55 quickly?

Name Box

You have defined a range and named it "Bonus." Which features would you use to edit the Bonus range?

Name Manager

You want to use the expense report template. Which feature would you choose to access this template?

New

Use me when you want to open up a new window that contains a view of the current workbook.

New Window

You want to change your numbers to "Currency", change the font style to "Times New Roman," and add a "yellow" fill color. Which feature would be best to use?

Number Dialog Box Launcher

If you want to insert an object into a worksheet from a file, which icon would you select?

Object

You have misplaced your Excel workbook. Which feature may help you find your misplaced workbook?

Open

Your boss asks you to move a worksheet from the workbook, Product Results, into the workbook, Best Results. What is the first step in moving this worksheet?

Open up Product Results workbook.

You want to change the Office Theme and Background. Which feature would be best to use to accomplish this task?

Option-General

You want to change the top margin of your worksheet to 1 inch. Which feature would you use?

Page Layout

Your teacher wants you to turn on the row & column headings as well as the gridlines. Which feature would you use to accomplish this task?

Page Setup Launcher

You are going to add the color, "blue, 18pt, glow, accent color 1" to your image. Which feature would you use?

Picture Effect

You want to add a caption to an image in your Excel worksheet. Which feature would allow you to add a visual image as well as a caption to the image?

Picture Layout

This tool is used when you want specialized fields to be displayed in a specialized format.

Pivot Table

When you preview your worksheet, you noticed that one row has been extended onto the next page. You decide to change your top margin so that all of it will fit on a page. Which feature would you use?

Print

You are previewing your Excel workbook and noticed that the book would look better if you used landscape orientation. Which feature would you choose?

Print

You want to get rid of the background of an image. Which feature would best accomplish this task?

Remove Background

You want to turn the "down arrow" shape 90 degrees to the right. Which feature would accomplish this task?

Rotate

Your document is five pages long. You want to have the 1st row repeat on every page. What feature would you use?

Rows to repeat at top

You want your workbook saved every 10 minutes instead of every 5. Which feature would you select to change the setting?

Save

In your column chart, you want to change the cell range. Which feature would you use to adjust the cell range of the chart?

Select Data

To add a filter to your worksheet, what would be your first step?

Select Data

To set a print area, you must first

Select the data

You want to insert the lightning bolt shape. Which feature would you select?

Shapes

You want to delete all comments in a worksheet. Which is the first step to the process of deleting all these comments?

Show All Comments

You want to change your shape's dimension to 1" height and 1" width. Which feature would you use to adjust the size of your shape?

Size

Which places values in chronological order?

Smallest to Largest

You want to add visual representation without comparing text and values. Which feature would be best to use?

SmartArt Graphics

You want to filter out certain date in Col. F. Which feature would you select in order to start filtering out date?

Sort & Filter

Which feature would you use if you want to display a tiny chart in J18 that would represent a comparison between B5:I5?

Sparklines

Which feature would you use to divide your worksheet into sections?

Split

This feature allows you to go back and forth between similar workbooks.

Switch Window

Which is the best feature to use when you want to apply Table Style Light 4 to cells D4 through H35?

Table Styles

You want to filter out all occupations that do not end with the suffix, "Lux" or "Ex". Which feature would you choose to accomplish this task?

Text Filters-Ends With

You want to place a Light Red fill with a Dark Red text on all words in Column B that contain "Deliver" in its name. Which feature would you select?

Text That Contains

You have recorded the first and last names in one cell. Your boss wants the first name separated from the last name so that you can sort by last name. Which feature should you use to accomplish this task?

Text to Columns

You want to change the theme of the workbook to Civic. Which feature would you select?

Themes

You want to filter out all departments in column C that do not contain the name "Billing." The first step would be to:

Uncheck Select All

You have defined two names: EstIncome and EstExpenses. You click on the AutoSum feature to start your formula. Which feature should you select to add the name formulas into your formula?

Use in Formula

We want to find a product cost by using a unique identifier. Which feature would you use?

VLookup

You want to copy the values from one worksheet to another workbook; however, you do not want to copy the formatting that is on the original worksheet. Which feature would you select?

Values

You want to change the view to 125%. Which feature would be best to use?

Zoom

I am another name for rows and columns when using a PivotTable.

field

You want to remove all data and formulas in cell F15. Which feature would be best to use?

Clear All

You want to add a note to cell A5. Which feature would be best to use?

Comments

You want to change your column chart to a bar chart. Which feature would you use to make the change?

Change Chart Type

Which feature would allow you to add a name to a chart in your worksheet?

Chart Title

Your screen is set on 400%. Which feature would return the screen to normal view?

100%

In a worksheet, in cells E4:E33, you want to display a 1 if the values of the cells D4:D33 are greater than 2500, and a 0 if it is less than 2500. Which formula would be the best to use?

=IF(D4>2500,1,0)

In the Totals worksheet, you want to enter a cell reference to the matching "Totals" values from the June worksheet that are located in B34.

=June!B34

You have defined the name "FICTION12" for the cell range B4:B33. In the totals worksheet, you enter a formula in cell B2 that displays the sum of the defined name range. Which is the correct formula?

=SUM(Fiction12)

Which answer below would place text in alphabetical order?

A-Z

You want to sort the data in column J on two levels. What feature do you need to select in order to add the second level?

Add Level

You have six workbooks that are open. Which feature would allow you to tile all of your workbooks at the same time?

Arrange all

You insert an image in your document. Which feature would you use to add the plastic wrap effect to the image?

Artistic Effect

Which feature would you use to extend the series starting in A4 to the cell in A12?

AutoFill

I want to find the average of ten different test scores. Which feature would be the best to use?

AutoSum

You want to change the file extension of a worksheet to a css file. Which menu tab would you use?

Backstage View

Which feature would you use to count the number of times that the values in the cell range B6:B15 exceed 5000?

COUNTIF

Which feature would you use to place a "title" style to the text in A1?

Cell Styles