Spreadsheets

Question 1

electronic spreadsheet

Answer 1

a computer file created by spreadsheet software which allows users to input and organize data, create charts and perform data analysis

Question 2

Name two popular spreadsheet software

Answer 2

Microsoft Excel and Mac Numbers

Question 3

usage of electronic spreadsheet

Answer 3

to produce accounting reports, financial models, inventory reports, quotation and personal mail lists

Question 4

worksheet

Answer 4

contains cells to input data

Question 5

workbook

Answer 5

a spreadsheet file that contains one or more worksheets to organize data

Question 6

data on different worksheets can be _____

Answer 6

interdependent

Question 7

row number

Answer 7

1 to 1,048,576

Question 8

column letter

Answer 8

A to XFD

Question 9

cell

Answer 9

The intersection of a row and a column

Question 10

modify data in an active cell

Answer 10

Double-click the cell and then change the cell content in the cell

Question 11

different data formats in cells

Answer 11

• General
• Number
• Currency
• Percentage
• Date
• Time

Question 12

wrap text

Answer 12

merging and formatting cells so that the text does not overflow to the right but wraps around the cell

Question 13

When you enter too much text in a cell

Answer 13

if it is left-aligned it will overflow to the right on a single row

Question 14

Autofill

Answer 14

allows users to create a series of values based on the value of one or more selected cells adjacent to each other

Question 15

usage of autofill

Answer 15

to create number sequences, time lists, day lists, week lists, month lists and regular text patterns

Question 16

how to function autofill

Answer 16

• Use the fill handle (A tiny solid square located at the bottom right corner of a cell).
• Move the cursor above the fill handle and it will change to a cross +
• Drag it downwards to fill the cells below.

Question 17

Sorting

Answer 17

process of reordering the records according to a specific criterion

Question 18

how can sorting be performed in an Excel spreadsheet

Answer 18

by either simple sort list or sorting with multiple criteria

Question 19

Filtering

Answer 19

a function to select and display the records meeting the criteria specified by a user, leaving the rest of the records hidden

Question 20

Conditional formatting

Answer 20

can change the appearance of cells on the basis of conditions
that you specify

Question 21

chart

Answer 21

an important tool for data analysis and presentation

Question 22

chart usage

Answer 22

to visualize the relationship between data

Question 23

different chart types

Answer 23

• Column chart
• bar chart
• Line chart
• Pie chart
• Scatter chart
• Radar chart

Question 24

types of cell references

Answer 24

relative cell reference and absolute cell reference

Question 25

relative cell reference example

Answer 25

=A1+A2

Question 26

format of cell reference linking to cells in other worksheet

Answer 26

='7B grades' ! A1

Question 27

format of MAX function (example)

Answer 27

=MAX(A1:A4)

Question 28

format of MIN function (example)

Answer 28

=MIN(A1:A4)

Question 29

format of SUM function (example)

Answer 29

=SUM(A1:A4)

Question 30

format of AVERAGE function (example)

Answer 30

=AVERAGE(A1:A5)

Question 31

format of ROUND function (example)

Answer 31

=ROUND(A1,x) (x = round off to x decimal places) (round off to integar if x=0)

Question 32

format of COUNT function (example)

Answer 32

=COUNT(A1:A4)

Question 33

COUNT function

Answer 33

counts the number of cells that contain numbers (including dates and formula) as within the specified range

Question 34

format of COUNTIF function (example)

Answer 34

=COUNTIF(C1:C10, "=Apples")

Question 35

more than or equal to symbol in COUNTIF function

Answer 35

>=

Question 36

more than or equal to symbol in COUNTIF functions

Answer 36

>=

Question 37

not equal to symbol in COUNTIF function

Answer 37

<>

Question 38

format of IF function (example & meaning)

Answer 38

=IF(A1>=50,"pass","fail") Display "Pass" if the score is higher than or equal to 50. Otherwise display “Fail”.

Question 39

#VALUE!

Answer 39

shown when there is something wrong with the value

Question 40

#DIV/0!

Answer 40

shown when a number is divided by 0, which is not defined mathematically

Question 41

####

Answer 41

shown when cell is not wide enough to show the data (numeric data)

Question 42

#NAME?

Answer 42

shown when function is incomplete or contains spelling mistakes

Question 43

how does absolute cell reference work

Answer 43

When a formula is copied or moved to other cells, the absolute cell reference in the formula remains unchanged.

Question 44

absolute cell reference examples

Answer 44

$A$5

Question 45

The relative cell reference in the target cell is ________

Answer 45

changed accordingly