Question 1

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 A

Question 2

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

Question 3

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

Accepted Answer

To insert new rows in Microsoft Excel,click the number of the row above which you want new rows and select as many rows as you want to insert,left-click,and then select Insert:The new rows would be inserted above the selected row:To add columns in Microsoft Excel,click the name of the column before which you want to insert columns,select as many columns to the right of that as you want to add,right-click,and then select Insert.

Question 4

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

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

Excel lacks features that can add data based on a pattern.

Accepted Answer

A) True 
 B)False

Question 11

In an Excel spreadsheet,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 12

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

Accepted Answer

A) True 
 B)False

Question 13

In Excel,________.

Accepted Answer

A)  only 26 columns are present 
B)  an entire row cannot be deleted 
C)  only numbers are recognized as patterns and used to fill data 
D)  a formula that does not start with an equal sign is considered as plain text 
A)  only 26 columns are present 
B)  an entire row cannot be deleted 
C)  only numbers are recognized as patterns and used to fill data 
D)  a formula that does not start with an equal sign is considered as plain text

Question 14

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

Accepted Answer

Excel can be used to work with a number

Question 15

In Excel,________ refers to whether the worksheet is printed normally or sideways on the page.

Accepted Answer

A)  font 
B)  orientation 
C)  alignment 
D)  gridline 
A)  font 
B)  orientation 
C)  alignment 
D)  gridline

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

What is a spreadsheet?

Accepted Answer

A spreadsheet is a table of data having

Question 19

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)  configuring the appearance of Excel 
A)  creating more complex formulas 
B)  filtering and sorting data in the spreadsheet 
C)  tracking changes and making comments 
D)  configuring the appearance of Excel

Question 20

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

Accepted Answer

A) True 
 B)False

Exam 16: Introduction to Microsoft Excel 2013

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

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 inserting rows and columns in Microsoft Excel.

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

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.

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

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

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

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

Excel lacks features that can add data based on a pattern.

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

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

In Excel,________.

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

In Excel,________ refers to whether the worksheet is printed normally or sideways on the page.

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.

What is a spreadsheet?

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

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

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