In Microsoft Excel, what is used to emphasize certain entries and make the worksheet easier to read and understand?

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

Which set of formatting choices

includes a set of colors, fonts, and effects that you can apply to a worksheet to enhance its appearance?

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?

Jack would like the data in Row 10 not to display on his spreadsheet. Which option should he select?

Jack would like to force the data in his spreadsheet to fit on one page when printed. Which option should he select?

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 group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?

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

What feature of Microsoft Excel keeps a portion of a worksheet visible while the other portion scrolls?

What is a single character, word,

or phrase in a cell on a worksheet that is typically used in searches?

Virgil wants to emphasize the sheet tabs in his workbook. Which command should he choose?

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

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

select?

Joan wants to be able to view row 1 as well as column A while scrolling through her worksheet. Which option should she choose?

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?

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

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?

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?

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?

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

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

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?