Excel Chapter 2 MC

Question 1

____ theme colors are designated for text and background, ____ colors are used for accents and highlights, and ____ colors are used for hyperlinks.

Answer 1

Four, six, two

Question 2

You can create a ____ color by specifying a mixture of red, blue, and green color values.

Answer 2

custom

Question 3

To add a ____ to a sheet tab, click the Format button, point to Tab color, and then click a color.

Answer 3

fill color

Question 4

Selecting the Font Color button arrow will display ____.

Answer 4

10 theme colors A standard color bar A ScreenTip displaying the color name

Question 5

The ____ appears when you select text and contains buttons for commonly used text formats.

Answer 5

Mini toolbar

Question 6

When creating an Excel document, you should avoid using ____ text and background together, since this is the most common form of color blindness.

Answer 6

red and green

Question 7

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

Answer 7

General number format

Question 8

Which of the following can you format using the Number group in Excel’s home tab?

Answer 8

Currency formats Numbers to percentages Commas as a thousands separator

Question 9

Using date and time in Excel, you can ____.

Answer 9

Calculate date and time intervals Format a date or time value

Question 10

Dates and times in Excel measure intervals between the specified date and time and ____.

Answer 10

January 1, 1900 at 12:00am

Question 11

In Excel, dates are ____-aligned in the cell by default, regardless of date format.

Answer 11

right

Question 12

As a general rule, you should ____.

Answer 12

center column titles, left-align text, and right-align numbers

Question 13

____ merges each of the rows in the selected range across the columns in the range.

Answer 13

Merge Across

Question 14

In Excel, to merge cells A1, B1, C1, D1, and E1, ____ is the correct reference for the merged cell.

Answer 14

A1:E1

Question 15

Options to rotate cells in Excel are available using the ____ button in the Alignment group on the Home tab.

Answer 15

Orientation

Question 16

You can add a border in Excel ____.

Answer 16

To enhance readability To the top, right, or bottom of a cell And specify the thickness

Question 17

All of the following options are available on the Format Cells dialog box except ____.

Answer 17

size

Question 18

The Paste Options button allows you to ____.

Answer 18

Keep source formatting Copy formatting only, Copy values only

Question 19

In the Paste Special dialog box, you can ____

Answer 19

Select to rotate selected range 90 degrees Paste only values Paste values and formats

Question 20

You can treat a range of data as a distinct object in a worksheet known as a(n) ____.

Answer 20

Excel table

Question 21

A(n) ____ specifies formats for elements in an Excel table, such as font color, fill color, and so forth.

Answer 21

table style

Question 22

The most efficient way to format an entire table is to ____.

Answer 22

use a table style

Question 23

Applying a table style marks the range as a table, making available tools designed for analyzing tabular data, including ____.

Answer 23

The ability to sort data Transferring data to and from an external file Filtering data to show only rows that match specified criteria

Question 24

In Excel, the table style ____ inserts a new row at the bottom of the table that adds the column values.

Answer 24

Total Row

Question 25

In Excel, the ____ table style formats alternating columns in different colors.

Answer 25

Banded Columns

Question 26

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

Answer 26

font sets

Question 27

A ____ is a horizontal bar added to the background of a cell to provide a visual indicator of a cell’s value.

Answer 27

data bar

Question 28

Data bar ____ is based on a cell’s value.

Answer 28

length

Question 29

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

Answer 29

A Date Occurring

Question 30

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

Answer 30

hide columns without information you need