FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 7: Excel Module Formatting Workbook Text and Data

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 31

Multiple Choice

Review LaterAdd Note

Review Later

Case 2-2 Antoinette is part of a college department creating a number of student files with Microsoft Excel. She  is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. -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

Correct Answer

verified

Show Answer

Question 32

Short Answer

Review LaterAdd Note

Review Later

The ____________________ tab in the Format Cells dialog box in Excel provides options for creating and applying background colors and patterns to cells.

Correct Answer

verified

Show Answer

Question 33

Multiple Choice

Review LaterAdd Note

One of the benefits of Live Preview is that it _____.

Excel organizes fonts into theme and non-theme fonts.

Case 2-2 Antoinette is part of a college department creating a number of student files with Microsoft Excel. She  is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. -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 conditional format can make negative numbers red and positive numbers black.

You can open the Format Cells dialog box by right-clicking a cell or selected range, and then clicking _____ on the shortcut menu.

In the Format Cells dialog box, the _____ tab allows you to format currency by choosing decimal places, comma separators, and regular number displays.

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

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

The appearance of non-theme fonts, colors, and effects remains unchanged no matter which theme is applied to the workbook. 

A  conditional format applies formatting to a cell when its value meets a specified condition.

Italic, bold, bold italic, and underline are examples of _____.

Formatting changes only the appearance of data-it does not affect the data itself. 

Antoinette wants to be sure that her worksheet does not contain any duplicates. She will use the highlight cells rule _____ to check for this.

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

To remove conditional formatting in Excel, click ____________________ after clicking the Conditional Formatting button.

The header and footer sections include a _____.

By default, numbers appear in the _____ and generally display values exactly as you type them.

Case 2-2 Antoinette is part of a college department creating a number of student files with Microsoft Excel. She  is working on a student retention project and wants to produce a worksheet that can alert faculty of student progress and current grade status. -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.