Excel Module 2, Chapter 6

One of the benefits of Live Preview is that it _____. a. lets you see and evaluate different formats as you develop your workbook b. shows you what a document will look like when printed c. applies thematic styles to your document d. allows you to track changes in your document

Because Excel stores dates and times as _____, you can apply different formats without affecting the date and time value. a. numbers b. text c. universal numbers d. Greenwich Mean Time

In Excel, dates are _____-aligned in the cell by default, regardless of date format. a. right b. left c. center d. top

As a general rule, you should _____. a. center column titles, left-align text, and right-align numbers b. center column titles, right-align text, and left-align numbers c. right-align column titles, left-align text, and right-align numbers d. left-align column titles, left-align text, and right-align numbers

In Excel, to merge cells A1,B1,C1,D1, and E1, _____ is the correct reference for the merged cell. a. A1!E1! b. A1 c. E1 d. A1-E1

When using the Format Painter, double-click the Format Painter button to paste the same format multiple times and click the Format Painter again to _____. a. turn it on b. turn it off c. copy formatting d. paste formatting

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format ______. a. Master b. Gallery c. Palette d. Painter

Setting the ______ to A1:L10 will print data in those cells. a. Page Format b. Print Area c. Page Break d. Print Preview

To avoid splitting a worksheet in awkward places, you can insert a _____ to specify a specific breaking point. a. page insert b. manual page break c. print area d. selection

Information that prints on each page, like a company name or logo, may be set as a ____. a. print setup b. copied text c. text header d. print title

The code ____ will display the filename of the current workbook. a. &name b. &[File] c. +name d. +[File]

The header and the footer sections include a ____. a. left and right section b. center section only c. top and bottom section d. left, right, and center section

The ______ command searches through the current worksheet or workbook for the content or formatting you want to locate. a. Seek b. Find c. Locate d. Search

Antoinette wants all her worksheets to have the same formatting for text, colors, and graphical effects applied to create a specific look and feel. Antoinette needs to apply a _______. a. theme b. template c. style d. font

Antoinette's workbook has all the data entered and students' current grades displayed. She would like the current grade cells to display the value in red if it is less than 60. Antoinette needs to add ______ to the cell. a. cell formatting b. conditional formatting c. highlighting d. fill color

When Antoinette shares her worksheet with other colleagues, she wants to ensure that everyone knows why certain cells are highlighted. To accomplish this, she will create a _______. a. journal b. documentation sheet c. legend d. formula sheet

Antoinette wants to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule ____ to check for this. a. Equal to b. Between c. Duplicate Values d. A Date Occurring

In one of Harold's columns there are too many numbers after the decimal place. Harold does not need this level of detail. It is distracting from the data and he really only needs two numbers after the decimal. How could Harold make the data appear cleaner in the most efficient way? a. re-enter all numbers and only enter two decimal places. b. decrease the column width c. decrease the font size d. use the Number group to decrease number of digits displayed

Harold cannot increase the width of his worksheet because, if he does, he will be able to print it on one sheet. However, his columns are truncating his content. What solution would be the best for Harold to use to make all his text visible without losing data? a. abbreviate all text b. change the font style c. choose Wrap text for the columns d. delete one column

Harold would like to center a title across the top of his data. His data runs across five columns, form column A to column E. One way he could accomplish this is to ____. a. type the data in A1 and Merge cells A1:A5 b. type the data in A1 and Merge cells A1:E1 c. type the data in C1 d. type the data in any column in row 1 and then choose Center from the Format menu