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

Choose one answer.

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

Question 2

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

Choose one answer.

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

Question 3

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

Choose one answer.

	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.

Question 4

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

Choose one answer.

	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.

Question 5

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

Choose one answer.

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

Question 6

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.

Choose one answer.

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

Question 7

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

Choose one answer.

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

Question 8

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

Choose one answer.

	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

Question 9

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

Choose one answer.

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

Question 10

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?

Choose one answer.

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

Question 11

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

Choose one answer.

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

Question 12

Fill in the blank to complete the statement below.

Excel follows the ______________ that is found in Algebra.

Choose one answer.

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

Question 13

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

Choose one answer.

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

Question 14

What does cell reference refer to?

Choose one answer.

	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.

Question 15

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

Choose one answer.

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

Question 16

What is the order of operations that Excel uses?

Choose one answer.

	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

Question 17

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

Choose one answer.

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

Question 18

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

Choose one answer.

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

Question 19

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

Choose one answer.

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

Question 20

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?

Choose one answer.

	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)

Question 21

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

Choose one answer.

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

Question 22

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

Choose one answer.

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

Question 23

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

Choose one answer.

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

Question 24

On what ribbon will you find Freeze Panes?

Choose one answer.

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

Question 25

The COUNTIF function has which parts in what order?

Choose one answer.

	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)

Question 26

The IF function has which three parts in what order?

Choose one answer.

	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)

Question 27

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?

Choose one answer.

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

Question 28

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

Choose one answer.

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

Question 29

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

Choose one answer.

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

Question 30

Fill in the blanks to complete the statement below.

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

Choose one answer.

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

Question 31

Goal Seek is part of which set of tools?

Choose one answer.

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

Question 32

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

Choose one answer.

	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.

Question 33

Fill in the blanks to complete the statement below.

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

Choose one answer.

	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

Question 34

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

Choose one answer.

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

Question 35

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

Choose one answer.

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

Question 36

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

Choose one answer.

	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

Question 37

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

Choose one answer.

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

Question 38

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

Choose one answer.

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

Question 39

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.

Choose one answer.

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

Question 40

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?

Choose one answer.

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

Question 41

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.

Choose one answer.

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

Question 42

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

Choose one answer.

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

Question 43

What are the three styles of Sparklines?

Choose one answer.

	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

Question 44

Fill in the blanks to complete the statement below.

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

Choose one answer.

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

Question 45

In what view are Headers and Footers visible onscreen?

Choose one answer.

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

Question 46

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

Choose one answer.

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

Question 47

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

Choose one answer.

	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

Question 48

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

Choose one answer.

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

Question 49

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

Choose one answer.

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

Question 50

Fill in the blank to complete the statement below.

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

Choose one answer.

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

Question 51

Fill in the blank to complete the statement below.

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

Choose one answer.

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

Question 52

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

Choose one answer.

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

Question 53

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?

Choose one answer.

	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)

Question 54

Creating a table for your data allows you to:

Choose one answer.

	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.

Question 55

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

Choose one answer.

	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

Question 56

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

Choose one answer.

	a. True
	b. False

Question 57

What are the table styles available in Excel 2010?

Choose one answer.

	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

Question 58

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?

Choose one answer.

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

Question 59

What should you do first when subtotaling a table?

Choose one answer.

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

Question 60

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

Choose one answer.

	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.

Question 61

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

Choose one answer.

	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.

Question 62

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

Choose one answer.

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

Question 63

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

Choose one answer.

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

Question 64

You will find Filter options on which ribbon?

Choose one answer.

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

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