Question 1

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

Accepted Answer

A)  plus 
B)  minus 
C)  percent 
D)  equal 
A)  plus 
B)  minus 
C)  percent 
D)  equal

Question 2

A user types in a1 and a2 in the cells G1 and G2: If the user selects those two cells and drags the small black box to the four cells below them,then the four cells ________.

Accepted Answer

A)  will display a3, a4, a5, and a6 
B)  will display b1, b2, c1, and c2 
C)  will remain blank 
D)  will display a1, a2, a1, and a2 
A)  will display a3, a4, a5, and a6 
B)  will display b1, b2, c1, and c2 
C)  will remain blank 
D)  will display a1, a2, a1, and a2

Question 3

In Excel,every formula must begin with an equal sign.

Accepted Answer

A) True 
 B)False

Question 4

While copying a formula,Excel can adjust the terms of the formula to refer to the cells in the row to which it is copied.

Accepted Answer

A) True 
 B)False

Question 5

Selecting the $ English (U.S.)option displays numbers with a dollar sign and two decimal places.

Accepted Answer

A) True 
 B)False

Question 6

In an Excel sheet,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 all the values starting from the third cell to eighth cell in the third row. 
C)  Add the value of the third cell in the third column to the eighth cell in the third column. 
D)  Add the value of the third cell in the third row to the eighth cell in the third row. 
A)  Add all the values starting from the third cell to eighth cell in the third column. 
B)  Add all the values starting from the third cell to eighth cell in the third row. 
C)  Add the value of the third cell in the third column to the eighth cell in the third column. 
D)  Add the value of the third cell in the third row to the eighth cell in the third row.

Question 7

The rows in an Excel spreadsheet are identified by letters,and the columns are identified by numbers.

Accepted Answer

A) True 
 B)False

Question 8

In Excel,if the user clicks the center icons in the ________ section of the ribbon,the selected text will be centered both horizontally and vertically in the cell.

Accepted Answer

A)  font 
B)  alignment 
C)  styles 
D)  editing 
A)  font 
B)  alignment 
C)  styles 
D)  editing

Question 9

In Excel,which of the following tabs can be used for filtering and sorting the data in the user's spreadsheet?

Accepted Answer

A)  DATA 
B)  REVIEW 
C)  INSERT 
D)  HOME 
A)  DATA 
B)  REVIEW 
C)  INSERT 
D)  HOME

Question 10

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

Accepted Answer

A)  workbook 
B)  balance sheet 
C)  worksheet 
D)  gridline 
A)  workbook 
B)  balance sheet 
C)  worksheet 
D)  gridline

Question 11

If a user enters "jan" and "feb" in cells E1 and E2,selects those two cells and drags the small black box to three more cells below them,then ________.

Accepted Answer

A)  the three cells remain empty 
B)  Excel displays an error message 
C)  the three cells display "jan, feb, jan" respectively 
D)  the three cells display "mar, apr, may" respectively 
A)  the three cells remain empty 
B)  Excel displays an error message 
C)  the three cells display "jan, feb, jan" respectively 
D)  the three cells display "mar, apr, may" respectively

Question 12

In Excel,the INSERT tab is used to add pictures,graphs,and hyperlinks.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

In Excel,the REVIEW tab is used to format a page for printing.

Accepted Answer

A) True 
 B)False

Question 15

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

Accepted Answer

A)  menu tab 
B)  task pane 
C)  gridline 
D)  ribbon 
A)  menu tab 
B)  task pane 
C)  gridline 
D)  ribbon

Question 16

In Excel,to insert new rows,click the number of the row above which new rows are to be added,and then select the number of rows to be added.

Accepted Answer

A) True 
 B)False

Question 17

In 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 18

What are the different ways of entering data into an Excel worksheet?

Accepted Answer

Data can be entered into an Ex

Question 19

Data can be imported to Excel from other programs.

Accepted Answer

A) True 
 B)False

Question 20

Explain the process of naming the rows,columns,and cells in Microsoft Excel.

Accepted Answer

Excel spreadsheets have rows and columns

Exam 16: Introduction to Microsoft Excel 2013

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

A user types in a1 and a2 in the cells G1 and G2: If the user selects those two cells and drags the small black box to the four cells below them,then the four cells ________.

In Excel,every formula must begin with an equal sign.

While copying a formula,Excel can adjust the terms of the formula to refer to the cells in the row to which it is copied.

Selecting the $ English (U.S.)option displays numbers with a dollar sign and two decimal places.

In an Excel sheet,what is the meaning of the formula =SUM(C3:C8)?

The rows in an Excel spreadsheet are identified by letters,and the columns are identified by numbers.

In Excel,if the user clicks the center icons in the ________ section of the ribbon,the selected text will be centered both horizontally and vertically in the cell.

In Excel,which of the following tabs can be used for filtering and sorting the data in the user's spreadsheet?

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

If a user enters "jan" and "feb" in cells E1 and E2,selects those two cells and drags the small black box to three more cells below them,then ________.

In Excel,the INSERT tab is used to add pictures,graphs,and hyperlinks.

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

In Excel,the REVIEW tab is used to format a page for printing.

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

In Excel,to insert new rows,click the number of the row above which new rows are to be added,and then select the number of rows to be added.

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

What are the different ways of entering data into an Excel worksheet?

Data can be imported to Excel from other programs.

Explain the process of naming the rows,columns,and cells in Microsoft Excel.

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organizations and Information Systems

Social Media Information Systems

Business Intelligence Systems

Information Systems Development

Information Systems Management

Information Security Management

Collaboration Information Systems for Decision Making problem Solving and Project Management

Collaborative Information Systems for Student Projects

Mobile Systems

Database Design

Using Microsoft Access 2013

Using Excel and Access Together

Network and Cloud Technology

Enterprise Resource Planning ERP Systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems GIS

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters