Excel Quiz

Excel is a ____ program developed by Microsoft.

• Spreadsheet

• Document

• presentation

• All of the above

What is the extension of a Microsoft Excel file?

• msxcl

• xcl

• xlsx

• xlsm

The intersection of a row and a column is called a ________.

• Chart

• Worksheet

• Cell

• Sum

What is the default file name of Microsoft Excel file?

• Workbook.xlsx

• Workbook1.xlsx

• Worksheet.xlsx

• Worksheet1.xlsx

Microsoft Excel is used for ...

• Analysis

• Data Entry

• Data Management

• All of the above

Let’s say you’re trying to find your average grade. What’s wrong with the formula shown in the image?

• It should use quotation marks instead of parentheses

• It should have an equals sign (=) at the beginning

• It should use the COUNT function instead

• There is nothing wrong with the formula

Assuming cell A1 is displaying the number "12000.7789". What formula should be used to round this number to the closest integer?

• =MROUND(A1,100)

• =MROUND(A1,10)

• =ROUND(A1,0)

• =ROUND(A1,1)

The feature to center text across several cells is called:

• Wrap Text

• Merge and Center

• Shrink to Fit

• Number Formatting

What is the formula to find the lowest number in cells C1:C4?

• =average(C1:C4)

• =max(C1:C4)

• =min(C1:C4)

• =sum(C1:C4)

   ________ are horizontal

• Rows

• Columns