Interactive Worksheet - Excel-V Fill-in-the-Blanks Quiz

Excel Quiz - Fill in the Blanks

Fill in the blanks by selecting the correct option from the dropdown. Click submit to check your answers.

1. Excel is used primarily for __________ management and data analysis. Select an answer spreadsheet document presentation

2. The intersection of a row and column in Excel is called a __________. Select an answer cell box sheet

3. Each Excel workbook can contain multiple __________. Select an answer sheets cells columns

4. The Excel function to add numbers is __________. Select an answer SUM ADD PLUS

5. Excel’s file extension for workbooks is usually .xlsx or .__________. Select an answer .xls .docx .pptx

6. To change the font color in Excel, you use the __________ tool. Select an answer Font Color Font Size Font Style

7. You can format numbers as currency using the __________ tool. Select an answer Number Format Currency Tool Cell Format

8. Cell __________ allows you to combine multiple cells into one. Select an answer merging splitting aligning

9. To adjust cell borders, use the __________ tool in the Format Cells dialog. Select an answer Border Outline Edges

10. To apply a color to the background of a cell, use the __________ tool. Select an answer Fill Color Background Shading

11. The __________ function in Excel calculates the total of a range of cells. Select an answer SUM TOTAL ADD

12. To calculate the average of numbers, you use the __________ function. Select an answer AVERAGE SUM MEAN

13. The __________ function returns the highest value in a range. Select an answer MAX HIGH LARGE

14. To count the number of cells that contain numbers, use the ___ function. Select an answer COUNT NUMBER SUM