Question 1

The Data Validation Wizard provides a step-by-step process to help you choose how to separate your data.

Accepted Answer

A) True 
 B)False

Question 2

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. Cheryl has found the formula she wants to use by using Formula AutoComplete. How can she access a Screen Tip to guide her in entering the necessary arguments?

Accepted Answer

A)  Double-click the name of the function 
B)  Double-click anywhere inside the worksheet 
C)  Double-click anywhere outside the worksheet 
D)  None of the above 
A)  Double-click the name of the function 
B)  Double-click anywhere inside the worksheet 
C)  Double-click anywhere outside the worksheet 
D)  None of the above

Question 3

When should the Error Checking feature be used instead of the Trace Error feature?

Accepted Answer

The Trace Error feature is helpful when

Question 4

The ____ is the total for all the data.

Accepted Answer

A)  row total 
B)  grand total 
C)  subtotal 
D)  pre-total 
A)  row total 
B)  grand total 
C)  subtotal 
D)  pre-total

Question 5

You can change which cells are included in a reference by dragging any corner of the ____ to resize the selected range.

Accepted Answer

A)  column border 
B)  formula bar 
C)  colored outline 
D)  row border 
A)  column border 
B)  formula bar 
C)  colored outline 
D)  row border

Question 6

When data with letters is arranged in alphabetical order (A to Z), data with numbers is arranged from lowest to highest, and data with dates is arranged from earliest to latest, it's referred to as descending order.

Accepted Answer

A) True 
 B)False

Question 7

If you add password protection to individual worksheets, only the people who know the password can make changes to them.

Accepted Answer

A) True 
 B)False

Question 8

FIGURE EX 3-1   The line marked with the number 2 in Figure EX 3-1 above, indicates the ____.

Accepted Answer

A)  end of frozen rows 
B)  beginning of frozen rows 
C)  end of frozen columns 
D)  beginning of frozen columns 
A)  end of frozen rows 
B)  beginning of frozen rows 
C)  end of frozen columns 
D)  beginning of frozen columns

Question 9

If you were using relative cell references, the formula =A3+A4 would change to ____ when copied from cell A5 to cell B5.

Accepted Answer

A)  =B3+B4 
B)  =B4+B5 
C)  =$B3+$B4 
D)  =B$4+B$5 
A)  =B3+B4 
B)  =B4+B5 
C)  =$B3+$B4 
D)  =B$4+B$5

Question 10

Match between columns
                        Premises: A grid of rows and columns in which you enter text, numbers, and the results of calculations.

Accepted Answer

The Answer of Active worksheet and Workbook and Cell reference is...

Question 11

Themes are a simple way to make your worksheet appear more professional.

Accepted Answer

A) True 
 B)False

Question 12

You can show or hide all the comments in a worksheet by toggling the ___________________ Comments button in the Comments group.

Accepted Answer

The answer of You can show or hide all the...

Question 13

To move or copy a worksheet, right-click the sheet tab of the worksheet you want to move or copy, and then click ____ on the shortcut menu.

Accepted Answer

A)  Move or Copy 
B)  Relocate 
C)  New 
D)  Location 
A)  Move or Copy 
B)  Relocate 
C)  New 
D)  Location

Question 14

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. When Anna is bring the text data into Excel, selecting ____ in Step 3 of the Text Import Wizard will convert the number values to a number format, date values to dates, and the remaining text data will be brought in as text.

Accepted Answer

A)  Text 
B)  Date 
C)  General 
D)  Tab 
A)  Text 
B)  Date 
C)  General 
D)  Tab

Question 15

____ refers to bringing data from other programs into an Excel workbook.

Accepted Answer

A)  Exporting 
B)  Extracting 
C)  Validating 
D)  Importing 
A)  Exporting 
B)  Extracting 
C)  Validating 
D)  Importing

Question 16

Each part of a pie chart is shown as a ____ of the pie.

Accepted Answer

A)  bowl 
B)  slice 
C)  serving 
D)  dish 
A)  bowl 
B)  slice 
C)  serving 
D)  dish

Question 17

The ____ function replaces existing text in a specified cell with new text.

Accepted Answer

A)  FIND AND REPLACE 
B)  WRITE OVER 
C)  SUBSTITUTE 
D)  REPLACE 
A)  FIND AND REPLACE 
B)  WRITE OVER 
C)  SUBSTITUTE 
D)  REPLACE

Question 18

The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar.

Accepted Answer

A) True 
 B)False

Question 19

Case EX 13-1 Kim is a photographer. To supplement her income, she also teaches a basic photography class in her studio. She uses an Excel workbook to keep track of information related to her class. The columns in her worksheet are: Student Name, Address, Phone number, Fees, Fees Paid. When Kim was reviewing her worksheet, she realized that some of the addresses are missing. To find out the number of students for whom she doesn't have an address, she needs to use the ____ function.

Accepted Answer

A)  COUNT 
B)  COUNTBLANK 
C)  EMPTY 
A)  COUNT 
B)  COUNTBLANK 
C)  EMPTY

Question 20

What is a first-level and second-level sort, and what is a situation where you would use both levels?

Accepted Answer

You can sort by more than one column of

The Data Validation Wizard provides a step-by-step process to help you choose how to separate your data.

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. Cheryl has found the formula she wants to use by using Formula AutoComplete. How can she access a Screen Tip to guide her in entering the necessary arguments?

When should the Error Checking feature be used instead of the Trace Error feature?

The ____ is the total for all the data.

You can change which cells are included in a reference by dragging any corner of the ____ to resize the selected range.

When data with letters is arranged in alphabetical order (A to Z), data with numbers is arranged from lowest to highest, and data with dates is arranged from earliest to latest, it's referred to as descending order.

If you add password protection to individual worksheets, only the people who know the password can make changes to them.

FIGURE EX 3-1 The line marked with the number 2 in Figure EX 3-1 above, indicates the ____.

If you were using relative cell references, the formula =A3+A4 would change to ____ when copied from cell A5 to cell B5.

Themes are a simple way to make your worksheet appear more professional.

You can show or hide all the comments in a worksheet by toggling the ___________________ Comments button in the Comments group.

To move or copy a worksheet, right-click the sheet tab of the worksheet you want to move or copy, and then click ____ on the shortcut menu.

____ refers to bringing data from other programs into an Excel workbook.

Each part of a pie chart is shown as a ____ of the pie.

The ____ function replaces existing text in a specified cell with new text.

The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar.

What is a first-level and second-level sort, and what is a situation where you would use both levels?

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters

Exam 2: Microsoft Excel Basics

The Data Validation Wizard provides a step-by-step process to help you choose how to separate your data.

Case EX 5-1 Cheryl is planning to use Formula AutoComplete to help her enter some formulas in her new worksheet. Cheryl has found the formula she wants to use by using Formula AutoComplete. How can she access a Screen Tip to guide her in entering the necessary arguments?

When should the Error Checking feature be used instead of the Trace Error feature?

The ____ is the total for all the data.

You can change which cells are included in a reference by dragging any corner of the ____ to resize the selected range.

When data with letters is arranged in alphabetical order (A to Z), data with numbers is arranged from lowest to highest, and data with dates is arranged from earliest to latest, it's referred to as descending order.

If you add password protection to individual worksheets, only the people who know the password can make changes to them.

FIGURE EX 3-1 The line marked with the number 2 in Figure EX 3-1 above, indicates the ____.

If you were using relative cell references, the formula =A3+A4 would change to ____ when copied from cell A5 to cell B5.

Themes are a simple way to make your worksheet appear more professional.

You can show or hide all the comments in a worksheet by toggling the ___________________ Comments button in the Comments group.

To move or copy a worksheet, right-click the sheet tab of the worksheet you want to move or copy, and then click ____ on the shortcut menu.

____ refers to bringing data from other programs into an Excel workbook.

Each part of a pie chart is shown as a ____ of the pie.

The ____ function replaces existing text in a specified cell with new text.

The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar.

What is a first-level and second-level sort, and what is a situation where you would use both levels?

Microsoft Access Basics

Microsoft Office 2010 and the Internet

Microsoft Powerpoint Basics

Microsoft Word Basics

Filters