Which shortcut key is used to insert a new worksheet in Excel?

• A. Shift + F11
• B. Ctrl + F1
• C. Alt + F1
• D. None of these

In Excel, which function returns the largest value in a range?

• A. LARGE
• B. MIN
• C. MAX
• D. VALUE

Which shortcut key opens the ‘Find and Replace’ dialog in Excel?

• A. Ctrl + R
• B. Ctrl + F
• C. Ctrl + H
• D. Ctrl + Shift + H

By default, numbers in Excel are aligned to the ___?

• A. Left
• B. Center
• C. Right
• D. Justify

Which symbol anchors a cell reference in Excel formulas?

• A. @
• B. #
• C. $
• D. %

In Excel, the function =NOW() provides the ____?

• A. Current Date
• B. Current Time
• C. Current Date and Time
• D. None of these

In Excel, which of the following functions returns the smallest value?

• A. SMALL
• B. MIN
• C. LOWER
• D. LOW

In Excel, where can you find the ‘Sort & Filter’ options in the menu?

• A. Insert
• B. Page Layout
• C. Data
• D. Review

Which key combination is used to insert the current date in a cell?

• A. Ctrl + ;
• B. Alt + ;
• C. Shift + ;
• D. Ctrl + Shift + ;

In Excel, which key is used to start a new line within a cell?

• A. Enter
• B. Shift + Enter
• C. Alt + Enter
• D. Ctrl + Enter