MENU
Microsoft Excel
11)
Which Excel function can be used to find the largest value in a specified range while ignoring any text values?
Answer: C) MAXA()
Explanation
The MAXA() function in Excel is used to find the largest numeric value in a specified range while ignoring text values.
12)
In Excel, which formula is used to calculate the average of a range of cells that meet specific criteria?
Answer: D) AVERAGEIF()
Explanation
The AVERAGEIF() function in Excel is used to calculate the average of a range of cells that meet specific criteria based on a given condition.
13)
What function is used to round a number up to the nearest integer greater than or equal to that number?
Answer: A) ROUNDUP()
Explanation
The ROUNDUP() function in Excel rounds a number up to the nearest integer greater than or equal to the specified number.
14)
Which feature in Excel allows you to highlight cells based on specified criteria?
Answer: B) Conditional Formatting
Explanation
Conditional Formatting in Excel allows you to apply formatting rules to cells based on specified criteria, making it easier to identify important data.
15)
What is the default extension for saving an Excel workbook in the latest Excel format (e.g., Excel 2019 or Excel 365)?
Answer: B) .xlsx
Explanation
The default extension for saving an Excel workbook in the latest Excel format is .xlsx. This format supports modern features and is widely compatible.
16)
Which Excel function is used to combine text from multiple cells into one cell?
Answer: A) CONCATENATE()
Explanation
The CONCATENATE() function is used to combine (concatenate) text from multiple cells into a single cell
17)
What is the keyboard shortcut to insert a new worksheet in Excel?
Answer: C) Ctrl + Shift + N
Explanation
Pressing Ctrl + Shift + N is the keyboard shortcut to insert a new worksheet in Excel.
18)
Which application software enables you to arrange data in rows and columns?
Answer: C) Spreadsheet Program
Explanation
A spreadsheet program is an application software that allows you to organize data in rows and columns, making it easy to perform calculations, create charts, and analyze information.
19)
What is the keyboard shortcut to create a default chart from the selected data in Excel?
Answer: D) F11
Explanation
In Microsoft Excel, you can quickly create a default chart from selected data using the F11 keyboard shortcut.
20)
Which command will you choose to convert a column of data into row?
Answer: B) Paste Special > Transpose
Explanation
Transposing data in Excel means switching rows and columns, changing the layout of information.