FREE COMPUTERS AND STUDY GAMES ABOUT EXCEL

PDF Download

FREE COMPUTERS AND STUDY GAMES ABOUT EXCEL

UNIT 2 EXAM QUESTIONS

Actual Qs and Ans Expert-Verified Explanation

This Exam contains:

-Guarantee passing score -38 Questions and Answers -format set of multiple-choice -Expert-Verified Explanation Question 1: When you draw a text box in a worksheet and then release the mouse button, this tab is active

Answer:

DRAWING TOOLS FORMAT

Question 2: To print all of the worksheets in a workbook, display the Print backstage area, click the first gallery in the Settings category, and then click this option at the drop-down list

Answer:

Print Entire Workbook Question 3: The Font option is available at the Symbol dialog box with this tab selected

Answer:

Symbols Question 4: This function finds the payment for a loan based on constant payments and a constant interest rate

Answer:

PMT

Question 5: To capture a portion of a screen, click the Screenshot button and then click this option at the drop-down list

Answer:

Screen Clipping

Question 6: By default, a workbook contains this number of worksheets

Answer:

one

Question 7: This button displays in the lower right corner of pasted cells

Answer:

Paste Options

Question 8: Click this button to insert a new worksheet in a workbook

Answer:

New sheet Question 9: To link a workbook to another workbook, click this button in the Link to section of the Insert Hyperlink dialog box

Answer:

Existing File or Web Page Question 10: At the Open dialog box, hold down this key while selecting nonadjacent workbooks

Answer:

Ctrl Question 11: The most recently opened workbook names display in this list, which displays when the Recent Workbooks option is selected at the Open backstage area

Answer:

Recent Workbooks

Question 12: Insert a shape in a chart and this tab is active

Answer:

DRAWING TOOLS FORMAT tab

Question 13: Size a chart by dragging one of these on the selected chart border

Answer:

sizing handle Question 14: Select a chart (not a chart element), click the Format Selection button in the Current Selection group on the CHART TOOLS FORMAT tab, and this task pane displays at the right side of the screen

Answer:

Format Chart Area Question 15: A style you create displays in this section of the Cell Styles button drop-down gallery

Answer:

Custom Question 16: Suppose cell B2 contains the total sales amountWrite a formula that inserts the word BONUS in cell C2 if the sales amount is greater than $49,999 and inserts the words NO BONUS if the sales amount is not greater than $49,999

Answer:

=IF(B2>49999,"BONUS","NO BONUS") Question 17: To select adjacent worksheet tabs, click the first tab, hold down this key, and then click the last tab

Answer:

Shift Question 18: To move an image, position the mouse pointer on the image border until the mouse pointer displays with this attached and then drag the image to the desired location

Answer:

four-headed arrow Question 19: To select nonadjacent worksheet tabs, click the first tab, hold down this key, and then click any other tabs you want selected

Answer:

Ctrl

Question 20: The Split button is located on this tab

Answer:

VIEW

Question 21: The Symbol button is located on this tab

Answer:

INSERT

Question 22: Copy styles from one workbook to another with options at this dialog box

Answer:

Merge Styles Question 23: Do this to a workbook name you want to remain at the top of the Recent Workbooks list at the Open backstage area

Answer:

pin it Question 24: This type of chart shows proportions and relationships of the parts to the whole

Answer:

pie Question 25: Display the Arrange Windows dialog box by clicking this button in the Window group on the VIEW tab

Answer:

Arrange All Question 26: Insert a picture, clip art image, screenshot, shape, or SmartArt graphic with buttons in this group on the INSERT tab

Answer:

Illustrations Question 27: Click this option at the Move Chart dialog box to move the chart to a separate sheet

Answer:

New sheet