microsoft excel 2016
What is the shortcut key to save a workbook in Microsoft Excel 2016?
Ctrl + S
Which function in Excel 2016 is used to find the largest number in a range?
MAX()
What does the 'Merge & Center' option do in Excel 2016?
It combines selected cells and centers the content.
Which tab in Excel 2016 would you use to add a chart to your worksheet?
Insert
What is the default file extension for an Excel 2016 workbook?
.xlsx
Which feature allows you to automatically fill a series of cells based on the content of a single cell?
AutoFill
Which function in Excel 2016 can be used to join text from two or more cells?
CONCATENATE()
What is the purpose of freeze panes in Excel 2016?
To keep selected rows or columns visible while scrolling.
Which symbol is used to start a formula in Excel 2016?
=
Which feature in Excel 2016 allows you to summarize data using rows and columns?
Pivot Table