Upgrade to remove ads
Lesson 6-7 Test
Terms in this set (40)
Which command on the Home Ribbon do you use to rotate text to a vertical or diagonal angle in a worksheet?
Which command do you use to remove manual page breaks from a worksheet area?
Select remove page break from menu
What command do you use to apply a background color to cells in a worksheet?
Jonathan notices that column D is not showing on his spreadsheet. What action does he need to take to view
Which dialog box contains the commands to specify an exact date and time format to use for a selected cell in a worksheet?
Lindsey is showing her spreadsheet to a customer and does not want the customer to be able to see the
wholesale prices column. What option should she choose?
Column D in a spreadsheet contains information about regional sales. Which formatting would be most appropriate for the data in column D?
Liam would like the data in Row 10 not to display on his spreadsheet. Which option should he select?
What type of formatting appears only when the value in a cell meets conditions specified by a user?
Which term describes the blank portions of a page that fall outside the main body of the printed document?
Which command on the Home Ribbon do you use to format row height and column width, organize sheets,
and protect or hide cells in a worksheet?
Sean 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?
Column D in a spreadsheet contains employee ID Number. Which formatting would be most appropriate for the data in column D?
Robbie notices that the data in cell E4 reads #######. What command could he choose to correct this problem?
Where can you find the command to apply a fill color to a cell or range of cells in a worksheet?
Aneesh would like to outline the cell range A1:F20. Which formatting style should he select?
Which command on the Insert Ribbon creates a link to a web page, picture, email address, or program in a worksheet?
Which command do you use to reduce the margin between the border and the text in an indented cell?
Which quick-number style button formats numbers to display as currency in the worksheet?
Which defines the appearance and shape of the letters, numbers, and special characters in Microsoft Excel?
Which command on the Home Ribbon joins selected cells into one and centers that content into a larger single cell?
Merge and Center
In Microsoft Excel, what do you use to emphasize certain entries and make the worksheet easier to read and
On the Home Ribbon, what do you use to change the text color of characters in a cell?
Font Color drop-down list
What command do you use to insert information into a worksheet that will display at the top and bottom
edges of the printed page?
Header and Footer
What defines the color of the characters in an Microsoft Excel worksheet?
Which ribbon contains the command to apply a theme to a worksheet in Microsoft Excel?
Which command on the Home Ribbon do you use to remove cells, rows, or columns from a worksheet or table?
On the Home Ribbon, what do you use to change the font size of characters in a cell?
Font size drop down
Which set of formatting choices includes a set of colors, fonts, and effects that you can apply to a worksheet
to enhance its appearance?
Which command do you use to format a cell or selected cells quickly by choosing from a defined list of styles?
Which command on the Page Layout Ribbon enables a user to mark where a new page will begin on the printed copy?
Alex would like to apply a rule to the data in cell range A1:F20 that will highlight numbers greater than
50,000 with a yellow fill color and dark yellow text. Which formatting style should he select?
Which command group on the Page Layout Ribbon controls the presence of gridlines and headings on a worksheet?
William would like to force the data in his spreadsheet to fit on one page when printed. Which option should he
Jaejin would like to apply the Title format to the data in Row 1 of a spreadsheet. Which formatting style
should he select?
Which dialog box in Microsoft Excel do you use to set the rotation of text in a cell to a specific degree?
Nikita needs the title in cell A1 to align horizontally across cells A1 through D1. Which alignment option should she select?
Merge and Center
Patrick's spreadsheet includes multiple pages of records. If Patrick wants to view his headings while scrolling
through his spreadsheet what should he do?
Alex needs the text in cell A1 to be angled at 90 degrees. Which alignment option should she select?
Conner notices the last two lines of text in cell B4 are not showing up in his spreadsheet. How could he format the cell to correct this problem?
You might also like...
Excel Lesson 6
1.06 - Formatting Cells and Ranges
Excel Lesson 6 Review
Other sets by this creator
Lesson 8-9 Test
Lesson 3-5 Excel Test
First Excel Test
P3- 7 Study guide