Excel Interface Quiz

What are columns in Excel?

• Horizontal sections labeled with numbers

• Vertical sections labeled with letters

• Labels identifying the data in each row

• A group of cells defined by their starting and ending cells

What does the Name Box display?

• The last modified cell

• The average of a range of cells

• The current cell's reference

• The total of selected cells

What is an absolute reference in Excel?

• Refers to the same cell regardless of where the formula is copied

• Changes based on the formula's new location

• Refers to a range of cells

• Locks either the row or column

Which function adds up values in a range of cells?

• VLOOKUP

• AVERAGE

• SUM

• IF

What does the IF function do?

• Performs a logical test and returns different values based on the outcome

• Calculates the average of values in a range of cells

• Searches for a value in a table

• Adds up values in a range of cells

What is a range in Excel?

• A formula that performs calculations

• A label identifying data in a column

• A single cell reference

• A group of cells defined by their starting and ending cells

Click this to Move to the first cell in the sheet

• Ctrl + End

• Ctrl + Home

• Ctrl + Arrow up

• Ctrl + Arrow Down

Is a correct cell reference

• 1A

• A1

• A 1

• None