Deck 5: Working With Multiple Worksheets and Workbooks

Question 1

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

Answer 1

True

Question 2

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

A) MINUTE(G5)
B) =MINUTE(G5)
C) =MINUTE("10:00:56")
D) MINUTE("10:00:56")

Answer 2

B

Question 3

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

Answer 3

True

Question 4

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?

A) Date
B) Time
C) Number
D) Currency

Question 5

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?

A) Insert Column Chart
B) Insert Combo Chart
C) Insert Pie or Doughnut Chart
D) Insert Stock,Surface or Radar Chart

Question 6

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?

A) =DATEVALUE(1-Jan-2017)
B) =DATEVALUE(01/01/2017)
C) =DATEVALUE(1st Jan,2017)
D) =DATEVALUE(''01/01/2017'')

Question 7

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.

Question 8

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

Question 9

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

A) =DAY(A1)
B) =DAY("A1'')
C) =DATE(DAY(A1))
D) =DATE("DAY"(A1))

Question 10

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

Question 11

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.

Question 12

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

A) =DATE(1998,1,12)
B) =DATE(1998,12,1)
C) =DATE(12-1-1998)
D) =DATE(1/12/1998)

Question 13

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

A) =MONTH(F5)
B) =MONTH("F5")
C) =MONTH(DATE(2016,7,0))
D) =MONTH(DAY(2016,7,0))

Question 14

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.

Question 15

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

Question 16

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?

A) Special
B) Custom
C) Fraction
D) Percentage

Question 17

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

Question 18

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

A) HOUR(A1)
B) =HOUR(A1)
C) =HOUR("12:00:56")
D) HOUR("12:00:56")

Question 19

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) Effects
B) Text Options
C) Fill & Line
D) Legend Options

Question 20

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.

Question 21

Which worksheet view shows headers,footers,and rulers?

A) Normal view
B) Page Break Preview
C) Page Layout view
D) Formula view

Question 22

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.

Question 23

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

Question 24

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

A) relative cell reference
B) Auto Fill Options button
C) argument
D) mode indicator

Question 25

You can edit a worksheet footer in _____.

A) Page Layout view
B) Normal view
C) Page Break Preview
D) Print Preview

Question 26

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

A) Ctrl + Alt
B) Alt + Tab
C) Ctrl + Alt + Tab
D) Ctrl + Shift + Alt

Question 27

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

Question 28

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

A) Use a button on the Header and Footer Tools Design tab.
B) Type your name in the Header and Footer Elements group.
C) Type your name in the lower right cell of the worksheet.
D) Select the right footer text box and type your name.

Question 29

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

Question 30

What will you do to explode a pie chart slice?

A) Right-click the pie chart,click on Format Data Series,then enter a number in the percentage box.
B) Right-click the pie-chart,then click Change Series Chart Type,click Pie,and then click Pie of Pie.
C) Right-click the pie-chart,then click Change Series Chart Type,click Pie,and then click Bar of Pie.
D) Click the pie chart,then double-click the slice you want to explode,and drag it away from the center of the chart.

Question 31

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.

Question 32

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?

A) X- Margins,Y- Narrow
B) X- Margins,Y- Custom Margins
C) X- Orientation,Y- Landscape
D) X- Print Area,Y- Set Print Area

Question 33

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?

A) View tab > Window group > New Window
B) View tab > Window group > Arrange All
C) View tab > Window group > Reset Window Position
D) View tab > Window group > Switch Windows > Select a file

Question 34

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?

A) Label Options
B) Text Options
C) Chart Options
D) Series Options

Question 35

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

A) Drag its sheet tab to a new location.
B) Press and hold CTRL and drag its sheet tab to a new location.
C) Press and hold SHIFT and drag its sheet tab to a new location.
D) Press and hold ALT and drag its sheet tab to a new location.

Question 36

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

Question 37

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

A) a deleted worksheet
B) a worksheet with no calculations
C) a repositioned worksheet
D) a copy of another worksheet named Income