Microsoft Excel Final Study Guide
Gabriel needs to create a formula that does not change when it is copied to cell B2. Which formula should he create?
=$B$1+25
Sandra is creating a formula to multiply the values in cells B4 and C4. Which formula should she use?
=B4*C4
Sandra is creating a formula to subtract the values in cells B4 and C4. Which formula should she use?
=B4-C4
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?
=SUM(B1:B39)
6. 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
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
A. AutoFill
Alicia needs to delete the data in cell B5. Which command would she select? A. Clear B. Copy C. Cut D. Format Painter
A. Clear
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
A. Cut
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
A. Fill handle
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
A. Label
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?
AND
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?
AVERAGE
Which of the following are valid Microsoft Excel functions?
AVERAGE, MAX, and MIN
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?
AVERAGEIFS
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?
Absolute
Which quick-number style button formats numbers to display as currency in the worksheet?
Accounting
John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use?
Analyze
What command will arrange Microsoft Excel windows so that they appear side by side on the screen?
Arrange All
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?
Ascending
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem?
AutoFit
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?
AutoFit
Which command on the Home Tab displays the total of the selected cells directly after the selected cells?
AutoSum
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
B. Active Sheets
In a 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
B. AutoFit
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
B. Backspace key
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
B. Document properties
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
B. Print Active Sheet
Trey would like to outline the cell range A1:F20. Which formatting style should he select?
Borders
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
Breaks
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
C. Cut
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
C. File Tab
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
C. Print Area
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
C. Print Entire Workbook
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
C. Range
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
C. Range
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
C. Save
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
C. Save As
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
C. Shortcut Menu
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
C. labels
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
C. labels
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?
COUNTIF
On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called?
Calculated field
Which group on the Formulas Ribbon enables a user to specify when a formula is computed?
Calculation
How is a cell reference in a formula and its corresponding location in a worksheet identified?
Cell reference and cell location are outlined in matching colors
Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?
Cell style
Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?
Cell style
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?
Chart Title
How would you move sheet tabs to a new position in the workbook?
Click and drag the sheet tab to the new location
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?
Collapse
What is the purpose of the -/+ buttons that appear across the categories on a PivotTable?
Collapse/Expand
Edward would like to create a chart that uses vertical rectangles to compare iPod and iPad sales. Which chart type should he create?
Column
What type of formatting appears only when the value in a cell meets conditions specified by a user?
Conditional
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?
Conditional formatting
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?
Convert text to Column Wizard
What method is the MOST EFFICIENT way to copy five separate formulas to adjacent cells simultaneously?
Copy using the Fill Handle
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?
Corrections
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?
Ctrl + End
Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
Currency
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?
Custom filter
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
D. Copy
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
D. Drag and Drop
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
D. Fill Series
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
D. Template
Which command do you use to reduce the margin between the border and the text in an indented cell?
Decrease Indent
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula?
Defined Names
John would like to remove a worksheet from his workbook. Which option would he choose?
Delete
Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
Delete
John wants to change the chart style on his Pivot table. Which Pivot Table chart tools tab would he create?
Design
Which Chart Tools Ribbon tab allows a user to select from a gallery of chart styles?
Design
Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart?
Design
Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?
Design
Which tab in the PivotChart Tools Ribbon allows a user to apply a chart style to the PivotChart?
Design
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?
Edit Comment
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?
Embedded Chart
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?
Entry
Which of the following software programs is a powerful spreadsheet program that allows users to organize data, complete calculations, and graph data?
Excel
Which command do you use to close an open file and completely exit the Microsoft Excel program?
Exit
What term refers to an Excel Chart with offset pieces?
Exploded
Joshua created a budget workbook that contains the formula =(Summary!B3). "Summary" is an example of a(n):
External Reference
Tyler created a monthly sales workbook that contains the formula =(January!B3). "January" is an example of a(n):
External Reference
James wants to use an advanced function to search his spreadsheet for a specific string in a text string?
FIND
When creating a PivotTable, which are drawn in columns in the worksheet data?
Fields
Which tab do you use to display the area that contains the print command?
File
What command do you use to apply a background color to cells in a worksheet?
Fill Color
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?
Filter
What is the process of viewing a PivotTable report for a subset that meets the criterion only?
Filtering
Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?
Find & Select
David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task?
Find and Replace
Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
Font
On the Home Ribbon, what do you use to change the text color of characters in a cell?
Font Color drop-down list
On the Home Ribbon, what do you use to change the font size of characters in a cell?
Font Size drop-down list
What defines the color of the characters in an Microsoft Excel worksheet?
Font color
Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt?
Format
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?
Format
Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
Format Cells
Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?
Format Cells
Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?
Format as table
In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand?
Formatting
Which group on the Formulas Ribbon contains the command that checks for common errors found in a formula?
Formula Auditing
Where can you find the Insert Function button in Microsoft Excel?
Formula Bar
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry?
Formulas
Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?
Freeze
Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?
Freeze
John's spreadsheet includes multiple pages of records. If John wants to view his headings while scrolling through his spreadsheet what should he do?
Freeze Panes
What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?
Freeze Panes
What is a prewritten formula that is built into Microsoft Excel called?
Function
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?
Functions
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?
Gridlines
Tom wants to search his spreadsheet for a value in the fourth row of his table. What function should he use?
HLOOKUP
What command do you use to insert information into a worksheet that will display at the top and bottom edges of the printed page?
Header & Footer
Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
Hide
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?
Hide
Which ribbon includes the commands to apply a quick table style to a range of cells?
Home
Where can you find the command to apply a fill color to a cell or range of cells in a worksheet?
Home Ribbon
Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?
Hyperlink
What is the process of bringing data containing text fields separated by commas into Excel called?
Importing data
What ribbon contains the commands for creating charts in Microsoft Excel?
Insert
What ribbon contains the commands used to create a chart in Excel?
Insert Ribbon
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?
Key Tips
Tom wants to convert all text to lowercase. Which function she he use?
LOWER
John wants to identify the exact value that each column in his chart represents. Which option should he choose?
Labels
Which ribbon option opens a related dialog box?
Launcher
Which Chart Tools Ribbon tab allows a user to insert various labels on the chart?
Layout
Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart?
Layout
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?
Legend
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?
Legend Fields
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?
Line
John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create?
Line Chart
IF, AND, OR and NOT are all part of which category of functions?
Logical
Amanda has created a spreadsheet containing test grades for the first nine weeks. Which function would she use to find the highest test grade?
MAX
Which term describes the blank portions of a page that fall outside the main body of the printed document?
Margins
SUMIF and SUMIFS are in which category of functions?
Math & Trig
Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
Merge & Center
Kathryn needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
Merge and Center
John would like to change the order of the worksheets in his workbook. Which option would he choose?
Move
Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?
Move
James wants his spreadsheet to return true when the logical value is false. What function should he use?
NOT
Lakeisha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1?
NOW
Which area, on the left side of the formula bar, can you look at to determine the cell address of a selected cell?
Name box
Tyler created a monthly sales workbook that contains the formula =SUM(Sales). "Sales" is an example of a(n):
Named Range
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?
New
Which view is the default view used in Microsoft Excel?
Normal
What is typically included in the range of data selected to create a chart?
Numeric data and titles
Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?
Online Pictures
Joyce needs to access a spreadsheet she saved yesterday. Which command would she select?
Open
Kathryn needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
Orientation
Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?
Orientation
Jessica needs to capitalize the first letter in each word. Which function would she use?
PROPER
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format?
Page Layout
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?
Picture Styles
Which is the name of an interactive graphical representation of data that allows a user to change the groupings?
PivotChart
In order to directly report the data, what must a PivotChart always be associated with?
PivotTable
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?
PivotTable
Dorothy designed a column chart and would like to change the background color to yellow. Which chart feature should she modify?
Plot Area
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?
Print Titles
What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?
Protect Workbook
Which is a way to qualify data by specifying a matching condition or asking a question of the data?
Query
Which Microsoft Office object would you use for quick, convenient, one-click access to frequently used Excel commands?
Quick Access Toolbar(QAT)
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location?
Relative Reference
Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?
Rename
Which ribbon contains commands to add a comment about a selected cell in a worksheet
Review
Where is the spellchecker located?
Review Ribbon
How is an exact copy of a worksheet created within the same workbook?
Right click the sheet tab then choose Move or Copy from the Shortcut menu
How do you quickly modify a table style to meet user preferences?
Right-click on style and choose duplicate
Which command on the Page Layout Ribbon enables a user to flip objects on a worksheet?
Rotate
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent?
Row
Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the:
Row
Peter wants to replace a specific text in a text string in his spreadsheet. What function should he use?
SUBSTITUTE
What function adds all of the numbers in a range of cells?
SUM
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?
SUMIF
Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?
Scale
Which command on the Insert Ribbon enables a user to insert a picture of a part of a screen into a worksheet?
Screen Clipping
Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?
Screenshot
Which command do you use to remove manual page breaks from a worksheet area?
Select Remove Page Break from the Breaks drop-down area
John would like to add a banner at the top of his spreadsheet. Which object should he insert?
Shapes
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?
Share Workbook
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
Sheet Options
Which group on the View Ribbon enables a user to show or hide the ruler, gridlines, Formula Bar, or headings?
Show
What can you use to easily filter pivot tables and cube functions interactively in a worksheet?
Slicer
What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts?
Slicers
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?
Sort
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?
Sort
Which command on the Home Ribbon do you use to organize data in ascending or descending order?
Sort & Filter
Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?
Sort & Filter
Which is a tiny chart that provides a visual representation of data in a worksheet cell?
Sparkline
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option?
Split
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?
String
What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?
Styles
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?
Subtotal
Which of the following is the default method for summarizing data in a PivotTable?
Sum
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date in cell A1?
TODAY
Which function do you use to insert today's date in a worksheet so that it automatically updates each time the worksheet is opened?
TODAY
Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?
Tab color
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
Text
What occurs when the cursor is moved over a cell and a user clicks?
The cell is selected
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?
Theme
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?
Tracking Changes
What graphically represents trends in plotted data and predicts future values?
Trendline
Elizabeth needs to convert all text in Column A to uppercase. Which function should she use?
UPPER
John notices that column D is not showing on his spreadsheet. What action does he need to take to view column D?
Unhide
Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use?
VLOOKUP
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?
Values
Which command creates decorative text in a worksheet?
WordArt
Which of the following notebook- like features organizes the sheets for use in Excel?
Workbook
Which of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?
Worksheet
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?
Worksheet Reference
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?
Zoom to Selection