Question 1

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.

Question 2

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.

Question 3

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

Question 4

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

Question 5

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

Question 6

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

Accepted Answer

False - En...

Question 7

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 8

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.

Question 9

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

Accepted Answer

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

Question 10

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.

Question 11

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.

Question 12

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.

Question 13

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.

Question 14

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

Question 15

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)

Question 16

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

Question 17

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.

Question 18

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

Question 19

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

Question 20

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

Accepted Answer

False - Sh...

Exam 1: Getting Started With Excel

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

Which of the following is true about moving cell contents?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse - En...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse - relativeFal...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedFalse - Sh...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

After you delete a worksheet column, _____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False - En...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False - relative
Fal...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
False - Sh...
View Answer

Correct Answer
verified

Correct Answer
verified