Question 1

A new row can be inserted at the desired point in an Excel worksheet by selecting the row below which you want to add the new row and clicking insert.

Accepted Answer

A) True 
 B)False  False

Question 2

Explain spreadsheets.

Accepted Answer

A spreadsheet is a table of data having rows and columns and is used to make calculations and data processing.Electronic spreadsheets provide incredible labor savings over paper spreadsheets and were a major factor in the early adoption of personal computers.Microsoft Excel is the most popular spreadsheet.

Question 3

In Microsoft Excel,the intersection of a row and column is called a(n)________.

Accepted Answer

A)  junction 
B)  content point 
C)  cell 
D)  data point 
A)  junction 
B)  content point 
C)  cell 
D)  data point C

Question 4

The option to disable the grid view of an Excel worksheet appears in the View ribbon.

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

The real power of Excel lies in its amazing computational capability.Explain.

Accepted Answer

Excel can be used to work with a number

Question 7

To save a worksheet in Microsoft Excel,you use the Save option in the Edit menu.

Accepted Answer

A) True 
 B)False

Question 8

In Excel,a ________ is a combination of one or more worksheets.

Accepted Answer

A)  dashboard 
B)  workbook 
C)  batch 
D)  datasheet 
A)  dashboard 
B)  workbook 
C)  batch 
D)  datasheet

Question 9

A portion of the spreadsheet to be printed can be specified using the Print Preview feature.

Accepted Answer

A) True 
 B)False

Question 10

In Microsoft Excel,most frequently used tools and selections appear under the ________ tab.

Accepted Answer

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

Question 11

In Excel,the Review tab can be used for ________.

Accepted Answer

A)  creating more complex formulas 
B)  filtering and sorting data in the spreadsheet 
C)  tracking changes and making comments 
D)  formatting the page, often for printing 
A)  creating more complex formulas 
B)  filtering and sorting data in the spreadsheet 
C)  tracking changes and making comments 
D)  formatting the page, often for printing

Question 12

The Add-Ins tab contains the nonstandard features that have been added to Excel.

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

Excel spreadsheets have rows and columns

Question 14

Data can be imported to Microsoft Excel from other programs.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is the correct method for accessing Microsoft Help?

Accepted Answer

A)  It can be accessed by clicking the question mark in the office button that appears at the upper left-corner of the Excel window. 
B)  It can be accessed by clicking the question mark in the upper right-hand corner of the ribbon on the Excel window. 
C)  It can be accessed by clicking the question mark in the status bar that appears at the very bottom of the Excel window. 
D)  It can be accessed by clicking the question mark present on the title bar of the Excel window. 
A)  It can be accessed by clicking the question mark in the office button that appears at the upper left-corner of the Excel window. 
B)  It can be accessed by clicking the question mark in the upper right-hand corner of the ribbon on the Excel window. 
C)  It can be accessed by clicking the question mark in the status bar that appears at the very bottom of the Excel window. 
D)  It can be accessed by clicking the question mark present on the title bar of the Excel window.

Question 16

The Review tab can be used for filtering and sorting data in a spreadsheet.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

Data can be entered into an Ex

Question 18

When adding graphs,hyperlinks,or images to a Microsoft Excel worksheet,you use the ________ tab.

Accepted Answer

A)  Data 
B)  Format 
C)  View 
D)  Insert 
A)  Data 
B)  Format 
C)  View 
D)  Insert

Question 19

Using the F2 key is recommended when you have a long value in a cell and need to edit a letter or two without retyping the whole entry.

Accepted Answer

A) True 
 B)False

Question 20

In Microsoft Excel,you would use the Review tab to format your page for printing.

Accepted Answer

A) True 
 B)False

Exam 17: Introduction to Microsoft Excel

A new row can be inserted at the desired point in an Excel worksheet by selecting the row below which you want to add the new row and clicking insert.

Explain spreadsheets.

In Microsoft Excel,the intersection of a row and column is called a(n)________.

The option to disable the grid view of an Excel worksheet appears in the View ribbon.

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

The real power of Excel lies in its amazing computational capability.Explain.

To save a worksheet in Microsoft Excel,you use the Save option in the Edit menu.

In Excel,a ________ is a combination of one or more worksheets.

A portion of the spreadsheet to be printed can be specified using the Print Preview feature.

In Microsoft Excel,most frequently used tools and selections appear under the ________ tab.

In Excel,the Review tab can be used for ________.

The Add-Ins tab contains the nonstandard features that have been added to Excel.

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

Data can be imported to Microsoft Excel from other programs.

Which of the following is the correct method for accessing Microsoft Help?

The Review tab can be used for filtering and sorting data in a spreadsheet.

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

When adding graphs,hyperlinks,or images to a Microsoft Excel worksheet,you use the ________ tab.

Using the F2 key is recommended when you have a long value in a cell and need to edit a letter or two without retyping the whole entry.

In Microsoft Excel,you would use the Review tab to format your page for printing.

The Importance of MIS

Business Processes, Information, and Information Systems

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

Data Communications

Business Process Management

E-Commerce, Web 2.0, and Social Networking

Business Intelligence and Information Systems for Decision Making

Information Systems Development

Information Systems Management

Information Security Management

Improving Your Collaboration Skills

Using Collaboration Information Systems

Information Systems and Decision Making

Knowledge Management and Expert Systems

Preparing a Computer Budget Using Excel

Database Design

Using Microsoft Access 2010

Using Excel and Access Together

Remote, Nomadic, and Mobile Systems

Functional Processes, Applications, and Systems

Enterprise Resource Planning (ERP)Systems

Supply Chain Management

Processing Social Capital: Facebook, Twitter, and User-Generated Content (UGC)

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Business Process Management

Systems Development Project Management

Outsourcing

International MIS

Filters