AICT_Quiz_3_Section_K

What is the default file extension for an Excel workbook in Excel 2016 and later?

• .xls

• .xlsx

• .csv

• .docx

Which of the following starts a formula in Excel?

• +

• @

• =

• #

Which function is used to find the average of a group of numbers?

• SUM()

• TOTAL()

• MEAN()

• AVERAGE()

What is the intersection of a row and a column in Excel called?
A.
B.
C.
D.

• Box

• Cell

• Data

• Range

Which keyboard shortcut is used to save a workbook in Excel?

• Ctrl + X

• Ctrl + V

• Ctrl + S

• Ctrl + C

What does the AutoSum button (∑) do in Excel?

• Adds all selected numbers

• Multiplies values

• Counts characters

• Subtracts selected cells

Which symbol is used to lock a cell reference in a formula (absolute reference)?

• %

• &

• $

• #

Which function returns the current date in Excel?

• NOW()

• DATE()

• TIME()

• TODAY()

What is the use of the Fill Handle in Excel?

• To copy formatting

• To drag a worksheet

• To fill cells with a series of values or formulas

• To zoom in

Which of the following is used to arrange data in ascending or descending order in Excel?

• Filter

• Sort

• Format

• Group