Deck 97: Formatting Spreadsheets

Question 1

The Number Format box includes two formats that contain dollar signs: ____.

A) Accounting and Currency
B) Accounting and Dollar
C) Currency and Dollar
D) Currency and Number

Answer 1

A

Question 2

By default,numbers entered in cells display in the General format type.

Answer 2

True

Question 3

You specify a range of cells as an Excel table by applying a cell format.

Answer 3

False

Question 4

When a cell is formatted in Currency,a zero value will display as ____.

A) #DIV/0!
B) $0.00
C) 0
D) $ -

Question 5

When a cell is formatted in Accounting,a zero value will display as ____.

A) #DIV/0!
B) $0.00
C) 0
D) $ -

Question 6

Excel aligns text along the left cell border by default.

Question 7

A cell contains the value .065,and you click the Percent Style button.What value displays in the cell?

A) 65%
B) .065%
C) 6.5%
D) .065/12

Question 8

In the Table Styles group,the gallery of table styles is divided into two sections: Light and Dark.

Question 9

Selected spreadsheet cells can be sorted by the values in more than one column.

Question 10

Functionality to add a border to a cell is found in the Font group on the Home tab.

Question 11

To center a heading over four cells,in the Paragraph group,click the Merge button.

Question 12

Using Conditional Formatting,text in a range of cells can be formatted to display a certain color depending on the function in the cell.

Question 13

Applying the Comma format to a cell displays the ____.

A) Currency format without dollar signs
B) Accounting format without dollar signs
C) Accounting format with dollar signs
D) Currency format with dollar signs

Question 14

In Excel,filtering a column's data means that you temporarily exclude data from screen visibility.

Question 15

When the "My list has headers" check box is not selected,Excel excludes column headings when it sorts data.

Question 16

When the Currency format type is applied to a cell,numbers display with a dollar sign and three decimals.

Question 17

Number formatting options are found on the Home tab on the Ribbon.

Question 18

You improve the look of a worksheet by aligning the contents of cells,but adding borders and colors is a distraction to viewers.

Question 19

A border can be applied to a cell or to a range of cells.

Question 20

You can merge three cells together to create one bordered cell.

Question 21

The ____ group on the Home tab contains the buttons you use to format text in cells.

A) Paragraph
B) Styles
C) Format
D) Alignment

Question 22

When you want a cell's background to contain color,click the ____________________ button in the Font group on the Home tab.

Question 23

Excel's gallery of table styles is divided into three sections: ____.

A) Business,Education,and Personal
B) Short,Medium,and Long
C) Light,Medium,and Dark
D) Header,Body,and Totals

Question 24

The general rule for formatting is to ____ column headings.

A) center
B) left-align
C) right-align
D) justify

Question 25

Excel aligns numbers along the ____________________ cell border by default.

Question 26

To display a cell's entire contents,click the ____________________ button in the Alignment group on the Home tab.

Question 27

Conditional formatting is used to ____ that are usually difficult to visualize when viewing a spreadsheet.

A) define data names
B) format table heading rows
C) highlight data trends
D) filter data results

Question 28

When you apply a(n)____________________ format to selected cells,filter arrows appear so you can manipulate what displays on the screen.

Question 29

A range of cells designated as a(n)____ can be analyzed and treated as separate from the rest of the Excel worksheet.

A) filtered group
B) defined name
C) function
D) Excel table

Question 30

You can draw attention to a range of cells by adding a(n)____________________ to its edges.

Question 31

In Excel,the Conditional Formatting option is located in the ____ group on the Home tab.

A) Cells
B) Format
C) Alignment
D) Edit

Question 32

The general rule for formatting is to keep text ____.

A) centered
B) left-aligned
C) right-aligned
D) justified

Question 33

When you click the Center button,a cell's contents are ____ centered within its cell borders.

A) vertically
B) left
C) horizontally
D) right

Question 34

Tools for filtering data are in the Data tab's ____ group.

A) Sort & Filter
B) Sorting
C) Filtering
D) Cells

Question 35

When you want a cell's contents,which consist of the total amount of wages paid this pay period,to stand out in a spreadsheet,you should apply a ____ border.

A) four-sided
B) bottom
C) two-sided
D) top

Question 36

When you apply the Currency format type,the ____________________ symbol is displayed in the cell.

Question 37

A cell's border can be displayed in ____.

A) only blue,black,or red
B) any color
C) only black
D) only black or red

Question 38

The general rule for formatting is to keep numbers ____,with decimal places aligned.

A) centered
B) left-aligned
C) right-aligned
D) justified

Question 39

____________________ data makes it easier to read large sets of data.

Question 40

To display headings in the middle of the cell rather than at the bottom,click the Align Text ____ button on the Home tab.

A) Top
B) Middle
C) Center
D) Relative

Question 41

The ____________________ can be used to copy a cell's color shading from one cell to another to ensure consistency between related cells.