Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?

Which command on the Home Ribbon is used to format row height and column width, organize sheets, and protect or hide cells in a worksheet?

Which command on the Home Ribbon do you use to replace information in a selected cell with new information or new formatting?

Jack would like the data in Row 1 to remain stationary on the screen while he scrolls. Which option should he select?

What is a single character, word, or phrase in a cell on a worksheet that is typically used in searches?

John would like to change the order of the worksheets in his workbook. Which option would he choose?

Virgil needs to transfer a worksheet in the current workbook to a different workbook. Which command should he choose?

What command will arrange Microsoft Excel windows so that they appear side-by-side on the screen?

David wants to change all occurrences of "North Carolina" to "NC" in his spreadsheet. What command should he use to complete this task?

Virgil wants to customize the sheet tabs in his workbook with the names June, July, and August. Which command should he choose?

How is an exact copy of a worksheet created within the same workbook?

How can a table style be quickly modified to meet user preferences?

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?

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?

What is the process of bringing data containing text fields separated by commas into Excel called?

What Home Ribbon group contains the command used for quickly converting selected cells to a table by choosing a table style?

Which command on the Home Ribbon do you use to temporarily hide specific values on a worksheet based on a criterion?

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?

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?

Kenyon would like to convert the cell range A1:F20 to a Medium 19 style. Which formatting style should he select?

Which ribbon includes the commands to apply a quick table style to a range of cells?

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?

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?

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?

Which command on the Home Ribbon do you use to organize data in ascending or descending order?

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?

Tom wants to search his spreadsheet for a value in the fourth row of his

table. What function should he use?

Jill would like to use a function that will return “True” when only one of

the arguments in the function is true. What function should she use?

Jill wants to search her spreadsheet for a value in the first column of her

table. What function should she use?

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?

James wants to use an advanced function to search his spreadsheet for a

specific string in a text string. What function should he use?

Tom wants to convert all text to lowercase. Which function should he

use?

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

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?

James wants his spreadsheet to return true when the logical value is

false. What function should he use?

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?

Jessica needs to capitalize the first letter in each word. Which function

would she use?

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 she use?

Where is the spell checker feature located in Microsoft Excel?

What command limits structural changes, such as adding, deleting, or

moving sheets, that can be made in a workbook?

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?

All of the FBLA officers have access to the spreadsheet of member

contact information. Which feature of Excel allows others to view who

made changes to the spreadsheet, when the changes were made, and

what was changed?

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?

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?

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?

Which is the default method for summarizing data in a PivotTable?

John wants to change the chart style on his Pivot table. Which Pivot

Table chart tools tab would he choose?

What ribbon contains the commands for creating charts in Microsoft

Excel?

What graphically represents trends in plotted data and predicts future

values?

Which ribbon is visible when a PivotTable is selected, and allows a user

to apply various styles to the PivotTable?

What are graphical objects that contain buttons a user can click to filter

the data in PivotTables and PivotCharts?

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

John wants to identify the exact value that each column in his chart

represents. Which option should he choose?

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

worksheet cell?

What is the purpose of the -/+ buttons that appear across the categories

on a PivotTable?

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

meets the criterion only?

When creating a PivotTable, which are drawn in columns in the worksheet

data?

In order to directly report the data, what must a PivotChart always be

associated with?

John wants to add text effects to his PivotChart. Which PivotTable Chart

Tools tab would he use?

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?

Which is an interactive view of worksheet data that gives a user the

ability to summarize the data by selecting categories for grouping?

Which tab in the PivotChart Tools Ribbon allows a user to apply a chart

style to the PivotChart?

What term refers to an Excel Chart with offset pieces for emphasis?

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?

John would like to display the count of employee last names on the Yaxis

of a PivotChart. What area would he drag this information to in order

to display correctly?

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?

John wants to create a chart that shows trends of sales for four quarters.

What type of chart should he create?

Which Chart Tools Ribbon tab enables a user to apply a style to the

selected chart?

What can you use to easily filter pivot tables and cube functions

interactively in a worksheet?

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

On a PivotTable, what is a field with values not entered as data but

determined by a computation involving data in other fields called?

In Microsoft Excel, which tab is used to add shape effects to a chart?

Edward would like to create a chart that uses vertical rectangles to

compare iPod and iPad sales. Which chart type would he create?

Which is the name of an interactive graphical representation of data that

allows a user to change the groupings?

Dorothy designed a column chart and would like to change the

background color to yellow. Which chart feature would she modify?

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?

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?

Which command on the Insert Ribbon enables a user to insert a picture

of a part of a screen into a worksheet?

Which command on the Insert Ribbon inserts a graphic from the Microsoft

Office collection into a worksheet?