Excel

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

• .xls
• .csv
• .xlsx.old
• .xlsx

Which function is used to calculate the sum of a range of cells?

• COUNT
• SUM
• AVERAGE
• MAX

How do you start a formula in Excel?

• Start with '!' to create a formula.
• Use '#' to initiate a formula.
• Begin by typing 'calc' for a formula.
• Type '=' to begin a formula.

Which symbol is used to fix a row or column in a formula?

• $
• #
• %
• &

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

• 1,048,576
• 2,000,000
• 500,000
• 1,000,000

Which chart is best suited to show proportions of a whole?

• Line graph
• Bar chart
• Scatter plot
• Pie chart

How can you quickly apply the same formatting to multiple cells?

• Apply a different style from the cell styles gallery.
• Use the Format Painter tool

• Manually format each cell one by one.
• Use the AutoFill feature to copy cell contents.

What does the AutoFill feature do?

• Fills a range of cells with a sequence based on the selected cells

• Saves a file automatically

• Creates charts automatically

• Deletes blank cells

Which of these is not a valid data type in Excel?

• Text

• Boolean

• dates
• Image

What does Ctrl + ; (semicolon) do in Excel?

• Highlights blank cells.

• Selects all cells

• Inserts the current date

• Inserts the current time