Question 1

Which of the following is true about deleting a worksheet? Select all the options that apply.

Accepted Answer

A)  You can right-click a sheet tab and click Delete. 
B)  You can use the Delete list arrow in the Cells group on the Home tab. 
C)  You can use the Delete button in the worksheet group on the Insert tab. 
D)  You cannot delete a worksheet from a workbook. 
A)  You can right-click a sheet tab and click Delete. 
B)  You can use the Delete list arrow in the Cells group on the Home tab. 
C)  You can use the Delete button in the worksheet group on the Insert tab. 
D)  You cannot delete a worksheet from a workbook.

Question 2

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

Accepted Answer

A)  delete 
B)  conditionally format 
C)  edit 
D)  hide 
A)  delete 
B)  conditionally format 
C)  edit 
D)  hide

Question 3

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

Accepted Answer

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

Question 4

Which of the following is true when you copy and paste formulas using the fill handle?

Accepted Answer

A)  The Paste Options button lets you paste only specific elements of the copied selection. 
B)  The AutoFill Options button lets you fill cells with specific elements of the copied cell. 
C)  The formula is placed on the Office clipboard. 
D)  You need to change the cell references to reflect the new formula location. 
A)  The Paste Options button lets you paste only specific elements of the copied selection. 
B)  The AutoFill Options button lets you fill cells with specific elements of the copied cell. 
C)  The formula is placed on the Office clipboard. 
D)  You need to change the cell references to reflect the new formula location.

Question 5

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

Accepted Answer

A)  Leave the workbook closed. 
B)  Open the workbook, change the first worksheet, and save it using the Save command. 
C)  Open the workbook, make changes, and then save it using the same name. 
D)  Open the workbook, make changes, and then save it using a different name. 
A)  Leave the workbook closed. 
B)  Open the workbook, change the first worksheet, and save it using the Save command. 
C)  Open the workbook, make changes, and then save it using the same name. 
D)  Open the workbook, make changes, and then save it using a different name.

Question 6

Which of the following is true about inserting cells in a worksheet?

Accepted Answer

A)  Excel automatically adjusts cell references to reflect new formula locations. 
B)  You need to adjust cell references in all formulas that have moved. 
C)  You cannot insert cells in a worksheet. 
D)  Cells below the inserted cells are always moved downward. 
A)  Excel automatically adjusts cell references to reflect new formula locations. 
B)  You need to adjust cell references in all formulas that have moved. 
C)  You cannot insert cells in a worksheet. 
D)  Cells below the inserted cells are always moved downward.

Question 7

To see a preview of how a pasted value will look, which of the following would you use?

Accepted Answer

A)  Fill button 
B)  AutoFill Options button 
C)  Paste button 
D)  Paste List arrow 
A)  Fill button 
B)  AutoFill Options button 
C)  Paste button 
D)  Paste List arrow

Question 8

To enter a typed number into a cell, you can press Tab or Backspace.

Accepted Answer

False - En

Question 9

In the formula =A8*$A$1, which of the following describes A8?

Accepted Answer

A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  AutoSum 
A)  Relative cell reference 
B)  Absolute cell reference 
C)  Function 
D)  AutoSum

Question 10

Which of the following is true when you delete a cell?

Accepted Answer

A)  When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells. 
B)  Row and column alignment will not be affected. 
C)  You need to manually adjust cell references in surrounding formulas. 
D)  You can use the Delete command on the Insert tab. 
A)  When you delete cells using the Delete list arrow, you can choose which way to move adjacent cells. 
B)  Row and column alignment will not be affected. 
C)  You need to manually adjust cell references in surrounding formulas. 
D)  You can use the Delete command on the Insert tab.

Question 11

Which of the following is true about moving cell contents?

Accepted Answer

A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents, they remain in their original location. 
D)  You can move cells using the drag-and-drop feature. 
A)  You can move cells using the Copy command. 
B)  You cannot move cells from one worksheet to another. 
C)  When you move cell contents, they remain in their original location. 
D)  You can move cells using the drag-and-drop feature.

Question 12

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

Accepted Answer

A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20) 
A)  =COUNT(B1:B20) 
B)  =COUNTIF(B1:B20) 
C)  =SUM(B1:B20) 
D)  =CALCULATE(B1:B20)

Question 13

When you double-click a cell's right column border, which of the following occurs?

Accepted Answer

A)  The column is deleted. 
B)  AutoFit resizes the column to 8.43 characters wide. 
C)  A column is added to the right of the column's border. 
D)  AutoFit resizes the column to the widest cell entry. 
A)  The column is deleted. 
B)  AutoFit resizes the column to 8.43 characters wide. 
C)  A column is added to the right of the column's border. 
D)  AutoFit resizes the column to the widest cell entry.

Question 14

If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following tabs lets you set worksheet print options?

Accepted Answer

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

Question 16

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

Accepted Answer

False - Sh

Question 17

Which of the following is true about changing worksheet column width?

Accepted Answer

A)  In Normal view, the Column Width dialog box lets you set column width to an exact value in inches. 
B)  In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column. 
C)  When you drag the right column border in Normal view, a ScreenTip displays the exact width in inches. 
D)  When you drag the right column border in Page Layout view, a ScreenTip displays the exact width in pixels. 
A)  In Normal view, the Column Width dialog box lets you set column width to an exact value in inches. 
B)  In Normal view, the Column Width dialog box lets you set the exact number of characters that will fit in the column. 
C)  When you drag the right column border in Normal view, a ScreenTip displays the exact width in inches. 
D)  When you drag the right column border in Page Layout view, a ScreenTip displays the exact width in pixels.

Question 18

After you delete a worksheet column, _____.

Accepted Answer

A)  the columns to its right shift left 
B)  the columns to its left shift right 
C)  the row remains but its contents are deleted 
D)  only its formats are deleted 
A)  the columns to its right shift left 
B)  the columns to its left shift right 
C)  the row remains but its contents are deleted 
D)  only its formats are deleted

Question 19

Where can you see a preview of how your worksheet will look when printed, including headers?

Accepted Answer

A)  Print tab in Backstage view 
B)  Page Break preview 
C)  Normal view 
D)  File preview 
A)  Print tab in Backstage view 
B)  Page Break preview 
C)  Normal view 
D)  File preview

Question 20

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

Accepted Answer

False - relative
Fal

Which of the following is true about deleting a worksheet? Select all the options that apply.

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

Which of the following is true when you copy and paste formulas using the fill handle?

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

Which of the following is true about inserting cells in a worksheet?

To see a preview of how a pasted value will look, which of the following would you use?

To enter a typed number into a cell, you can press Tab or Backspace.

In the formula =A8*$A$1, which of the following describes A8?

Which of the following is true when you delete a cell?

Which of the following is true about moving cell contents?

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

When you double-click a cell's right column border, which of the following occurs?

If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.

Which of the following tabs lets you set worksheet print options?

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

Which of the following is true about changing worksheet column width?

After you delete a worksheet column, _____.

Where can you see a preview of how your worksheet will look when printed, including headers?

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

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

Which of the following is true about deleting a worksheet? Select all the options that apply.

Your worksheet contains confidential information in column C; to prevent others who use your worksheet from seeing the data, you can _____ column C.

To print your worksheet on a piece of paper larger than 8-1/2 x 11", which Excel tab would you use?

Which of the following is true when you copy and paste formulas using the fill handle?

To preserve the original version of a workbook so you can make changes to a copy of it, which of the following would you do?

Which of the following is true about inserting cells in a worksheet?

To see a preview of how a pasted value will look, which of the following would you use?

To enter a typed number into a cell, you can press Tab or Backspace.

In the formula =A8*$A$1, which of the following describes A8?

Which of the following is true when you delete a cell?

Which of the following is true about moving cell contents?

Sam wants to count the number of cells between B1 and B20 that contain numbers in them. Which of the following formula should he use to do so?

When you double-click a cell's right column border, which of the following occurs?

If you specify that you want worksheet gridlines to appear on the screen, they will automatically appear on the printout as well.

Which of the following tabs lets you set worksheet print options?

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

Which of the following is true about changing worksheet column width?

After you delete a worksheet column, _____.

Where can you see a preview of how your worksheet will look when printed, including headers?

When you copy and paste a formula with absolute cell references, Excel substitutes new references to reflect the new formula location.

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