MIDTERM EXAM

What is the default file extension for an Excel workbook?

• .xlsx

• .xls

• .csv

• .docx

Which of the following is NOT a component of an Excel worksheet?

• Row

• Column

• Cell

• Page

In Excel, what is the intersection of a row and a column called?

• Matrix

• Cell

• Grid

• Table

Which keyboard shortcut is used to save an Excel workbook?

• Ctrl + S

• Ctrl + P

• Ctrl + N

• Ctrl + X

Which symbol is used to begin a formula in Excel?

• +

• -

• =

• @

How can you quickly move to the first cell in a worksheet (A1)?

• Ctrl + End

• Ctrl + Home

• Alt + A

• Shift + A

Which function will you use to add a range of cells in Excel?

• MAX

• ADD

• SUM

• AVG

In Excel, what is the maximum number of rows in a worksheet?

• 65,536

• 1,048,576

• 100,000

• 500,000

How do you select an entire column in Excel?

• Click on the row header

• Click on the column header

• Click on the first cell

• Double-click any cell

How do you activate a cell in Excel?

• Double-click it

• Right-click it

• Left-click it

• Scroll over it