ITM 209 CH.1 Practice Quiz
Which of the following symbols display when a column is too narrow
####
Which of the following keyboard shortcuts opens the Format Cells dialog box?
Ctrl+1
Which of the following keyboard shortcuts opens a new blank workbook?
Ctrl+N
Which format should you use to save a file if you want it to be compatible with earlier versions of Microsoft Excel?
Excel 97-2003 file format (. xls),
In Excel, which of the following keys opens the Save As dialog box?
F12
Which of the following activates edit mode?
F2
The feature that resizes column width or row height to accommodate the width or height of the longest or tallest entry is called the AutoWiden feature.
False
Center the content in the selected cells horizontally.
Format Cells menu item. You clicked the Alignment tab. Inside the Format Cells dialog in the Horizontal drop-down, you selected Center.
Wrap the text in the selected cell
Home tab, alignment group, wrap text
Insert new sheet to the left
Home tab, cells group, insert button, insert sheet
Set row 1 to print on every page.
In the Page Layout Ribbon Tab in the Page Setup Ribbon Group, you clicked the Print Titles button. You clicked on the row 1 header.
Change the scaling option so all columns will print on one page
Page layout tab, scale to fit group, width, dropdown arrow, 1 page
Add an element to the center section of the header to display the current date.
Page layout view, click header, header and footer section, current time
Which of the following paste options copies all data and formulas from the source cell(s), but not the formatting?
Paste Formulas Formulas & Number Formatting
Spell Check a worksheet
Review, Spelling
Switch to Page Break Preview
View Tab, Page Break Preview
Arrange the Excel windows in a row next to each other.
View tab, arrange all, cascade
which of the following is not true when editing a function arguement
in edit mode, you can only make changes in the formula bar
Which of the following is not true about worksheets
sheet tab names cannot exceed 15 characters
