Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

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

Accepted Answer

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

Question 5

Using the F2 function key is recommended when the user has a long value in a cell and needs to edit a letter or two without retyping the whole entry.

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) To add a column,click on the name of the column after which you want to insert new columns. 
B) To decrease the height of a row,drag the line between the line numbers up. 
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) To increase the size of a column,drag the line between the two columns in the column headings to the left. 
A) To add a column,click on the name of the column after which you want to insert new columns. 
B) To decrease the height of a row,drag the line between the line numbers up. 
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) To increase the size of a column,drag the line between the two columns in the column headings to the left.

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

import data from ano

Question 10

What is a spreadsheet?

Accepted Answer

A spreadsheet is a table of data having

Question 11

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

Accepted Answer

A) configuring the appearance of Excel 
B) filtering and sorting data in the spreadsheet 
C) tracking changes and making comments 
D) creating more complex formulas 
A) configuring the appearance of Excel 
B) filtering and sorting data in the spreadsheet 
C) tracking changes and making comments 
D) creating more complex formulas

Question 12

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

Accepted Answer

Excel can be used to work with a number

Question 13

If the months of a year have been entered in text form,Excel does not recognise it as a pattern.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

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

Question 15

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 16

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

Accepted Answer

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

Question 17

In an Excel spreadsheet,the rows are identified by ________.

Accepted Answer

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

Question 18

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 19

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

Accepted Answer

To insert new rows in Microsoft Excel,cl

Question 20

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 remain blank 
B) will display a1,a2,a1,and a2 
C) will display b1,b2,c1,and c2 
D) will display a3,a4,a5,and a6 
A) will remain blank 
B) will display a1,a2,a1,and a2 
C) will display b1,b2,c1,and c2 
D) will display a3,a4,a5,and a6

Exam 16: Introduction to Microsoft Excel 2013

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

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

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

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

Using the F2 function key is recommended when the user has a long value in a cell and needs to edit a letter or two without retyping the whole entry.

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

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

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

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

What is a spreadsheet?

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

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

If the months of a year have been entered in text form,Excel does not recognise it as a pattern.

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

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,every formula must begin with a(n)________ sign.

In an Excel spreadsheet,the rows are identified by ________.

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

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

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