Deck 3: Working With Large Worksheets, charting, and What-If Analysis

Question 1

Bertie wants to show data labels inside a text bubble shape.Which option can she click on after clicking on the arrow next to Data labels under Chart Elements?

A) Best Fit
B) Inside End
C) Outside End
D) Data Callout

Answer 1

D

Question 2

Bart needs to apply a sparkline style to a sparkline chart.To do so,he can click on the following: Sparkline chart > Design > Style (choose a style).

Answer 2

False

Question 3

Which of the following will you select as X in the following series of clicks to change the chart layout for lines or bars that you want to change: Chart > Chart Tools > Layout tab > X > Layout option for any lines or bars that you want to add or change?

A) Axes
B) Labels
C) Analysis
D) Background

Answer 3

C

Question 4

Jose inserts the formula '=DATE('2000,2,2)' in cell AI5.Upon pressing ENTER,2/2/2000 will appear in AI5.

Question 5

To which of the following chart types can you not add axis titles?

A) Pie chart
B) Line chart
C) Area chart
D) Column chart

Question 6

To edit placeholder text in a chart element,select the cell whose placeholder text you want to edit,on Ribbon,click Data > Data Validation > Data Validation > Input Message tab and edit the text in the box.

Question 7

Arrow keys can be used to move any chart element.

Question 8

Which of the following should you select as X in the following series of clicks to change the chart type to a clustered column chart: Chart > Chart Tools > Design tab > Type group > Change Chart Type > All Charts > X > Clustered Column > OK?

A) Pie
B) Bar
C) Line
D) Column

Question 9

Which of the following will you select as X in the following series of clicks to lay the title over a chart: Chart Title box > Plus (+)sign > Arrow next to Chart title > X?

A) Above Chart
B) Over Chart
C) Below Chart
D) Centered Overlay

Question 10

To insert the current date in cell B1,type CURRENT DATE in cell A1 and NOW()in cell B1 and press ENTER.

Question 11

Michelle finished a 5 kilometer run in 180th position.The organizers shared an Excel spreadsheet with names of all the participants and the time they took to complete the race.The top 15 finishers are listed in rows 2 to 16.Michelle wants to compare her time against theirs.How can she do so?

A) Select row 17 and click View tab > Window group > Split.
B) Select rows 2 to 16 and click View tab > Window group > Split.
C) Select rows 2 to 16 and click View tab > Window group > New Window > Split.
D) Select row 16 and click View tab > Window group > Split > Arrange All.

Question 12

Jack wants to insert a Win/Loss sparkline in Excel.To do this,he can click on the cell he wants to insert a Sparkline in,then click Apps tab,select Win/Loss Sparkline from the Sparklines group and then click OK.

Question 13

The score of five students in a subject are inserted in row B from B2 to B6 cells and the grades for the scores are: A: 90 to 100,B: 80 to 89,C: 70 to 79,D: 60 to 69,and F: 0 to 59.Which of the following functions can you insert in the D2 cell so that it returns the grade for each score in row B?

A) =IF(B2<60,"F",IF(B2<70,"D",IF(B2<80,"C",IF(B2<90,"B","A"))))
B) =IF(B2<59,"F",IF(B2<69,"D",IF(B2<79,"C",IF(B2<89,"B","A"))))
C) =IF(B2D) =IF(B2=0-59,"F",IF(B2=60-69,"D",IF(B2=70-79,"C",IF(B2=80-89,"B",IF(B2=90-100,"A"))))

Question 14

Penina wants to insert markers into a sparkline chart.To do so,she can click on the following: Sparkline chart > Design > Line > Markers check box.

Question 15

How can you remove data labels from a chart?

A) Uncheck the box beside Data Labels in Chart Elements.
B) Click on Remove on the options on the right side of Data Labels.
C) Click on Delete on the options on the right side of Data Labels.
D) Click to select the Data labels,then click on Edit and then Delete.

Question 16

Which of the following will you select as X in the following series of clicks/entries to change the number format of a chart axis: (Double-click)Value Axis labels > Format Axis > Axis Options > X > Select choice in Category box?

A) Labels
B) Number
C) Tick Marks
D) Text Options

Question 17

Niki wants to insert a Line sparkline in Excel.To do this,she can click on the cell she wants to insert a Sparkline,then click Insert tab,select Line Sparkline from the Sparklines group and then OK.

Question 18

Nathan wants TRUE to be elicited if either of the statements are true,and FALSE if both are true.Which of the following formula can he use to ensure that?

A) =IFNA(...)
B) =XOR(...)
C) =IFERROR(...)
D) =TRUE OR FALSE(...)

Question 19

To show formulas instead of values,click on the Formulas tab in the ribbon,then in the Formula Auditing group,click on the Show Formulas option.

Question 20

The score of students in a subject is inserted in B2 cell and the passing score for the subject is 60.Which of these functions will you insert in C2 cell to check if the student has passed or failed?

A) =IF(B2>=60,"Pass","Fail")
B) =OR(B2>=60,"Pass","Fail")
C) =AND(B2>=60,"Pass","Fail")
D) =NOT(OR((B2>=60,"Pass","Fail"))

Question 21

Nisha wants to freeze all rows above row 4 in a worksheet she is working on to keep them visible while scrolling through the rest of the worksheet.Which of the following series of clicks will help her do so?

A) Row 4 > View tab > Windows group > Freeze Panes > Freeze Panes
B) Row 4 > View tab > Windows group > Freeze Panes > Freeze Top Row
C) Row 3 > View tab > Windows group > Freeze Panes > Freeze Top Row > Arrange All
D) Row 3 > View tab > Windows group > Freeze Panes > Freeze First Column > View Side by Side

Question 22

When you paste formula cells using the Paste button in the Clipboard group,which of the following is true?

A) The Paste Options button then lets you paste specific elements of the copied cells.
B) The formula is copied with cell references you must adjust to avoid worksheet errors.
C) The Auto Fill Options button appears.
D) Pointing to the destination cell causes a preview of the cell contents to appear.

Question 23

A students wants to insert a column sparkline in Excel.To do this,she can click on the cell she wants to insert a Sparkline,then click Insert tab,select the Sparkline type of choice from the Sparklines group and then select OK.

Question 24

Ursula wants to freeze the header row so that it remains visible while she scrolls down the worksheet.To do so,she can click the View tab and then click Freeze Top Row.

Question 25

Which of the following is not a way to move cell contents?

A) the Cut and Paste buttons on the Home tab
B) the fill handle in the lower-right corner of an active cell or range
C) the CTRL key + the Move pointer
D) drag-and-drop

Question 26

Which of the following is true when you delete a cell?

A) When you delete cells using the Delete list arrow,you can choose which way to move adjacent cells.
B) Row and column alignment will not be affected.
C) You need to manually adjust cell references in surrounding formulas.
D) You can use the Delete command on the Insert tab.

Question 27

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

Question 28

Dean wants to insert five blank rows above a row.To do so,he can select the heading of the row above which he wants to insert the additional rows,hold Ctrl key,click the selected rows,and then click Insert on the pop-up menu.

Question 29

How can you remove Split panes in a worksheet you are working on?

A) Click the View tab in the Ribbon,then click the Split button in the Window group.
B) Click the Page Layout tab in the Ribbon,then click the Bring Forward button in the Arrange group.
C) Click the View tab in the Ribbon,then click the Split button and then the Hide button in the Window group.
D) Click the Page layout tab in the Ribbon,then click the Insert Breaks button and choose from the drop down menu in the Page Setup group.

Question 30

Which of the following is true about moving cell contents?

A) You can move cells using the Copy command.
B) You cannot move cells from one worksheet to another.
C) When you move cell contents,they remain in their original location.
D) You can move cells using the drag-and-drop feature.

Question 31

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

A) To erase the cell value from the clipboard.
B) To paste the value's number formatting only.
C) To paste all items on the clipboard.
D) To compute the results of a function.

Question 32

To preserve an exact cell address in a copied formula,you can use a relative cell reference.

Question 33

Your worksheet contains a price in cell A5,and many formulas refer to that price.How would you refer to that price in the formulas?

A) A5
B) $A$5
C) $A5
D) A$5

Question 34

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 35

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 36

Sala wants to unfreeze the first column of his worksheet.Which of the following series of clicks will help him do so?

A) View tab > Windows group > Freeze Panes > Unfreeze Panes
B) View tab > Windows group > Freeze Panes > Freeze Top Column > Arrange All
C) View tab > Windows group > Freeze Panes > Unfreeze Panes> Arrange All
D) View tab > Windows group > Freeze Panes > Freeze First Column > Unfreeze Panes

Question 37

Which of the following is true about inserting cells in a worksheet?

A) Excel automatically adjusts cell references to reflect new formula locations.
B) You need to adjust cell references in all formulas that have moved.
C) You cannot insert cells in a worksheet.
D) Cells below the inserted cells are always moved downward.

Question 38

Which of the following is true when you copy and paste formulas using the fill handle?

A) The Paste Options button lets you paste only specific elements of the copied selection.
B) The AutoFill Options button lets you fill cells with specific elements of the copied cell.
C) The formula is placed on the Office clipboard.
D) You need to change the cell references to reflect the new formula location.

Question 39

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 40

Why is it necessary to use care when inserting worksheet cells?

A) It might automatically change the functions you are using.
B) It can change relative references to absolute references in formulas.
C) You will have to manually correct cell references in formulas.
D) It may disturb row or column alignment,which can affect worksheet accuracy.

Question 41

After you delete a worksheet column,_____.

A) the columns to its right shift left
B) the columns to its left shift right
C) the row remains but its contents are deleted
D) only its formats are deleted

Question 42

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 43

To check your workbook for features that assist people with disabilities,you can use the Ability Checker.

Question 44

To make your workbooks usable by people with disabilities,you can add alternative text to worksheet images.

Question 45

You need to add another product to your inventory worksheet,which shows product names in row
A)Which of the following should you add?

A) a row
B) a column
C) a button
D) conditional formatting

Question 46

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 47

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

Question 48

You've copied a cell containing formula to the rows below it,and the results in the copied cells are all zeros.To find the problem,what should you check for in your original formula?

A) If it needs an absolute cell reference.
B) If it needs a relative cell reference.
C) If it needs landscape orientation.
D) If it needs a function.

Question 49

Which of the following is true about deleting a worksheet row?

A) After you delete a row,the rows below it shift down one row.
B) To delete a row,you can select the row,then press the DELETE key on the keyboard.
C) To delete a row,you can select the row,then use the Delete button in the Cells group.
D) If you select a row and click the Delete list arrow,you can select Delete Sheet to delete the row.

Question 50

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

Question 51

When you select a cell range,the cells must be adjacent to each other.

Question 52

Which of the following is true about changing worksheet column width?

A) In Normal view,the Column Width dialog box lets you set column width to an exact value in inches.
B) In Normal view,the Column Width dialog box lets you set the exact number of characters that will fit in the column.
C) When you drag the right column border in Normal view,a ScreenTip displays the exact width in inches.
D) When you drag the right column border in Page Layout view,a ScreenTip displays the exact width in pixels.

Question 53

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

Question 54

To move a worksheet,you can drag its sheet tab to the left or right.

Question 55

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

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

Question 56

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

Question 57

When you insert a worksheet row,a row is inserted above the cell pointer and the sheet contents move downward.

Question 58

In the formula =B6*$B$2,which of the following describes $B$2?

A) Relative cell reference
B) Absolute cell reference
C) Function
D) Average

Question 59

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 60

To delete a worksheet column,you can first select it by _____.

A) clicking the column heading
B) double-clicking the column heading
C) clicking anywhere in the column
D) double-clicking anywhere in the column

Question 61

Arlo wants to use goal seek to answer "what if" questions in a file.To do this,he clicks the cell in the spreadsheet that he wants to change,then selects the "X" button from the Data tab and selects Goal seek...from the drop down menu.What is X in the procedure?

A) What-if Analysis
B) Data Validation
C) Consolidate
D) Relationships

Question 62

To change the name of a worksheet,you rename the _____.

A) sheet columns
B) sheet rows
C) sheet header
D) sheet tab

Question 63

To select nonadjacent cells or ranges on a worksheet,you can press and hold _____ while selecting each one.

A) CTRL
B) ALT
C) SHIFT
D) ESC

Question 64

There is a limit of 35 changing cells in the Edit Scenario dialog box whose values can be modified in the Scenario Values dialog box.