Question 1

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 2

To apply a cell style,you would use the Cell Styles command on the _____ tab.

Accepted Answer

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

Question 3

When you underline cell content,you are using _____.

Accepted Answer

A)  a font style 
B)  an orientation setting 
C)  an indent setting 
D)  a centering style 
A)  a font style 
B)  an orientation setting 
C)  an indent setting 
D)  a centering style

Question 4

Which of the following tabs lets you see exactly how your worksheet looks before printing?

Accepted Answer

A)  Insert 
B)  View 
C)  Formulas 
D)  File 
A)  Insert 
B)  View 
C)  Formulas 
D)  File

Question 5

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 6

Which of the following functions inserts the total of a range?

Accepted Answer

A)  ROUND 
B)  AUTOSUM 
C)  AVERAGE 
D)  SUM 
A)  ROUND 
B)  AUTOSUM 
C)  AVERAGE 
D)  SUM

Question 7

In the formula =SUM(A6:A9),which of the following best describes A6?

Accepted Answer

A)  argument 
B)  function 
C)  label 
D)  active cell 
A)  argument 
B)  function 
C)  label 
D)  active cell

Question 8

Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X >?

Accepted Answer

A)  Insert Column Chart 
B)  Insert Combo Chart 
C)  Insert Pie or Doughnut Chart 
D)  Insert Stock,Surface or Radar Chart 
A)  Insert Column Chart 
B)  Insert Combo Chart 
C)  Insert Pie or Doughnut Chart 
D)  Insert Stock,Surface or Radar Chart

Question 9

A _______ refers to a collection of characters with a similar,specific design.

Accepted Answer

A)  symbol 
B)  font 
C)  point 
D)  keyword 
A)  symbol 
B)  font 
C)  point 
D)  keyword

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

To apply a cell style,you would use the Cell Styles command on the _____ tab.

When you underline cell content,you are using _____.

Which of the following tabs lets you see exactly how your worksheet looks before printing?

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

Which of the following functions inserts the total of a range?

In the formula =SUM(A6:A9),which of the following best describes A6?

Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X >?

A _______ refers to a collection of characters with a similar,specific design.

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

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

To apply a cell style,you would use the Cell Styles command on the _____ tab.

When you underline cell content,you are using _____.

Which of the following tabs lets you see exactly how your worksheet looks before printing?

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

Which of the following functions inserts the total of a range?

In the formula =SUM(A6:A9),which of the following best describes A6?

Which of the following will you select as X in the given series of clicks to insert a pie chart: Insert > Charts group > X >?

A _______ refers to a collection of characters with a similar,specific design.

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