Excel Vocabulary and Functions Assessment

What is a workbook in Excel?

• A. A single spreadsheet containing data

• B. A file containing one or more related worksheets

• C. A tool for mathematical calculations

• D. A collection of formulas and functions

Which file extension is commonly used for data downloaded from Internet databases?

• XLSX

• PDF

• CSV

• DOC

What happens when you hide a column in Excel?

• The data is permanently deleted

• The column becomes password protected

• The information remains but is not visible until unhidden

• The column is automatically backed up

Which paste option would you use to copy only the values without formulas?

• Paste Special

• Paste Values

• Paste All

• Paste Format

What is the purpose of the Freeze Panes feature?

• To lock cells from editing

• To keep specific rows or columns visible while scrolling

• To prevent printing of certain areas

• To protect data from being deleted

What does the Transpose feature do?

• Deletes selected data

• Copies formatting only

• Switches rows and columns of copied cells

• Merges selected cells

What are Arithmetic Operators in Excel?

• Special formatting options

• Basic math symbols like +, -, *, and /

• Cell navigation tools

• Data sorting functions

What is AutoFit used for?

• Automatically filling a series of numbers

• Adjusting column and row dimensions to fit content

What is displayed in the Formula Bar?

• Only mathematical calculations

• The contents of the active cell

• The print preview

• Cell styles and formatting

What is a Function Argument?

• A. A dispute between two functions

• B. The values inside parentheses of a function

• C. A type of cell formatting

• D. A mathematical equation