Q31
Q31 What does the function XLOOKUP() replace in newer versions of Excel?
VLOOKUP() and HLOOKUP()
LOOKUP()
MATCH()
INDEX()
Q32
Q32 How do you calculate the number of workdays between two dates, excluding weekends and holidays?
WORKDAY()
NETWORKDAYS()
TOTALDAYS()
WORKDAYS()
Q33
Q33 Which function can be used to perform a lookup across multiple criteria in Excel?
XLOOKUP()
DLOOKUP()
MULTILOOKUP()
SUMIFS()
Q34
Q34 What function should be used to find the root of a number in Excel?
SQRT()
ROOT()
POW()
RADICAL()
Q35
Q35 Which function allows you to count unique values within a range that meet specified criteria?
COUNTIF()
COUNTA()
COUNTIFS()
UNIQUE()
Q36
Q36 How can you calculate the depreciation of an asset using the double-declining balance method in Excel?
DDB()
DB()
SLN()
SYD()
Q37
Q37 What Excel function is used to forecast a future value based on existing values?
FORECAST()
PREDICT()
PROJECT()
ESTIMATE()
Q38
Q38 How can you split text from one cell into multiple columns?
Use Text to Columns feature
Use SPLIT() function
Use DIVIDE()
Use SEGMENT()
Q39
Q39 Which tool in Excel can automatically apply complex calculations to data in a table format?
Formulas
Functions
What-If Analysis
Quick Analysis
Q40
Q40 How do you link data from a cell in one worksheet to another worksheet within the same workbook?
Use the Link feature
Type the cell reference directly
Use a hyperlink
Use a formula
Q41
Q41 What function calculates the sum of the products of corresponding ranges or arrays?
SUMPRODUCT()
PRODUCTSUM()
MULTISUM()
ARRAYSUM()
Q42
Q42 What is the purpose of the INDIRECT function in Excel?
To delay calculation
To convert text into a formula
To prevent auto-calculation
To create dynamic cell references
Q43
Q43 Which function dynamically ranks values within a data set in Excel?
RANK()
RANK.EQ()
RANK.AVG()
RANK.DYNAMIC()
Q44
Q44 How do you array-enter a formula in Excel (versions prior to dynamic arrays)?
Press Enter
Press Ctrl + Shift + Enter
Press Shift + Enter
Press Alt + Enter
Q45
Q45 Which function would you use to analyze trends in data over intervals you specify?
TREND()
LINEST()
GROWTH()
FREQUENCY()
Q46
Q46 What feature would you use to automatically update the results of a formula when the input data changes?
AutoCalculate
AutoFill
AutoUpdate
Automatic Formulas
Q47
Q47 You have a large dataset where multiple entries per individual need to be summed up. Which function helps streamline this process?
SUMIF()
SUMIFS()
AGGREGATE()
CONSOLIDATE()
Q48
Q48 How can you merge data from multiple sheets into one master sheet without using VBA?
Use the Consolidate function
Use a macro
Use a pivot table
Use a template
Q49
Q49 How would you create a dynamic drop-down list that adjusts based on the data in another cell?
Use the Data Validation feature with INDIRECT()
Use a simple drop-down
Use a macro
Use Conditional Formatting
Q50
Q50 What is the maximum number of rows supported in an Excel 2019 worksheet?
1,048,576
65,536
100,000
500,000
Q51
Q51 Which feature automatically adjusts the width of a column to fit the longest cell entry?
AutoFit
AutoFill
AutoAdjust
AutoSize
Q52
Q52 In Excel, what does the 'Sort & Filter' feature allow you to do?
Modify data types
Change cell colors
Organize data alphabetically or numerically
Create data forms
Q53
Q53 What function would you use to combine data from two different cells into one?
CONCAT()
MERGE()
COMBINE()
LINK()
Q54
Q54 Which Excel tool allows you to manage large amounts of data from different sources?
Data Model
PivotTable
Formula Bar
Data Types
Q55
Q55 What is the purpose of Data Validation in Excel?
To filter data
To format data
To restrict data input types
To analyze data
Q56
Q56 Which feature should be used to track changes and updates made by different users in a shared Excel file?
Document Inspector
Track Changes
Shared Workbook
Audit Trail
Q57
Q57 How can you prevent other users from making unintended changes to a workbook?
Enable protection
Lock the file
Create a read-only copy
Password-protect the file
Q58
Q58 What shortcut key combination is used to hide a row in Excel?
Ctrl + 9
Ctrl + H
Ctrl + 0
Ctrl + Shift + 9
Q59
Q59 How do you display hidden rows or columns in an Excel worksheet?
Right-click and select 'Show'
Use the Unhide command
Use the Format menu
Click the Home tab
Q60
Q60 Which function is best to use when you need to find data within a range based on a condition?
LOOKUP()
SEARCH()
VLOOKUP()
FIND()
