Excel Final Exam Review 211 Questions with Verified Answers
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula
... [Show More] Bar, or headings? - CORRECT ANSWER B. Show
Which of the following notebook- like features organizes the sheets for use in Excel? - CORRECT ANSWER A. Workbook
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format? - CORRECT ANSWER A. Page Layout
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel? - CORRECT ANSWER B. Worksheet
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option? - CORRECT ANSWER B. Split
Joan wants to add a new entry at the bottom of her spreadsheet. What is the shortcut that will take her to the last record on her spreadsheet? - CORRECT ANSWER B. Ctrl + End
What occurs when the cursor is moved over a cell and a user clicks? - CORRECT ANSWER B. The cell is selected
Which tab do you use to display the area that contains the print command? - CORRECT ANSWER D. File
Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell? - CORRECT ANSWER C. Name box
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands? - CORRECT ANSWER A. Quick Access Toolbar(QAT)
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select? - CORRECT ANSWER B. Open
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent? - CORRECT ANSWER C. Row
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data? - CORRECT ANSWER C. Excel
Which view is the default view used in Microsoft Excel? - CORRECT ANSWER C. Normal
Which ribbon option opens a related dialog box? - CORRECT ANSWER C. Launcher
What command do you use to increase or decrease the view of a selected cell or range of cells to fill the Excel Window area for better visibility? - CORRECT ANSWER D. Zoom to Selection
What feature was created for users who prefer to use the keyboard rather than the mouse, and provides keyboard code icons that may be used in conjunction with the ALT key? - CORRECT ANSWER D. Key Tips
Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the: - CORRECT ANSWER D. Row
What command will arrange Microsoft Excel windows so that they appear side by side on the screen? - CORRECT ANSWER C. Arrange All
Joan has entered her name in the First Name field in cell B2 of her table. What does her First Name represent in the table? - CORRECT ANSWER A. Entry
Which command do you use to close an open file and completely exit the Microsoft Excel program? - CORRECT ANSWER C. Exit
In Microsoft Excel, which feature makes an exact replica of the cell data and format while keeping the original cell intact?
A. Paste B. Move C. Cut D. Copy - CORRECT ANSWER D. Copy
Sharon's spreadsheet contains information about the number of music downloads in F1:F25.F1:F25 represents a:
A. Cell B. Column C. Range D. Row - CORRECT ANSWER C. Range
When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?
A. Delete key B. Backspace Key C. Left arrow key D. Enter key - CORRECT ANSWER B. Backspace key
Joan is creating a table that will include demographic information about her employees. What is each header in her table considered?
A. Label B. Value C. Formula D. Function - CORRECT ANSWER A. Label
What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet?
A. Mini Toolbar B. Quick Access Toolbar C. Shortcut Menu
D. Shortcut Toolbar - CORRECT ANSWER C. Shortcut Menu
John wants to print only the Inventory worksheet that he is currently working on in his workbook. Which option should he choose?
A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit Sheet on One Page - CORRECT ANSWER B. Print Active Sheet
Which Microsoft Excel feature automatically inserts data into a cell that begins with the same characters as a previous entry?
A. AutoComplete B. AutoFill C. AutoCorrect D. AutoSpell - CORRECT ANSWER A. AutoComplete
David wants to key the numbers 1 to 1,000 in Column A of his spreadsheet. What command should he use to complete this task?
A. AutoFill B. Filter C. Find and Replace D. Sort - CORRECT ANSWER A. AutoFill
What is the name of the small black square in the lower-right corner of the heavy border of an active cell that repeats a cell's value in adjacent cells?
A. Fill handle B. Filler C. Copy handle D. Copy box - CORRECT ANSWER A. Fill handle
Which command on the Fill options dialog box is the default option if you enter a month or day?
A. Copy Cells B. Fill Formatting Only C. Fill without Formatting D. Fill Series - CORRECT ANSWER D. Fill Series
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group?
A. Segment B. Set C. Range D. Cluster - CORRECT ANSWER C. Range
Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header?
A. Values B. formulas C. labels D. functions - CORRECT ANSWER C. labels
What is the process of using the mouse to move or copy cells called?
A. Click and paste B. Drag and move C. Dragging D. Drag and Drop - CORRECT ANSWER D. Drag and Drop
To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use?
A. File details B. Document Properties C. File facts D. Document options - CORRECT ANSWER B. Document properties
Joyce has updated the data in an existing spreadsheet. Which command would she select to preserve the data for future use?
A. Exit B. Open C. Save D. Save As - CORRECT ANSWER C. Save
Alicia needs to delete the data in cell B5. Which command would she select?
A. Clear B. Copy C. Cut D. Format Painter - CORRECT ANSWER A. Clear
Alicia needs to move the date in cell B5 to cell E5. Which command would she select?
A. Clear B. Copy C. Cut D. Format Painter - CORRECT ANSWER C. Cut
Which command on the "Home Ribbon" allows data to be moved from one worksheet location to another?
A. Cut B. Move C. Copy D. Duplicate - CORRECT ANSWER A. Cut
In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit?
A. Smart Fit B. AutoFit C. Best Fit D. Trust Fit - CORRECT ANSWER B. AutoFit
Jennifer needs to identify the values in column B for a statistics report. Which type of entry should she use in the column header?
A. values B. formulas C. labels D. functions - CORRECT ANSWER C. labels
What area contains the command used to customize the print options in Microsoft Excel?
A. Home Ribbon B. Page Layout Ribbon C. File Tab D. Quick Access Toolbar - CORRECT ANSWER C. File Tab
Which command enables a user to save an existing worksheet with a new name or save the worksheet in a new location?
A. Close B. Save C. Save As D. Exit - CORRECT ANSWER C. Save As
Steve would like to print only the worksheet he is currently working on. What print option should he choose?
A. Print Area B. Active Sheets C. Entire Workbook D. Quick Print - CORRECT ANSWER B. Active Sheets
Jim would like to print only the cell range A1:F20. What page setup option should he change?
A. Orientation B. Page Break C. Print Area D. Print Titles - CORRECT ANSWER C. Print Area
Which is a special workbook a user can create and then use as a pattern to create new, similar workbooks or worksheets?
A. Form B. Boilerplate C. Smart Sheet D. Template - CORRECT ANSWER D. Template
John's workbooks includes 3 worksheets. Which option should he choose to print them?
A. Print Selection B. Print Active Sheet C. Print Entire Workbook D. Fit to one page - CORRECT ANSWER C. Print Entire Workbook
Relative reference - CORRECT ANSWER When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
external reference. - CORRECT ANSWER Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n):
formulas - CORRECT ANSWER Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
=B4-C4 - CORRECT ANSWER Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
Cell reference and cell location are outlined in matching colors - CORRECT ANSWER How is a cell reference in a formula and its corresponding location in a worksheet identified?
=$B$1+25 - CORRECT ANSWER Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
=B4*C4 - CORRECT ANSWER Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
named range. - CORRECT ANSWER Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):
Worksheet Reference - CORRECT ANSWER What do you call it when you reference cells in other sheets in a workbook formula using the sheet name as the reference rather than the cell address?
Copy using the Fill Handle - CORRECT ANSWER What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
external reference. - CORRECT ANSWER Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n):
Absolute - CORRECT ANSWER What type of formula cell reference instructs Microsoft Excel to keep the cell reference constant in the formula as it copies it to the destination area?
AVERAGE - CORRECT ANSWER Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to estimate the grade on her next test?
TODAY - CORRECT ANSWER Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1?
Formula bar - CORRECT ANSWER Where can you find the Insert Function button in Microsoft Excel?
functions - CORRECT ANSWER Angie is calculating her average sales for the past four months. If she uses "=AVERAGE(B1:B4)", this is an example of which type of entry?
Function - CORRECT ANSWER What is a prewritten formula that is built into Microsoft Excel called?
Calculation - CORRECT ANSWER Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
MAX - CORRECT ANSWER Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
Today - CORRECT ANSWER Which function do you use to insert today's date in a worksheet so that it automatically updates each time
the worksheet is opened?
AutoSum - CORRECT ANSWER Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
AVERAGE, MAX, and MIN - CORRECT ANSWER Which of the following are valid Microsoft Excel functions?
Sum - CORRECT ANSWER What function adds all of the numbers in a range of cells?
=SUM(B1:B39) - CORRECT ANSWER Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?
Formula Auditing - CORRECT ANSWER Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
NOW - CORRECT ANSWER Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1?
Defined Names - CORRECT ANSWER Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Carl notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could Carl
format the cell to correct this problem? - CORRECT ANSWER AutoFit
On the Home Ribbon, what do you use to change the font size of characters in a cell? - CORRECT ANSWER Font Size drop-down list
Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel? - CORRECT ANSWER Font
Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree? - CORRECT ANSWER Format Cells
Which command do you use to format a cell or selected cells quickly by choosing from a defined list of
styles? - CORRECT ANSWER Cell style
Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a
worksheet? - CORRECT ANSWER Orientation
Which command on the Home Ribbon joins selected cells into one and centers that content into a larger
single cell? - CORRECT ANSWER Merge & Center
What type of formatting appears only when the value in a cell meets conditions specified by a user? - CORRECT ANSWER Conditional
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for
the data in column D? - CORRECT ANSWER Text
Trey would like to outline the cell range A1:F20. Which formatting style should he select? - CORRECT ANSWER Borders
Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a
worksheet? - CORRECT ANSWER Hyperlink
Column D in a spreadsheet contains information about regional sales. Which formatting would be most
appropriate for the data in column D? - CORRECT ANSWER Currency
Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style
should he select? - CORRECT ANSWER Cell style
Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option
should she select? - CORRECT ANSWER Merge and Center
Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select? - CORRECT ANSWER Orientation
Where can you find the command to apply a fill color to a cell or range of cells in a worksheet? - CORRECT ANSWER Home Ribbon
Which quick-number style button formats numbers to display as currency in the worksheet? - CORRECT ANSWER Accounting
What defines the color of the characters in an Microsoft Excel worksheet? - CORRECT ANSWER Font color
Which dialog box contains the commands to specify an exact date and time format to use for a selected cell
in a worksheet? - CORRECT ANSWER Format Cells
What command do you use to apply a background color to cells in a worksheet? - CORRECT ANSWER Fill Color
On the Home Ribbon, what do you use to change the text color of characters in a cell? - CORRECT ANSWER Font Color drop-down list
Trey would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than
50,000 with a yellow fill color and dark yellow text. Which formatting style should he select? - CORRECT ANSWER Conditional formatting
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this
problem? - CORRECT ANSWER AutoFit
Which command do you use to reduce the margin between the border and the text in an indented cell? - CORRECT ANSWER Decrease Indent
In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand? - CORRECT ANSWER Formatting
Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or
table? - CORRECT ANSWER Delete
Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet? - CORRECT ANSWER Format
Which term describes the blank portions of a page that fall outside the main body of the printed document? - CORRECT ANSWER Margins
Which dialog box contains the commands to specify an exact date and time format to use for a selected cell
in a worksheet? - CORRECT ANSWER Format Cells
What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page? - CORRECT ANSWER Header & Footer
John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling
through his spreadsheet what should he do? - CORRECT ANSWER Freeze Panes
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy? - CORRECT ANSWER Breaks
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D? - CORRECT ANSWER Unhide
Joan is showing her spreadsheet to a customer and does not want the customer to be able to see the
wholesale prices column. What option should she choose? - CORRECT ANSWER Hide
Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he
select? - CORRECT ANSWER Scale
Jim would like the data in Row 1 of his spreadsheet to repeat on every page of his printout. What page setup option should he change? - CORRECT ANSWER Print Titles
Which command do you use to remove manual page breaks from a worksheet area? - CORRECT ANSWER Select Remove Page Break from the Breaks drop-down area
Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select? - CORRECT ANSWER Hide
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a
worksheet? - CORRECT ANSWER Sheet Options
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance? - CORRECT ANSWER Theme
Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting? - CORRECT ANSWER Find & Select
Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose? - CORRECT ANSWER Freeze
John would like to change the order of the worksheets in his workbook. Which option would he choose? - CORRECT ANSWER Move
Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose? - CORRECT ANSWER Tab color
Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select? - CORRECT ANSWER Freeze
Which command on the Home Ribbon do you use to format row height and column width, organize sheets, and protect or hide cells in a worksheet? - CORRECT ANSWER Format
How is an exact copy of a worksheet created within the same workbook? - CORRECT ANSWER Right click the sheet tab then choose Move or Copy from the Shortcut menu
David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task? - CORRECT ANSWER Find and Replace
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches? - CORRECT ANSWER String
Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose? - CORRECT ANSWER Move
John would like to remove a worksheet from his workbook. Which option would he choose? - CORRECT ANSWER Delete
How would you move sheet tabs to a new position in the workbook? - CORRECT ANSWER Click and drag the sheet tab to the new location
Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose? - CORRECT ANSWER Rename
What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls? - CORRECT ANSWER Freeze Panes
David wants to arrange the employee salaries in Column A of his spreadsheet from lowest to highest. What command should he use to complete this task? - CORRECT ANSWER Sort
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on
a criterion? - CORRECT ANSWER Sort & Filter
Which command on the Home Ribbon do you use to organize data in ascending or descending order? - CORRECT ANSWER Sort & Filter
Which is a way to qualify data by specifying a matching condition or asking a question of the data? - CORRECT ANSWER Query
What Home Ribbon group contains the command used for quickly converting selected cells to a table by
choosing a table style? - CORRECT ANSWER Styles
David only wants to view the employees in the Marketing department who earn a salary of more than
$25,000. What command should he use to complete this task? - CORRECT ANSWER Filter
Which ribbon includes the commands to apply a quick table style to a range of cells? - CORRECT ANSWER Home
How do you quickly modify a table style to meet user preferences? - CORRECT ANSWER Right-click on style and choose duplicate
Joan has created a spreadsheet that displays sales of her employees. She would like to view only those
employees with sales above $25,000 who are from Region 3. What option will allow her to do that? - CORRECT ANSWER Custom filter
Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he
select? - CORRECT ANSWER Format as table
Cooper is creating a spreadsheet for FBLA and wants to be able to put the spreadsheet in alphabetical order
by last name. What should Cooper apply to the spreadsheet? - CORRECT ANSWER Sort
What is the process of bringing data containing text fields separated by commas into Excel called? - CORRECT ANSWER Importing data
Joan wants to see her sales representatives in numerical order with the sales person who sold the least at the
top. Which sorting option should she choose? - CORRECT ANSWER Ascending
Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to show a
summary view of all of the first period classes. Which feature would allow him to do this? - CORRECT ANSWER Collapse
Dylan is creating an Excel spreadsheet of student schedules for all FBLA members. He would like to know
how many members are in the same first period class. Which feature would allow him to do this? - CORRECT ANSWER Subtotal
Elizabeth needs to convert all text in Column A to uppercase. Which function should she use? - CORRECT ANSWER Upper
SUMIF and SUMIFS are in which category of functions? - CORRECT ANSWER Math & Trig
Maggie wants to use a function that will return True when all its arguments are true, and False when one or
more arguments are false. What function would she use? - CORRECT ANSWER AND
Jamal wants to average a range of cells in his spreadsheet. He would like Excel to average only the cells in
that range that are greater than 100 but less than 500. What function should he use? - CORRECT ANSWER AVERAGEIFS
James wants to use an advanced function to search his spreadsheet for a specific string in a text string? - CORRECT ANSWER FIND
In Sam's spreadsheet, Column A has student first and last names. They need to be separated into two
different columns. Which tool would he use? - CORRECT ANSWER Convert text to Column Wizard
Jane wants to add a range of cells in her spreadsheet. She would like Excel to add only the cells in that
range that are greater than 1,000. What function should she use? - CORRECT ANSWER SUMIF
Jane wants to count the number of cells in a range in her spreadsheet. She would like to count only the
cells in that range that contain 100. What function should he use? - CORRECT ANSWER COUNTIF
Tom wants to convert all text to lowercase. Which function she he use? - CORRECT ANSWER LOWER
Jill wants to search her spreadsheet for a value in the first column of her table. What function should she
use? - CORRECT ANSWER VLOOKUP
IF, AND, OR and NOT are all part of which category of functions? - CORRECT ANSWER Logical
Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use? - CORRECT ANSWER HLOOKUP
Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use? - CORRECT ANSWER SUBSTITUTE
James wants his spreadsheet to return true when the logical value is false. What function should he use? - CORRECT ANSWER NOT
Jessica needs to capitalize the first letter in each word. Which function would she use? - CORRECT ANSWER PROPER
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion? - CORRECT ANSWER Sort & Filter
Lilly is making changes to a spreadsheet her FBLA Advisor created. She would like to make a change to the comment she made in the spreadsheet. What option in the comments group should she choose? - CORRECT ANSWER Edit Comment
Lilly is making changes to a spreadsheet her FBLA Advisor created. She wants to add a note informing her advisor of an incorrect address for a member. What option in the comments group should she use? - CORRECT ANSWER New
Which ribbon contains commands to add a comment about a selected cell in a worksheet - CORRECT ANSWER Review
Lilly is creating a spreadsheet for FBLA and would like all of the advisors at her school to be able to make changes to the spreadsheet at the same time. What command allows her to do this? - CORRECT ANSWER Share Workbook
Lilly is creating a spreadsheet for FBLA and would like to see the changes advisors have made to the workbook. What command allows her to do this? - CORRECT ANSWER Tracking Changes
The FBLA Advisor at your school would like to create random ID numbers for FBLA members at your school. Which function would allow her to have Excel pick a random number between 1000 and 5000 for the new member ID numbers? - CORRECT ANSWER RAND BETWEEN(1000,5000)
What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook? - CORRECT ANSWER Protect Workbook
Where is the spellchecker located? - CORRECT ANSWER Review Ribbon
Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart? - CORRECT ANSWER Design
What term refers to an Excel Chart with offset pieces? - CORRECT ANSWER Exploded
Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature should she modify? - CORRECT ANSWER Plot Area
What is the process of viewing a PivotTable report for a subset that meets the criterion only? - CORRECT ANSWER Filtering
John would like to display the count of employee last names on the Y-axis of a PivotChart. What area would he drag this information to in order to display correctly? - CORRECT ANSWER Values
John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use? - CORRECT ANSWER Analyze
Which is an interactive view of worksheet data that gives a user the ability to summarize the data by selecting categories in which to group the data? - CORRECT ANSWER PivotTable
John wants to identify the exact value that each column in his chart represents. Which option should he choose? - CORRECT ANSWER Labels
What can you use to easily filter pivot tables and cube functions interactively in a worksheet? - CORRECT ANSWER Slicer
John has created a Pivot chart and would like to include a guide that would display the names of the series of data included on the chart. Which option would allow him to do this? - CORRECT ANSWER Legend Fields
When creating a PivotTable, which are drawn in columns in the worksheet data? - CORRECT ANSWER Fields
What is typically included in the range of data selected to create a chart? - CORRECT ANSWER Numeric data and titles
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type should he create? - CORRECT ANSWER Column
Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart? - CORRECT ANSWER Design
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable? - CORRECT ANSWER Collapse/Expand
Edward would like to create a chart that shows the trend in iPod sales over the past 2 years. Which chart type should he create? - CORRECT ANSWER Line
John wants to be able to view his monthly sales chart as well as his data on the same worksheet. What type of chart should he create? - CORRECT ANSWER Embedded Chart
Which of the following is the default method for summarizing data in a PivotTable? - CORRECT ANSWER Sum
Which is a tiny chart that provides a visual representation of data in a worksheet cell? - CORRECT ANSWER Sparkline
Leigh Ann designed a bar chart and would like to add an element to the right of the chart that identifies each bar's color. Which chart feature would she need to include? - CORRECT ANSWER Legend
What ribbon contains the commands for creating charts in Microsoft Excel? - CORRECT ANSWER Insert
Which Chart Tools Ribbon tab allows a user to insert various labels on the chart? - CORRECT ANSWER Layout
What graphically represents trends in plotted data and predicts future values? - CORRECT ANSWER Trendline
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles? - CORRECT ANSWER Design
John wants to change the chart style on his Pivot table. Which Pivot Table chart tools tab would he create? - CORRECT ANSWER Design
John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create? - CORRECT ANSWER Line Chart
On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called? - CORRECT ANSWER Calculated field
In order to directly report the data, what must a PivotChart always be associated with? - CORRECT ANSWER PivotTable
What ribbon contains the commands used to create a chart in Excel? - CORRECT ANSWER Insert Ribbon
What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts? - CORRECT ANSWER Slicers
Which is the name of an interactive graphical representation of data that allows a user to change the groupings? - CORRECT ANSWER PivotChart
Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart? - CORRECT ANSWER Layout
Leigh Ann designed a bar chart and would like to add an element above the chart to make the data more meaningful. Which chart feature would she need to include? - CORRECT ANSWER Chart Title
Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable? - CORRECT ANSWER Design
Dorothy designed a column chart and would like to add an element that will help lead the eye and improve readability of the chart. Which chart feature should she include? - CORRECT ANSWER Gridlines
Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet? - CORRECT ANSWER Screen Clipping
Which command creates decorative text in a worksheet? - CORRECT ANSWER WordArt
Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet? - CORRECT ANSWER Rotate
Ken has inserted a picture into his spreadsheet and would like it to standout with a frame or 3D effect. Which tool would he use to achieve this? - CORRECT ANSWER Picture Styles
Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt? - CORRECT ANSWER Format
John would like to add a banner at the top of his spreadsheet. Which object should he insert? - CORRECT ANSWER Shapes
Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet? - CORRECT ANSWER Screenshot
Ken has inserted a picture into his spreadsheet that was taken with a low quality camera. Which tool would allow him to sharpen the image? - CORRECT ANSWER Corrections
Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet? - CORRECT ANSWER Online Pictures [Show Less]