To change the name of a worksheet, you should right click on the worksheet tab and then choose which option?

	a. Insert New Name
	b. Rename
	c. Name Again
	d. Select New Name
	e. None of the above answers is correct.

.

What is the feature that turns a curser into a small crosshair shape on the right corner of the active cell(s)?

	a. The Format Handle
	b. The Formula Handle
	c. The Function Handle
	d. The Fill Handle
	e. The Cross Hair Handle

.

Which of the following actions allows you to move a worksheet to another location?

	a. Right click, choose Move, and then choose the location.
	b. Click on the worksheet tab and drag it to the new location.
	c. From the Home Ribbon, choose Move and then choose the new location.
	d. Both A and B are correct.
	e. Both B and C are correct.

.

Which of the following actions allows you to print a worksheet?

	a. Right click on Cell A1 and then choose Print.
	b. Click on the File Ribbon or Office Button and then choose Print.
	c. Choose Quick Print from the Quick Access Toolbar.
	d. Both A and B are correct.
	e. Both B and C are correct.

.

All of the following elements are available to conditionally format except:

	a. Highlight cells rules
	b. Date and time bars
	c. Top and bottom rules
	d. Color scales
	e. Icon sets

.

Fill in the blank to complete the statement below.

To wrap text within a cell, you can use the keyboard shortcut ______ or the Wrap Text icon.

	a. Ctrl + Enter
	b. Shift + Ctrl + Enter
	c. Enter + Tab
	d. Alt + Enter
	e. Shift + Enter

.

The Format Cell dialog box has all of the following tabs except:

	a. Data
	b. Numbers
	c. Font
	d. Borders
	e. Fill

.

What are the three standard number formats that are available in the Number grouping on the Home Ribbon?

	a. Currency, Accounting, and Comma
	b. Accounting, Percent, and Comma
	c. Comma, Percent, and Date
	d. Percent, General, and Currency
	e. Date, Accounting, and Percent

.

Which of the following actions can be used to combine two or more cells into one?

	a. Wrap Cells
	b. Merge Across
	c. Merge and Center
	d. Merge Wrap
	e. B and C are both correct.

.

Which of the following features helps to visually answer specific questions about a user’s data by formatting the data to a set of requirements defined by the user?

	a. Subjective formatting
	b. Prescriptive formatting
	c. Conditional formatting
	d. Visually formatting
	e. Cell style formatting

.

Which of the following numbers would result from setting a cell’s number style to Comma [0]?

	a. 12345.27
	b. 12,345.27
	c. $12,345.27
	d. $12,345
	e. 12,345

.

Fill in the blank to complete the statement below.

Excel follows the ______________ that is found in Algebra.

	a. order of operations
	b. exponents
	c. hierarchies of numbers
	d. macros
	e. All of the above answers are correct.

.

In Excel, what are pre-defined formulas with a specific syntax pattern called?

	a. Flash formulas
	b. Factors and formulas
	c. Calculations
	d. Functions
	e. Operations

.

What does cell reference refer to?

	a. The name of a cell
	b. The placement of a cell
	c. The placement of a formula
	d. The name of a function
	e. Both A and B are correct.

.

What is a handy keyboard shortcut that puts dollar signs ($$) around cell and row addresses in a formula and creates an absolute value?

	a. F1
	b. Shift+~
	c. F4
	d. Ctrl+*
	e. F5

.

What is the order of operations that Excel uses?

	a. Parenthesis, addition, subtraction, multiplication, division
	b. Exponents, parenthesis, addition, subtraction, multiplication, division
	c. Parenthesis, multiplication, division, exponents, addition, subtraction
	d. Exponents, multiplication, addition, subtraction, division, parenthesis
	e. Parenthesis, exponents, multiplication, division, addition, subtraction

.

When you are creating formulas using cell location, your default cell reference is:

	a. Relative
	b. Absolute
	c. Constant
	d. Fixed
	e. Mixed

.

Which of the following functions is NOT available in the Sum function icon on the Home Ribbon?

	a. Max
	b. Count
	c. Average
	d. Min
	e. Count Numbers

.

Which of the following functions is written in the correct syntax?

	a. NOW(today)
	b. SUM(D2-A2)
	c. =SUM(A1=B1)
	d. =SUM(A1:D1)
	e. =NOW(today)

.

Which of the following is the correct syntax for a PMT function for a 20-year monthly mortgage payment with a 6% interest rate for a house that costs $100,000?

	a. =PMT (6%/12, 20*12,100000)
	b. =PMT (6%, 20*12, 100000)
	c. =PMT (6%/12, 20, 100000)
	d. =PMT (6%/12, 20*12, 100,000)
	e. =PMT (6%, 20, 100,000)

.

Which of the following tools is NOT available in the Formula Auditing grouping?

	a. Trace Precedents
	b. Trace Dependents
	c. Error Checking
	d. Define Name

.

Which symbol alerts Excel that you are entering a formula and not text?

	a. *
	b. $
	c. +
	d. #
	e. =

.

Which type of cell reference does not change when copied and remains in a fixed position during operations?

	a. Relative
	b. Absolute
	c. Constant
	d. Fixed
	e. Mixed

.

On what ribbon will you find Freeze Panes?

	a. Home
	b. Insert
	c. Formulas
	d. Data
	e. View

.

The COUNTIF function has which parts in what order?

	a. =COUNTIF (range, value if false, value if true)
	b. =COUNTIF (range, criteria)
	c. =COUNTIF (criteria, value if true, value if false)
	d. =COUNTIF (criteria, range)
	e. =COUNTIF (range, criteria, value if true, value if false)

.

The IF function has which three parts in what order?

	a. =IF (array operator, value if false, value if true)
	b. =IF (value if true, value if false, argument array)
	c. =IF (logical test, value if true, value if false)
	d. =IF (logical test, value if false, value if true)
	e. =IF (argument array, false value, true value)

.

What is the correct syntax for an IF Function where the value B2 is equal to C2 and where the True part is C2*$10,000 and the False part is C2*$5,000?

	a. =IF(B2=C2, $10,000*C2, $5,000*C2)
	b. =IF(B2=C2; C2*$10,000; C2*$5,000)
	c. =IF(B2=C2, C2*10000, C2*5000)
	d. IF(B2=C2; C2*10000; C2*5000)
	e. None of the above answers is correct.

.

When text is used in a function, such as IF or COUNTIF, the text should be enclosed in what grammatical marks?

	a. Quotation marks
	b. Parentheses
	c. Exclamation marks
	d. Single quotation mark (apostrophe) or Apostrophe (single quotation mark)
	e. Accent marks

.

Which function evaluates a specific condition and returns one value if it is true and another if it is false?

	a. COUNT
	b. HLOOKUP
	c. EVAL
	d. IF
	e. LOOKUP

.

Fill in the blanks to complete the statement below.

You will find Goal Seek in the _________ grouping on the ___________ ribbon.

	a. Cells; Home
	b. Calculations; Formulas
	c. Macros; View
	d. Data Tools; Data
	e. Proofing; Review

.

Goal Seek is part of which set of tools?

	a. Data validation tools
	b. Consolidation tools
	c. What-If analysis tools
	d. Advanced tools
	e. Filtering tools

.

The VLOOKUP function has which three main parts in what order?

	a. =VLOOKUP (Lookup_Value, Table_array, Col_index-num)
	b. =VLOOKUP (Col_index-num, Lookup_Value, Table_array, Col)
	c. =VLOOKUP (Range_lookup, Lookup_Value, Table_array)
	d. =VLOOKUP (Table_array, Col_index-num, Range_lookup)
	e. Both B and C are correct.

.

Fill in the blanks to complete the statement below.

To format a chart’s title, ______________ and choose ____________:

	a. click on the Design Ribbon; Quick Styles
	b. click on the Design Ribbon; Chart Titles
	c. click on the Layout Ribbon; Chart Titles
	d. right click on the chart; Edit Title
	e. right click on the Title; Edit Text

.

In Excel, a chart that is displayed on the same sheet as the data it is derived from is considered what?

	a. Embedded
	b. Linked
	c. Dependent
	d. Schematic
	e. Standalone

.

What is the name of a chart that shows percentages of a whole and has no axes?

	a. A sheet chart
	b. A bar chart
	c. A line graph
	d. A pie chart
	e. A percentage chart

.

What three chart ribbons appear after a chart has been created?

	a. View, Design, and Layout
	b. View, Layout, and Format
	c. Design, Layout, and Format
	d. Layout, Format, and Review
	e. Format, Review, and Design

.

Which of the following is an appropriate tool to use when you want to visually represent the numeric data in a worksheet?

	a. A report
	b. A chart
	c. A timeline
	d. Data layout
	e. A slicer

.

Which type of chart displays comparisons about items that are typically organized along the horizontal axis with values along the vertical axis?

	a. A sheet chart
	b. An area chart
	c. A line graph
	d. A pie chart
	e. A column chart

.

Data on this type of chart (also referred to as an XY chart) requires quantitative values on both the X and Y axes. It is a common chart type for supply and demand curves.

	a. An area chart
	b. A stock chart
	c. A surface chart
	d. A donut chart
	e. A scatter chart

.

Excel 2010 introduced a new feature that comprises a very small chart within a worksheet cell that provides a visual representation of data or shows patterns in data. What is this feature called?

	a. Sparkcharts
	b. A Win/Loss chart
	c. High/Low lines
	d. Sparklines
	e. Data Axis lines

.

Fill in the blanks to complete the statement below.

To change a chart type after it has been created, use the ______ tool on the Chart Tools ________ ribbon.

	a. Change Chart Type; Format
	b. Quick Layout Style; Design
	c. Change Chart Type; Design
	d. Select Data; Layout
	e. Format Selection; Format

.

To create a combination chart, in which any single data series is changed, the starting chart must be which of the following?

	a. A 3D chart
	b. A 2D chart
	c. A column or a pie chart
	d. A line chart
	e. A bubble chart

.

What are the three styles of Sparklines?

	a. Bar, Line, and Column
	b. Line, Column, and Win/Loss
	c. Column, Slicer, and Win/Loss
	d. Column, Win/Loss, and Slicer
	e. Slicer, Line, and Column

.

Fill in the blanks to complete the statement below.

To add a predefined shape to your worksheet, first choose _______, then choose _______.

	a. Insert Ribbon; Shapes
	b. Clip Art Ribbon; Shapes
	c. Insert Ribbon; Clip Art
	d. Insert Ribbon; Picture
	e. Clip Art Ribbon; SmartArt

.

In what view are Headers and Footers visible onscreen?

	a. Normal
	b. Page Layout
	c. Wide
	d. Page Break Preview
	e. Both A and C are correct.

.

The ‘Smiley Face’ shape is found under which category in Shapes?

	a. Lines
	b. Abstract
	c. Basic Shapes
	d. Equation Shapes
	e. Callouts

.

Which of the following destinations is NOT a choice in the Insert Hyperlink dialog box?

	a. A Slicer address
	b. A Place in This Document location
	c. An existing file or webpage
	d. An email address
	e. A current folder

.

Which of the following elements are related to symbols, and which symbols are considered to be another type of?

	a. Charts
	b. Fonts
	c. Styles
	d. Clip art
	e. Word art

.

Which of the following is NOT available in the Header-Footer Tool Ribbon?

	a. The current time
	b. The file path
	c. The current date
	d. The current formula
	e. The sheet name

.

Fill in the blank to complete the statement below.

To format multiple worksheets at one time, you should _________ the worksheets.

	a. link
	b. group
	c. unhide
	d. relate
	e. concur

.

Fill in the blank to complete the statement below.

When worksheets are grouped, the word ‘Group’ shows up in the ____________.

	a. Formula Bar
	b. Status Bar
	c. Quick Access Toolbar
	d. Name Bar
	e. None of the above answers is correct.

.

What is the term for a situation in which a formula/function uses cells from another worksheet within the same workbook?

	a. A link
	b. A 3D reference
	c. A lookup space
	d. A relative cell reference
	e. A FINDIF formula

.

Which of the following is the correct syntax for a Sum Function in a Summary worksheet for values coming from worksheets named Quarter 1, Quarter 2, Quarter 3, and Quarter 4?

	a. =SUM(Quarter 1 – Quarter 4, B9)
	b. =SUM(Quarter 1:Quarter 4, B9)
	c. =SUM(Quarter 1: Quarter 4!B9)
	d. =SUM(‘Quarter 1: Quarter 4’,B9)
	e. =SUM(‘Quarter 1:Quarter 4’!B9)

.

Creating a table for your data allows you to:

	a. manage and analyze the data independently of data outside the table.
	b. filter and sort the data efficiently.
	c. add a row for totals and prebuilt functions in that row.
	d. All of the above answers are correct.
	e. None of the above answers is correct.

.

In the Sort dialog box, what are the three options for sorting?

	a. Column, Sort by, and Options
	b. Column, Sort On, and Order
	c. Sort by, Order, and Add Level
	d. Add Level, Delete Level, and Options
	e. Sort by Values, Column, Options

.

True or False: The Advanced Filter and Custom Filter will bring up the same dialog box.

	a. True
	b. False

.

What are the table styles available in Excel 2010?

	a. Light, Medium, and Dark
	b. Light, Dark, and Banded
	c. Varied, Banded, and Scaled
	d. Varied, Light, and Dark
	e. Light, Medium, and Scaled

.

What Excel feature was designed to help summarize, analyze, and explore large amounts of data, as well as make it easier to present information in order to see comparisons, patterns and trends?

	a. PivotReports
	b. PivotTables
	c. PivotCharts
	d. PivotGroups
	e. Both B and C are correct.

.

What should you do first when subtotaling a table?

	a. Remove all filters
	b. Convert to range
	c. Export to another sheet
	d. Remove duplicates
	e. Nothing; just use the subtotal row

.

When sorting a column in a table, what are your three choices for sorting?

	a. A to Z; Z to A; advanced
	b. Greater than; Less than; Equal to
	c. Above average; Below average; Equal to
	d. Ascending; Descending; Advanced
	e. Both A and D are correct.

.

When you are conducting an advanced Sort, what three choices are available to you in the Order column?

	a. A to Z, Z to A, Custom List…
	b. Cell Color, Font Color, Cell Icon
	c. Z to A, A to Z, Special…
	d. Values, Options, Custom List…
	e. All of the above answers are correct.

.

Which of the following is NOT available on a Table Tools Ribbon for Table Styles Options?

	a. The subtotal
	b. The header row
	c. The total row
	d. Banded columns
	e. The first column

.

Which of the following number filters may NOT be used to filter a column of numbers in a table?

	a. Equals; Does not equal
	b. Above average; Below average
	c. Bottom 10 items
	d. Between
	e. Greater than; Less than

.

You will find Filter options on which ribbon?

	a. The Table Tools Design Ribbon
	b. The Data Ribbon
	c. The View Ribbon
	d. The Insert Ribbon
	e. The Home Ribbon

.