Font size
WorksheetsUnit 7 - Formatting Cells and Ranges
Total questions: 10
Worksheet time: 10mins
Which of the following statements describes how to increase or decrease a column’s width?
Right-click anywhere in the column and select Format Cells.
Use the Page Setup dialog box.
Drag the boundary next to the column heading.
Select a Width setting in the Scale to Fit group on the Page Layout tab.
Which of the following dialog boxes is used to transpose rows and columns?
Page Setup
Paste Special
Column Width
Row Height
In which of the following locations are check boxes that you can select to view or print gridlines?
In Print Preview
On the Home tab, in the Cells group
On the Page Layout tab, in the Sheet Options group
On the Page Layout tab, in the Page Setup group
Which of the following statements describes how to unhide a hidden row or column?
Select a range of cells in the row or column, right-click, and select Unhide.
Use the Page Setup dialog box.
Remove all page breaks.
Select the rows/columns before and after the hidden rows/columns and then right-click and select Unhide.
The (a) is the line between rows or columns.
A(n) (a) is a line of text that appears at the top of each page of a printed worksheet.
(a) is the top-to-bottom measurement of a row, measured in points.
The identifying letter at the top of a column is called the (a) .
(a) refers to shrinking or stretching printed output to a percentage of its actual size.
A(n) (a) is a predefined set of colors, fonts, and effects that can be applied to an entire workbook.
