Excel Module 05

Which of the following appears in Page Layout view?

- Text box containing the header - Margins - Page number indicator

What will you do to explode a pie chart slice?

Click the pie chart, then double-click the slice you want to explode, and drag it away from the center of the chart.

The formula =ROUNDDOWN(G5,0) can be used to round the number 46.734, entered in cell G5, to the nearest whole number.

True

The formula =ROUNDUP(G5,0) can be used to round up 59.425, entered in cell G5, to 0.

True

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.

True

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

True

To move a chart to a different worksheet, click on the Chart > Chart Tools > Design tab > Location group > Move Chart > New sheet, and then in the New sheet box, type a name for the worksheet.

True

To move a chart to another location on the sane worksheet, drag it to the location you want.

True

To save a workbook for the first time, you use the Save As dialog box.

True

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

Alt + Tab

Which of the following lets you fill a cell with only specific elements of a copied cell?

Auto Fill Options button

Which worksheet view shows headers, footers, and rulers?

Page Layout view

You can edit a worksheet footer in _____.

Page Layout view

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

Press and hold CTRL and drag its sheet tab to a new location.

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

Select the right footer text box and type your name.

To ungroup worksheets after grouping them and working on them simultaneously, right-click any worksheet tab in the group and click Ungroup Sheets.

True

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?

View tab > Window group > New Window

What is the correct formula to insert the date January 12, 1998 into a cell?

=DATE(1998,1,12)

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?

=DATEVALUE(''01/01/2017'')

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

=DAY(A1)

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

=HOUR(A1)

Which of the following formulas can you use to extract the minute from the time in cell G5: 10:00:56?

=MINUTE(G5)

Which formula can you use to extract the month from the date in cell F5: 2016 July 8th?

=MONTH(DATE(2016,7,0))

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?

Custom

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

False

A student types the formula '= YEAR( TODAY())-2005' to calculate the age of a person born in 2005. This formula will use the TODAY function as an argument for the YEAR function to obtain the current year, and then subtract 2005 returning the person's age.

False

Miley wants to perform calculations on four worksheets with identical structures at the same time. So, in order to group them and perform the task faster, she can press the Ctrl + Alt key and click the worksheet tabs she wants to group and then modify either of the worksheets for automatic change in the other one.

False

Stuart inserts the formula '=YEAR ('23-Aug-2012)' into cell B12. When he presses ENTER, 23/08/2012 will appear in B12.

False

To add a worksheet to a workbook, you would use the New formula tab below the worksheet.

False

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.

False

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?

Fill & Line

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?

Insert Pie or Doughnut Chart

Which of the following will you select as X in the following series of clicks/entries to change the number format of data labels in a chart: (Double-click) Data labels > Format Data Labels > X > Number > Select choice in Category Box?

Label Options

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

True

Rohan wants to create a column containing dates and want to display days beside each date in the next column. He can use the formula '=CHOOSE(WEEKDAY(B5),"Mon", "Tue", "Wed", "Thur", "Fri", "Sat")'.

True

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?

Time

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.

True

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?

X- Margins, Y- Custom Margins

A worksheet named Income (2) is most likely which of the following?

a copy of another worksheet named Income