Excel Final Module 2
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
a
put the following steps in order in which you would perform them to use the paste special function.
1,5,2,4,3
A ____ is the space between the page content and the edges of the page A) Margin B) Border C) Frame D) Ruler
A
As a general rule, you should ____. A) center column titles, left-align text, and right-align numbers
A
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
A
In Excel, dates are _____-aligned in the cell by default, regardless of date format. A) right B) left C) center D) top
A
In the formats cells dialog box, the ____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays. A) number B) font C) alignment D) fill
A
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
A
To add a _____ to a sheet tab, right-click a sheet tab, point to Tab Color on the shortcut menu, and then click a color. A) fill color B) tab setting C) format color D) formatting style
A
____ are an example of conditional formats in Excel. A) Data bars B) Quick Analysis Tool C) Font Sets D) Percentages
A
By default, numbers appear in the _____ and generally display values exactly as you type them. A) Home tab B) General format C) General number toolbar D) currency format
B
Each worksheet will contain a specific class with the students' grades for the entire term. In order to determine the current student grade, Antoinette would have to use the _____ function. a. SUM B. AVERAGE C. COUNT D. MEDICAN
B
In Excel, to merge cells A1, B1, C1, D1, and E1, ___ is the correct merge reference for the merged cell. A) A1!E1! B) A1 C) E1 D)A1-E1
B
Italic, bold, bold italic, and underline are examples of _____. A) font themes B) font styles C) graphics D) character settings
B
Options to rotate cells in Excel are available using the _____ button in the Alignment group on the Home tab. A) format B) orientation C) sorter D) allignment
B
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
B
In a workbook's theme, ____ colors are designated for text and background , ____ colors are used for accents and highlights, and ____ colors are used for hyperlinks. A) 4,2,6 B) 2,4,6 C) 4,6,2 D) 6,4,2
C
The Format Cells dialog box has six tabs, including _____. A) decimals B) security C) border D) shading
C
You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking _____ on the shortcut menu. A) format B) cells C) format cells D) cell style
C
____ merges each of the rows in the selected range across the columns in the range. A) Merge Build B) Merge and Center C) Merge Across D) Merge Cells
C
A footer appears at the top of each printed page. True or False
False
A(n) theme is a collection of formatting options that include a specified font, font size, font styles, font color, fill color, and borders. True or false
False
By default, Excel sets the page margins to 0.5 on the left and right margins and 0.75 on the top and bottom margins. True or False
False
Page Break Preview identifies manual page breaks with a dotted blue line and automatic page breaks with a solid blue line. True or False
False
Text and numbers are displayed vertically within cells True or False
False
The cell reference for the merged cell is the upper-right cell reference. True or False
False
A conditional format applies formatting to a cell when its value meets a specified condition. True or False
True
By default, Excel displays text in a black font color. True or False
True
Calculated values too large to fit into the cell are displayed in scientific notation. True or False
True
Changing the number of decimal places displayed in a cell doesn't change the value stored in the cell. True or False
True
Conditional formats are dynamic, so a cell's appearance will change to reflect its current value. "True or False
True
Each header and footer has three sections-a left section, a center section, and a right section. True or False
True
Excel organizes fonts into theme and non-theme fonts. True or False
True
Formatting changes only the appearance of data—it does not affect the data itself. A) True B) False
True
If you want to print only part of a worksheet, you can set a print area, which is the region of the worksheet that is sent to the printer. True or False
True
The background image does not affect any cell's format or content. True or False
True
The format painter doesn't copy formatting applied to selected text within a cell, and it doesn't copy data/ True or False
True
a conditional format can make negative numbers red and positive numbers black. True or False
True
the appearance of non-theme fonts, colors, and effects remain unchanged no matter which theme is applied to a workbook True or False
True
Harold has chosen green as the background color for his workbook. He should not use ______ for any of the font or highlight colors. a. red b. white c. black d. gray
a
Harold needs to format several cells with 11pt Calibri font, two decimal places, right-aligned, and a blue font color. The most efficient way to accomplish this would be to _____. a. use format painter b. format each element using the toolbar c. select all cells and use the formatting dialog box d. apply a table style
a
To set a page break in Excel, select the ________________. a. first cell below the row where you want to insert a page break b.first cell above the row where you want to insert a page break c. row above where you want to insert a page break d. row below where you want to insert a page break
a
fonts, colors , and cell styles are organized in ___ categories. a. them and non-theme b.numbers and text c. color and black and white d. form and function
a
A _____ indicates a manual page break. a. dashed blue line b. solid blue line c. dashed red line d. solid red line`
b
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
b
Because Antoinette is familiar with conditional formatting, she can use the _____, which provides access to the most common tools for data analysis and formatting. a.quick tool bar b. quick analysis tool c. quick formatting bar d. conditional analysis bar
b
Harold wants to print ranges E6:F12 and E16:F22 of his worksheet. These are referred to as _____ cell ranges. a. selective b. nonadjacent c. consecutive d. specific
b
Harold would like to center a title across the top of his data. His data runs across five columns, from 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:A5 c. type the date in C1 d. type the date in any column in row 1 and then choose Center from the Format menu
b
Header and footer elements such as worksheet name, current date, and time are _________ elements. a. descriptive b. dynamic c. impact d. required
b
Setting the _____ to A1:L10 will print only date in those cells. a. Page format b. Print Area C. Page Break d. Print Preview
b
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
b
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
b
the code ______ will display the filename of the current workbook. a. &name b.&[File] c. +name d. +[File]
b
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
c
Harold cannot increase the width of his worksheet because, if he does, he will not 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
c
The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is ___________. a. Alignment b. font c. Protection d. Security
c
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
c
In one of Harold's columns there are too many numbers after the decimal place. Harold doesn't 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 date 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
d
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 tile
d
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
d
The header and footer sections include a _______. a. left and right section b. center section only c. top and bottom section d. left,right, and center section
d
When creating an Excel document, you should avoid using ____ text and background together, since this is the most common form of color blindness.
red and green
