Question 1

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

Accepted Answer

A) True 
 B)False  False

Question 2

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  False

Question 3

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

Accepted Answer

A) True 
 B)False  False

Question 4

Rachel is working on a spreadsheet to calculate financial ratios.She tabulates the values and begins creating a formula to calculate the ratios.Which of the following signs should Rachel remember to use at the beginning of her formula?

Accepted Answer

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

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

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

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 9

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

Accepted Answer

Excel spreadsheets have rows and columns

Question 10

In Excel, ________.

Accepted Answer

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

Question 11

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.

Question 12

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 13

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 14

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

Question 15

Nancy, a teacher, creates a table using Excel to list the number of students in her class.She uses rows and columns to add subject names and the grades received by each student.Nancy's table is also called a ________.

Accepted Answer

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

Question 16

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 17

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 18

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

Accepted Answer

A) True 
 B)False

Question 19

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 20

What is a spreadsheet?

Accepted Answer

A spreadsheet is a table of data having

Exam 16: Introduction to Microsoft Excel 2013

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

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

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

Rachel is working on a spreadsheet to calculate financial ratios.She tabulates the values and begins creating a formula to calculate the ratios.Which of the following signs should Rachel remember to use at the beginning of her formula?

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

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

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

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

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

In Excel, ________.

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?

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

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

Nancy, a teacher, creates a table using Excel to list the number of students in her class.She uses rows and columns to add subject names and the grades received by each student.Nancy's table is also called a ________.

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

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

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

In an Excel spreadsheet, columns are identified by ________.

What is a spreadsheet?

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