IGCSE ICT - Spreadsheets

Question 1

To insert a row into a spreadsheet, you should

Accepted Answer

Right-click the row number and select Insert

Question 2

Which of the following describes the process of adjusting row height in an Excel spreadsheet?

Accepted Answer

Both A and B are correct

Question 3

Which formula would you use to add the contents of cells B2 and B3?

Accepted Answer

=B2+B3

Question 4

Which of the following symbols is used for multiplication in Excel?

Accepted Answer

*

Question 5

To change the page orientation to landscape, you should

Accepted Answer

Use the Page Layout tab

Question 6

Which operator is used for division in Excel?

Accepted Answer

/

Question 7

To protect a worksheet from being edited, you should

Accepted Answer

Use the Review tab and select Protect Sheet

Question 8

The formula =B2/$A$1 is an example of:

Accepted Answer

Mixed referencing

Question 9

How do you make a cell reference absolute in Excel?

Accepted Answer

By adding a $ symbol

Question 10

Which of the following is a valid Excel formula to subtract the value in cell B3 from B2?

Accepted Answer

=B2-B3

Question 11

If cell A1 contains the value 5, what will the formula =A1*2 display?

Accepted Answer

10

Question 12

What does the formula =SUM(A1) do?

Accepted Answer

Adds all values in cells A1 through A5

Question 13

To apply conditional formatting, you should

Accepted Answer

Use the Home tab and select Conditional Formatting

Question 14

If you need to ensure the accuracy of data entry in Excel, you should

Accepted Answer

Use data validation

Question 15

If you want to sort data in ascending order, you should:

Accepted Answer

Use the Data tab and select Sort A to Z

Question 16

What is a data model in the context of spreadsheets?

Accepted Answer

A spreadsheet used to explore different possible answers

Question 17

To create a bar chart from selected data, you should

Accepted Answer

Use the Insert tab and select Bar Chart

Question 18

What does the formula =A4^2 calculate?

Accepted Answer

The reciprocal of the value in A4

Question 19

What function would you use to find the average of a range of cells in Excel?

Accepted Answer

AVERAGE

Question 20

What does the function =MAX(A1) do?

Accepted Answer

Finds the maximum value in the range A1 to A10

Question 21

To adjust the width of a column to fit the contents automatically, you should:

Accepted Answer

Double-click the boundary line to the right of the column header

Question 22

Which of the following functions can be used to find the position of a value within a range?

Accepted Answer

MATCH

Question 23

To display only the formulas in a spreadsheet, you should use

Accepted Answer

The Formulas tab and select Show Formulas

Question 24

The function =IF(A1>10, "Yes", "No") is an example of

Accepted Answer

A logical function

Question 25

Which Excel function would you use to count the number of cells that contain numbers in a range?

Accepted Answer

COUNT

Question 26

Which key should you press to enter data into a cell and move to the next cell below in Excel?

Accepted Answer

Enter

Question 27

To display the formulas in your spreadsheet instead of the values, you should:

Accepted Answer

Click on the Formulas tab and then Show Formulas

Question 28

What does the CONCATENATE function do?

Accepted Answer

Joins text strings together

Question 29

If cell B5 contains the formula =A5, this is an example of:

Accepted Answer

Relative referencing

Question 30

What does the formula =A2*A3 do?

Accepted Answer

Multiplies the values in cells A2 and A3

Question 31

Which function can be used to search for a value within a range and return a corresponding value from another range?

Accepted Answer

VLOOKUP

Question 32

In Excel, what is the result of using relative cell referencing?

Accepted Answer

The cell references change when copied

Question 33

What is the order of operations used by Excel for calculations?

Accepted Answer

BIDMAS

Question 34

In the order of mathematical operations (BIDMAS), what does the ‘I’ stand for?

Accepted Answer

Indices

Question 35

To merge cells A1 and B1 into one cell, you should:

Accepted Answer

Use the Merge & Center button on the Home tab

Question 36

What does the function =MIN(A1) do?

Accepted Answer

Finds the minimum value in the range A1 to A10

Question 37

Which of the following is not a valid Excel function?

Accepted Answer

ADDITION

Question 38

What symbol is used to denote a formula in Excel?

Accepted Answer

=

IGCSE ICT - Spreadsheets

Questions 38

IGCSE ICT - Spreadsheets

Questions 38