Excel Functions
What is a function in Excel?
A predefined formula that performs calculations using specific values.
What does the AVERAGE function do?
Calculates the mean of selected numbers.
What does "sort" do in Excel?
Organizes data in a specific order.
What is a shape used for in Excel?
Adding arrows, boxes, or other visual elements to worksheets.
What is a comment in Excel?
A note or annotation attached to a specific cell.
What is an argument in a function?
The data inside the parentheses of a function, like numbers or cell ranges.
What is a financial function used for?
Performing calculations like loan payments or interest.
What is ascending sort?
Sorts data from A to Z or smallest to largest.
How do you insert a picture into Excel?
Use the Insert tab > Pictures.
How can hyperlinks be used in Excel?
To link to websites, documents, or other cells.
What does Formula AutoComplete help you do?
It suggests valid functions and arguments while typing a formula.
What Excel function returns the current date?
TODAY()
What is descending sort?
Sorts data from Z to A or largest to smallest.
What is a screenshot tool used for?
Capturing a snapshot of a window or screen to insert into the sheet.
Where do you find the comment tool in Excel?
Under the Review tab > New Comment.
What is a mathematical function? Give an example.
Functions like SUM, AVERAGE, or ROUND that perform math operations.
What function counts how many cells contain numbers?
COUNT
What does the filter feature do?
Allows users to display only rows that meet certain criteria.
What’s the difference between screenshot and screen clipping?
Screenshot captures entire windows; screen clipping lets you select a portion.
What is the benefit of using hyperlinks in spreadsheets?
They help navigate between sheets, files, or external resources easily.
What is a logical function? Give one example.
IF, AND, OR – used to return values based on true/false logic.
What function would you use to calculate future payments?
PMT (Payment function for financial calculations)
What are filter arrows used for?
Small dropdowns in column headers to apply filters.
What is a template?
A pre-designed spreadsheet used as a starting point for new files.
Give an example of using a comment in a group project.
Adding a note to explain a calculation or ask a teammate a question.