Question 1

When planning the layout of a spreadsheet,relevant data includes the ____ of an item being purchased.&#10;A) manufacture date&#10;B) cost&#10;C) patent number&#10;D) warranty

Accepted Answer

The cost of an item being purchased is relevant data when planning the layout of a spreadsheet as it helps in calculating total expenses, comparing prices across different vendors, and tracking budget. The other options such as manufacture date, patent number, and warranty are not directly relevant to planning the layout of a spreadsheet for tracking purchases.

Question 2

Tools on the Formulas tab provide pre-made functions to generate formulas.

Accepted Answer

The tools on the Formulas tab in Microsoft Excel do provide pre-made functions to generate formulas.

Question 3

When designing a spreadsheet,data ____ used in calculations should be separated from the rest of the worksheet.&#10;A) variables&#10;B) headings&#10;C) bars&#10;D) design

Accepted Answer

Variables refer to the data that is being used in calculations. It's important to separate these from the rest of the worksheet so they can be easily identified and updated if necessary. Headings are used to label columns and rows, bars aren't typically relevant in spreadsheet design, and design refers to the overall layout and formatting.

Question 4

As a student,you feel it is important to keep track of your current grade average in this class.From the choices below,select the Office application that should be utilized to accomplish this task.&#10;A) Word&#10;B) PowerPoint&#10;C) Excel&#10;D) Windows 7

Accepted Answer

Microsoft Excel is a spreadsheet application that is designed for organizing and manipulating data. Using Excel, a student can create a gradebook or tracker with formulas to calculate the current grade average based on assignments and exams completed.

Question 5

In Excel,you can fully display,or show only the results of ____________________.

Accepted Answer

The answer of In Excel,you can fully display,or show only...

Question 6

In a spreadsheet,____________________ call attention to important information.

Accepted Answer

The answer of In a spreadsheet,____________________ call attention to important...

Question 7

In Excel,a worksheet and a spreadsheet are the same thing.

Accepted Answer

In Excel, a worksheet and a spreadsheet are interchangeable terms used to refer to a single file containing a grid of cells where data can be inputted, stored, and manipulated.

Question 8

Data presented in spreadsheets is not useful in the management process of making financial decisions for a business.

Accepted Answer

Data presented in spreadsheets can be very useful in the management process of making financial decisions for a business. It allows users to organize and analyze data, perform calculations, create charts and graphs, and generate reports. However, it is important to ensure that the data is accurate and relevant to the decision-making process.

Question 9

Spreadsheets are best suited for decisions that need ____ support.&#10;A) qualitative&#10;B) quantitative&#10;C) graphical&#10;D) table

Accepted Answer

Spreadsheets are primarily designed to handle quantitative data manipulation and analysis. They are excellent tools for performing numerical calculations, statistical analyses, and other mathematically-oriented tasks. While tables and graphs can certainly be utilized in spreadsheets, they are not the primary focus or reason for their development. Qualitative support is also not well-suited for spreadsheets because they are not designed for subjective or interpretive decision-making processes.

Question 10

From the choices below,select a valid cell reference.&#10;A) 14B&#10;B) Z92&#10;C) E#6&#10;D) T?56

Accepted Answer

B) Z92 is a valid cell reference in spreadsheet programs like Microsoft Excel. It follows the standard format of a letter (or letters) followed by a number, where the letter(s) represent the column and the number represents the row.

Question 11

The ____ tab provides tools for formatting a worksheet.&#10;A) Format&#10;B) Insert&#10;C) Home&#10;D) Formulas

Accepted Answer

The answer of The ____ tab provides tools for formatting...

Question 12

The Home tab provides tools for displaying charts.

Accepted Answer

The answer of The Home tab provides tools for displaying...

Question 13

A well-formed spreadsheet is a document that is neatly organized and properly formatted to help support financial reporting and decision making.

Accepted Answer

The answer of A well-formed spreadsheet is a document that...

Question 14

In a spreadsheet,the intersection of a row and a column is referred to as a ____.&#10;A) cell&#10;B) grid&#10;C) worksheet&#10;D) workbook

Accepted Answer

The answer of In a spreadsheet,the intersection of a row...

Question 15

The first step in planning the layout of a spreadsheet is to ____.&#10;A) gather relevant data&#10;B) determine needed calculations&#10;C) identify the problem&#10;D) prepare an easy-to-read design

Accepted Answer

The answer of The first step in planning the layout...

Deck 93: Overview of Spreadsheets