Excel Midterm Exam Fall 2025

What is Microsoft Excel primarily used for?

• Writing letters

• Managing and analyzing data

• Creating slideshows

• Editing videos

What is a workbook in Excel?

• A single spreadsheet

• A file containing one or more worksheets

• A collection of charts

• A type of formula

What do you call the intersection of a row and a column?

• Chart

• Formula

• Cell

• Table

What is an active cell in Excel?

• A cell currently selected for data entry

• A cell with the highest value

• A cell in the first row

• A cell in the last column

What does pressing Ctrl + C do in Excel?

• Cuts the selected data

• Copies the selected data

• Pastes the copied data

• Deletes the selected data

Which key is used to edit data inside a cell?

• Enter

• F2

• Esc

• Shift

How do you rename a sheet in Excel?

• Click on it and press Enter

• Right-click the sheet tab and select Rename

• Press Ctrl + R

• Delete and create a new sheet

What symbol is used to start a formula in Excel?

• #

• =

• @

• $

What does the SUM function do?

• Counts numeric values

• Finds the highest value

• Adds numbers in a range

• Finds the lowest value

What is the correct syntax for the AVERAGE function?

• =AVERAGE(A1:A5)

• =AVG(A1:A5)

• =MEAN(A1:A5)

• =SUM(A1:A5)/5