Question 1

In Excel, to insert new rows, click the number of the row above which new rows need to be added, and then select the number of rows to be added.

Accepted Answer

A) True 
 B)False

Question 2

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 3

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 4

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

Accepted Answer

Data can be entered into an Excel worksh

Question 5

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

Question 6

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

If a user enters "jan" and "feb" in cells E1 and E2, respectively, selects those two cells and drags the small black box to three more cells below them, then ________.

Accepted Answer

A)  the three cells will remain empty 
B)  Excel will display an error message 
C)  the three cells will display "jan," "feb," and "jan," respectively 
D)  the three cells will display "mar," "apr," and "may," respectively 
A)  the three cells will remain empty 
B)  Excel will display an error message 
C)  the three cells will display "jan," "feb," and "jan," respectively 
D)  the three cells will display "mar," "apr," and "may," respectively

Question 8

Angelo's spreadsheet has more columns than rows therefore he wants a sideways or Landscape print of the sheet. His secretary, however, gets an upright print. Angelo asks his secretary to take another print because he was unhappy with the ________.

Accepted Answer

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

Question 9

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 10

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 11

For general work in Excel spreadsheets, the tools and selection under the DATA tab are most useful.

Accepted Answer

A) True 
 B)False

Question 12

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

Accepted Answer

Excel spreadsheets have rows and columns

Question 13

Data can be imported to Excel from other programs.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

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

Question 16

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 17

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

Accepted Answer

A) True 
 B)False

Exam 16: Introduction to Microsoft Excel 2016

In Excel, to insert new rows, click the number of the row above which new rows need to be added, and then select the number of rows to be added.

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?

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

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

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

In an Excel spreadsheet, columns are identified by ________.

If a user enters "jan" and "feb" in cells E1 and E2, respectively, selects those two cells and drags the small black box to three more cells below them, then ________.

Angelo's spreadsheet has more columns than rows therefore he wants a sideways or Landscape print of the sheet. His secretary, however, gets an upright print. Angelo asks his secretary to take another print because he was unhappy with the ________.

In Excel, which of the following tabs is used for filtering and sorting information in a 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.

For general work in Excel spreadsheets, the tools and selection under the DATA tab are most useful.

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

Data can be imported to Excel from other programs.

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

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

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

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

The Importance of Mis

Business Processes, Information Systems, and Information

Organizational Strategy, Information Systems, and Competitive Advantage

Hardware and Software

Database Processing

The Cloud

Processes, 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 2016

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

Artificial Intelligence and Automation

Data Breaches

International Mis

Systems Development Project Management

Agile Development

Business Process Management

Filters