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?

Where is the spell checker feature located in Microsoft Excel?

Lisa has added WordArt to her spreadsheet. Which tab is now available

for her to edit the WordArt?

Which command on the Home Ribbon do you use to temporarily hide

specific values on a worksheet based on a criterion?

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?

What is the process of bringing data containing text fields separated by

commas into Excel called?

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

John’s spreadsheet includes multiple pages of records. If John wants to

view his headings while scrolling through his spreadsheet what should he

do?

Which command is used to format a cell or selected cells quickly by

choosing from a defined list of styles?

John would like to add a banner at the top of his spreadsheet. Which

object should he insert?

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?

In Microsoft Excel, what is used to emphasize certain entries and make

the worksheet easier to read and understand?

Joan has entered her name in the First Name field in cell B2 of her table.

What does her First Name represent in the table?

Kathryn needs the title in cell A1 to align horizontally across cells A1

through D1. Which alignment option should she select?

Column D in a spreadsheet contains employee ID Numbers. Which

formatting would be most appropriate for the data in column D?

Which command on the Home Ribbon can be used to rotate text to a

vertical or diagonal angle in a worksheet?

Alicia needs to delete the data in cell B5. Which command would she

select?

Joan has a table that includes demographic information about her

employees. If the demographic information is listed across the top and

employee names down the left side of the table, what does all the

information about one employee represent?

Which Microsoft Excel feature automatically inserts data into a cell that

begins with the same characters as a previous entry?

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?

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

Sharon’s spreadsheet contains information about the number of music

downloads in F1:F25. F1:F25 represents a:

Where is the command to apply a fill color to a cell or range of cells in a

worksheet?

John notices that column D is not showing on his spreadsheet. What

action does he need to take to view column D?

What defines the color of the characters in a Microsoft Excel worksheet?

Which Microsoft Office object would you use for quick, convenient, oneclick

access to frequently used Excel commands?

On the Home Ribbon, what is used to change the font size of characters

in a cell?

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?

The FBLA Advisor at Hilltop High School would like to create random ID

numbers for FBLA members. Which function would be used to have Excel

pick a random number between 1,000 and 5,000 for the new member ID

numbers?

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?

Kenyon would like to convert the cell range A1:F20 to a Medium 19 style.

Which formatting style should he select?

How is a cell reference in a formula and its corresponding location in a

worksheet identified?

What method is the most efficient way to copy five separate formulas to

adjacent cells simultaneously?

Joyce needs to access a spreadsheet she saved yesterday. Which

command would she select?

Which notebook-like feature organizes the sheets for use in Excel?

Which term refers to a group of selected cells that may be formatted,

moved, copied or deleted as a group?

Which command on the Fill options dialog box is the default option if a

month or day is entered?

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

ability to summarize the data by selecting categories for grouping?

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

allows a user to change the groupings?

John wants to identify the exact value that each column in his chart represents. Which option should he choose?

What ribbon contains the commands for creating charts in Microsoft Excel?

Which ribbon is visible when a PivotTable is selected, and allows a user to apply various styles to the PivotTable?

What command limits structural changes, such as adding, deleting, or moving sheets, that can be made in a workbook?

James wants his spreadsheet to return true when the logical value is false. What function should he use?

Which command on the Insert Ribbon enables a user to insert a picture of a program window into a worksheet?

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 of the following would you use to enter, calculate, manipulate, and analyze data such as numbers and text in Excel?

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

Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?

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?

Which is a way to qualify data by specifying a matching condition or asking a question of the data?

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

What command is used to apply a background color to cells in a worksheet?

Which command on the Insert Ribbon inserts a graphic from the Microsoft Office collection into a worksheet?

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

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

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

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?

Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?

Kenyon would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style should he select?

When entering data into a cell, which keyboard key is used to remove characters to the left of the insertion point?

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?

Gabriel needs to create a shortcut formula in cell B40 to calculate total sales located in cells B1 through B39. Which function should he create?

Which command is used to remove manual page breaks from a worksheet area?

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 using the mouse to move or copy cells called?

Which group on the Formula Ribbon contains the command that checks for common errors found in a formula?

Dawn is creating a formula to multiply the values in cells D4 and F4. Which formula should she use?

Which group on the Formulas tab enables a user to specify when a formula is computed?

Leah and her fellow FBLA officers want to analyze scores from the most recent competitive events. Which of the cell values would least likely be determined by using the Conditional Formatting feature of Excel?

Vicki wants to create a custom font format for her Excel workbook in which she changes the Heading and Body fonts. Which tab should she select to create a new font format?

Mary is editing a worksheet and has updated the formatting of a cell. She wants to copy the formatting to several cells throughout the worksheet. Which will reduce the time it takes to complete the task?

Carol has created a worksheet that employees in her company will access to input data. To make it user-friendly and reduce input errors, Carol can insert a:

What does Emma need to do before she can group the data in her PivotTable?

Amy is currently viewing a chart she recently created and would like to make a chart template from it. To complete this task, Amy should:

On which tab is the Shape Effects command located?

The statement that best describes the GETPIVOTDATA function is that it:

PMT, PV, and FV are functions found in which Function Library category?

Which function takes three separate values and combines them to form a date-time code?

Michelle is trying to correct a formula error in cell B7. Which command will help her identify the cells that affect the value of B7?

Which Excel command allows Susan to automatically save her workbook every 15 minutes?

Which Excel command will allow Amarii to limit the number of characters that can be entered into a cell?

Which Excel command allows a user to display hidden ribbon tabs?

Changes become part of the change history only when the user:

To create a PivotTable from Power Pivot data, the data must be in:

Which is a graphical representation that fails to depict all of the exact data in the worksheet?

As the manager of a furniture store, Sally is using an Excel spreadsheet to keep track of the store sales goals. She wants to use a function that will return "TRUE" if at least one of the two goals is reached. Which function should she use?

Tyrone would like to use a function that returns a value that meets criteria in the second row of a table in his spreadsheet. Which function should he use?

Chris wants to update the default Title Style by changing the font color and font style. To accomplish this, on the Home tab, in the Styles Group, Chris should click on the Cell Styles icon, right-click the Title Style, and select which option?

In order to change the name of a range of cells, the user must first click the Formulas tab. What feature should the user click next?

Which Excel term, denoted with [square brackets], can be found in the header row of a table and refers to the set of all cells that comprise the named column in the table?

Perry is using multiple worksheets and would like to total the numbers into one summary worksheet. Which built-in Excel tool should Perry use to accomplish his goal quickly?

Which is an example of a correctly written nested function?

Combo boxes, check boxes, scroll bars, text boxes, and labels are all examples of:

Daniel wants to create a custom theme color in Excel. On which tab will he find theme colors?

Katie wants to calculate the total dues collected from FBLA members. She notices the total is not being updated as she changes the data. Which option on the Formula tab would allow her to fix this problem?

Which file name would be used for an Excel 2016 template?

Which is an example of a trendline option in Excel?

An advantage of using the Power Pivot model over standard PivotTables is the ability to: