Module 5 - Spreadsheets

Question 1

What can an electronic spreadsheet contribute for the business world?

Answer 1

Build Great Charts
Use conditional Formatting
Help Identify Trends
Bring data Together
Online access
Problem solving and decision support

Question 2

There are different charts that an electronic spreadsheet could present data. To name a few, pie charts, graphs and clustered columns. These charts add visualizations and extra emphasis to business reports and marketing materials

Answer 2

Build great charts

Question 3

With the help of ________________, you can display related data, you can compare values using different colors, bolds and italics. You can also find the duplicates and differentiate between columns.

Answer 3

Use conditional formatting

Question 4

Electronic spreadsheet is a good tool to present forecasts and trends in the form of graphs or charts. Average lines give emphasis and will explicitly detail key trends that emerge based on the information generated

Answer 4

Help identify trends

Question 5

Spreadsheet is a good tool to bring information together. For example,
using MS Excel, you can create a single location for your different files and documents by adding them into different worksheets in a single
spreadsheet document. Objects can also be added into the file using
the Insert Tab feature. It is even possible to import images and text into
your document.

Answer 5

Bring data together

Question 6

With the use of the Internet, it is possible to access spreadsheet on your mobile phones or web-enabled laptop or PC. You can even add collaborators for your document like how Google Spreadsheet is used
for online collaboration.

Answer 6

Online access

Question 7

Lastly, with the different features of a spreadsheet, this is a good tool
even for problem solving and decision support. The simplest example
for this feature is the use of Pivot table in MS Excel.

Answer 7

Problem solving and decision support

Question 8

Is the term to refer to a single spreadsheet document.

Answer 8

Workbook

Question 9

refers to an individual sheet that can be contained in a single workbook.

Answer 9

Worksheet

Question 10

refers to the row of buttons displayed in a working sheet

Answer 10

Ribbons

Question 11

refers to a single box within the worksheet

Answer 11

Cell

Question 12

shows the name of the current cell. Example is A1 or AB21.

Answer 12

Name box

Question 13

In a spreadsheet document is always preceded with an equal sign (=). Are used for you to perform mathematical calculations

Answer 13

Formula

Question 14

This is where the contents of the
active cell or the current cell are shown

Answer 14

Formula bar

Question 15

are the built-in formulas in an electronic spreadsheet to perform commonly used mathematical calculations. Instead of taking the sum of all the numbers then divide with the number of items, you
can just use the AVERAGE()

Answer 15

Function

Question 16

refers to the grouping of consecutive cells

Answer 16

Array/Range

Question 17

A fast way to add up this column of numbers is to click on the cell below
the numbers and then:

Answer 17

Click the AutoSum button on the Standard toolbar, then press
ENTER

Question 18

If you want to paste a formula result — but not the underlying formula — to another cell. You would copy the cell with the formula, then place the insertion point in the cell you want to copy to. What next?

Answer 18

Click the arrow on the Paste button on the Standard toolbar, then
click Values.

Question 19

How do you change the column width to fit the contents?

Answer 19

Double-click the boundary to the right of the column heading.

Question 20

Which formula can add all the numeric values in a range of cells, ignoring those which are not numeric, and place the result in a different cell?

Answer 20

SUM

Question 21

When this displays in the active cell: ####, what does it mean?

Answer 21

The cell is not wide enough to display the numbers.