Microsoft Excel Trivia 5 — Questions and Answers
Question 1: Which Excel function returns the largest value in a set of values?
- LARGE
- MAX (Correct answer)
- UPPER
- CEILING
Correct answer: MAX
MAX returns the largest numeric value in a specified range or list of values.
Question 2: What Excel feature lets you restrict the type of data entered into a cell, such as allowing only whole numbers?
- Cell Protection
- Data Validation (Correct answer)
- Input Masking
- Format Cells
Correct answer: Data Validation
Data Validation defines rules that control what users can enter in a cell, with options for whole numbers, decimals, dates, lists, and more.
Question 3: What does the acronym 'VBA' stand for in the context of Excel?
- Visual Basic for Applications (Correct answer)
- Variable-Based Automation
- Visual Batch Assignments
- Verified Build Architecture
Correct answer: Visual Basic for Applications
VBA stands for Visual Basic for Applications, the programming language built into Excel for creating macros and automating tasks.
Question 4: Which keyboard shortcut selects the entire current row in Excel?
- Ctrl+Spacebar
- Shift+Spacebar (Correct answer)
- Ctrl+Shift+Spacebar
- Alt+Spacebar
Correct answer: Shift+Spacebar
Shift+Spacebar selects the entire row of the active cell in an Excel worksheet.
Question 5: What is the purpose of the ROUND function in Excel?
- Converts numbers to circular chart data
- Rounds a number to a specified number of digits (Correct answer)
- Removes decimal places permanently
- Calculates the circumference of a circular value
Correct answer: Rounds a number to a specified number of digits
ROUND(number, num_digits) rounds a number to the specified count of decimal places, rounding up at 5 or above.
Question 6: Which Excel view shows exactly how a spreadsheet will look when printed, including page breaks and margins?
- Normal View
- Page Layout View (Correct answer)
- Page Break Preview
- Reading View
Correct answer: Page Layout View
Page Layout View displays the worksheet as it will appear on printed pages, showing headers, footers, margins, and rulers.
Question 7: What does a green triangle in the upper-left corner of an Excel cell typically indicate?
- The cell contains a hyperlink
- Excel has detected a potential error or inconsistency (Correct answer)
- The cell is locked for editing
- The cell is part of a PivotTable
Correct answer: Excel has detected a potential error or inconsistency
A green triangle is Excel's error indicator, flagging potential issues like numbers stored as text or formulas inconsistent with neighboring cells.
Microsoft Excel Trivia 5
Which Excel function returns the largest value in a set of values?