Spreadsheets

Question 1

What are the three basic structures of spreadsheet software?

Answer 1

Cells, rows, and columns

Question 2

What is a cell in a spreadsheet?

Answer 2

The intersection of a row and column where data can be entered

Question 3

How are rows identified in a spreadsheet?

Answer 3

By numbers (1, 2, 3, etc.)

Question 4

How are columns identified in a spreadsheet?

Answer 4

By letters (A, B, C, etc.)

Question 5

What are the main data types that can be entered in spreadsheet cells?

Answer 5

Text, numbers, dates, times, and formulas

Question 6

What is the difference between text and number data types in spreadsheets?

Answer 6

Text is used for labels and descriptions, numbers can be used in calculations

Question 7

What is a spreadsheet template?

Answer 7

A pre-designed spreadsheet with formatting, formulas, and structure that can be reused

Question 8

What are headers and footers in spreadsheets?

Answer 8

Text that appears at the top (header) or bottom (footer) of every printed page

Question 9

What is conditional formatting?

Answer 9

A feature that automatically changes cell appearance based on the cell’s value or content

Question 10

Give an example of when you might use conditional formatting

Answer 10

To highlight cells with values above a certain threshold, like highlighting grades above 80% in green

Question 11

What is data validation in spreadsheets?

Answer 11

A feature that restricts the type of data that can be entered into a cell

Question 12

Give an example of data validation

Answer 12

Setting a cell to only accept whole numbers between 1 and 100

Question 13

What does importing data mean in spreadsheets?

Answer 13

Bringing data from external sources (like CSV files or databases) into the spreadsheet

Question 14

What is the difference between entering text and entering a formula in a cell?

Answer 14

Text is entered directly, formulas start with an equals sign (=) and perform calculations

Question 15

How do you enter a formula in a spreadsheet cell?

Answer 15

Start with an equals sign (=) followed by the calculation or function

Question 16

What formatting options are available for cells?

Answer 16

Font style, size, color, borders, background color, number format, alignment

Question 17

How can you format an entire row or column?

Answer 17

Select the row number or column letter, then apply formatting options

Question 18

What does replicating a formula mean?

Answer 18

Copying a formula to other cells, with cell references automatically adjusting

Question 19

How do you replicate a formula to adjacent cells?

Answer 19

Use the fill handle (small square at bottom-right of cell) and drag to copy

Question 20

What should you consider when creating a template for others to use?

Answer 20

Clear labels, instructions, protected formulas, consistent formatting, and user-friendly layout

Question 21

Name three simple functions commonly used in spreadsheets

Answer 21

SUM, AVERAGE, COUNT

Question 22

What does the SUM function do?

Answer 22

Adds up all the numbers in a selected range of cells

Question 23

What does the AVERAGE function do?

Answer 23

Calculates the mean (average) of numbers in a selected range

Question 24

What is the difference between relative and absolute cell referencing?

Answer 24

Relative references change when copied (A1), absolute references stay fixed ($A$1)

Question 25

How do you make a cell reference absolute?

Answer 25

Add dollar signs before the column letter and row number ($A$1)

Question 26

When would you use absolute cell referencing?

Answer 26

When you want to refer to a fixed cell (like a tax rate) that shouldn't change when copying formulas

Question 27

What is an IF statement in spreadsheets?

Answer 27

A logical function that returns one value if a condition is true, another if false

Question 28

Write the basic syntax for an IF statement

Answer 28

=IF(condition, value_if_true, value_if_false)

Question 29

Give an example of an IF statement

Answer 29

=IF(A1>50,"Pass","Fail") - shows Pass if A1 is greater than 50, otherwise Fail

Question 30

What does VLOOKUP stand for?

Answer 30

Vertical Lookup

Question 31

What is the purpose of VLOOKUP?

Answer 31

To search for a value in the first column of a table and return a value from another column in the same row

Question 32

What are the four arguments needed for VLOOKUP?

Answer 32

Lookup value, table array, column index number, range lookup (TRUE/FALSE)

Question 33

What is data modelling in spreadsheets?

Answer 33

Using spreadsheets to represent real-world situations with data, formulas, and scenarios

Question 34

Give an example of data modelling

Answer 34

Creating a budget model that shows how changes in income or expenses affect total savings

Question 35

What types of charts can you create in spreadsheets?

Answer 35

Bar charts, line graphs, pie charts, scatter plots, column charts

Question 36

Why is it important to label charts properly?

Answer 36

To make the data clear and understandable, including titles, axis labels, and legends

Question 37

What formatting options are available for charts?

Answer 37

Colors, fonts, chart style, data labels, gridlines, chart title, axis titles

Question 38

How do you select specific areas of a spreadsheet for printing?

Answer 38

Use Page Layout options to set print area, or select the range and choose 'Print Selection'

Question 39

Why might you want to print only part of a spreadsheet?

Answer 39

To save paper, focus on relevant data, or create reports with specific information

Question 40

What is a macro in spreadsheets?

Answer 40

A recorded sequence of actions that can be replayed automatically

Question 41

When would you use a macro?

Answer 41

To automate repetitive tasks like formatting, calculations, or data entry

Question 42

What are the benefits of using macros?

Answer 42

Saves time, reduces errors, ensures consistency, automates complex tasks

Question 43

How do you typically create a simple macro?

Answer 43

Record your actions while performing a task, then save the recording as a macro

Question 44

What precautions should you take when using macros?

Answer 44

Test thoroughly, backup data, understand what the macro does, be cautious with macros from unknown sources