Excel Weekdays Batch _ Quiz 1

What is the intersection of a column and a row on a worksheet called ?

• 1.Column
• 2.Value
• 3.Address
• 4.Cell

Which function in Excel tells how many numeric entries are there ?

• 1.NUM
• 2.COUNT
• 3.SUM
• 4.CHKNUM

Which one is not a Function in MS Excel ?

• 1.SUM
• 2.AVG
• 3.MIN
• 4.MAX

Functions in MS Excel must begin with ___

• 1.An () sign
• 2.An Equal Sign
• 3.A Plus Sign
• 4.A > Sign

In Excel, Columns are labelled as ___

• 1.A, B, C, etc
• 2.A1, A2, etc.
• 3.1,2,3 etc
• 4.$A$1, $A$2, etc.

 Excel is a ____ program developed by Microsoft.

• 1.Spreadsheet
• 2.Document
• 3.Data management
• 4.All of the above

What is the extension of a Microsoft Excel file?

• 1.msxcl
• 2.xcl
• 3.xlsx
• 4.xlsm

What is the default file name of Microsoft Excel file?

• 1.Workbook.xlsx
• 2.Workbook1.xlsx
• 3.Worksheet.xlsx
• 4.Worksheet1.xlsx

The fill function can be ____ to complete formulas in a range.

• 1.Single clicked
• 2.Double-clicked
• 3.Triple clicked
• 4.Right clicked

Which symbol is used to specify the fixed columns or rows in the formula?

• 1.=
• 2.*
• 3.$
• 4.'%"