What is the default file extension for an Excel workbook?.xls.xlsx.xlsm.csvB) .xlsxThe default file extension for a modern Excel workbook is .xlsx.
Which of the following is a valid Excel formula?=2 + 32 + 3=2 * 32 * 3A) =2 + 3A formula must start with an equal sign (=) to be valid in Excel.
What does the VLOOKUP function do?Searches for a value vertically in a tableSearches for a value horizontally in a tableFinds the maximum valueFinds the minimum valueA) Searches for a value vertically in a tableVLOOKUP stands for vertical lookup, which searches for a value in the first column of a table and returns a value in the same row from another column.
What does the Excel function =SUM(A1:A10) do?Adds the numbers from A1 to A10Multiplies the numbers from A1 to A10Divides the numbers from A1 to A10Subtracts the numbers from A1 to A10A) Adds the numbers from A1 to A10The SUM function adds up all the values in the specified range.
Which key is used to start a new line within a cell in Excel?EnterCtrl + Enter Alt + EnterShift + EnterC) Alt + EnterAlt + Enter creates a new line within the same cell.
How do you freeze the top row in Excel?View → Freeze Panes → Freeze Top RowInsert → Freeze RowView → Lock RowFormat → Freeze Top RowA) View → Freeze Panes → Freeze Top RowYou can freeze the top row through the "Freeze Panes" option in the "View" tab.
What is the shortcut key to select the entire worksheet?Ctrl + ACtrl + Shift + AShift + AAlt + AA) Ctrl + ACtrl + A selects the entire worksheet in Excel.
What type of data can a cell in Excel contain?Only numbersOnly textNumbers, text, or datesOnly formulasC) Numbers, text, or datesA cell can contain numbers, text, dates, formulas, or a combination of these.
What does the CONCATENATE function do?Joins two or more strings of textAdds two numbersSeparates text into columnsFormats textA) Joins two or more strings of textThe CONCATENATE function joins multiple strings of text into one string.
Which of the following is NOT a valid Excel function?=SUM=AVERAGE=COUNT=MULTIPLYD) =MULTIPLYExcel has no MULTIPLY function; multiplication is done with the * operator.
What does the =IF() function do?It checks a condition and returns one value if true, and another if false.It calculates the sum of two numbers.It multiplies two numbers.It checks if a number is divisible by another.A) It checks a condition and returns one value if true, and another if false.The =IF() function evaluates a condition and returns one value if true, and another if false.
Which of the following Excel chart types is best suited for showing proportions of a whole?Line chartColumn chartPie chartScatter plotC) Pie chartPie charts are ideal for showing proportions of a whole.
What is a Pivot Table used for in Excel?Performing calculationsOrganizing and summarizing large sets of dataCreating chartsFormatting cellsB) Organizing and summarizing large sets of dataPivot tables are used to summarize, analyze, and explore large datasets.
How can you change the width of a column in Excel?Double-click the column borderRight-click and choose "Column Width"Both A and BUse the "Format" menuC) Both A and BYou can either double-click the column border or use the "Column Width" option to change the width.
Which of the following functions returns the current date in Excel?=DATE()=TODAY()=CURRENTDATE()=NOW()B) =TODAY()The =TODAY() function returns the current date in Excel.
Which feature allows users to apply the same formatting across multiple cells or ranges?Copy and PasteFormat PainterConditional FormattingAutoFillB) Format PainterThe Format Painter allows you to copy formatting from one cell and apply it to others.
What is the purpose of the COUNTIF() function?Counts the number of non-empty cellsCounts the number of cells that meet a conditionCounts the total number of rowsCounts the number of text cellsB) Counts the number of cells that meet a conditionThe COUNTIF() function counts the number of cells that meet a specific condition.
Which function returns the largest number from a range of cells?=LARGE()=MAX()=SUM()=AVERAGE()B) =MAX()The =MAX() function returns the largest value in a range.
How do you apply a cell reference that doesn't change when copied to other cells?Use a relative referenceUse an absolute referenceUse a mixed referenceUse a dynamic referenceB) Use an absolute referenceAn absolute reference (e.g., $A$1) remains fixed when copied to other cells.
What is the shortcut for saving a workbook in Excel?Ctrl + SCtrl + PCtrl + CCtrl + NA) Ctrl + SCtrl + S is the shortcut for saving a workbook.
How do you hide a row in Excel?Right-click the row and select "Hide"Use the "Format" menuPress Ctrl + HBoth A and BD) Both A and BYou can hide a row by right-clicking and selecting "Hide" or using the "Format" menu.
What is the result of the formula =A1+B1 when A1 contains 10 and B1 contains 5?5101550C) 15The formula adds the values in A1 and B1, so the result is 15.
What is the purpose of the "Data Validation" feature in Excel?To ensure data is correctly formattedTo check if data meets specific conditionsTo filter dataTo calculate dataB) To check if data meets specific conditionsData validation ensures that the data entered into a cell meets specific conditions, such as a range of numbers or specific text.
Which Excel function is used to find the average of a range of numbers?=AVG()=AVERAGE()=MEAN()=MID()B) =AVERAGE()The =AVERAGE() function calculates the average of a specified range of numbers.
What happens when you press Ctrl + Z in Excel?Undo the last actionRedo the last actionSave the documentCopy the selected dataA) Undo the last actionCtrl + Z is the shortcut for undoing the last action.
