Deck 2: Formatting Workbook Text and Data

Question 1

To combine multiple cells into one combined cell,which of the following do you use?

A) Column Width command
B) Center button
C) Merge and Center button
D) Increase Indent button

Answer 1

C

Question 2

To change a range's conditional formatting from data bars to icon sets,which of the following can you do?

A) Delete the conditional formatting rule.
B) Edit the conditional formatting rule.
C) Format the range in the Font dialog box.
D) Format the range as a table.

Answer 2

B

Question 3

To change the color of cell content,you use the ________ color list arrow.

A) Cell
B) Text
C) Pattern
D) Font

Answer 3

D

Question 4

Currency is an example of a number format.

Question 5

To help you easily identify sheets in a workbook,you can add _____ to the sheet tab.

A) Alignment
B) Fonts
C) Color
D) Styles

Question 6

To apply a cell style,you would use the Cell Styles command on the _____ tab.

A) Layout
B) Insert
C) View
D) Home

Question 7

How can you distinguish between a manually added page break and an automatic page break in a worksheet?

A) Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines.
B) Automatic page breaks appear as curved lines while manual page breaks appear as jagged lines.
C) Automatic page breaks appear as dashed lines while manual page breaks appear as wavy lines.
D) Automatic page breaks appear as zigzag lines while manual page breaks appear as solid lines.

Question 8

Which of the following lets you apply bold formatting to a selected cell? Select all the options that apply.

A) Home tab
B) Format Cells dialog box
C) Insert tab
D) Mini toolbar

Question 9

Clicking the Percentage style in the Number Format list applies _____ decimal places by default.

A) one
B) two
C) three
D) four

Question 10

To return cell contents to its default font and style,you can use the _____ command.

A) Clear Formats
B) Clear Contents
C) Clear All
D) Clear Comments

Question 11

When you underline cell content,you are using _____.

A) a font style
B) an orientation setting
C) an indent setting
D) a centering style

Question 12

You can apply date formats to cells by using the Date category in the Format Cells dialog box.

Question 13

Which of the following are ways to align cell contents in relation to cell edges? Select all the options that apply.

A) left
B) center
C) bold
D) underline

Question 14

Steffie wants to change the margins of a worksheet to Normal to align it better on a printed page.To do this,what can she do after selecting the worksheet for this purpose?

A) Click Margins in the Page Setup group on the Page Layout tab and then click on Normal.
B) Set Width and Height to Automatic and Scale to 100% in the Scale to Fit group on the Page Layout tab.
C) Click Orientation and then select from the drop down menu in the Page Setup group on the Page Layout tab.
D) Check the boxes beside Gridlines View Point and Headings View Point in the Sheet Options group on the Page Layout tab.

Question 15

To remove conditional formatting from a selected range,you can select the rule in the Conditional Formatting Rules Manager dialog box,then click the Delete Rule button.

Question 16

A _______ refers to a collection of characters with a similar,specific design.

A) symbol
B) font
C) point
D) keyword

Question 17

The Comma Style format adds a comma and a dollar sign to a cell value.

Question 18

To align currency symbols and decimal points in a column of numbers,you can apply the ____ number format.

A) Currency
B) Accounting
C) Percentage
D) General

Question 19

To format a range so that all values greater than $500 appear in red,which of the following can you use?

A) conditional formatting
B) cell formatting
C) cell styles
D) Quick Access toolbar

Question 20

Jim frequently prints out the same section of a worksheet.To do so,he selects the cells he wants to define as print area,then clicks Print Area and then clicks Set Print Area on the Page Layout tab in the Scale to Fit group.

Question 21

Eleanor wants a title row to be printed at the top of every sheet when she prints her data in an MS Excel file.What will she do in step X in the following series of clicks/tasks to do so: Page Layout tab > Print Titles > Page Setup Dialog box > X > OK?

A) Click on the select button in Rows to repeat at top area and select a title row.
B) Click on the select button in Columns to repeat at left area and select a title row.
C) Click the check box before Row and column headings under Print.
D) Click the check box before Gridlines under Print.

Question 22

When you change cell contents to italics,you are changing the cell's alignment.

Question 23

To copy a cell's formatting to another cell,which of the following can you use?

A) Format Cells dialog box
B) Format Painter
C) Quick Analysis Tool
D) Format as Table

Question 24

Which of the following will you select as X in the series of clicks to highlight the top 10 items in a range of cells: (Select)Range of cells > Home tab > Styles group > Conditional formatting > X > Top 10 items > Change value and highlight option in dialog box if required > OK?

A) Icon Sets
B) Color Scales
C) Top/Bottom Rules
D) Highlight Cells Rules

Question 25

To insert information that appears at the bottom of every worksheet page,you can use a command on the Insert tab.

Question 26

To enter your name in the lower right corner of a worksheet page,you can _____.

A) Use a button on the Header and Footer Tools Design tab.
B) Type your name in the Header and Footer Elements group.
C) Type your name in the lower right cell of the worksheet.
D) Select the right footer text box and type your name.

Question 27

You double-click the Format Painter button when you want to _____.

A) copy a cell's format to more than one cell
B) copy a cell's format to only one cell
C) use conditional formatting
D) clear a cell's formatting

Question 28

Which of these will you do in step X in the series of clicks/ selections to delete a vertical page break: View tab > Workbook View > Page Break Preview > X > Page layout tab > Page Setup > Breaks > Remove Page Break?

A) Select the column to the left of the page break you want to delete.
B) Select the column to the right of the page break you want to delete.
C) Select the row above the page break you want to delete.
D) Select the row below the page break you want to delete.

Question 29

Amari wants to paint the format of one object onto a target object.She selects the first object,then clicks on Format Painter,on the Clipboard group in the Home tab.She then observes the cursor change to a specific icon.Which of the following is the icon into which the cursor changed?

A) Hand
B) Blackbox
C) Paintbrush
D) Underscore

Question 30

Helga wants to reset page breaks in a worksheet to display only automatic page breaks.Which of these can she select as X and Y in the series of clicks to do so: Worksheet > View tab > Workbook Views group > X > Page Layout tab > Page Setup group > Y > Reset All Page Breaks?

A) X- Normal,Y- Print Area
B) X- Page Layout,Y- Print Tiles
C) X- Page Break Preview,Y- Breaks
D) X- Custom Views,Y- Background

Question 31

To paste copied cell contents with values only,not including formatting,which of the following can you use?

A) Paste Preview
B) Paste option icon
C) Paste list arrow
D) Paste button

Question 32

Igor wants to set margins for a worksheet he has created per his choice.Which of these will he select as X and Y in the series of clicks to do so: Page Layout tab > Page Setup > X > Margins drop-down list > Y > Specify choice for Top,Header,Left,Right,Bottom and Footer text boxes > OK?

A) X- Margins,Y- Narrow
B) X- Margins,Y- Custom Margins
C) X- Orientation,Y- Landscape
D) X- Print Area,Y- Set Print Area

Question 33

To format a cell range so that values between 100 and 500 appear in red,which of the following can you use?

A) icon sets
B) themes
C) Top/Bottom Rules
D) Highlight Cells Rules

Question 34

You can edit a worksheet footer in _____.

A) Page Layout view
B) Normal view
C) Page Break Preview
D) Print Preview

Question 35

To rotate cell contents to an exact value,you change its _____.

A) Font
B) Width
C) Indent
D) Orientation

Question 36

The Clipboard task pane shows the contents of the _____.

A) Office Clipboard
B) Table Styles gallery
C) Quick Analysis tool
D) Recently-Used Add-Ins

Question 37

Decreasing a cell's indent moves its contents to the right one space.

Question 38

You can repeatedly paste an item from the Office Clipboard as many times as you like.

Question 39

Clicking the Increase Decimal button in the Number group would change the displayed cell value 14.54 to 14.5.

Question 40

You can create conditional cell formats using either the Home tab or the _____.

A) Quick Analysis tool
B) Cell Styles dialog box
C) Font formatting buttons on the Home tab
D) Number formatting buttons on the Home tab

Question 41

From how many theme options can you choose to change the theme of a Power View report?

A) 12
B) 20
C) 39
D) 56

Question 42

Musa wants to choose a standard color theme for an Excel worksheet he is working on.He clicks on the Page Layout tab and then clicks Colors.What should he do next to complete the procedure?

A) Pick the color set he wants.
B) Enter numbers on the Custom tab.
C) Select More Colors,and then pick a color on the Standard tab.
D) Under Customize Colors,click the button next to the theme color he wants to change and then pick a color under Theme Colors.

Question 43

Which of the following should be selected as X in the series of clicks to save a custom theme: X > Themes group > Themes > Custom > Document theme you want to use?

A) Insert
B) Developer
C) Formulas
D) Page Layout

Question 44

To format the cell value 44.54 as 44.540,you can use the Increase Decimal button.

Question 45

To choose a standard theme color,click on the Insert tab,click Colors,then pick the color set you want.

Question 46

To paste a data range so that column data appears in rows and row data appears in columns,you can _____ the data using the Paste list arrow.

A) reverse
B) transpose
C) fill
D) merge

Question 47

To change the background colors in a Power View report,click the POWERVIEW tab > Themes group > Background > Select a color.

Question 48

On which tab and button are document properties located for editing?

A) File tab,Info Button
B) View tab,Show button
C) Review tab,Changes button
D) Home tab,Alignment button

Question 49

To change theme effects,click on Effects on the Page Layout tab,then select the set of effects that you want to use.

Question 50

Sven wants to create a custom theme font set for the heading and body of a presentation.Under tab X,he selects Fonts,and then selects Create New Theme Fonts.Then he selects a heading font,a body font,types in a name for his theme font set and clicks Save.Which of the following can tab X be in the above-mentioned procedure?

A) Insert
B) Design
C) Review
D) Developer

Question 51

To apply formats to data when it meets criteria you specify,you can use conditional formatting.

Question 52

To rotate cell contents,you use the Alignment tab in the Format Cells dialog box.

Question 53

To load the Analysis ToolPak and select Anova: Single Factor for statistical analysis in Excel,one should click on the following series: File tab > Options > Add-Ins category > Manage box > Excel Add-ins > Go .select Analysis ToolPak option on the appearing dialog box > OK > Data > Analysis > Data Analysis dialog box > Anova: Single Factor > OK.

Question 54

You want to change all worksheet occurrences of "Radio" to "TV"; to do this,you can use the _____ feature.

A) Find and Replace
B) Locate and Replace
C) Edit and Find
D) Find and Edit

Question 55

For use as watermark,Alba wants to insert a picture as a worksheet background.For this,she clicks the worksheet she wants to display with a background,then selects an option X from the Page Layout tab in the Page Setup group.Alba then selects the picture for use as background,and then clicks Insert.What can X in her series of selections be?

A) Breaks
B) Margins
C) Orientation
D) Background

Question 56

To paste only a copied cell's formats,use the Paste Special command.

Question 57

To create your own theme color,click on Page Layout,then Colors,then Customize Colors,then click the button next to the theme color you want to change,and finally pick a color under Theme Colors.

Question 58

Betty wants to choose the list to create a custom number format.To do so,what should she choose after the following series of clicks? Home tab < Number group < Number Format list < More Number Formats < Format Cells dialog box < Category < Custom

A) Type
B) Symbol
C) Locale
D) Decimal places