1 What is the file extension of a Microsoft Excel workbook?
A) .xls
B) .xlsx
C) .xlsm
D) .xlsb
Answer: B) .xlsx
2 Which function is used to sum a range of cells in Excel?
A) =SUM()
B) =TOTAL()
C) =ADD()
D) =RANGE()
Answer: A) =SUM()
3 Which symbol is used to start a formula in Excel?
A) =
B) +
C) –
D) #
Answer: A) =
4 What does the function =AVERAGE(A1:A10) do in Excel?
A) Finds the median of the range A1:A10
B) Finds the average of the range A1:A10
C) Finds the mode of the range A1:A10
D) Finds the standard deviation of the range A1:A10
Answer: B) Finds the average of the range A1:A10
5 Which ribbon tab in Excel contains the options for formatting cells?
A) Home
B) Insert
C) Data
D) Format
Answer: A) Home
6 What is the keyboard shortcut to save an Excel workbook?
A) Ctrl + S
B) Ctrl + C
C) Ctrl + V
D) Ctrl + X
Answer: A) Ctrl + S
7 Which function is used to find the maximum value in a range of cells?
A) =MAX()
B) =MIN()
C) =LARGE()
D) =SMALL()
Answer: A) =MAX()
8 Which option in Excel allows you to freeze rows and columns so they remain visible as you scroll?
A) Freeze Panes
B) Hide
C) Lock
D) Protect Sheet
Answer: A) Freeze Panes
9 Which function is used to count the number of cells in a range that contain numbers in Excel?
A) =COUNT()
B) =SUM()
C) =AVERAGE()
D) =MAX()
Answer: A) =COUNT()
10 In Excel, what is the purpose of the VLOOKUP function?
A) To look up values in a vertical range
B) To look up values in a horizontal range
C) To look up values in a table array
D) To look up values in a specified column
Answer: A) To look up values in a vertical range
11 Which option in Excel allows you to add a comment to a cell?
A) Insert Comment
B) Add Note
C) Add Comment
D) Insert Note
Answer: A) Insert Comment
12 How can you quickly select the entire worksheet in Excel?
A) Click the Select All button at the intersection of row numbers and column letters
B) Press Ctrl + A
C) Right-click on the sheet tab and select Select All
D) Double-click on the sheet tab
Answer: A) Click the Select All button at the intersection of row numbers and column letters
13 Which function in Excel is used to concatenate two or more text strings?
A) =CONCATENATE()
B) =JOIN()
C) =MERGE()
D) =TEXTJOIN()
Answer: A) =CONCATENATE()
14 How can you create a chart in Excel?
A) Click on the Chart button in the Insert tab
B) Right-click on the data and select Create Chart
C) Press Alt + F1
D) All of the above
Answer: A) Click on the Chart button in the Insert tab
15 What does the function =IF(A1>10, "Yes", "No") do in Excel?
A) Returns "Yes" if cell A1 is greater than 10, otherwise returns "No"
B) Returns "Yes" if cell A1 is less than or equal to 10, otherwise returns "No"
C) Returns "Yes" if cell A1 is equal to 10, otherwise returns "No"
D) Returns "Yes" if cell A1 is greater than or equal to 10, otherwise returns "No"
Answer: A) Returns "Yes" if cell A1 is greater than 10, otherwise returns "No"
16 Which option in Excel allows you to create a dropdown list in a cell?
A) Data Validation
B) List
C) Dropdown
D) Combo Box
Answer: A) Data Validation
17 What is the keyboard shortcut to insert a new worksheet in Excel?
A) Ctrl + N
B) Ctrl + W
C) Ctrl + Shift + N
D) Ctrl + Shift + W
Answer: C) Ctrl + Shift + N
18 Which function in Excel is used to round a number to a specified number of digits?
A) =ROUND()
B) =ROUNDUP()
C) =ROUNDDOWN()
D) =TRUNC()
Answer: A) =ROUND()
19 How can you apply a filter to a range of data in Excel?
A) Click on the Filter button in the Data tab
B) Right-click on the data and select Filter
C) Press Ctrl + F
D) All of the above
Answer: A) Click on the Filter button in the Data tab
20 What is the purpose of the COUNTIF function in Excel?
A) To count the number of cells in a range that meet a specific condition
B) To count the number of cells in a range that contain numbers
C) To count the number of cells in a range that are not empty
D) To count the number of cells in a range that contain text
Answer: A) To count the number of cells in a range that meet a specific condition
21 Which option in Excel allows you to create a formula that can be copied to other cells with
different cell references?
A) Relative referencing
B) Absolute referencing
C) Mixed referencing
D) Incremental referencing
Answer: A) Relative referencing
22 How can you insert a row in Excel?
A) Right-click on the row and select Insert
B) Click on the Insert button in the Home tab
C) Press Ctrl + Shift + +
D) All of the above
Answer: D) All of the above
23 Which function is used to find the square root of a number in Excel?
A) =SQRT()
B) =ROOT()
C) =POWER()
D) =SQUARE()
Answer: A) =SQRT()
24 What is the purpose of the IFERROR function in Excel?
A) To return a specified value if a formula evaluates to an error
B) To check if a cell contains an error
C) To convert an error value to 0
D) To display an error message
Answer: A) To return a specified value if a formula evaluates to an error
25 How can you format a cell to display a number as a percentage in Excel?
A) Select the cell, right-click, and choose Format Cells, then select Percentage
B) Click on the Percentage button in the Home tab
C) Type the percentage symbol (%) after the number
D) All of the above
Answer: A) Select the cell, right-click, and choose Format Cells, then select Percentage
26 Which function is used to find the current date and time in Excel?
A) =NOW()
B) =TODAY()
C) =DATE()
D) =TIME()
Answer: A) =NOW()
27 What does the function =TEXT(A1, "mm/dd/yyyy") do in Excel?
A) Converts the date in cell A1 to the format mm/dd/yyyy
B) Converts the text in cell A1 to a date in the format mm/dd/yyyy
C) Converts the date in cell A1 to text in the format mm/dd/yyyy
D) Converts the text in cell A1 to uppercase
Answer: A) Converts the date in cell A1 to the format mm/dd/yyyy
28 Which option in Excel allows you to group and outline data?
A) Group
B) Outline
C) Subtotal
D) Consolidate
Answer: B) Outline
29 How can you quickly copy the formatting of a cell to another cell in Excel?
A) Use the Format Painter button in the Home tab
B) Right-click on the cell and select Copy Format
C) Press Ctrl + Shift + C to copy the format and Ctrl + Shift + V to paste the format
D) All of the above
Answer: A) Use the Format Painter button in the Home tab
30 What is the purpose of the CONCAT function in Excel?
A) To concatenate two or more text strings
B) To concatenate two or more ranges
C) To concatenate two or more numbers
D) To concatenate two or more dates
Answer: A) To concatenate two or more text strings
31 Which function is used to find the largest value that is less than or equal to a given value in a
sorted array in Excel?
A) =LOOKUP()
B) =MATCH()
C) =HLOOKUP()
D) =VLOOKUP()
Answer: B) =MATCH()
32 How can you quickly delete a column in Excel?
A) Right-click on the column and select Delete
B) Click on the Delete button in the Home tab
C) Press Ctrl + –
D) All of the above
Answer: A) Right-click on the column and select Delete
33 What does the function =SUBTOTAL(9, A1:A10) do in Excel?
A) Finds the average of the range A1:A10
B) Finds the maximum value in the range A1:A10
C) Finds the sum of the range A1:A10
D) Finds the count of cells in the range A1:A10
Answer: C) Finds the sum of the range A1:A10
34 Which option in Excel allows you to protect a worksheet from being edited?
A) Protect Sheet
B) Lock Sheet
C) Hide Sheet
D) Secure Sheet
Answer: A) Protect Sheet
35 How can you format a cell to display a date in a specific format in Excel?
A) Select the cell, right-click, and choose Format Cells, then select Date and choose a format
B) Click on the Date button in the Home tab
C) Type the date in the desired format
D) All of the above
Answer: A) Select the cell, right-click, and choose Format Cells, then select Date and choose a format
36 What is the purpose of the TRANSPOSE function in Excel?
A) To transpose a range of cells
B) To transpose a single cell
C) To convert text to uppercase
D) To convert text to lowercase
Answer: A) To transpose a range of cells
37 Which function in Excel is used to calculate the compound interest on a loan or investment?
A) =CUMIPMT()
B) =IPMT()
C) =FV()
D) =PV()
Answer: C) =FV()
38 How can you insert the current date in a cell in Excel?
A) Type =TODAY()
B) Type =NOW()
C) Type the date manually
D) All of the above
Answer: B) Type =NOW()
39 What is the purpose of the PMT function in Excel?
A) To calculate the payment for a loan
B) To calculate the interest rate for a loan
C) To calculate the present value of a loan
D) To calculate the future value of a loan
Answer: A) To calculate the payment for a loan
40 Which option in Excel allows you to automatically fill a series of data?
A) Auto Fill
B) Auto Complete
C) Auto Series
D) Auto Increment
Answer: A) Auto Fill
41 What does the function =LEN(A1) do in Excel?
A) Returns the length of the text in cell A1
B) Returns the number of characters in cell A1
C) Returns the number of words in cell A1
D) Returns the number of lines in cell A1
Answer: B) Returns the number of characters in cell A1
42 How can you quickly format a cell to display currency in Excel?
A) Select the cell, right-click, and choose Format Cells, then select Currency
B) Click on the Currency button in the Home tab
C) Type the currency symbol ($) before the number
D) All of the above
Answer: A) Select the cell, right-click, and choose Format Cells, then select Currency
43 Which function is used to find the smallest value in a range of cells in Excel?
A) =MIN()
B) =MAX()
C) =SMALL()
D) =LARGE()
Answer: A) =MIN()
44 How can you quickly move to the last cell in a worksheet that contains data in Excel?
A) Press Ctrl + End
B) Press Ctrl + Home
C) Press Ctrl + ↓
D) Press Ctrl + →
Answer: A) Press Ctrl + End
45 What is the purpose of the DATEDIF function in Excel?
A) To calculate the difference between two dates
B) To calculate the number of days between two dates
C) To calculate the number of months between two dates
D) To calculate the number of years between two dates
Answer: A) To calculate the difference between two dates
46 Which option in Excel allows you to create a pivot table?
A) Pivot Table
B) Create Pivot
C) Insert Pivot Table
D) Pivot
Answer: C) Insert Pivot Table
47 How can you format a cell to display a time in a specific format in Excel?
A) Select the cell, right-click, and choose Format Cells, then select Time and choose a format
B) Click on the Time button in the Home tab
C) Type the time in the desired format
D) All of the above
Answer: A) Select the cell, right-click, and choose Format Cells, then select Time and choose a format
48 What does the function =NOW() - A1 do in Excel?
A) Returns the current date and time minus the date in cell A1
B) Returns the current date and time plus the date in cell A1
C) Returns the current date and time divided by the date in cell A1
D) Returns the current date and time multiplied by the date in cell A1
Answer: A) Returns the current date and time minus the date in cell A1
49 Which option in Excel allows you to create a table from a range of data?
A) Create Table
B) Insert Table
C) Table
D) Format as Table
Answer: D) Format as Table
50 How can you quickly insert the current time in a cell in Excel?
A) Type =NOW()
B) Type =TIME()
C) Type the time manually
D) All of the above
Answer: A) Type =NOW()
51 What is Tableau?
A) A database management system
B) A data visualization software
C) A programming language
D) A statistical analysis tool
Answer: B) A data visualization software
52 Which of the following data sources can be connected to Tableau?
A) Excel files
B) SQL databases
C) Google Sheets
D) All of the above
Answer: D) All of the above
53 What is a dimension in Tableau?
A) A measure that can be aggregated
B) A categorical field used for grouping and labeling data
C) A continuous field used for numeric calculations
D) A geographic field for mapping data
Answer: B) A categorical field used for grouping and labeling data
54 Which type of chart is best suited for comparing values across categories in Tableau?
A) Line chart
B) Bar chart
C) Pie chart
D) Scatter plot
Answer: B) Bar chart
55 What is the purpose of a calculated field in Tableau?
A) To perform calculations on existing fields
B) To filter data in a visualization
C) To sort data in a visualization
D) To group data in a visualization
Answer: A) To perform calculations on existing fields
56 How can you create a dashboard in Tableau?
A) By dragging and dropping sheets onto the dashboard canvas
B) By selecting the New Dashboard option from the File menu
C) By clicking on the Dashboard tab in the worksheet
D) By using the Create Dashboard button in the toolbar
Answer: A) By dragging and dropping sheets onto the dashboard canvas
57 What is the purpose of the Show Me feature in Tableau?
A) To display data in a visual format
B) To suggest different types of visualizations based on the data
C) To export data to other applications
D) To share visualizations with others
Answer: B) To suggest different types of visualizations based on the data
58 Which of the following is a Tableau data blending feature?
A) Data Union
B) Data Merge
C) Data Join
D) Data Blend
Answer: D) Data Blend
59 What is the purpose of a filter in Tableau?
A) To change the appearance of a visualization
B) To remove unwanted data from a visualization
C) To add additional data to a visualization
D) To group data in a visualization
Answer: B) To remove unwanted data from a visualization
60 Which of the following is a Tableau Server feature?
A) Data Source
B) Workbook
C) Dashboard
D) Project
Answer: D) Project
61 How can you create a parameter in Tableau?
A) By right-clicking on a field and selecting Create Parameter
B) By selecting the New Parameter option from the Analysis menu
C) By clicking on the Parameters tab in the Data Source pane
D) By using the Create Parameter button in the toolbar
Answer: A) By right-clicking on a field and selecting Create Parameter
62 What is the purpose of the Pages shelf in Tableau?
A) To create animated visualizations
B) To add additional data to a visualization
C) To group data in a visualization
D) To filter data in a visualization
Answer: A) To create animated visualizations
63 Which of the following is a Tableau data connection option?
A) Live
B) Direct
C) Indirect
D) Static
Answer: A) Live
64 What is the purpose of the Marks card in Tableau?
A) To add data to a visualization
B) To format the appearance of a visualization
C) To sort data in a visualization
D) To group data in a visualization
Answer: B) To format the appearance of a visualization
65 Which of the following is a Tableau aggregation function?
A) TOTAL()
B) SUM()
C) AVG()
D) All of the above
Answer: D) All of the above
66 How can you sort data in a visualization in Tableau?
A) By clicking on the Sort button in the toolbar
B) By right-clicking on a field and selecting Sort
C) By dragging and dropping fields onto the Sort shelf
D) All of the above
Answer: B) By right-clicking on a field and selecting Sort
67 What is the purpose of the Trend Lines feature in Tableau?
A) To add trend lines to a visualization
B) To create forecasts based on historical data
C) To analyze data trends over time
D) All of the above
Answer: D) All of the above
68 How can you format the axis labels in a visualization in Tableau?
A) By clicking on the Axis Labels button in the toolbar
B) By right-clicking on an axis and selecting Format
C) By dragging and dropping fields onto the Axis Labels shelf
D) By using the Format Axis dialog box
Answer: B) By right-clicking on an axis and selecting Format
69 What is the purpose of the Data Interpreter feature in Tableau?
A) To interpret data from different sources
B) To clean and prepare data for analysis
C) To import data into Tableau
D) To export data from Tableau
Answer: B) To clean and prepare data for analysis
70 Which of the following is a Tableau mapping feature?
A) Map Layers
B) Map Styles
C) Map Legends
D) All of the above
Answer: D) All of the above
