Question 1

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

Which of the following is true of the printing option in Excel spreadsheets?

Accepted Answer

A) Gridlines can only be viewed in the print preview and cannot be printed. 
B) Print Preview is present in the Review tab. 
C) Landscape orientation prints a worksheet upright. 
D) Print area can be used to specify the portion of the spreadsheet to be printed. 
A) Gridlines can only be viewed in the print preview and cannot be printed. 
B) Print Preview is present in the Review tab. 
C) Landscape orientation prints a worksheet upright. 
D) Print area can be used to specify the portion of the spreadsheet to be printed.

Question 3

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 4

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

Question 5

A user enters a formula into cell G9.Which of the following would be possible if the user presses the F2 function key after selecting the cell G9?

Accepted Answer

A) The formula in G9 can be edited without retyping the entire formula. 
B) The formula can be copied to the clipboard. 
C) A graph can be created based on the cells that appear in the formula. 
D) The formula in the cell can be locked. 
A) The formula in G9 can be edited without retyping the entire formula. 
B) The formula can be copied to the clipboard. 
C) A graph can be created based on the cells that appear in the formula. 
D) The formula in the cell can be locked.

Question 6

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 7

Joe is working on a business presentation on his company's sales figures for the previous quarter.He needs to add a graph to his Excel worksheet showing the difference in sales figures of different quarters.Which of the following tabs will Joe use to add the graph?

Accepted Answer

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

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

In an Excel spreadsheet, rows are identified by ________.

Which of the following is true of the printing option in Excel spreadsheets?

In Excel, the REVIEW tab is used for ________.

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

A user enters a formula into cell G9.Which of the following would be possible if the user presses the F2 function key after selecting the cell G9?

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.

Joe is working on a business presentation on his company's sales figures for the previous quarter.He needs to add a graph to his Excel worksheet showing the difference in sales figures of different quarters.Which of the following tabs will Joe use to add the graph?

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

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems

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

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 Erpsystems

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

Exam 16: Introduction to Microsoft Excel 2013

In an Excel spreadsheet, rows are identified by ________.

Which of the following is true of the printing option in Excel spreadsheets?

In Excel, the REVIEW tab is used for ________.

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

A user enters a formula into cell G9.Which of the following would be possible if the user presses the F2 function key after selecting the cell G9?

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.

Joe is working on a business presentation on his company's sales figures for the previous quarter.He needs to add a graph to his Excel worksheet showing the difference in sales figures of different quarters.Which of the following tabs will Joe use to add the graph?

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

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems

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

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 Erpsystems

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