Question 1

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

Accepted Answer

A) True 
 B)False  True

Question 2

In Excel,a sequence of tabs that appear in a horizontal line,just below the Excel icon,controls the contents of the ribbon.

Accepted Answer

A) True 
 B)False  True

Question 3

If a user enters the value 100 into cell G1,presses Enter,and then clicks the 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) All of those cells' values will be multiplied by 100. 
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) All of those cells' values will be multiplied by 100. C

Question 4

The ________ section of the ribbon in Excel enables selected text to be centered both horizontally and vertically in a cell.

Accepted Answer

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

Question 5

In Excel,which of the following tabs is used for filtering and sorting information in a spreadsheet?

Accepted Answer

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

Question 6

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

Accepted Answer

A) layout 
B) orientation 
C) alignment 
D) setup 
A) layout 
B) orientation 
C) alignment 
D) setup

Question 7

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

Accepted Answer

A) To add a column,click the name of the column before which new columns are needed and select as many columns to the right as required. 
B) To increase the size of a column,drag the line between the two columns in the column headings to the left. 
C) To insert new rows,click the number of the row below which new rows are needed and select as many rows below as required. 
D) To decrease the height of a row,drag the line between the line numbers down. 
A) To add a column,click the name of the column before which new columns are needed and select as many columns to the right as required. 
B) To increase the size of a column,drag the line between the two columns in the column headings to the left. 
C) To insert new rows,click the number of the row below which new rows are needed and select as many rows below as required. 
D) To decrease the height of a row,drag the line between the line numbers down.

Question 8

In Excel,the REVIEW tab is used for ________.

Accepted Answer

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

Question 9

In Excel,when the HOME tab is selected,the contents of the ribbon concern charts,filter,tables,and so forth.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

Excel spreadsheets have rows and columns

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

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

Question 13

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

Accepted Answer

A) node 
B) grid 
C) cell 
D) junction 
A) node 
B) grid 
C) cell 
D) junction

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

If the months of a year are entered in the text form,then Excel does not recognize them as a pattern.

Accepted Answer

A) True 
 B)False

Question 16

Excel creates multiple worksheets when a new workbook is created.

Accepted Answer

A) True 
 B)False

Question 17

In Excel,the FORMULAS tab is used for creating complex formulas.

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A) True 
 B)False

Question 19

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

Accepted Answer

A) True 
 B)False

Question 20

The tools and selections in the PAGE LAYOUT ribbon determine how a document will be arranged as a printed document.

Accepted Answer

A) True 
 B)False

Exam 16: Introduction to Microsoft Excel 2013

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

In Excel,a sequence of tabs that appear in a horizontal line,just below the Excel icon,controls the contents of the ribbon.

If a user enters the value 100 into cell G1,presses Enter,and then clicks the 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 ________ section of the ribbon in Excel enables selected text to be centered both horizontally and vertically in a cell.

In Excel,which of the following tabs is used for filtering and sorting information in a spreadsheet?

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

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

In Excel,the REVIEW tab is used for ________.

In Excel,when the HOME tab is selected,the contents of the ribbon concern charts,filter,tables,and so forth.

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

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

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

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

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

If the months of a year are entered in the text form,then Excel does not recognize them as a pattern.

Excel creates multiple worksheets when a new workbook is created.

In Excel,the FORMULAS tab is used for creating complex formulas.

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

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

The tools and selections in the PAGE LAYOUT ribbon determine how a document will be arranged as a printed document.

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 Security

Information Systems Management

Information Systems Development

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

Enterprise Social Networks and Knowledge Management

Database Marketing

Reporting Systems and OLAP

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters