Excel Module 01

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

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

=IF(B2<60, "F",IF(B2<70,"D",IF(B2<80,"C"IF(B2<90,"B","A"))))

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

=IF(B2>=60, "Pass". "Fail")

In the formula =B6*$B$2, what describes $B$2?

Absolute cell reference

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

Analysis

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

Automatic page breaks appear as dashed lines while manual page breaks appear as solid lines.

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

CTRL

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

Centered Overlay

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

Click on the View tab in the Ribbon, then click the Split button in the Window group.

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

Column

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

Copy a cell's format to more than one cell

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

Data Callout

What is true about intersecting cells in a worksheet?

Excel automatically adjusts cell references to reflect new formula locations.

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

False

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

False

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

False

To move cell contents one space to the right, you can use the Increase Space button.

False

To paste a copied cell range, you only need to specify the upper right of the range where you want to paste it.

False

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

False

To see how copied contents will look with both values and number formatting, you would use Paste Numbers.

False

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

False

When you copy cells contents, the data is removed from its original location and placed on the Clipboard.

False

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

False

To copy cell's formatting to another cell, what can you use?

Format Painter

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?

If it needs an absolute cell reference.

What is true about changing worksheet column width?

In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column.

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

It may disturb roe or column alignment which can effect worksheet accuracy.

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

Number

The Clipboard task pane shows the contents of the __________

Office Clipboard

To rotate cell contents to an exact value you change its ________

Orientation

To what chart types can you not add axis titles?

Pie chart

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

Row 4 > View tab > Windows group > Freeze Panes > Freeze Panes

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

Select the column to the right of the oage break you want to delete.

What is true when you copy and paste formulas using the fill handle?

The AutoFill Options button lets you fill cells with specific elements of the copied cell.

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

The Paste Options button then lets you paste specific elements of the copied cells.

What is not a way to move cell contents?

The fill handle in the lower-right corner of an active cell or range

What is true about deleting a worksheet row?

To delete a row, you can select the row, then use the Delete button in the Cells group.

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

To paste the value's number formatting only.

A student 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 Sparking group and then select OK.

True

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.

True

Jack wants to insert in 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 Sparkline group and then click OK.

True

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

True

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.

True

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

True

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

True

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

True

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

True

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

True

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

True

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

True

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

True

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

True

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

True

arrow keys can be used to move any chart element.

True

How can you remove data labels from a chart?

Uncheck the box beside Data Labels in Chart Elements.

Sala wants to unfreeze the fist column of his worksheet. what series of clicks will help him do so?

View tab > Windows group > Freeze Panes > Unfreeze Panes

What is true when you delete a cell?

When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells.

Helga wants to reset page breaks in a worksheet to display only automatic page breaks. What 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?

X- Page Break Preview, Y- Breaks

What is true about moving cell contents?

You can move cells using the drag-and-drop feature.

To delete a worksheet column you can first select it by ________

clicking the column heading

You need to add another product to your inventory worksheet, which shows product names in row A. What should you add?

column

To change the name of a worksheet, you rename the _______

sheet tab

After you delete a worksheet column, __________

the columns to its right shift left