1. Which of the following is NOT a type of cell reference in Excel?

A) Mixed reference
B) Dynamic reference
C) Absolute reference
D) Relative reference



2. Which of the following Excel features allows you to view two worksheets side by side?

A) Freeze Panes
B) View Side by Side
C) Split Window
D) Consolidate



3. What is the shortcut key to move to the next worksheet in Excel?

A) Alt + Shift + Tab
B) Alt + Tab
C) Ctrl + Page Down
D) Ctrl + Shift + Tab



4. What is the result of the formula =SUM(A1:A5, B1:B5) in Excel?

A) The sum of the values in both ranges A1:A5 and B1:B5
B) The sum of the values in range A1:A5 only
C) The sum of the values in range B1:B5 only
D) An error message



5. Which of the following is NOT a valid format for a number in Excel?

A) Binary
B) Fraction
C) Scientific notation
D) Accounting