Question 1

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 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. 
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 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 2

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 3

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

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

To insert new rows in Microsoft Excel,cl

Question 5

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 6

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

Accepted Answer

A) datasheet 
B) matrix 
C) worksheet 
D) gridline 
A) datasheet 
B) matrix 
C) worksheet 
D) gridline

Question 7

When adding graphs,hyperlinks,or images to an 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 8

An Excel workbook is a collection of one or more spreadsheets.

Accepted Answer

A) True 
 B)False

Question 9

Which of the following is true of rows and columns in Excel?

Accepted Answer

A) To add a column,click the name of the column after which you want to insert columns. 
B) The cursor is moved to the left to increase the size of the column. 
C) To insert new rows,click the number of the row below which you want new rows,and select as many rows as you want to insert. 
D) The cursor is dragged up to decrease the height of the row. 
A) To add a column,click the name of the column after which you want to insert columns. 
B) The cursor is moved to the left to increase the size of the column. 
C) To insert new rows,click the number of the row below which you want new rows,and select as many rows as you want to insert. 
D) The cursor is dragged up to decrease the height of the row.

Question 10

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

Accepted Answer

Excel can be used to work with a number

Question 11

The ________ tab is used for configuring the appearance of Excel.

Accepted Answer

A) View 
B) Review 
C) Data 
D) Home 
A) View 
B) Review 
C) Data 
D) Home

Question 12

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

Accepted Answer

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

Question 13

In Excel,the rows are identified by ________.

Accepted Answer

A) letters 
B) numbers 
C) Roman numerals 
D) symbols 
A) letters 
B) numbers 
C) Roman numerals 
D) symbols

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

You have entered a formula in the cell G9.Which of the following would occur if you press the 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. 
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 16

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

Accepted Answer

Data can be entered into an Ex

Question 17

A ________ is a table of data having rows and columns.

Accepted Answer

A) spreadsheet 
B) matrix 
C) gridline 
D) library 
A) spreadsheet 
B) matrix 
C) gridline 
D) library

Question 18

If a user types the value 100 into cell G1,presses Enter,and then clicks cell G1,a rectangle will be drawn around the cell with a little black box in the lower right-hand corner.Which of the following occurs if the user drags that little black box down to cell G7?

Accepted Answer

A) Excel will fill in the value 100 multiplied by the number of cells in each of those cells. 
B) All of those cells will remain blank. 
C) Excel will fill in the value 100 into all of those cells. 
D) Excel will divide the corresponding value sequentially in each of those cells. 
A) Excel will fill in the value 100 multiplied by the number of cells in each of those cells. 
B) All of those cells will remain blank. 
C) Excel will fill in the value 100 into all of those cells. 
D) Excel will divide the corresponding value sequentially in each of those cells.

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

What is a spreadsheet in Excel?

Accepted Answer

A spreadsheet is a table of data having

Exam 15: Introduction to Microsoft Excel 2010

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

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

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

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

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

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

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

An Excel workbook is a collection of one or more spreadsheets.

Which of the following is true of rows and columns in Excel?

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

The ________ tab is used for configuring the appearance of Excel.

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

In Excel,the rows are identified by ________.

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

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

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

A ________ is a table of data having rows and columns.

If a user types the value 100 into cell G1,presses Enter,and then clicks cell G1,a rectangle will be drawn around the cell with a little black box in the lower right-hand corner.Which of the following occurs if the user drags that little black box down to cell G7?

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

What is a spreadsheet in Excel?

The Importance of Mis

Business Processes information Systems and Information

Organizational Strategy information Systems and Competitive Advantage

Hardware and Software

Database Processing

Data Communication and 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

Database Design

Using Microsoft Access 2010

Using Excel and Access Together

Mobile Systems

Functional Applications

Enterprise Resource Planning ERP systems

Supply Chain Management

Hyper-Social Organizations and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Geographic Information Systems

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters