Question 1

When making a chart with two y-axes, you will need to use a ____ data series.

Accepted Answer

A)  1-D 
B)  2-D 
C)  3-D 
D)  4-D 
A)  1-D 
B)  2-D 
C)  3-D 
D)  4-D

Question 2

The ____________________ is the foundation, or base, of a 3-D chart.

Accepted Answer

The answer of The ____________________ is the foundation, or base,...

Question 3

Embedded charts are useful when you want to print a chart next to the data the chart illustrates.

Accepted Answer

A) True 
 B)False

Question 4

Match between columns
                        Premises: Determines the height of characters as measured in points.

Accepted Answer

The Answer of Font and Font style and Cell style is...

Question 5

To delete a worksheet, you can right-click a sheet tab, click Delete on the shortcut menu, and then click ____________________ in the message box to delete a worksheet.

Accepted Answer

The answer of To delete a worksheet, you can right-click...

Question 6

In Excel, ____ involves bringing data from several worksheets together into one worksheet.

Accepted Answer

A)  consolidating 
B)  auditing 
C)  tracing 
D)  joining 
A)  consolidating 
B)  auditing 
C)  tracing 
D)  joining

Question 7

Excel tracks changes to worksheet names and formats applied to cells or data.

Accepted Answer

A) True 
 B)False

Question 8

Match between columns
                        Premises: Data that is separated at the same place in each cell, such as after 15 characters.

Accepted Answer

The Answer of SkyDrive and signature line and delimited and is...

Question 9

Case EX 17-1 Anna just took over a computer repair business. The previous owner had used an Access database and some text files to store client and work data. Anna wants to use Excel to store this data in the future. If Anna wants an easy way to bring the Access data into Excel, she needs to ____ the data into Excel.

Accepted Answer

A)  chart 
B)  throw 
C)  cycle 
D)  import 
A)  chart 
B)  throw 
C)  cycle 
D)  import

Question 10

By default, ____________________, row numbers, and column letters appear in the worksheet-but not on the printed page-to help you enter and format data.

Accepted Answer

The answer of By default, ____________________, row numbers, and column...

Question 11

To edit the data directly in a cell, make the cell active and then press the ____ key or double-click the cell.

Accepted Answer

A)  F1 
B)  F2 
C)  F3 
D)  F4 
A)  F1 
B)  F2 
C)  F3 
D)  F4

Question 12

Please briefly describe the DATE and NOW functions, including how the formula is written, any arguments involved, and a situation of when you would use that function: DATE and NOW.

Accepted Answer

- The DATE function: How it is written :

Question 13

You can use the ____ feature when you want to project the results of a function in several cells, not just the one cell containing the function.

Accepted Answer

A)  Goal Seek 
B)  Data Table 
C)  Trace Dependents 
D)  Trace Precedents 
A)  Goal Seek 
B)  Data Table 
C)  Trace Dependents 
D)  Trace Precedents

Question 14

When you password-protect a workbook, you are ____ the file.

Accepted Answer

A)  decrypting 
B)  synchronizing 
C)  charting 
D)  encrypting 
A)  decrypting 
B)  synchronizing 
C)  charting 
D)  encrypting

Question 15

You will use the ____ function to see how many cells do not contain data.

Accepted Answer

A)  EMPTY 
B)  COUNT 
C)  BLANK 
D)  COUNTBLANK 
A)  EMPTY 
B)  COUNT 
C)  BLANK 
D)  COUNTBLANK

Question 16

A group of selected cells is called a(n) ____________________.

Accepted Answer

The answer of A group of selected cells is called...

Question 17

FIGURE EX 10-1   In Figure EX 10-1 above, item 2 points to the ____.

Accepted Answer

A)  sparklines 
B)  gauge table 
C)  data table 
D)  data series 
A)  sparklines 
B)  gauge table 
C)  data table 
D)  data series

Question 18

The ____________________ format displays numbers with a dollar sign, a thousands separator, and two decimal places.

Accepted Answer

The answer of The ____________________ format displays numbers with a...

Question 19

FIGURE EX 7-1   The area indicated by #3 in Figure EX 7-1 above is ____.

Accepted Answer

A)  Sheet tabs for the inactive worksheets 
B)  Sheet tabs for the active worksheets 
C)  Tab scrolling buttons 
D)  Custom sheet buttons 
A)  Sheet tabs for the inactive worksheets 
B)  Sheet tabs for the active worksheets 
C)  Tab scrolling buttons 
D)  Custom sheet buttons

Question 20

The vertical axis of a chart is called the ____.

Accepted Answer

A)  a-axis 
B)  b-axis 
C)  x-axis 
D)  y-axis 
A)  a-axis 
B)  b-axis 
C)  x-axis 
D)  y-axis

When making a chart with two y-axes, you will need to use a ____ data series.

The ____________________ is the foundation, or base, of a 3-D chart.

Embedded charts are useful when you want to print a chart next to the data the chart illustrates.

To delete a worksheet, you can right-click a sheet tab, click Delete on the shortcut menu, and then click ____________________ in the message box to delete a worksheet.

In Excel, ____ involves bringing data from several worksheets together into one worksheet.

Excel tracks changes to worksheet names and formats applied to cells or data.

By default, ____________________, row numbers, and column letters appear in the worksheet-but not on the printed page-to help you enter and format data.

To edit the data directly in a cell, make the cell active and then press the ____ key or double-click the cell.

Please briefly describe the DATE and NOW functions, including how the formula is written, any arguments involved, and a situation of when you would use that function: DATE and NOW.

You can use the ____ feature when you want to project the results of a function in several cells, not just the one cell containing the function.

When you password-protect a workbook, you are ____ the file.

You will use the ____ function to see how many cells do not contain data.

A group of selected cells is called a(n) ____________________.

FIGURE EX 10-1 In Figure EX 10-1 above, item 2 points to the ____.

The ____________________ format displays numbers with a dollar sign, a thousands separator, and two decimal places.

FIGURE EX 7-1 The area indicated by #3 in Figure EX 7-1 above is ____.

The vertical axis of a chart is called the ____.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

When making a chart with two y-axes, you will need to use a ____ data series.

The ____________________ is the foundation, or base, of a 3-D chart.

Embedded charts are useful when you want to print a chart next to the data the chart illustrates.

To delete a worksheet, you can right-click a sheet tab, click Delete on the shortcut menu, and then click ____________________ in the message box to delete a worksheet.

In Excel, ____ involves bringing data from several worksheets together into one worksheet.

Excel tracks changes to worksheet names and formats applied to cells or data.

By default, ____________________, row numbers, and column letters appear in the worksheet-but not on the printed page-to help you enter and format data.

To edit the data directly in a cell, make the cell active and then press the ____ key or double-click the cell.

Please briefly describe the DATE and NOW functions, including how the formula is written, any arguments involved, and a situation of when you would use that function: DATE and NOW.

You can use the ____ feature when you want to project the results of a function in several cells, not just the one cell containing the function.

When you password-protect a workbook, you are ____ the file.

You will use the ____ function to see how many cells do not contain data.

A group of selected cells is called a(n) ____________________.

FIGURE EX 10-1 In Figure EX 10-1 above, item 2 points to the ____.

The ____________________ format displays numbers with a dollar sign, a thousands separator, and two decimal places.

FIGURE EX 7-1 The area indicated by #3 in Figure EX 7-1 above is ____.

The vertical axis of a chart is called the ____.

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters