About Spreadsheet

Which of the following is a spreadsheet application developed by Microsoft?

• Word

• PowerPoint

• Excel

• Access

In Excel, what is the name given to a single spreadsheet organized by rows and columns?

• Workbook

• Worksheet

• Database

• Chart

What is the default alignment for numbers and dates in Excel?

• Left-aligned

• Center-aligned

• Right-aligned

• Justified

What keyboard shortcut is used to save a workbook in Excel?

• Ctrl + X

• Ctrl + V

• Ctrl + S

• Ctrl + Z

Which function in Excel returns the average of a set of values?

• SUM

• COUNT

• AVERAGE

• MAX

What does the AutoSum button in Excel do?

• Automatically formats text

• Automatically sorts data

• Automatically totals selected cells

• Automatically changes font

In Excel, which of the following is a valid absolute reference?

• A1

• $A1

• A$1

• $A$1

Which tool allows you to replicate the formatting from one cell to another in Excel?

• AutoFill

• Format Painter

• AutoSum

• Data Validation

What is the purpose of Freeze Panes in Excel?

• To apply color to cells

• To make rows and columns invisible

• To keep specific rows/columns visible while scrolling

• To automatically adjust column width

Which file format is used when saving an Excel workbook by default?

• .docx

• .xlsx

• .pptx

• .pdf