Exam 5: Working With Multiple Worksheets and Workbooks

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.

(True/False)

4.8/5

(34)

Question 21

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

(True/False)

4.7/5

(31)

Question 22

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

(True/False)

4.7/5

(36)

Question 23

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

(Multiple Choice)

4.9/5

(29)

Question 24

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

(Multiple Choice)

4.8/5

(43)

Question 25

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

(True/False)

4.8/5

(35)

Question 26

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

(True/False)

4.9/5

(34)

Question 27

Which worksheet view shows headers,footers,and rulers?

(Multiple Choice)

4.7/5

(41)

Question 28

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

(True/False)

4.8/5

(35)

Question 29

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

(True/False)

4.8/5

(37)

Question 30

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/False)

4.7/5

(37)

Question 31

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

(Multiple Choice)

4.9/5

(36)

Question 32

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

(Multiple Choice)

4.8/5

(38)

Question 33

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/False)

4.7/5

(29)

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?

(Multiple Choice)

4.9/5

(43)

Question 35

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

(Multiple Choice)

4.9/5

(44)

Question 36

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.

(True/False)

4.8/5

(34)

Question 37

Showing 21 - 37 of 37

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.

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

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

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

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

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

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

Which worksheet view shows headers,footers,and rulers?

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

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

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

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

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

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.

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?

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

Creating a Worksheet and a Chart

Formulas,functions,and Formatting

Working With Large Worksheets, charting, and What-If Analysis

Financial Functions, data Tables, and Amortization Schedules

Creating, sorting, and Querying a Table

Creating Templates, importing Data, and Working With Smartart, images, and Screenshots

Working With Trendlines, pivot Table Reports, pivotchart Reports, and Slicers

Formula Auditing, data Validation, and Complex Problem Solving

Data Analysis With Power Tools and Creating Macros

User Interfaces, visual Basic for Applications Vba, and Collaboration Features in Excel

Filters