1. Question 1 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
2. Question 2 of 30

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

   A Formula B Function C Cell reference D Range
3. Question 3 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
4. Question 4 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
5. Question 5 of 30

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

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

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

   A # B $ C @ D &
7. Question 7 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
8. Question 8 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
9. Question 9 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
10. Question 10 of 30

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

    A Database B Workbook C Presentation D Document
11. Question 11 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
12. Question 12 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
13. Question 13 of 30

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

    A 60 B 30 C 20 D 10
14. Question 14 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
15. Question 15 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
16. Question 16 of 30

    Which function key edits the active cell in Excel?

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

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

    A .xlsx B .xls C .doc D .csv
18. Question 18 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
19. Question 19 of 30

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

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

    Which shortcut key moves to cell A1 in Excel?

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

    Every formula in Excel must begin with:

    A The = sign B The @ sign C The # sign D The $ sign
22. Question 22 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
23. Question 23 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
24. Question 24 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
25. Question 25 of 30

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

    A Alt + = B Ctrl + = C Shift + = D Ctrl + S
26. Question 26 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
27. Question 27 of 30

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

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

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

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

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

    A 4 B 6 C 5 D Excel
30. Question 30 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

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