Exam 5: Working With Multiple Worksheets and Workbooks

A student is asked to find the difference between two values of time entered in cells A1 and B1,where A1 is the greater value and B1 the lesser value.In order to do so,he will type the formula =A1-B1 in an empty cell.

Sheila wants to extract the hour from the time,12:00:56,in cell A1.Which formula can she use to do this?

Igor wants to set margins for a worksheet he has created per his choice.Which of these will he select as X and Y in the series of clicks to do so: Page Layout tab > Page Setup > X > Margins drop-down list > Y > Specify choice for Top,Header,Left,Right,Bottom and Footer text boxes > OK?

Ian needs to extract the day from the date 5/31/2017 entered in cell A1.Which formula can he use to do this?

You can edit a worksheet footer in _____.

To round time 10:30 pm inserted in cell A4 to the nearest 30-minute interval,the formula: =MROUND(A4,0:30)can be used.

Which of the following methods copies an existing worksheet within the same workbook?

Ariana wants to view data from two workbooks at the same time so that one of them opens in a new window.What can she click to display one workbook in a new window?

Which of the following will you select as X in the given series of clicks to insert a 3-D pie chart: Insert > Charts group > X > 3-D Pie?

Which of these combination of keys will you press to switch between two workbook windows?

To insert information that appears at the bottom of every worksheet page,you can use a command on the Insert tab.

Which formula can be applied for the given data in a cell A2: 01/01/2017 to get the serial number of the date as text?

Marianna wants to add a border to a legend.Which of the following should she select as X in the following series of clicks to do so?

A student inserts the formula =TIMEVALUE("10:30 AM")in a cell.On pressing ENTER,it will return the value 10:30.

To extract the seconds from the time entered in cell B1 as 12:00:52 PM,type =SECOND(B1)in cell C1 and press ENTER.

To enter your name in the lower right corner of a worksheet page,you can _____.

What will you do to explode a pie chart slice?

Which of the following will you select as X in the following series of clicks to create a number format code in a chart: Home tab > Number Format > More Number Formats > Format Cells Dialog Box > Category Box > X > Type list > Type Box > Number format you want to customize > Make changes in it?

Kamala enters a date as the start date in cell E2 and a list of holidays in cells F2:F5.Now she wants to add 30 workdays to the start date.She can do this using the following formula: = WORKDAY (E2,30,F2:F5).

George wants to apply the time number format to time entered in a cell as '11:30'.Which of the following options,when chosen as X,will help him to do? Ctrl+1 < Category < X < Type < 13:30?