1. Question 1 of 30

   The cell in which you are currently working, shown with a thick border, is called the:

   A Active cell B Home cell C Fixed cell D Target cell
2. Question 2 of 30

   Freeze Panes is used to:

   A Keep selected rows or columns visible while scrolling B Lock the file with a password C Stop formulas from calculating D Prevent printing
3. Question 3 of 30

   The VLOOKUP function searches for a value in:

   A The first row of a table B The first column of a table and returns a value from the same row C Any single cell D The last column of a table
4. Question 4 of 30

   What is the maximum number of rows in an Excel worksheet (Excel 2007 and later)?

   A 1,048,576 B 65,536 C 16,384 D 1,000,000
5. Question 5 of 30

   The COUNT function counts:

   A All cells that contain data B Only text cells C Blank cells D Only the cells that contain numbers
6. Question 6 of 30

   Which type of chart best shows the parts of a whole as percentages?

   A Pie chart B Line chart C Scatter chart D Column chart
7. Question 7 of 30

   Which shortcut key inserts the SUM function (AutoSum) in Excel?

   A Alt + = B Ctrl + = C Shift + = D Ctrl + S
8. Question 8 of 30

   The SUM function is used to:

   A Count the cells in a range B Add the numbers in a range C Find the largest number D Round a number
9. Question 9 of 30

   The Filter feature in Excel is used to:

   A Delete unwanted data B Display only the rows that meet certain criteria C Add new rows D Change cell colours
10. Question 10 of 30

    What is the default file extension of an Excel workbook (2007 and later)?

    A .xlsx B .xls C .doc D .csv
11. Question 11 of 30

    What is the result of =UPPER("excel")?

    A Excel B EXCEL C excel D eXCEL
12. Question 12 of 30

    Which symbol is used to make a cell reference absolute (for example $A$1)?

    A # B $ C @ D &
13. Question 13 of 30

    An Excel file that can contain several worksheets is called a:

    A Database B Workbook C Presentation D Document
14. Question 14 of 30

    What is the result of =MAX(5,9,2)?

    A 2 B 16 C 9 D 5
15. Question 15 of 30

    What is the result of =IF(5>3,"Yes","No")?

    A No B Yes C True D 5
16. Question 16 of 30

    The name of a cell such as B3 is called its:

    A Formula B Function C Cell reference D Range
17. Question 17 of 30

    The bar in Excel that shows the content of the active cell is called the:

    A Status bar B Title bar C Ribbon D Formula bar
18. Question 18 of 30

    Sorting in Excel is used to:

    A Remove duplicate rows B Add a total to the data C Arrange data in ascending or descending order D Print the sheet
19. Question 19 of 30

    What is the result of =AVERAGE(10,20,30)?

    A 60 B 30 C 20 D 10
20. Question 20 of 30

    The intersection of a row and a column in an Excel worksheet is called a:

    A Field B Record C Cell D Table
21. Question 21 of 30

    Which shortcut key moves to cell A1 in Excel?

    A Ctrl + End B Ctrl + A C Home D Ctrl + Home
22. Question 22 of 30

    What is the result of =ROUND(3.567,1)?

    A 3.5 B 4 C 3.57 D 3.6
23. Question 23 of 30

    What is the maximum number of columns in an Excel worksheet (Excel 2007 and later)?

    A 256 B 1,024 C 65,536 D 16,384
24. Question 24 of 30

    What is the result of =LEN("Excel")?

    A 4 B 6 C 5 D Excel
25. Question 25 of 30

    Merge and Center is used to:

    A Split one cell into two B Delete the selected cells C Combine selected cells into one and centre the contents D Add borders to the cells
26. Question 26 of 30

    The small square at the bottom-right corner of the active cell is called the:

    A Fill handle B Cell pointer C Name box D Drag box
27. Question 27 of 30

    Which function key edits the active cell in Excel?

    A F4 B F2 C F5 D F12
28. Question 28 of 30

    The error #DIV/0! appears in Excel when:

    A A formula refers to a deleted cell B A function name is misspelled C The column is too narrow D A number is divided by zero
29. Question 29 of 30

    Every formula in Excel must begin with:

    A The = sign B The @ sign C The # sign D The $ sign
30. Question 30 of 30

    The COUNTA function counts:

    A Only numeric cells B Only blank cells C Only text cells D All cells that are not empty

You can practise as a guest, but sign in to save your score and track your progress.