Excel Functions and Features

Which of the following is NOT a type of template available in Excel?

• Weather forecasts

• Student schedules

• Loan calculators

• Monthly budgets

What is the purpose of the 'Home' tab in Excel?

• To insert charts

• To manage fonts and alignments

• To set up page layouts

• To create pivot tables

In Excel, what is the intersection of a column and a row called?

• A cell

• A range

• A tab

• A ribbon

How can you merge a group of cells into one in Excel?

• By using the 'Align' option

• By pressing Ctrl + M

• By dragging the cells together

• By using the 'Merge & Center' option

What is the function of the autofill feature in Excel?

• To format cells

• To automatically save your work

• To extend a pattern of data

• To create charts

How do you adjust the width of a column in Excel?

• By double-clicking the column header

• By using the 'Format' menu

• By pressing Ctrl + W

• By dragging the column border

Which symbol is used for multiplication in Excel formulas?

• &

• *

• %

• #

What function would you use to find the average of a set of numbers in Excel?

• SUM

• AVERAGE

• COUNT

• MEDIAN

How can you create a new worksheet in an Excel workbook?

• By right-clicking on an existing sheet

• By clicking the 'New Sheet' button at the bottom

• By pressing Ctrl + N

• By selecting 'File' > 'New'

What is the purpose of using borders in an Excel table?

• To enhance the visual appearance

• To sort the data

• To protect the data

• To link cells together