Deck 50: Formatting Spreadsheets

Question 1

You can improve the look of a worksheet by aligning the contents of cells only; it is not necessary to add colors or borders because it is a distraction to readers.

Answer 1

False

Question 2

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

Answer 2

True

Question 3

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 3

A

Question 4

The general rule for formatting is to ____ column headings.

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

Question 5

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 6

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

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

Question 7

You specify a range of cells as an Excel table by applying a cell format such as bold to the selected cells.

Question 8

The general rule for formatting is to keep text ____.

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

Question 9

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

Question 10

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

Question 11

The TABLE TOOLS DESIGN tab is always visible when you are working in Excel.

Question 12

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

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

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 15

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

Question 16

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

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

Question 17

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

Question 18

Using the sort and filter tools in a large spreadsheet can simplify the data needed for decision making or problem solving.

Question 19

Format Painter is a good tool to use when you are formatting tables alphabetically.

Question 20

Excel aligns text along the left cell border by default.

Question 21

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 22

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 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

When an Excel table is activated,a new tab titled ____ appears.

A) EDIT
B) TABLE TOOLS DESIGN
C) DESIGN TABLE
D) OPTIONS...

Question 25

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 26

Using the Custom Sort feature,data can be rearranged by all of the following EXCEPT ____.

A) color
B) column
C) font
D) value length

Question 27

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 28

A range of cells assigned 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 29

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 30

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

A) Editing
B) Sorting
C) Filtering
D) Cells

Question 31

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

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

Question 32

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

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

Question 33

To enhance the visibility of data in a series of cells in order to signify a conditional change within a column,use ____ formatting.

A) Top/Bottom Rules
B) Data Bar
C) Bold
D) Data Validation