Lessons 10 - 13 Excel

To create a chart that shows trends of sales for 4 quarters. What chart would you create

What ribbon contains the commands used to create a chart in Excel

A function that will return T when all arguments are T, and F when one or more arguments are F

To count only cells in a range that contain only 100, what function do you use

Where is the spell checker feature located in Excel

To average the cells in a range that is greater than 100 but less than 500, the function is

What limits structural changes, such as adding, deleting, or moving sheets, that can be made

What is the purpose of the -/+ buttons that appear across the categories in a Pivot table

James wants his spreadshseet to return true when the logical value is false. The function is

To identify the exact value each column in a chart represents what option should you use

What ribbon is visible when a PivotTable is selected, and allows you to apply various styles

To make a picture stand out with a frame or 3D effect, which tool can you use to do this with

Which chart tools ribbon tab allows a user to select from a gallery of chart styles

How can you sharpen an image that's been taken with a low image camera to put into a worksheet

Molly needs to convert all text in Column A to uppercase, what function can she use

To replace specific text in a text string in a spreadsheet what function is this

What graphically represents trends in plotted data and predicts future values

Column A has first & last names that need to separate into 2 different columns. What tool?

In a column chart you would like to change the background color to yellow. What feature?

What tab in the PivotChart Tools ribbon allows a user to apply a chart style to the Pivot Table

What is typically included in the range of data selected to create a chart

What command on the Insert Ribbon inserts a graphic from MS Office Collection into a worksheet

What command on the Insert Ribbon lets you insert a pic of part of a screen into a worksheet

What chart tools ribbon tab enables a user to apply a style to the selected chart

To add only cells in a spreadsheet in a range that are greater than 1,000 what function is used

To directly report the data, what must a Pivot Chart always be associated with

To change the cart style on a Pivot table chart,which Pivot chart tools tab would you choose

What function is used for Excel pick a random number between 100 and 5000 for new member ids

Which feature of Excel allows others to view who made changes to the spreadsheet

SUMIF and SUMIFS are in which category of functions

To add a banner at the top of a spreadsheet, which object do you insert

To add an element that will help lead the eye and improve readability in a chart the feature is

IF, AND, OR and NOT are all part of which category of functions

On the Insert Ribbon what command lets you insert a picture of a program window on a worksheet

You added Word Art to a spreadsheet. Which tab is now available to edit the Word Art

To search a spreadsheet for a value in the 4th row of a table, what function should you use

What graphical objects contain buttons you can click to filter the data in Pivotcharts/tables

Using an advanced function to search for a specific string in a text string, the function is

To add a note informing about an incorrect address for a member, what option can be used

To the count of employee last names on the Y axis of a Pivot chart, what area would you drag

To see the changes advisors have made to a workbook, the command that would allow this is

Mack needs to capitalize the first letter in each word. Which function woul she use

A chart that uses vertical rectangle sot compare IPod and IPad sales. What chart demonstrates?

Which command on the Page layout ribbon enables you to flip objects on a worksheet

To add an element to the right of a bar chart that identifies ear bars color is a

So all advisors in a group make changes to a spreadsheet at the same time, the command would be

To be able to view monthly sales chart as well as data on the same worksheet you would creat

Which command creates decorative text in a worksheet

To add text effects to a Pivot Chart, which Pivot Table Chart Tools Tab would you use

What term refers to an Excel chart with offset pieces for emphasis

What is the process of viewing a PivotTable report for a subset that meets the criterion only

Which ribbon contains commands to add a comment about a selected cell in a worksheet.

What can you use to easily filter pivot tables and cube functions interactively in a worksheet

What ribbon contains the commands for creating charts in Microsoft Excel

A chart that shows the trend in IPod sales over the past 2 years would be

Sue wants to convert all text to lowercase, which function should she use

Which is tiny chart that provides a visual representation of data in a worksheet cell

What gives you the ability to summarize the data by selecting categories for grouping.

To change a comment you made in a spreadsheet, what option in the comments group do you choose

What chart feature, lets you add an element above the chart to make the data more meaningful

When creating a Pivot table, which are drawn in columns in the worksheet data

To search a spreadsheet for a value in the first column of a table, what function do you use

Which is the default method for summarizing data in a Pivot Table