Questions

What is the shortcut key to create a new workbook in Excel?
A) Ctrl + N
B) Ctrl + O
C) Ctrl + W
D) Ctrl + S

Answer

Answer: A) Ctrl + N

Which tab in the Ribbon contains the command to insert a new worksheet?
A) Home
B) Insert
C) Page Layout
D) Data

Answer

Answer: B) Insert

Which of the following is a valid Excel cell reference?
A) A1.1
B) A-1
C) 1A
D) A1

Answer

Answer: D) A1

Which command can be used to resize a column to fit its contents?
A) AutoFill
B) AutoFormat
C) AutoSum
D) AutoFit

Answer

Answer: D) AutoFit

What is the maximum number of columns in an Excel worksheet?
A) 256
B) 512
C) 1024
D) 16384

Answer

Answer: D) 16384

Which of the following is not a valid way to select multiple cells in Excel?
A) Click and drag
B) Hold down the Shift key and click
C) Hold down the Ctrl key and click
D) Double-click

Answer

Answer: D) Double-click

What is the shortcut key to move to the last cell in a worksheet?
A) Ctrl + Home
B) Ctrl + End
C) Alt + Home
D) Alt + End

Answer

Answer: B) Ctrl + End

Which command can be used to apply formatting to cells based on their values?
A) AutoFill
B) AutoFormat
C) AutoSum
D) Conditional Formatting

Answer

Answer: D) Conditional Formatting

What is the default file format for Excel 2019 workbooks?
A) .xls
B) .xlsx
C) .xlsm
D) .xlsb

Answer

Answer: B) .xlsx

Which command can be used to insert a function into a cell?
A) AutoFill
B) AutoFormat
C) AutoSum
D) Insert Function

Answer

Answer: D) Insert Function

Which of the following is a valid Excel function?
A) =AVG(A1:A5)
B) =SUM(A1+A5)
C) =COUNT(A1:A5)
D) =MAX(A1+A5)

Answer

Answer: A) =AVG(A1:A5)

Which command can be used to sort data in a range of cells?
A) AutoFill
B) AutoFormat
C) AutoSum
D) Sort & Filter

Answer

Answer: D) Sort & Filter

Which of the following is not a valid chart type in Excel?
A) Line
B) Pie
C) Bar
D) Scatter

Answer

Answer: D) Scatter

Which command can be used to print an Excel worksheet?
A) Print Preview
B) Page Layout
C) Print Area
D) Print Titles

Answer

Answer: A) Print Preview

Which of the following is not a valid way to save an Excel workbook?
A) Ctrl + S
B) File > Save
C) File > Save As
D) File > Export

Answer

Answer: D) File > Export