Question 1

The ____________________(logical) function returns a value of TRUE if the argument is false, and FALSE if the argument is true;

Accepted Answer

The answer of The ____________________(logical) function returns a value of...

Question 2

Match between columns
                        Premises: The worksheet that appears in the workbook window.

Accepted Answer

The Answer of Worksheet range and Destination and Source and is...

Question 3

You can add formulas to a worksheet that instantly calculate totals within the worksheet data using Excel's ____ feature.

Accepted Answer

A)  Quick Formula 
B)  Totals 
C)  Sum 
D)  Subtotal

Question 4

Excel offers quite a variety of table sizes in the Table Format gallery.

Accepted Answer

A) True 
 B)False

Question 5

To make a workbook active, just click ____.

Accepted Answer

A)  its title bar 
B)  anywhere in the worksheet 
C)  either a. or b. 
D)  neither a. nor b.

Question 6

The ____________________ calculation lists how many of the selected cells contain numbers.

Accepted Answer

The answer of The ____________________ calculation lists how many of...

Question 7

To make all formulas visible, click the Formulas tab on the Ribbon, and then click the Show Formulas button in the ____ group.

Accepted Answer

A)  Formula 
B)  View 
C)  Formula Auditing 
D)  Formula View

Question 8

The cell in the worksheet in which you can type data is called the open cell.

Accepted Answer

A) True 
 B)False

Question 9

Formats are composed of ____.

Accepted Answer

A)  numbers 
B)  letters 
C)  codes 
D)  symbols

Question 10

You can pull one or more slices away from the pie to distinguish them, creating what is called a(n) ____________________ pie chart.

Accepted Answer

The answer of You can pull one or more slices...

Question 11

You can copy and paste formats from one label to another using the Format ____ feature.

Accepted Answer

A)  Duplicator 
B)  Painter 
C)  Replicator 
D)  Copier

Question 12

A(n) ____ is a digital photograph or other image file.

Accepted Answer

A)  attachment 
B)  fax 
C)  picture 
D)  shape

Question 13

Match between columns
                        Premises: Does not change when copied or moved to a new cell.

Accepted Answer

The Answer of Operator and Mixed cell reference and Absolute is...

Question 14

To display data or formula results from one worksheet in another worksheet of the same workbook, you use a(n) ____________________ with a reference to another worksheet.

Accepted Answer

The answer of To display data or formula results from...

Question 15

If someone tries to open a password-protected workbook, he or she will first be prompted to enter the ____ in a dialog box.

Accepted Answer

A)  file name 
B)  author name 
C)  list of changes 
D)  password

Question 16

If the next cell already contains data, any text that does not fit in the cell is ____________________, or hidden from view.

Accepted Answer

The answer of If the next cell already contains data,...

Question 17

You can use the Ribbon to select chart elements. Click the Format tab or the ____ tab on the Ribbon. In the Current Selection group, click the arrow next to the Chart Elements box.

Accepted Answer

A)  Chart 
B)  Home 
C)  Layout 
D)  Design

Question 18

You can choose a style for the slicer on the ____________________ tab.

Accepted Answer

The answer of You can choose a style for the...

Question 19

Date and time functions can be used to convert serial numbers to a ____.

Accepted Answer

A)  month 
B)  day 
C)  year 
D)  all of the above

Question 20

The Format Painter button is found on the Clipboard group on the ____ tab.

Accepted Answer

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

Exam 2: Microsoft Excel Basics