Excel MCQ Quiz

What is the default file extension for Excel 2016 and later versions?

• .xls

• .xlsx

• .xlsm

• .csv

In Excel, what is the term used to describe a single cell's location?

• Range

• Reference

• Address

• Cell Number

Which menu in Excel provides options for formatting cells?

• Home

• Insert

• Data

• View

What does the 'Save As' option do in Excel?

• Saves the current file with the same name

• Saves a copy of the file with a different name or format

• Closes the current file

• Deletes the current file

How can you add a new worksheet in an Excel workbook?

• Right-click on an existing sheet tab and select "Add"

• Use the 'Insert' tab and choose 'Worksheet'

• Click the '+' icon next to the sheet tabs

• Press 'Ctrl + N'

Which function is used to find the average of a range of cells in Excel?

• AVERAGE

• SUM

• MEDIAN

• MEAN

What formula would you use to add the numbers in cells A1 through A10?

• =SUM(A1)

• =ADD(A1)

• =TOTAL(A1)

• =SUM(A1:A10)

Which function would you use to find the highest number in a range of cells?

• MAX

• HIGH

• TOP

• HIGHEST

To calculate the number of cells containing numbers in a range, which function should you use?

• COUNT

• COUNTA

• COUNTIF

• SUM

How would you reference cell B2 in another formula as an absolute reference?

• B2

• $B$2

• B$2

• $B2