Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

To save a worksheet in Excel,the Save option in the Edit menu is used.

Accepted Answer

A) True 
 B)False

Question 3

The portion of the spreadsheet to be printed can be specified using Margins.

Accepted Answer

A) True 
 B)False

Question 4

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

Accepted Answer

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

Question 5

Data can be imported to Excel from other programs.

Accepted Answer

A) True 
 B)False

Question 6

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 divide the corresponding value in another column by 100 and sequentially display those results in each of those cells. 
B) Excel will display the value 100 in all of those cells. 
C) All of those cells will remain blank. 
D) Excel will display values that progressively increase by 100 in each of those cells. 
A) Excel will divide the corresponding value in another column by 100 and sequentially display those results in each of those cells. 
B) Excel will display the value 100 in all of those cells. 
C) All of those cells will remain blank. 
D) Excel will display values that progressively increase by 100 in each of those cells.

Question 7

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

Accepted Answer

Excel spreadsheets have rows and columns

Question 8

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

Question 9

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

Accepted Answer

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

Question 10

To add graphs,hyperlinks,or images to an Excel worksheet,the ________ tab is used.

Accepted Answer

A) VIEW 
B) FORMAT 
C) INSERT 
D) DATA 
A) VIEW 
B) FORMAT 
C) INSERT 
D) DATA

Question 11

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 12

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

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

Question 14

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 15

If a spreadsheet is printed sideways on a page,the orientation is said to be Portrait.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Accepted Answer

A) gridline 
B) cell 
C) ribbon 
D) node 
A) gridline 
B) cell 
C) ribbon 
D) node

Exam 16: Introduction to Microsoft Excel 2013

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

To save a worksheet in Excel,the Save option in the Edit menu is used.

The portion of the spreadsheet to be printed can be specified using Margins.

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

Data can be imported to Excel from other programs.

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?

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

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

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

To add graphs,hyperlinks,or images to an Excel worksheet,the ________ tab is used.

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

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

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

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.

If a spreadsheet is printed sideways on a page,the orientation is said to be Portrait.

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

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

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

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

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

The Importance of Mis

Business Processes, Information Systems and Information

Organisational Strategy, Information Systems and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Organisations 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

Collaboration 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 Organisations and Knowledge Management

Database Marketing

Reporting Systems and Olap

Systems Development Project Management

Agile Development

Business Process Management

International Mis

Filters