Question 1

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?

Accepted Answer

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 2

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

Accepted Answer

A) True 
 B)False

Question 3

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?

Accepted Answer

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 4

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?

Accepted Answer

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(B2

Question 5

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?

Accepted Answer

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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?

Accepted Answer

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

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

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 11

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.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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 17

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?

Accepted Answer

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

Question 18

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.

Accepted Answer

A) True 
 B)False

Question 19

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?

Accepted Answer

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 20

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.

Accepted Answer

A) True 
 B)False

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.