Excel Final Exam Review Higher Difficulty Questions
Which of the following should you press to close both an open file and Excel at the same time? Alt + F3 Ctrl + F4 F4 Alt + F4
Alt + F4
What command will arrange Microsoft Excel windows so that they appear side by side on the screen? Freeze Panes Arrange All Zoom to Selection New Window
Arrange All
Which Excel feature helps you quickly enter previous data into cells? QuickComplete AutoData QuickData AutoComplete
Auto Complete
Carl notices that the data in cell E4 reads #######. What command could Carl choose to correct this problem? AutoFit Special Formatting Wrap Text Subscript Formatting
AutoFit
In an Microsoft Excel worksheet, how do you change the width of a column so that the widest entry will fit? AutoFit Best Fit True Fit Smart Fit
AutoFit
What is the name of the feature that saves copies of your files at specified intervals? Document Recovery AutoRecover Track Changes Protect Sheet
AutoRecover
hich of the following displays in the title bar when a new window is opened from the View tab? Book1,2 Book2:1 Book1;2 Book1:2
Book1:2
Trey would like to outline the cell range A1:F20. Which formatting style should he select? Format as Table Borders Cell Style Conditional Formatting
Borders
The __________ is the line between rows or columns.
Boundary
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy? Breaks Background Effects Print Area
Breaks
If you want to move a shape up one level within a stack of overlapping graphics, which of the following buttons should be clicked? Restack Rearrange Bring Forward Bring to Front
Bring Forward
Which of the following statements accurately describes the default selection for AutoSum? 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. You must make the selection before clicking AutoSum. By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell. AutoSum does not have a default selection.
By default, AutoSum calculates the total from the adjacent cell through the first nonnumeric cell.
You want to calculate the number of non-blank cells in your worksheet. Which function do you use? COUNT SUM MAX COUNTA
COUNTA
On a PivotTable, what is a field with values not entered as data but determined by a computation involving data in other fields called? AutoSum Analyzed field Total field Calculated Field
Calculated Field
Which group on the Formulas Ribbon enables a user to specify when a formula is computed? Calculation Function Library Defined Names Formula Auditing
Calculation
Which of the following can you not copy using Format Painter? Font color Font size Bold Cell content
Cell content
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? Use the Undo command. Clear the cell's content. Apply the Normal style to the cell. Apply another style to the cell.
Clear the cell's content.
Which command do you use to close an open file and completely exit the Microsoft Excel program? Quit Exit Save As Close
Close
The identifying letter at the top of a column is called the _____. (hint: answer is two words)
Column Header
When you want to create a dual-axis chart, which chart type should be selected in the Change Chart Type dialog box ? Column Area Line Combo
Combo
What type of formatting appears only when the value in a cell meets conditions specified by a user? Restrictive Conditional Criterion Logical
Conditional
Which of the following object resizing handles is used to resize a shape or picture proportionally? Corner Left or right side Rotate Top center
Corner
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 + Up Arrow Ctrl + End Ctrl + 1 Ctrl + Home
Ctrl + End
To get to the last cell on the worksheet, which of the following should you press. Ctrl + Right Ctrl + End Ctrl + Home Ctrl + Left
Ctrl + End
To display the Open dialog box, which of the following should you press? Ctrl + F10 Ctrl + F8 Ctrl + F12 Ctrl + F11
Ctrl + F12
Alicia needs to move the data in cell B5 to cell E5. Which command would she select? Clear Cut Format Painter Copy
Cut
Which command on the "Home Ribbon" allows data to be moved from one worksheet location to another? Move Copy Duplicate Cut
Cut
Which group on the Formulas Ribbon contains a command that allows a user to create names for cells to use in a formula? Function Library Defined Names Formula Auditing Calculation
Defined Names
Which command on the Home Ribbon is used to remove cells, rows, or columns from a worksheet or table? Remove Format Delete Format as Table
Delete
John wants to change the chart style on his Pivot table. Which Pivot Table chart tools tab would he create? Design Layout Format Analyze
Design
Which Chart Tools Ribbon tab enables a user to apply a style to the selected chart? Style Design Layout Format
Design
Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable? Design Options Layout Format
Design
To help organize and identify Microsoft Excel files by providing details about the files, which of the following would you use? File Facts Document Options Document Properties File details
Document Properties
What is the process of using the mouse to move or copy cells called? Drag and move Drag and drop Dragging Click and paste
Drag and drop
What is the process of using the mouse to move or copy cells called? Drag and move Drag and drop Dragging Click and paste
Drag and move
Which of the following statements describes how to increase or decrease a column's width? Use the Page Setup dialog box. Select a Width setting in the Scale to Fit group on the Page Layout tab. Drag the boundary next to the column heading. Right-click anywhere in the column and select Format Cells.
Drag the boundary next to the column heading.
Which of the following statements best describes how to copy macros from one workbook to another? Drag the module from one project to another in the Project Explorer window of the Visual Basic Editor. Use the Record Macro button on the Developer tab. Open the Visual Basic Editor and type RUN COPYMACROS in the Project Explorer window. Use the Add-Ins button on the Developer tab.
Drag the module form one project to another in the Project Explorer window of the Visual Basic Editor.
The Shape Styles group is found on which of the following tabs? Home Insert Styles Drawing Tools Format
Drawing Tools Format
Which chart type appears on a worksheet with other data? Chart sheet Embedded PivotChart Mixed
Embedded
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 Line Chart Pivot Chart Linked Chart
Embedded Chart
What term refers to an Excel Chart with offset pieces? Separated Shattered Exploded Detached
Exploded
Which of the following is the Keyboard Shortcut, used to access help? F2 F5 F10 F1
F1
Dates can be displayed in only one way within Excel. True False
False
The AVERAGE function returns the number of cells in the selected range that contain text or values, but not blank cells. True False
False
The Quick Access Toolbar appears on the right side of the title bar, above the ribbon. False True
False
Using the Delete key removes both text and formats from a cell. True 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 False
False
You can access Backstage view by pressing Ctrl+B. False True
False
You do not have the ability to modify the number of default worksheets in a workbook. True False
False
To use a worksheet or workbook outside Excel, you have the option to save as which of the following? Worksheet File range File sheet File format
File format
What defines the color of the characters in a Microsoft Excel worksheet? Background Cell Color Font Size Font Color
Font Color
John wants to add text effects to his PivotChart. Which PivotTable Chart Tools tab would he use? Format Design Layout Analyze
Format
Lisa has added WordArt to her spreadsheet. Which tab is now available for her to edit the WordArt? Data Style Format Design
Format
Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree? Orientation Format Text Alignment Format Cells
Format Cells
In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and understand? Printing Configuring Arranging Formatting
Formatting
Which group on the Data tab includes commands that enable you to connect to external data sources and create new queries in the workbook? Get & Transform Forecast Connections Data Tools
Get & Transform
A(n) __________ is a line of text that appears at the top of each page of a printed worksheet.
Header
On which tab will you find the Go To command? Formulas File Home Page Layout
Home
Which of the following functions returns one value if a condition is true and a different value when the condition is not true? IF AND SUM OR
IF
When drawing lines, which of the following statements accurately describes how to change line thickness? In the Shape Outline menu, select Weight. You must set the thickness before drawing the line. In the Shapes menu, select the Thicker Line option. Right-click the line and choose Thickness
In the Shape Outline menu, select Weight.
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 alignment option do you choose? Distributed Middle Align Center Justify
Justify
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 Hot Keys Quick Access Toolbar Mini Toolbar
Key Tips
Joan is creating a table that will include demographic information about her employees. What is each header in her table considered? Value Label Formula Function
Label
Jennifer needs to identify the values in column B for a sales report. Which type of entry should she use in the column header? Functions Labels Values Formulas
Labels
Which ribbon option opens a related dialog box? Ellipse Slider Drop-down Arrow Launcher
Launcher
Which tab in the PivotChart Tools Ribbon allows a user to apply chart titles to the PivotChart? Format Layout Analyze Design
Layout
When you type text into a shape, which of the following paragraph alignments is applied by default? Right Center Full Justify Left
Left
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? Column Pie Line Bar
Line
John wants to create a chart that shows trends of sales for 4 quarters. What type of chart should he create? PivotChart Linked chart Line chart Embedded chart
Line Chart
The AND, OR, and NOT functions are included in which category of Excel functions? Text Lookup & Reference Financial Logical
Logical
James wants his spreadsheet to return true when the logical value is false. What function should he use? IF NOT AND OR
NOT
Larkeysha has created a spreadsheet containing student grades. Which function would she use to return the current date and time in cell A1? IF NOW TODAY COUNT
NOW
Which financial function is used to determine the number of periods for an investment or the number of loan payments? FV PMT PV NPER
NPER
Per the order of operations, which of the following is calculated first? Addition (+) and subtraction (−) (left to right) Exponentiation (ˆ) Negative number (−) Percent (%)
Negative number (-)
Which of the following commands is similar to Split? Preview Page Layout Zoom New Window
New Window
In which of the following locations are check boxes that you can select to view or print gridlines? On the Home tab, in the Cells group On the Page Layout tab, in the Sheet Options group In Print Preview On the Page Layout tab, in the Page Setup group
On the Page Layout tab, in the Sheet Options group
In which of the following locations does the Format Picture pane appear by default? As a free-floating pane On the right side of the workspace On the left side of the workspace Centered across the bottom of the workspace
On the right side of the workspace
Which of the following is the file extension used for Excel Template files? .xlsm .xltx .xlsx .xlam
.xltx
What option on the View tab displays worksheet margins and page breaks and gives you an opportunity to add a header or footer? Page Break Preview Custom Views Normal Page Layout
Page Layout
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel? View Home Data Page Layout
Page Layout
Which view enables a user to create or modify a worksheet while seeing how it will look in printed format? Print Web Normal Page Layout
Page Layout
Which of the following dialog boxes is used to transpose rows and columns? Paste Special Row Height Column Width Page Setup
Paste Special
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 Artistic Effects Corrections WordArt Styles
Picture Styles
The Crop tool is found on which of the following ribbon tabs? Drawing Tools Format Insert Home Picture Tools Format
Picture Tools Format
Which is the name of an interactive graphical representation of data that allows a user to change the groupings? PivotTable PivotDate Rotate Table PivotChart
PivotChart
In order to directly report the data, what must a PivotChart always be associated with? Table Range PivotTable Worksheet
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? PivotChart Rotate Table PivotTable PivotDate
PivotTable
What is the name of the window used in Excel to insert a calculated column in a table? PivotTable Tools Calculated Fields Power Pivot Pivot Power
PowerPoint
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 Area Orientation Page Break Print Titles
Print Titles
Which of the following is not on the Review tab? Share Workbook button Protect and Share Workbook button Protect Cells button Track Changes button
Protect Cells button
Which term refers to a group of selected cells that may be formatted, moved, copied or deleted as a group? Segment Cluster Ref Range
Range
When copying values in Microsoft Excel, which feature automatically adjusts cell references for the new copy location? Absolute Reference Certain Reference Variable Reference Relative Reference
Relative Reference
Where is the spellchecker located? Page Layout Ribbon View Ribbon Review Ribbon Home Ribbon
Review Ribbon
Joan has a table that includes demographic information about her employees. What does all the information about one employee represent? Workbook Row Column Entry
Row
Sharon's spreadsheet contains information about the number of music downloads in F25. "25" identifies the: Range Cell Column Row
Row
__________ is the top-to-bottom measurement of a row, measured in points. (hint: answer is two words)
Row Height
Which of the following is not a valid range name? SalesQ1 tbl.Holidays Sales Data \MyBudget
Sales Data
__________ refers to shrinking or stretching printed output to a percentage of its actual size.
Scaling
Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet? Picture Screenshot SmartArt Shapes
Screenshot
Some Keyboards come equipped with a/an __________ key, which disables arrow key movement when activated. Pg Dn Pg Up Caps Lock Scroll Lock
Scroll Lock
Which command do you use to remove manual page breaks from a worksheet area? Select break, press Remove Page Break from Shortcut Menu Select break, press Delete on keyboard Select Remove Page Break from the Breaks drop-down area Select break, press Backspace on keyboard
Select Remove Page Break from the Breaks drop-down area
Which tab in the Data Validation dialog box is used to specify the validation criteria? Settings Input Manager Error Alert Number
Settings
Which of the following buttons is clicked to apply a shadow to a shape or line? Picture Effects Shape Effects Artistic Effects 3D Effects
Shape Effects
John would like to add a banner at the top of his spreadsheet. Which object should he insert? Screenshot Shapes Picture SmartArt
Shapes
Which of the following demonstrates the general format of a formula that references a cell in a different worksheet? CellAddress!SheetName SheetName!CellAddress CellAddress#SheetName SheetName#CellAddress
SheetName!CellAddress
Which of the following keyboard shortcuts can be used to add a note to a cell? Shift+F2 Alt+Shift+C Alt+Shift+C Ctrl+N
Shift + F2
What is the name of the list of frequently used Excel commands available when a user right-clicks an item in the worksheet? Mini Toolbar Shortcut Menu Shortcut Toolbar Quick Access Toolbar
Shortcut Menu
What can you use to easily filter pivot tables and cube functions interactively in a worksheet? Slicer Division Sliver Cutter
Slicer
What are graphical objects that contain buttons a user can click to filter the data in PivotTables and PivotCharts? Partials Slicers Movers Slivers
Slicers
In order to display additional search options, which button in the Go To dialog box should you use? Drop down More Special Advanced
Special
John wants to be able to view multiple areas of his spreadsheet at the same time. What would be his best option? Hide Unhide Freeze Panes Split
Split
What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches? Key Thread String Text
String
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? Outline Subtotal Collapse Group
Subtotal
Which of the following is the default method for summarizing data in a PivotTable? Average Count Sum Max
Sum
Larry has created a spreadsheet containing student grades. Which function would he use to return the current date in cell A1? TODAY COUNT NOW IF
TODAY
When you modify the ribbon, which of the following is created? Worksheet Command Tab Button
Tab
Which of the following represents the syntax for a structured reference to a field in an Excel table? TableName[FieldName] FieldName[TableName] [FieldName]TableName [TableName]FieldName
TableName[FieldName]
Which argument in both the VLOOKUP and HLOOKUP function syntax refers to the range in which you want to look up data? Table_array Range_lookup Lookup_value Array_table
Table_array
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D? Date Text Number Currency
Text
Which of the following can not be used to turn on track changes? The Share Workbook button The Protect Sheet button The Track Changes button The Protect and Share Workbook button
The Protect Sheet button
Which of the following starts off with Save, Undo, and Redo and can be customized to contain the commands you use most frequently? The ribbon A worksheet The Help window The Quick Access Toolbar
The Quick Access Toolbar
Which of the following happens to a chart when the source data is deleted? Nothing. The chart will move to the area where the data was located. The data in the chart is deleted. You will be asked if you want the chart deleted.
The data in the chart is deleted
A(n) __________ is a predefined set of colors, fonts, and effects that can be applied to an entire workbook.
Theme
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 Template Layout Design
Theme
What graphically represents trends in plotted data and predicts future values? Chartline Error bar Trendline Sparkline
Trendline
After you select a color and apply it to a cell's background, the Fill Color button takes on that color. True False
True
Page Layout view is useful when preparing your data for printing? False True
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 False
True
You cannot split a single worksheet cell that has not been merged. True False
True
Jill wants to search her spreadsheet for a value in the first column of her table. What function should she use? VLOOKUP LOOKUP SEARCH HLOOKUP
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? Axis Fields Values Legend Fields Report Filter
Values
Which of the following is not a built-in Group By option when grouping dates in PivotTables? Years Weeks Seconds Quarters
Weeks
Which of the following is not found in the Illustrations group on the Insert tab? Shapes Online Pictures WordArt SmartArt
WordArt
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? Sheet Name Call the Sheet Worksheet Reference Name Reference
Worksheet Reference
Which of the following statements is not true? When a chart sheet is created, the chart no longer appears on the worksheet containing the data series. You can change both the height and width of a chart with commands on the Format tab. You can use the sizing handles to change the height and width of a chart. You must delete an existing chart in order to have the data displayed in a different chart type.
You must delete an existing chart in order to have the data displayed in a different chart type.
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 Enlarge Selected Area Magnify Area Amplify Range
Zoom to Selection
Jennifer is calculating her GPA. If she uses "=(A1+A2+A3+A4)/4", this is an example of which type of entry? formulas labels functions values
formulas
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? values functions formulas labels
functions
The COUNT and MIN functions are examples of which category or functions? financial text statistical logical
statistical
Where are the icons available to change views outside the ribbon? status bar worksheet cell titlebar
status bar
Which of the following is an acceptable name for a named range? subtotal west subtotal_west C7 subtotal/west
subtotal_west
If you cannot find the command you need while working in the ribbon, where can you click to find more options? the Group title at the bottom of the ribbon group the File tab on the left side of the ribbon the Help icon in the upper right corner above the ribbon the Options arrow in the bottom right corner of the group
the Options arrow in the bottom right corner of the group
Which of the following is the name of the specialized type of slicer that allows you to more quickly filter dates in a PivotTable? dateline slicer date/time slicer filter slicer timeline slicer
timeline slicer
When you split a window, the window is divided into how many panes? four three two or four two
two or four
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? OR NOT AND IF
AND
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? Unconditional Relative Mixed Absolute
Absolute
Which quick-number style button formats numbers to display as currency in the worksheet? Accounting Percent Dollar Comma
Accounting
Which of the following is an example of an absolute cell reference? A$9 $A$9 A9 A9:E9
$A$9
What is the maximum number of characters allowed in a file name? 200 255 175 125
255
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 =1$B$+25 =B1+25 =B1:B3
=$B$1+25
You want to create a worksheet where the user can see seven choices in a list all at once. When the user makes a selection on the list, another cell on the worksheet will show the number (position) of the item they selected (not the text itself from the item selection). Which control must be inserted in the worksheet? A Form List Box control An ActiveX List Box control A Form Combo Box control An ActiveX Option Button control
A Form List Box
Which of the following statements describes the difference between an AutoFiltered range of records in a list and a table? C A table maintains its sort order after you close and then open it again. There is no difference between an AutoFiltered range of records in a list and a table. A table enables special subtotal functions for total rows.
A table given a title enables its field names to be used in formulas in place of cell references.
Which of the following is an example of a mixed cell reference? A9 A9:E9 A$9 $A$9
A$9