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
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 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
Which feature would you select to add a table into your worksheet?
Format as Table
How would you turn off the background error check function in your workbook?
Formula
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 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
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
If you want to insert an object into a worksheet from a file, which icon would you select?
Object
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
You are previewing your Excel workbook and noticed that the book would look better if you used landscape orientation. Which feature would you choose?
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 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
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
We want to find a product cost by using a unique identifier. Which feature would you use?
VLookup
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
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
You want to add a note to cell A5. Which feature would be best to use?
Comments
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 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 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
You want to copy only the formatting in cells A1:D45 to another worksheet. Which feature would be the best to use?
Formatting
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
You want to remove all data and formulas in cell F15. Which feature would be best to use?
Clear All
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)
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 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 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
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
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
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?
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
Which feature would you use to divide your worksheet into sections?
Split
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
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
