S.
No Questions
1 Which of the following is the correct shortcut to copy data in Excel
2 Which Excel function is used to find the average of a data range?
3
What does the 'AutoSum' function in Excel do?
4 Which function in Excel finds the standard deviation of a set of data?
5 Which of the following Excel functions is used for matrix multiplication?
6
What is the purpose of the 'Paste Special' function in Excel?
7 Which option allows you to sort data in Excel?
8 Which option would you use to remove duplicate data from a range in Excel?
9
How can you filter data in Excel?
10 Which of the following is NOT a type of chart available in Excel?
11 Which key do you press to open the Paste Special dialog box in Excel?
12
How do you calculate the transpose of a matrix in Excel?
13 Which chart type is best for showing percentage contributions in Excel?
14 What is the default file extension of an Excel workbook?
15
Which of the following methods is used to export Excel data to PowerPoint?
16 Which function can be used to find the inverse of a matrix in Excel?
17 Which Excel feature helps you to create a dynamic chart that updates automatically when data changes?
18 Which is the correct formula for calculating the sum of cells A1 to A10?
19 What is the shortcut to paste data in Excel?
20 Which function would you use to find the largest number in a dataset in Excel?
21 Which of the following is an Excel function used to find the median of a set of numbers?
22 What happens when you press Ctrl + Z in Excel?
23 Which function would you use in Excel to concatenate two text strings?
24 What type of chart is most appropriate for comparing values across categories in Excel?
25 Which function would you use in Excel to calculate the number of cells containing numerical data?
26 In Excel, which function would you use to find the smallest value in a range?
27 Which Excel function can be used to find the difference between two dates in days?
28 How do you insert a hyperlink in Excel?
29 In Excel, which type of chart is best suited for showing trends over time?
30
What does the 'Format as Table' feature in Excel do?
31 What is the primary function of a Pivot Table in Excel?
32 What is R primarily used for?
33 Which of the following is a feature of R?
34 Which of the following is the correct way to assign a value to a variable in R?
35 Which operator is used for assignment in R?
36 What type of data is returned by the following command: typeof(3)?
37
Which of the following is a correct R data structure?
38
Which environment is commonly used for R programming?
39
Which of the following is the default mode for a variable in R?
40
Which of the following is a logical value in R?
41 Which operator is used to compare values for equality in R?
42
Which of the following is a control structure in R?
43 Which function is used to create a sequence of numbers in R?
44 What is the output of the expression 5 > 3 & 4 < 6 in R?
45 Which of the following is used to return the class of an object in R?
46 Which of the following is used to display a summary of an object in R?
47
What does the typeof() function return in R?
48 Which function would you use to create a new object and assign it to a variable in R?
49 Which of the following can R be used for?
50
What type of language is R considered to be?
Correct Answer
Option A Option B Option C Option D
( A/ B /C / D)
A) Ctrl + C B) Ctrl + V C) Ctrl + X D) Ctrl + P A
A) AVERAGE B) MEAN C) SUM D) MEDIAN A
A) Automatically calculates the B) Automatically inserts a sum C) Automatically filters D) Automatically checks B
average of selected data of selected data data for errors in data
A) STDEV.P B) AVG C) [Link] D) VARIANCE A
A) MMULT B) TRANSPOSE C) [Link] D) MULTIPLY A
A) To only paste values C) To paste a linked D
without formatting B) To paste formatting only reference to another sheet D) All of the above
A) Home Tab B) Data Tab C) Review Tab D) View Tab B
A) Clear Contents B) Remove Duplicates C) Delete Row D) Format as Table B
A) Use the Sort & Filter option B) Use the Find & Replace C) Use the Conditional D) Use the Page Layout
in the Data tab option Formatting feature tab A
A) Line Chart B) Bar Chart C) Heat Map Chart D) Pie Chart C
A) F2 B) Ctrl + C C) Ctrl + Alt + V D) Shift + F12 C
A) Use the TRANSPOSE C) Use the AVERAGE D) Use the VLOOKUP
function function function A
B) Use the SUM function
A) Line chart B) Pie chart C) Bar chart D) Scatter plot B
A) .xls B) .xlsx C) .docx D) .pptx B
A) Copy and paste the data C) Use the Export option D) Use the ‘Insert A
manually B) Save as PowerPoint format under the File tab Object’ option
A) MINVERSE B) INVERSE C) [Link] D) TRANSPOSE A
A) Table B) Pivot Table C) Chart Filters D) Named Ranges B
A) =SUM(A1:A10) B) =ADD(A1:A10) C) =TOTAL(A1:A10) D) =SUM(A1,A10) A
A) Ctrl + C B) Ctrl + V C) Ctrl + X D) Ctrl + P B
A) MAX B) MIN C) LARGE D) HIGH A
A) MEDIAN B) AVERAGE C) MODE D) SUM A
A) Undo the last action B) Redo the last action C) Save the workbook D) Zoom in A
A) CONCATENATE B) COMBINE C) JOIN D) CONCAT A
A) Line Chart B) Bar Chart C) Scatter Plot D) Pie Chart B
A) COUNT B) COUNTA C) COUNTIF D) SUM A
A) MIN B) MAX C) SMALL D) LOW A
A) DATEDIF B) DAYS C) DATE D) DIFF B
select 'Insert Hyperlink' Insert tab =HYPERLINK() D) All of the above D
A) Bar Chart B) Line Chart C) Pie Chart D) Histogram B
B) Converts a range of data into C) Converts the data into a D) Organizes data in B
A) Adds gridlines to the table a structured table with filters bar chart alphabetical order
selected data present large data sets worksheets into one on user input B
A) Web development B) Data analysis and statistics C) System programming D) Game development B
A) Open-source programming packages D) All of the above D
A) x = 10 B) 10 <- x C) x <- 10 D) All of the above D
A) = B) <- C) == D) := B
A) integer B) numeric C) double D) character A
D
A) List B) Vector C) Data Frame D) All of the above
B
A) Jupyter Notebooks B) RStudio C) Visual Studio Code D) IntelliJ IDEA
D) Integer D
A) Character B) Numeric C) Logical
D
A) TRUE B) FALSE C) NA D) All of the above
A) = B) == C) := D) != B
B) else C) for D) All of the above D
A) if
A) seq() B) rep() C) range() D) numbers() A
A) FALSE B) TRUE C) NA D) Error B
A) class() B) type() C) mode() D) str() A
A) summary() B) print() C) describe() D) structure() A
D) The dimensions of A
A) The data type of an object B) The class of an object C) The length of an object an object
A) create() B) assign() C) new() D) def() B
A) Data manipulation B) Data visualization C) Statistical analysis D) All of the above D
D
A) Object-oriented B) Procedural C) Functional D) All of the above
( −4)/(−2)=( −5)/3
=( −9)/(−2)
The
straight
lines
and