Question 1

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

Accepted Answer

A) True 
 B)False

Question 2

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 3

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

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 6

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 7

You can not add a row or column to excel if there is data in the cell.

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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 13

Excel spreadsheets can only be printed with gridlines visible.

Accepted Answer

A) True 
 B)False

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

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

Accepted Answer

A) True 
 B)False

Question 16

The real power of Excel lies in its amazing computational capability. Explain.

Accepted Answer

Excel can be used to work with a number

Question 17

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

Accepted Answer

A) True 
 B)False

Question 18

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 19

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

Accepted Answer

A) True 
 B)False

Question 20

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

Exam 16: Introduction to Microsoft Excel 2016

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

In Excel, ________.

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

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?

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?

In Excel, the REVIEW tab is used for ________.

You can not add a row or column to excel if there is data in the cell.

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

In an Excel spreadsheet, rows are identified by ________.

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

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

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

Excel spreadsheets can only be printed with gridlines visible.

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

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

The real power of Excel lies in its amazing computational capability. Explain.

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

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

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

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

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