Question 1

To set a page break in Excel,____.
A) select the first cell below the row where you want to insert a page break
B) select the first cell above the row where you want to insert a page break
C) select the row above where you want to insert a page break
D) select the row below where you want to insert a page break

Accepted Answer

Select the first cell below the row where you want to insert a page break.

Question 2

All of the following are conditional formats in Excel except ____.
A) data bars
B) highlighting
C) font sets
D) icon sets

Accepted Answer

Data bars, Highlighting, and Icon sets are all examples of conditional formatting in Excel, while font sets are not. Font sets refer to a pre-defined set of font styles and sizes that can be applied to text in Excel, but they are not used for conditional formatting.

Question 3

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

Accepted Answer

A solid blue line indicates a manual page break in Microsoft Word.

Question 4

Fonts,colors,and cell styles are organized in ____ categories.
A) theme and non-theme
B) numbers and text
C) color and black & white
D) form and function

Accepted Answer

Fonts, colors, and cell styles are organized in theme and non-theme categories in Microsoft Excel. Theme categories contain coordinated fonts, colors, and effects that give a professional and polished look to a spreadsheet. Non-theme categories contain individual options that can be customized as per the user's preference.

Question 5

Karl cannot increase the width of his worksheet or he will not be able to print it on one sheet.However,his columns are truncating his content.What solution could Karl use for making his text visible without losing data?
A) abbreviate all text
B) reduce the font size to 8 pt
C) click Wrap text
D) delete one column

Accepted Answer

Clicking on "Wrap Text" in the "Alignment" section of the Home tab will allow the text to be displayed on multiple lines within the cell without truncating it. This will make the text visible without having to increase the width of the worksheet or delete a column.

Question 6

To view certain columns on a large database,a good option is to ____.
A) hide columns without information you need
B) delete columns you aren't viewing
C) highlight columns you want to view
D) use data bars to find content

Accepted Answer

Hiding the columns without the information needed can make it easier to view the relevant columns, without deleting them or highlighting them unnecessarily. This can also help in avoiding confusion and clutter on the screen. Using data bars to find content may not be as effective when dealing with a large database.

Question 7

The header and footer sections include ____.
A) a left and right section
B) a center section only
C) a top and bottom section
D) a left,right,and center section

Accepted Answer

The header and footer sections typically include a left, right, and center section to allow for flexible placement of content such as page numbers, dates, or titles.

Question 8

Information that prints on each page,like a company name or logo,may be set as a(n)____.
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 9

In Page Layout view,the worksheet is displayed as it will appear on the ____.
A) printed page
B) screen
C) Web page
D) all of the above

Accepted Answer

In Page Layout view, the worksheet is displayed as it will appear on the printed page. While it may also be viewed on the screen or as a web page, the primary purpose of this view is for print layout and formatting.

Question 10

To remove banded rows from an Excel table,first you need to select the ____ tab on the Ribbon.
A) Insert
B) Home
C) Design
D) Page

Accepted Answer

The Design tab on the Ribbon contains formatting options specific to tables in Excel, including the option to remove banded rows.

Question 11

In column C,there are too many numbers after the decimal place.Karl does not need this level of detail as it is distracting from the data,and you really don't need more than two numbers after the decimal.How could Karl make the data appear cleaner?
A) reenter all numbers
B) decrease column width
C) decrease font size
D) use Number group to decrease number of digits displayed

Accepted Answer

Using the Number group to decrease the number of digits displayed is the most efficient solution. This can be done by selecting the column, clicking the Home tab, and choosing the Decrease Decimal button in the Number group. This will round the numbers to the nearest hundredth and make the data appear cleaner without having to reenter or adjust the column width or font size.

Question 12

When preparing to print,you have the option to select ____.
A) the position of the report on the page
B) the orientation of the page
C) to include headers or footers
D) all of the above

Accepted Answer

All of the above options are available when preparing to print. It is important to consider the position of the report on the page, the orientation of the page (landscape or portrait), and whether to include headers or footers to ensure that the printed document looks as intended.

Question 13

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

Accepted Answer

The answer of One way to ensure that you are...

Question 14

Case Based Critical-Thinking Questions
Case 2-1
Karl has been working on a field survey project where he has gathered data from across five cities in the last six months.Karl has a lot of data to report and needs help organizing his data sheet for an effective presentation.
-Karl has chosen green as the background color for his workbook.Karl should not use ____ for any of the font or highlight colors.
A) red
B) white
C) black
D) any color is fine

Accepted Answer

Red is not recommended as it can be difficult to read against a green background due to low contrast.

Question 15

To avoid splitting a worksheet in awkward places,you can insert a(n)____ to specify a specific breaking point.
A) page break
B) manual page break
C) print area
D) selection

Accepted Answer

A manual page break allows you to insert a specific breaking point within the worksheet, rather than relying on Excel's automatic page breaks which can sometimes split cells or data in awkward places.

Question 16

In conditional formatting,to highlight only cells that contain a specific date,select the rule____.
A) A Date Occurring
B) Duplicate Values
C) Text That Contains
D) Between

Accepted Answer

The rule "A Date Occurring" allows you to highlight cells that contain a specific date. This rule allows you to select the date format you want to highlight, such as a specific day of the week or a specific month. The other rules listed do not specifically target cells containing a specific date.

Question 17

-In the figure above,you can see that the following table elements were selected: Header Row and ____.
A) Total Row
B) Banded Columns
C) First Column
D) Last Column

Accepted Answer

The answer of 
-In the figure above,you can see that...

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

The Print Area in Excel allows you to specify a specific range of cells to be printed. By setting the print area to A1:L10, only data in those cells will be printed. Options A, C, and D are not relevant to specifying a specific range of cells to be printed.

Question 19

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

Accepted Answer

The syntax &[File] will display the filename of the current workbook.

Question 20

A ____ is the space between the page content and the edges of the page
A) margin
B) border
C) frame
D) ruler

Accepted Answer

The space between the page content and the edges of the page is called the margin. This is often used to create a visual buffer between the content and the edge of the page, making it easier to read and more visually appealing. Borders, frames, and rulers are all different elements that are used for different purposes and are not the same as the margin.

Quiz 2: Formatting a Workbook

To set a page break in Excel,____.

All of the following are conditional formats in Excel except ____.

A ____ indicates a manual page break.

Fonts,colors,and cell styles are organized in ____ categories.

Karl cannot increase the width of his worksheet or he will not be able to print it on one sheet.However,his columns are truncating his content.What solution could Karl use for making his text visible without losing data?

To view certain columns on a large database,a good option is to ____.

The header and footer sections include ____.

Information that prints on each page,like a company name or logo,may be set as a(n) ____.

In Page Layout view,the worksheet is displayed as it will appear on the ____.

To remove banded rows from an Excel table,first you need to select the ____ tab on the Ribbon.

In column C,there are too many numbers after the decimal place.Karl does not need this level of detail as it is distracting from the data,and you really don't need more than two numbers after the decimal.How could Karl make the data appear cleaner?

When preparing to print,you have the option to select ____.

One way to ensure that you are using consistent formats is to copy and paste your formats using the Format ____.

To avoid splitting a worksheet in awkward places,you can insert a(n) ____ to specify a specific breaking point.

In conditional formatting,to highlight only cells that contain a specific date,select the rule____.

-In the figure above,you can see that the following table elements were selected: Header Row and ____.

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

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

A ____ is the space between the page content and the edges of the page