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