Question 1

In Microsoft Excel,the wide bar of tools and selections that appears just under the tabs is termed the ________.

Accepted Answer

A)  menu tab 
B)  task pane 
C)  office button 
D)  ribbon.

Question 2

In Excel,the entire row or column can be selected by clicking on the name of the row or column.

Accepted Answer

A) True 
 B)False

Question 3

The Home tab holds the most frequently used tools and selections.

Accepted Answer

A) True 
 B)False

Question 4

After copying a formula to a different cell,the user has to edit the terms of the formula so that each refers to cells in the row to which it was copied.

Accepted Answer

A) True 
 B)False

Question 5

In Excel,the option to change the page orientation is located on the ________ tab.

Accepted Answer

A)  Page Layout 
B)  View 
C)  Review 
D)  Add-ins

Question 6

In Excel,every formula must begin with a(n)________ sign.

Accepted Answer

A)  plus 
B)  minus 
C)  dollar 
D)  equality

Question 7

In Microsoft Excel,the columns are identified by ________.

Accepted Answer

A)  capital letters 
B)  numbers 
C)  Roman numerals 
D)  lowercase letters

Question 8

Microsoft Help can be accessed by clicking the question mark located in the ribbon bar below the Review tab.

Accepted Answer

A) True 
 B)False

Question 9

What is the meaning of the formula SUM (C3:C8)?

Accepted Answer

A)  Add all the values starting from the third cell to eighth cell in the third column. 
B)  Add the all the values starting from the third cell to eighth cell in the third row. 
C)  Add the values of third cell in the third column and eighth cell in the third column. 
D)  Add the values of third cell in the third row and eighth cell in the third row.

Question 10

The intersection of a row and a column on a spreadsheet is called a data point.

Accepted Answer

A) True 
 B)False

Question 11

You have entered a formula in the cell G9.Which of the following would occur if you press F2 function key after selecting the cell G9?

Accepted Answer

A)  The formula in G9 can be edited without retyping. 
B)  The formula will be copied to the clipboard. 
C)  A graph that explains the formula would appear. 
D)  The formula in the cell will be locked.

Question 12

An Excel worksheet cannot add data based on a pattern.

Accepted Answer

A) True 
 B)False

Question 13

In Microsoft Excel,the wide bar of tools and selections that appears just under the tabs is referred to as the Menu bar.

Accepted Answer

A) True 
 B)False

Question 14

Explain the process of inserting rows and columns in Microsoft Excel.

Accepted Answer

The answer of Explain the process of inserting rows and...

Question 15

Which of the following can be used to move the focus to a different cell in the Excel worksheet?

Accepted Answer

A)  arrow keys 
B)  office button 
C)  shift key 
D)  data tab

Question 16

A Microsoft Excel workbook is a collection of one or more spreadsheets.

Accepted Answer

A) True 
 B)False

Question 17

Orientation refers to whether the worksheet is printed upright or sideways on the page.

Accepted Answer

A) True 
 B)False

Question 18

A ________ is a table of data which has rows and columns.

Accepted Answer

A)  spreadsheet 
B)  cell 
C)  broadsheet 
D)  library

Question 19

In Excel,the term "________" refers to a single spreadsheet.

Accepted Answer

A)  workbook 
B)  library 
C)  worksheet 
D)  gridline

Question 20

In Microsoft Excel,which of the following tabs can be used for filtering and sorting the information in your spreadsheet?

Accepted Answer

A)  Data 
B)  Add-ins 
C)  Formula 
D)  Home

Exam 17: Introduction to Microsoft Excel

In Microsoft Excel,the wide bar of tools and selections that appears just under the tabs is termed the ________.

In Excel,the entire row or column can be selected by clicking on the name of the row or column.

The Home tab holds the most frequently used tools and selections.

After copying a formula to a different cell,the user has to edit the terms of the formula so that each refers to cells in the row to which it was copied.

In Excel,the option to change the page orientation is located on the ________ tab.

In Excel,every formula must begin with a(n) ________ sign.

In Microsoft Excel,the columns are identified by ________.

Microsoft Help can be accessed by clicking the question mark located in the ribbon bar below the Review tab.

What is the meaning of the formula SUM (C3:C8) ?

The intersection of a row and a column on a spreadsheet is called a data point.

You have entered a formula in the cell G9.Which of the following would occur if you press F2 function key after selecting the cell G9?

An Excel worksheet cannot add data based on a pattern.

In Microsoft Excel,the wide bar of tools and selections that appears just under the tabs is referred to as the Menu bar.

Explain the process of inserting rows and columns in Microsoft Excel.

Which of the following can be used to move the focus to a different cell in the Excel worksheet?

A Microsoft Excel workbook is a collection of one or more spreadsheets.

Orientation refers to whether the worksheet is printed upright or sideways on the page.

A ________ is a table of data which has rows and columns.

In Excel,the term "________" refers to a single spreadsheet.

In Microsoft Excel,which of the following tabs can be used for filtering and sorting the information in your spreadsheet?