Indicate whether the statement is true or false. 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.

Indicate whether the statement is true or false. 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.

Indicate whether the statement is true or false. To move a worksheet, you can drag its sheet tab to the left or right.

Indicate whether the statement is true or false. 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.

Indicate whether the statement is true or false. To paste only a copied cell's formats, use the Paste Special command.

Indicate whether the statement is true or false. 7. Jose inserts the formula '=DATE('2000, 2, 2)' in cell AI5. Upon pressing ENTER, 2/2/2000 will appear in AI5.

Indicate whether the statement is true or false. 8. You can repeatedly paste an item from the Office Clipboard as many times as you like.

Indicate whether the statement is true or false. Arrow keys can be used to move any chart element.

Indicate whether the statement is true or false. 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.

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

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

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.

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.

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.

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

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

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

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

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

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

The Clipboard task pane shows the contents of the _____.

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

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?

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?

After you delete a worksheet column, _____.

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

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

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?

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?

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?

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?

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?

Which of the following is true about moving cell contents?

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?

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

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?

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?

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

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

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?

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?

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

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?

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

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?

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

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

What is another name for the collection of worksheets that make up the entire spreadsheet

Indicate whether the statement is true or false. To format the cell value 44.54 as 44.540, you can use the Increase Decimal button.

Which of the following is a valid formula to calculate the sum of cells A1 through A10?

Which symbol is used to start a formula in Excel?

What symbol is used to start a formula in Excel?

Mia is creating a worksheet tracking her company’s spending on a project. However, when viewing her document, she has noticed that some of the cells contain pound signs like in the example below.


Which of the following suggestions would help Mia?

How can you make a cell's color change based on the cell's value?

What do you call the blank boxes on the spreadsheet?

A program using a table comprising of rows, columns and cells

When inserting a formula, always start with

Address of the current cell is contained in

What is a Worksheet in Microsoft Excel?

A Workbook in Microsoft Excel is:

What are View Buttons in Microsoft Excel?

What is the Title Bar in Microsoft Excel?

A Row in Microsoft Excel is defined as:

The Formula Bar in Microsoft Excel is used for:

What is a Cell Address in Microsoft Excel?

A group of selected cells is called the

In Excel, Column is denoted by ___________

?

This is the name of the cell in the worksheet that is currently selected.