Basic Excel Knowledge Quiz

What is Microsoft Excel primarily used for?

• Creating presentations

• Organizing and analyzing data

• Writing documents

• Editing images

Which of the following is a key feature of Excel?

• Formulas and Functions

• Animations and Transitions

• Version History Tracking

• Mail Merge Functionality

What is the grid-like workspace in Excel called?

• Canvas

• Worksheet

• Spreadsheet

• Document

How are columns in an Excel worksheet labeled?

• Numbers

• Roman Numerals

• Letters

• Symbols

What is the intersection of a row and a column called in Excel?

• Block

• Node

• Cell

• Pixel

What symbol must all Excel formulas begin with?

• = (equals sign)

• + (plus sign)

• - (minus sign)

• * (asterisk)

Which function is used to add a range of numbers in Excel?

• ADD

• TOTAL

• SUM

• PLUS

What is a range in Excel?

• A single cell

• The difference between the highest and lowest values

• A group of selected cells

• A type of formula

What is the purpose of the fill handle in Excel?

• To format cells

• To insert functions

• To copy formulas to adjacent cells

• To sort data

Which function calculates the average of a range of numbers?

• MEAN

• AVERAGE

• MEDIAN

• MODE