Question 1

Font ____________________ are typically applied to the entire contents of a cell.

Accepted Answer

The answer of Font ____________________ are typically applied to the...

Question 2

Excel gives you the ability to apply number formats to your values. Please describe the Accounting Number Format, Percent Style, and Comma Style formats and give an example of how a number would appear in each case.

Accepted Answer

The answer of Excel gives you the ability to apply...

Question 3

Each type of data has special ____________________ characteristics that help to identify its purpose.

Accepted Answer

The answer of Each type of data has special ____________________...

Question 4

You can quickly add simple borders using the Borders button in the ____________________ group on the HOME tab.

Accepted Answer

The answer of You can quickly add simple borders using...

Question 5

As you insert and delete rows and columns, Excel adjusts _____ cell references in formulas to keep them accurate.

Accepted Answer

The answer of As you insert and delete rows and...

Question 6

In general, you begin most modifications by _____ the chart element you want to change.

Accepted Answer

The answer of In general, you begin most modifications by...

Question 7

To quickly select all cells in a column, click the column _____ at the top of the column.

Accepted Answer

The answer of To quickly select all cells in a...

Question 8

A(n) _____ chart (sometimes called a column chart) is used to show comparisons.

Accepted Answer

The answer of A(n) _____ chart (sometimes called a column...

Question 9

Excel gives you the ability to chart or graph data in your worksheet. Describe the main chart types (line, pie, and bar) and their purpose. Also describe how to insert a chart in your worksheet.

Accepted Answer

The answer of Excel gives you the ability to chart...

Question 10

Excel automatically adjusts the height and width of selected cells when you use the ____________________ command.

Accepted Answer

The answer of Excel automatically adjusts the height and width...

Question 11

Case-Based Critical Thinking Questions Case 6-1 Gabe is learning how to add graphics to a worksheet. Kyra, who has more experience, answers several questions Gabe has. Gabe asks Kyra where he can find tools that will allow him to draw simple lines and shapes. She advises him to use the _____.

Accepted Answer

The Shapes tools can be found in the Illustrations group on the INSERT tab, which are specifically designed for drawing simple lines and shapes. Option B is incorrect as there are no Lines and Shapes tools in the Illustrations group on the HOME tab. Option C is incorrect as there are no Drawings group on the INSERT tab. Option D is incorrect as Vector Graphic tools are not specifically designed for drawing simple lines and shapes.

Question 12

Case-Based Critical Thinking Questions Case 6-1 Gabe is learning how to add graphics to a worksheet. Kyra, who has more experience, answers several questions Gabe has. Gabe asks Kyra how to insert clip art. She tells him to _____.

Accepted Answer

The answer of Case-Based Critical Thinking Questions Case 6-1 Gabe...

Question 13

Predefined _____ are built into the software, and include formats for displaying currency, percentages, and general numbers.

Accepted Answer

The answer of Predefined _____ are built into the software,...

Question 14

When you click the ____________________ Decimal button, one fewer digit is displayed after the decimal point.

Accepted Answer

The answer of When you click the ____________________ Decimal button,...

Question 15

Case-Based Critical Thinking Questions Case 6-1 Gabe is learning how to add graphics to a worksheet. Kyra, who has more experience, answers several questions Gabe has. Gabe asks Kyra how he can resize a graphic inserted into his worksheet. Kyra says he can _____.

Accepted Answer

The handles that appear on the edges of a selected graphic allow you to resize the graphic proportionally. Using the round handle at the top of the graphic will only resize it vertically, dragging the graphic will also only resize it proportionally, and using the Zoom option will only adjust the view of the worksheet, not the actual size of the graphic.

Quiz 6: Formatting a Worksheet