Question 1

To print a worksheet, you begin by going to Backstage view.

Accepted Answer

A) True 
 B)False

Question 2

To select a single worksheet cell so you can work with it, which of the following would you do?

Accepted Answer

A)  Click the cell. 
B)  Move the cell pointer over the cell. 
C)  Click the status bar. 
D)  Click the Name box. 
A)  Click the cell. 
B)  Move the cell pointer over the cell. 
C)  Click the status bar. 
D)  Click the Name box.

Question 3

Which of the following is true about adding cell borders?

Accepted Answer

A)  You cannot apply borders to all worksheet cells. 
B)  A cell border underlines the cell text, not the entire cell. 
C)  A cell border extends the width of the cell. 
D)  You can only apply a border to the bottom of a cell. 
A)  You cannot apply borders to all worksheet cells. 
B)  A cell border underlines the cell text, not the entire cell. 
C)  A cell border extends the width of the cell. 
D)  You can only apply a border to the bottom of a cell.

Question 4

Which of the following will you select as X in the following series of clicks to convert a table to range: Table > Table Tools > Design > X > Convert to Range?

Accepted Answer

A)  Tools group 
B)  Themes group 
C)  Page Setup group 
D)  Background group 
A)  Tools group 
B)  Themes group 
C)  Page Setup group 
D)  Background group

Question 5

Rukha has created two custom views of a worksheet. In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden. What can she do to be able to see the view that she needs to at a given point in time?

Accepted Answer

A)  Click Custom Views and double-click on the display settings she wants to see. 
B)  Under Windows group on the View tab, click on View Side by Side. 
C)  Under Windows group on the View tab, click on Switch Windows and select the View she wants. 
D)  Click Custom View and check the box beside Hidden rows, column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden. 
A)  Click Custom Views and double-click on the display settings she wants to see. 
B)  Under Windows group on the View tab, click on View Side by Side. 
C)  Under Windows group on the View tab, click on Switch Windows and select the View she wants. 
D)  Click Custom View and check the box beside Hidden rows, column and filter settings to see Custom view of all rows and columns shown while uncheck the box to see the Custom view of specific rows and columns hidden.

Question 6

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

Accepted Answer

A)  To erase the cell value from the clipboard. 
B)  To paste the value's number formatting only. 
C)  To paste all items on the clipboard. 
D)  To compute the results of a function. 
A)  To erase the cell value from the clipboard. 
B)  To paste the value's number formatting only. 
C)  To paste all items on the clipboard. 
D)  To compute the results of a function.

Question 7

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

Accepted Answer

A) The Specific People B) The People with Existing Access C) The Co-workers in . D) The People in . A) The Specific People B) The People with Existing Access C) The Co-workers in . D) The People in .

Question 8

To print more than one copy of your worksheet, which tab would you go to?

Accepted Answer

A)  View 
B)  Page Layout 
C)  Insert 
D)  File 
A)  View 
B)  Page Layout 
C)  Insert 
D)  File

Question 9

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

Accepted Answer

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

Question 10

Which of the following is true about deleting a worksheet row?

Accepted Answer

A)  After you delete a row, the rows below it shift down one row. 
B)  To delete a row, you can select the row, then press the DELETE key on the keyboard. 
C)  To delete a row, you can select the row, then use the Delete button in the Cells group. 
D)  If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row. 
A)  After you delete a row, the rows below it shift down one row. 
B)  To delete a row, you can select the row, then press the DELETE key on the keyboard. 
C)  To delete a row, you can select the row, then use the Delete button in the Cells group. 
D)  If you select a row and click the Delete list arrow, you can select Delete Sheet to delete the row.

Question 11

To create a new, blank workbook, which of the following can you use?

Accepted Answer

A)  The Open command in Backstage view. 
B)  The New command in Backstage view. 
C)  The New command on the File tab. 
D)  The Open command on the File tab. 
A)  The Open command in Backstage view. 
B)  The New command in Backstage view. 
C)  The New command on the File tab. 
D)  The Open command on the File tab.

Question 12

You can use the I-beam pointer to copy cell contents into adjacent cells.

Accepted Answer

A) True 
 B)False

Question 13

To delete a worksheet column, you can first select it by _____.

Accepted Answer

A)  clicking the column heading 
B)  double-clicking the column heading 
C)  clicking anywhere in the column 
D)  double-clicking anywhere in the column 
A)  clicking the column heading 
B)  double-clicking the column heading 
C)  clicking anywhere in the column 
D)  double-clicking anywhere in the column

Question 14

Dean wants to insert five blank rows above a row. To do so, he can select the heading of the row above which he wants to insert the additional rows, hold Ctrl key, click the selected rows, and then click Insert on the pop-up menu.

Accepted Answer

A) True 
 B)False

Question 15

To change the name of a worksheet, you rename the _____.

Accepted Answer

A)  sheet columns 
B)  sheet rows 
C)  sheet header 
D)  sheet tab 
A)  sheet columns 
B)  sheet rows 
C)  sheet header 
D)  sheet tab

Question 16

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

Accepted Answer

A) True 
 B)False

Question 17

To move a worksheet, you can drag its sheet tab to the left or right.

Accepted Answer

A) True 
 B)False

Question 18

Which of the following is a built-in formula that helps you perform complex calculations?

Accepted Answer

A)  clipboard 
B)  mode indicator 
C)  named range 
D)  function 
A)  clipboard 
B)  mode indicator 
C)  named range 
D)  function

Question 19

You have cut the range A1:A5, and want to paste it to C1:C5. Which of the following statements is true?

Accepted Answer

A)  Before you paste it, you need to select C1:C5. 
B)  Before you paste it, you only need to select cell C1. 
C)  After you paste it, the information is deleted from the Clipboard. 
D)  After you paste it, the information is deleted from the original location. 
A)  Before you paste it, you need to select C1:C5. 
B)  Before you paste it, you only need to select cell C1. 
C)  After you paste it, the information is deleted from the Clipboard. 
D)  After you paste it, the information is deleted from the original location.

Question 20

To print your worksheet at its actual size, which of the following would you select?

Accepted Answer

A)  Fit to 
B)  No scaling 
C)  Fit sheet to one page 
D)  Scale to fit 
A)  Fit to 
B)  No scaling 
C)  Fit sheet to one page 
D)  Scale to fit

To print a worksheet, you begin by going to Backstage view.

To select a single worksheet cell so you can work with it, which of the following would you do?

Which of the following is true about adding cell borders?

Which of the following will you select as X in the following series of clicks to convert a table to range: Table > Table Tools > Design > X > Convert to Range?

Rukha has created two custom views of a worksheet. In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden. What can she do to be able to see the view that she needs to at a given point in time?

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

To print more than one copy of your worksheet, which tab would you go to?

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

Which of the following is true about deleting a worksheet row?

To create a new, blank workbook, which of the following can you use?

You can use the I-beam pointer to copy cell contents into adjacent cells.

To delete a worksheet column, you can first select it by _____.

Dean wants to insert five blank rows above a row. To do so, he can select the heading of the row above which he wants to insert the additional rows, hold Ctrl key, click the selected rows, and then click Insert on the pop-up menu.

To change the name of a worksheet, you rename the _____.

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

To move a worksheet, you can drag its sheet tab to the left or right.

Which of the following is a built-in formula that helps you perform complex calculations?

You have cut the range A1:A5, and want to paste it to C1:C5. Which of the following statements is true?

To print your worksheet at its actual size, which of the following would you select?

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Filters

Exam 1: Getting Started With Excel

To print a worksheet, you begin by going to Backstage view.

To select a single worksheet cell so you can work with it, which of the following would you do?

Which of the following is true about adding cell borders?

Which of the following will you select as X in the following series of clicks to convert a table to range: Table > Table Tools > Design > X > Convert to Range?

Rukha has created two custom views of a worksheet. In one view, all rows and columns can be seen whereas in the other, specific rows and columns are hidden. What can she do to be able to see the view that she needs to at a given point in time?

For which of the following would you use the Paste list arrow on the Ribbon when pasting a copied cell?

Which of the following options will you select to restrict access to a shared workbook to only co-workers in your company who are logged into Microsoft Office?

To print more than one copy of your worksheet, which tab would you go to?

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

Which of the following is true about deleting a worksheet row?

To create a new, blank workbook, which of the following can you use?

You can use the I-beam pointer to copy cell contents into adjacent cells.

To delete a worksheet column, you can first select it by _____.

Dean wants to insert five blank rows above a row. To do so, he can select the heading of the row above which he wants to insert the additional rows, hold Ctrl key, click the selected rows, and then click Insert on the pop-up menu.

To change the name of a worksheet, you rename the _____.

The easiest way to insert the SUM function is to use the AutoSum button on the Home tab.

To move a worksheet, you can drag its sheet tab to the left or right.

Which of the following is a built-in formula that helps you perform complex calculations?

You have cut the range A1:A5, and want to paste it to C1:C5. Which of the following statements is true?

To print your worksheet at its actual size, which of the following would you select?

Formatting Workbook Text and Data

Performing Calculations With Formulas and Functions

Analyzing and Charting Financial Data

Generating Reports From Multiple Worksheets and Workbooks

Managing Data With Data Tools

Summarizing Data With Pivottables

Performing What-If Analyses

Exploring Financial Tools and Functions

Analyzing Data With Business Intelligence Tools

Exploring Pivottable Design

Developing an Excel Application

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Customizing Your Workspace Text and Graphics

Filters