Question 1

Header and footer elements such as worksheet name,current date,and time are _____ elements.
A)descriptive
B)dynamic
C)impact
D)required

Accepted Answer

Header and footer elements such as worksheet name, current date, and time are dynamic elements as they change based on the content or formatting of the worksheet. They are not necessarily required for the functionality of the worksheet, but they can enhance the user experience and provide helpful information.

Question 2

The code _____ will display the filename of the current workbook.
A)&name
B)&[File]
C)+name
D)+[File]

Accepted Answer

The correct syntax for displaying the filename of the current workbook is &[File]. Therefore, the correct choice is B.

Question 3

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

Accepted Answer

Conditional formatting allows the user to apply formatting to cells based on specified conditions, such as if the value is less than 60. This will result in the current grade cells displaying the value in red if it meets the specified condition.

Question 4

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: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

Accepted Answer

To center a title across the top of the data, the best option is to type the data in the first cell (A1) and merge the cells across the entire row (A1:E1) to create a single cell that spans all columns. This way, the title will be centered perfectly across the top of all the columns of data.

Question 5

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

Accepted Answer

The answer of To set a page break in Excel,select...

Question 6

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

Accepted Answer

The answer of Antoinette wants all her worksheets to have...

Question 7

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

Accepted Answer

The "Find" command is used to search for content or formatting within a worksheet or a workbook. The other options (Seek, Locate, and Search) are not valid Excel commands.

Question 8

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

Accepted Answer

A manual page break allows you to specify exactly where you want to split the worksheet into separate pages, instead of relying on automatic page breaks which can sometimes split the worksheet in awkward places.

Question 9

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

Accepted Answer

A legend is a key or guide that explains the meaning of certain symbols or colors used on a chart, map or diagram. In this case, Antoinette wants to explain why certain cells are highlighted, so she would create a legend to accompany the worksheet so that her colleagues can understand the reason behind the highlighting.

Question 10

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)MEDIAN

Accepted Answer

The AVERAGE function would be the best choice as it calculates the average of a range of numbers, which is exactly what is needed to determine the current student grade. The SUM function adds up a range of numbers and the COUNT function counts the number of cells containing numbers, but neither of these functions provide the average needed for finding the current grade. The MEDIAN function finds the middle value of a range of numbers, which is not necessary for determining the current student grade.

Question 11

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

Accepted Answer

Using the Number group to decrease the number of digits displayed would be the most efficient way to clean up the data. This allows Harold to keep the original data without having to re-enter it and also saves time compared to changing the column width or font size.

Question 12

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

Accepted Answer

Using the Format Painter will allow Harold to quickly apply the formatting from one cell to multiple other cells without having to manually format each one individually or using the Formatting dialog box.

Question 13

A _____ indicates a manual page break.
A)dashed blue line
B)solid blue line
C)dashed red line
D)solid red line

Accepted Answer

In Microsoft Word, a solid blue line represents a manual page break.

Question 14

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

Accepted Answer

The answer of Harold has chosen green as the background...

Question 15

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

Accepted Answer

The cell ranges E6:F12 and E16:F22 are not adjacent to each other, meaning they are separated by at least one column or row. Therefore, they are referred to as nonadjacent cell ranges.

Question 16

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

Accepted Answer

The Protection tab in the Format Cells dialog box provides options for locking or hiding cells to prevent other users from modifying their contents. The Alignment and Font tabs deal with formatting options while the Security tab is not a part of the Format Cells dialog box.

Question 17

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

Accepted Answer

The answer of Information that prints on each page,like a...

Question 18

Setting the _____ to A1:L10 will print only data in those cells.
A)Page Format
B)Print Area
C)Page Break
D)Print Preview

Accepted Answer

Setting the Print Area to A1:L10 will ensure that only data within those cell ranges will be printed, and nothing outside of it. The other options (Page Format, Page Break, and Print Preview) are not relevant to this particular task of limiting the printed data to a specific range.

Question 19

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

Accepted Answer

The answer of The header and footer sections include a...

Question 20

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

Accepted Answer

Choosing the Wrap text option for the columns will allow Harold to display all the content within the current width of the worksheet, without having to abbreviate any text or delete a column. This will ensure that no data is lost and everything is visible to the viewer. Changing the font style may not necessarily make all the content visible, and abbreviating text or deleting a column could result in data loss.

Quiz 8: Formatting Workbook Text and Data

Header and footer elements such as worksheet name,current date,and time are _____ elements.

The code _____ will display the filename of the current workbook.

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.

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 _____.

To set a page break in Excel,select the _____.

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 _____.

The _____ command searches through the current worksheet or workbook for the content or formatting you want to locate.

To avoid splitting a worksheet in awkward places,you can insert a _____ to specify a specific breaking point.

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 _____.

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.

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?

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 _____ indicates a manual page break.

Harold has chosen green as the background color for his workbook.He should not use _____ for any of the font or highlight colors.

Harold wants to print ranges E6:F12 and E16:F22 of his worksheet.These are referred to as _____ cell ranges.

The Format Cells dialog box tab that provides options for locking or hiding cells to prevent other users from modifying their contents is _____.

Information that prints on each page,like a company name or logo,may be set as a _____.

Setting the _____ to A1:L10 will print only data in those cells.

The header and footer sections include a _____.

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?