Questions

What is Microsoft Excel?
a) A word processor
b) A presentation software
c) A spreadsheet application
d) A graphics editor

Answer

Answer: c) A spreadsheet application

Which of the following is not a component of an Excel workbook?
a) Worksheet
b) Chart
c) Table
d) Slide

Answer

Answer: d) Slide

What is a cell in Excel?
a) A formula
b) A chart type
c) The intersection of a row and column
d) A shape

Answer

Answer: c) The intersection of a row and column

What is the maximum number of rows in an Excel worksheet?
a) 10,000
b) 65,536
c) 1,048,576
d) 2,147,483,647

Answer

Answer: c) 1,048,576

What is the maximum number of columns in an Excel worksheet?
a) 255
b) 1,024
c) 16,384
d) 65,536

Answer

Answer: c) 16,384

What is a range in Excel?
a) A series of cells
b) A chart type
c) A font style
d) A worksheet tab

Answer

Answer: a) A series of cells

Which of the following is not a type of cell data in Excel?
a) Text
b) Number
c) Date/Time
d) Sound

Answer

Answer: d) Sound

What is a function in Excel?
a) A command that performs a specific task
b) A visual element such as a chart or graph
c) A type of cell formatting
d) A data validation rule

Answer

Answer: a) A command that performs a specific task

Which of the following is a valid Excel function?
a) =SUM(A1, B1, C1)
b) =MAX(A1+B1+C1)
c) =AVERAGE(A1*B1/C1)
d) =COUNT(A1:B3)

Answer

Answer: a) =SUM(A1, B1, C1)

Which of the following is not a valid Excel formula?
a) =A1+B1+C1
b) =A1*B1/C1
c) =A1^B1
d) =A1/B1+C1

Answer

Answer: d) =A1/B1+C1 (the correct formula should be =A1/(B1+C1))

Which of the following is not a valid Excel chart type?
a) Line
b) Bar
c) Pizza
d) Scatter

Answer

Answer: c) Pizza (the correct chart type is "Pie")

Which of the following is not a valid Excel data format?
a) Number
b) Text
c) Currency
d) Sound

Answer

Answer: d) Sound

What is the shortcut key for creating a new worksheet in Excel?
a) Ctrl + N
b) Ctrl + S
c) Ctrl + W
d) Ctrl + F

Answer

Answer: a) Ctrl + N

What is the shortcut key for saving an Excel workbook?
a) Ctrl + N
b) Ctrl + S
c) Ctrl + W
d) Ctrl + F

Answer

Answer: b) Ctrl + S

What is the shortcut key for closing an Excel workbook?
a) Ctrl + N
b) Ctrl + S
c) Ctrl + W
d) Ctrl + F

Answer

Answer: c) Ctrl + W