REVISION ON EXCEL

1- What is Microsoft Excel used for?

• • A) Playing games

• • B) Making presentations

• • C) Creating and calculating spreadsheets

• • D) Drawing pictures

2- What do we call a single box in an Excel sheet?

• • A) Row

• • B) Column

• • C) Table

• • D) Cell

3- Which of the following is a correct cell address?

• • A) A1

• • B) 1A

• • C) A#1

• • D) CellA1

• 4- Which function adds numbers together?

• • A) =SUBTRACT()

• • B) =SUM()

• • C) =DIVIDE()

• • D) =TEXT()

5- What is a column in Excel?

• • A) A horizontal line of cells

• • B) A vertical line of cells

• • C) A square box

• • D) A type of chart

6- How do you start typing in a cell?

• • A) Click the cell

• • B) Right-click

• • C) Press Shift

• • D) Hover over it

7- Which symbol is used to add numbers in Excel?

• A) - (minus)
  

• B) + (plus)
  

• C) * (multiply)
  

• D) / (divide)

8- Which of these is a common feature in Excel that helps you quickly add up numbers?

• A) Chart
  

• B) Formula
  

• C) Sum function
  

• D) Filter

9- What is a 'cell' in Excel?

• A) A type of chart
  

• B) A box where you can type data or numbers
  

• C) A way to print documents
  

• D) A special kind of formula

10. If you have sales amounts in cells B2 to B10, which formula will give you the total sales?

• • A) =SUM(B2:B10)

• • B) =TOTAL(B2:B10)

• • C) =ADD(B2:B10)

• • D) =SUM(B2,B10)