Exam 2: Formatting a Workbook

It is not good practice to include descriptive information,such as the company name,logo,and worksheet title on each page of a printout in case a page gets into the wrong hands.

(True/False)

4.9/5

(75)

Question 41

After you merge a range into a single cell,you cannot realign its content.

(True/False)

4.9/5

(87)

Question 42

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

(Multiple Choice)

4.8/5

(76)

Question 43

MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell

(Multiple Choice)

4.9/5

(71)

Question 44

Calculated values too large to fit into the cell are displayed in scientific notation._________________________

(True/False)

4.8/5

(72)

Question 45

Karl needs to format several cells with 11pt Calibri font with 2 decimals,right-align the text,and format font color to blue.The most efficient way to accomplish this would be to ____.

(Multiple Choice)

4.9/5

(71)

Question 46

To filter data in an Excel table,use filter blocks in the header row._________________________

(True/False)

4.8/5

(67)

Question 47

A print area can cover an adjacent or nonadjacent range._________________________

(True/False)

4.9/5

(83)

Question 48

Selecting the Font Color button arrow will display ____.

(Multiple Choice)

4.9/5

(81)

Question 49

-In the above figure,the preset button labeled ____ removes all borders.

(Multiple Choice)

4.9/5

(83)

Question 50

MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell

(Multiple Choice)

4.8/5

(86)

Question 51

Because Excel stores dates and times as ____,you can apply different formats without affecting the date and time value.

(Multiple Choice)

4.9/5

(78)

Question 52

Explain why it is important to use proper formatting,citing at least three benefits of a well-formatted workbook.

(Essay)

4.8/5

(69)

Question 53

Ajeesh has copied his data set to a new spreadsheet where he wants to draw attention to data that received above a 75% approval rating.To highlight these numbers,Ajeesh could apply ____.

(Multiple Choice)

5.0/5

(86)

Question 54

To change the font size one point at a time,in the Font group on the Home tab,click the ____ button.

(Multiple Choice)

4.8/5

(85)

Question 55

Font sizes are measured in points,where one is approximately 1/72 of an inch._________________________

(True/False)

4.8/5

(87)

Question 56

Excel uses themes to maintain a consistent look within a workbook._________________________

(True/False)

4.9/5

(70)

Question 57

Although dates and times in Excel appear as text,they are actually numbers._________________________

(True/False)

4.9/5

(79)

Question 58

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

(Multiple Choice)

4.8/5

(80)

Question 59

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

(Multiple Choice)

5.0/5

(77)

Question 60

Showing 41 - 60 of 150

It is not good practice to include descriptive information,such as the company name,logo,and worksheet title on each page of a printout in case a page gets into the wrong hands.

After you merge a range into a single cell,you cannot realign its content.

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

MATCHING Match each of the following icons with the description that most closely matches its function. -Rotates the cell content to any angle within the cell

Calculated values too large to fit into the cell are displayed in scientific notation._________________________

Karl needs to format several cells with 11pt Calibri font with 2 decimals,right-align the text,and format font color to blue.The most efficient way to accomplish this would be to ____.

To filter data in an Excel table,use filter blocks in the header row._________________________

A print area can cover an adjacent or nonadjacent range._________________________

Selecting the Font Color button arrow will display ____.

-In the above figure,the preset button labeled ____ removes all borders.

MATCHING Match each of the following icons with the description that most closely matches its function. -Horizontally centers the cell content within the cell

Because Excel stores dates and times as ____,you can apply different formats without affecting the date and time value.

Explain why it is important to use proper formatting,citing at least three benefits of a well-formatted workbook.

Ajeesh has copied his data set to a new spreadsheet where he wants to draw attention to data that received above a 75% approval rating.To highlight these numbers,Ajeesh could apply ____.

To change the font size one point at a time,in the Font group on the Home tab,click the ____ button.

Font sizes are measured in points,where one is approximately 1/72 of an inch._________________________

Excel uses themes to maintain a consistent look within a workbook._________________________

Although dates and times in Excel appear as text,they are actually numbers._________________________

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

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

Getting Started With Excel

Working With Formulas and Functions

Enhancing a Workbook With Charts and Graphs

Working With Excel Tables, Pivot-tables, and Pivot-charts

Managing Multiple Worksheets and Workbooks

Using Advanced Functions and Conditional Formatting

Developing an Excel Application

Working With Financial Tools and Functions

Performing What-If Analyses

Connecting to External Data

Expanding Excel With Visual Basic for Applications

Managing Your Files

Getting Started With Microsoft Office 2010

Filters