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

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?

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

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?

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?

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 check your workbook for features that assist people with disabilities,you can use the Ability Checker.

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

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?

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

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

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.

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

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.

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

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.

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

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?

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.

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?

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.