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

To add graphs,hyperlinks,or images to an Excel worksheet,the ________ tab is used.

Accepted Answer

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

Question 3

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 4

What is a spreadsheet?

Accepted Answer

A spreadsheet is a table of data having

Question 5

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.

Question 6

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

Accepted Answer

A) spreadsheet 
B) notepad 
C) clip art 
D) pie chart 
A) spreadsheet 
B) notepad 
C) clip art 
D) pie chart

Question 7

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 8

A user enters a1 and a2 into cells G1 and G2,respectively.If the user selects those two cells and drags the small black box to the four cells below them,then the four cells will display ________.

Accepted Answer

A) a3,a4,a5,and a6 
B) b1,b2,c1,and c2 
C) A1,A2,A1,and A2 
D) a1,a2,a1,and a2 
A) a3,a4,a5,and a6 
B) b1,b2,c1,and c2 
C) A1,A2,A1,and A2 
D) a1,a2,a1,and a2

Question 9

Each cell in an Excel spreadsheet is identified by the data entered in it.

Accepted Answer

A) True 
 B)False

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A) True 
 B)False

Question 12

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 13

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

Accepted Answer

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

Question 14

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 15

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 16

In Excel,the PAGE LAYOUT tab is used to format a page,often for printing.

Accepted Answer

A) True 
 B)False

Question 17

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 18

In Excel,a single spreadsheet is known as a ________.

Accepted Answer

A) workbook 
B) note 
C) worksheet 
D) page 
A) workbook 
B) note 
C) worksheet 
D) page

Question 19

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 20

Whenever users have a problem with a calculation in Excel,they can press F2 to highlight the cells involved in that calculation.

Accepted Answer

A) True 
 B)False

Exam 16: Introduction to Microsoft Excel 2013

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.

To add graphs,hyperlinks,or images to an Excel worksheet,the ________ tab is used.

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

What is a spreadsheet?

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

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

In an Excel spreadsheet,rows are identified by ________.

A user enters a1 and a2 into cells G1 and G2,respectively.If the user selects those two cells and drags the small black box to the four cells below them,then the four cells will display ________.

Each cell in an Excel spreadsheet is identified by the data entered in it.

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

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

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

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

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

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?

In Excel,the PAGE LAYOUT tab is used to format a page,often for printing.

In an Excel spreadsheet,columns are identified by ________.

In Excel,a single spreadsheet is known as a ________.

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.

Whenever users have a problem with a calculation in Excel,they can press F2 to highlight the cells involved in that calculation.

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