Question 1

Which of the following lets you edit the contents of a cell?

Accepted Answer

A)  Click the cell,click the status bar,and press Enter. 
B)  Click the cell and click in the status bar. 
C)  Double-click the cell,click in the status bar,or just start typing. 
D)  Double-click the cell or click in the formula bar. 
A)  Click the cell,click the status bar,and press Enter. 
B)  Click the cell and click in the status bar. 
C)  Double-click the cell,click in the status bar,or just start typing. 
D)  Double-click the cell or click in the formula bar.

Question 2

To align currency symbols and decimal points in a column of numbers,you can apply the ____ number format.

Accepted Answer

A)  Currency 
B)  Accounting 
C)  Percentage 
D)  General 
A)  Currency 
B)  Accounting 
C)  Percentage 
D)  General

Question 3

The Comma Style format adds a comma and a dollar sign to a cell value.

Accepted Answer

A) True 
 B)False

Question 4

When you cut or copy a cell,it is cut or copied to which of the following?

Accepted Answer

A)  Neither the Windows or Office Clipboard 
B)  Both the Windows and Office Clipboard 
C)  Only the Office Clipboard 
D)  Only the Windows Clipboard 
A)  Neither the Windows or Office Clipboard 
B)  Both the Windows and Office Clipboard 
C)  Only the Office Clipboard 
D)  Only the Windows Clipboard

Question 5

You can use the DELETE key to clear cell contents.

Accepted Answer

A) True 
 B)False

Question 6

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Accepted Answer

A)  Normal pointer 
B)  I-beam pointer 
C)  Move pointer 
D)  Copy pointer 
A)  Normal pointer 
B)  I-beam pointer 
C)  Move pointer 
D)  Copy pointer

Question 7

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer.He can do so by clicking on Page Layout > Save As > (Enter name in )File name box > Save As type list > PDF > Minimum Size (publishing online)> Options > OK > Save.

Accepted Answer

A) True 
 B)False

Question 8

How many actions does the Undo button let you reverse?

Accepted Answer

A)  24 
B)  50 
C)  75 
D)  100 
A)  24 
B)  50 
C)  75 
D)  100

Question 9

To customize the status bar,right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't want to show.

Accepted Answer

A) True 
 B)False

Question 10

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 11

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 12

Which of the following formulas totals the cells B6,B7,B8,B9,and B10 most efficiently?

Accepted Answer

A)  The formula =B6+B7+B8+B9+B10. 
B)  The formula =TOTAL(B6-B10) 
C)  The formula =SUM(B6:B10) 
D)  The formula +SUM(B6-B10) 
A)  The formula =B6+B7+B8+B9+B10. 
B)  The formula =TOTAL(B6-B10) 
C)  The formula =SUM(B6:B10) 
D)  The formula +SUM(B6-B10)

Question 13

When you enter a value in a worksheet cell,it is automatically left-aligned.

Accepted Answer

A) True 
 B)False

Question 14

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 15

To have Excel enter the lowest price from a range of prices,which of the following would you use?

Accepted Answer

A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function 
A)  MAX function 
B)  COUNT function 
C)  MIN function 
D)  COUNTA function

Question 16

Binay wants to create an X-Y scatter plot.To do so,he should select the data he wants to plot in the scatter chart,then click the Insert tab,and then click Insert Scatter (X,Y)or Bubble Chart.

Accepted Answer

A) True 
 B)False

Question 17

You have selected a cell with a formula.Which of the following can you use to copy that formula to an adjacent cell?

Accepted Answer

A)  mode indicator 
B)  Page Break Preview 
C)  scroll bar 
D)  Fill handle 
A)  mode indicator 
B)  Page Break Preview 
C)  scroll bar 
D)  Fill handle

Question 18

To insert an equation,click on the Object in the Text group on the Insert tab,then click Microsoft Equation 3.0 in the Object type box,and then click OK.

Accepted Answer

A) True 
 B)False

Question 19

To change the color of cell content,you use the ________ color list arrow.

Accepted Answer

A)  Cell 
B)  Text 
C)  Pattern 
D)  Font 
A)  Cell 
B)  Text 
C)  Pattern 
D)  Font

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

Which of the following lets you edit the contents of a cell?

To align currency symbols and decimal points in a column of numbers,you can apply the ____ number format.

The Comma Style format adds a comma and a dollar sign to a cell value.

When you cut or copy a cell,it is cut or copied to which of the following?

You can use the DELETE key to clear cell contents.

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer.He can do so by clicking on Page Layout > Save As > (Enter name in )File name box > Save As type list > PDF > Minimum Size (publishing online)> Options > OK > Save.

How many actions does the Undo button let you reverse?

To customize the status bar,right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't want to show.

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

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

Which of the following formulas totals the cells B6,B7,B8,B9,and B10 most efficiently?

When you enter a value in a worksheet cell,it is automatically left-aligned.

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

To have Excel enter the lowest price from a range of prices,which of the following would you use?

Binay wants to create an X-Y scatter plot.To do so,he should select the data he wants to plot in the scatter chart,then click the Insert tab,and then click Insert Scatter (X,Y)or Bubble Chart.

You have selected a cell with a formula.Which of the following can you use to copy that formula to an adjacent cell?

To insert an equation,click on the Object in the Text group on the Insert tab,then click Microsoft Equation 3.0 in the Object type box,and then click OK.

To change the color of cell content,you use the ________ color list arrow.

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

Formulas,functions,and Formatting

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

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

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

Exam 1: Creating a Worksheet and a Chart

Which of the following lets you edit the contents of a cell?

To align currency symbols and decimal points in a column of numbers,you can apply the ____ number format.

The Comma Style format adds a comma and a dollar sign to a cell value.

When you cut or copy a cell,it is cut or copied to which of the following?

You can use the DELETE key to clear cell contents.

Which of the following would you use to create a duplicate of the selected cell when the CTRL key is pressed?

Henri wants to convert a workbook to PDF so that he can print it in high quality using a commercial printer.He can do so by clicking on Page Layout > Save As > (Enter name in )File name box > Save As type list > PDF > Minimum Size (publishing online)> Options > OK > Save.

How many actions does the Undo button let you reverse?

To customize the status bar,right click on the status bar to open the Customize Status Bar menu and uncheck the items that you don't want to show.

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

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

Which of the following formulas totals the cells B6,B7,B8,B9,and B10 most efficiently?

When you enter a value in a worksheet cell,it is automatically left-aligned.

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

To have Excel enter the lowest price from a range of prices,which of the following would you use?

Binay wants to create an X-Y scatter plot.To do so,he should select the data he wants to plot in the scatter chart,then click the Insert tab,and then click Insert Scatter (X,Y)or Bubble Chart.

You have selected a cell with a formula.Which of the following can you use to copy that formula to an adjacent cell?

To insert an equation,click on the Object in the Text group on the Insert tab,then click Microsoft Equation 3.0 in the Object type box,and then click OK.

To change the color of cell content,you use the ________ color list arrow.

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

Formulas,functions,and Formatting

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

Financial Functions, data Tables, and Amortization Schedules

Working With Multiple Worksheets and Workbooks

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