Microsoft Excel Spreadsheet Quiz

What is the purpose of Microsoft Excel Spreadsheet?

• To play video games

• To organize, analyze, and present data in a tabular format.

• To cook meals and recipes

• To send emails and messages

What is the shortcut key to save a spreadsheet in Microsoft Excel?

• Shift + S

• Alt + A

• Ctrl + X

• Ctrl + S

What is the function of the 'SUM' formula in Microsoft Excel?

• It finds the average of the values in a range of cells.

• It adds up the values in a range of cells.

• It calculates the median of the values in a range of cells.

• It multiplies the values in a range of cells.

What is the purpose of sorting data in a spreadsheet?

• To randomize the order of the data

• To make the data more confusing

• To make the data harder to analyze

• To organize and arrange the data in a specific order based on certain criteria.

Which function is used to calculate the sum of a range of numbers?

• AVERAGE()

• COUNT()

• SUM()

• MAX()

Which symbol is used to start a formula in Excel?

• @

• =

• #

• $

What is the intersection of a row and a column called?

• Chart

• Cell

• Range

• Sheet

Which function is used to find the largest number in a given range?

• LARGE()
  
  

• MAX()
  
  

• MIN()
  
  

• 12. AVERAGE()

What is the default file extension for an Excel workbook?

• .docx

• .pptx

• .txt

• .xlsx

Which function is used to count the number of numeric values in a range?

• COUNT()

• COUNTA()

• COUNTIF()

• COUNTBLANK()