Excel Basics Quiz

What is the correct formula to add the values in cells A1 and B1 in Microsoft Excel?

• =SUM(A1 : B1)

• `=A1 + B1`

• `=ADD(A1, B1)`

• `=A1 & B1`

Which function would you use to find the average of a range of cells in Excel?

• `=SUM()`

• `=AVERAGE()`

• `=MEAN()`

• `=MEDIAN()`

How can you format a cell to display numbers as currency in Excel?

• Right-click the cell, select "Format Cells," and choose "Currency"

• Type the currency symbol before the number

• Use the `=CURRENCY()` function

• Use the `=FORMAT()` function

Which of the following is a valid Excel file type?

• `.docx`

• `.xlsx`

• `.pptx`

• `.txt`

What is the maximum number of rows available in an Excel worksheet?

• 65,536

• 1,048,576

• 104,857

• 10,485,760

Which function would you use to count the number of cells that contain numbers in a range?

• `=COUNT()`

• `=COUNTA()`

• `=COUNTIF()`

• `=COUNTBLANK()`

How do you create a bar chart in Excel?

• Insert > Chart > Bar Chart

• Data > Bar Chart

• Insert > Bar Chart

• Format > Bar Chart

Which feature allows multiple users to work on the same Excel file simultaneously?

• Share Workbook

• Track Changes

• Protect Sheet

• Data Validation

What is the shortcut to save an Excel file?

• Ctrl + S

• Ctrl + C

• Ctrl + V

• Ctrl + P

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

• `=LARGE()`

• `=MAX()`

• `=BIGGEST()`

• `=HIGHEST()`