Font size
WorksheetsMS Excel Review Questions - Cl 10
Total questions: 13
Worksheet time: 50mins
_______________ allows you to highlight cells that meet specific criteria.
Font formatting
Conditional formatting
Filtering
Find and replace
Karma wants to use the conditional formatting features in MS Excel. Which of the following has the conditional formatting button?
Styles group
Cells group
Editing group
Number group
Which of the following tabs will help Anil to create a chart for data visualization?
Home tab
Insert tab
Data tab
Review tab
Dorji has divided a numeric value by zero in a formula while working in a worksheet. Which of the following error will occur?
#VALUE!
#NUM!
#DIV/0!
#NAME?
Sunil Tamang wants to clean and validate the data in MS Excel using Sort and Filter method. He can sort data by any of the following option EXCEPT
font colour
cell icon
cell colour
number formatting
Pema clicked inside the (a) bar to edit the content of the cell.
Pema entered the name of different colours in column A in MS Excel. Which of the following functions can be used by Pema to count the number of cells with the value ‘Red’?
MAX
COUNT
COUNTIF
COUNTA
Consider the following table that shows the information about employees, their departments and their salaries.
Which of the following formulas will give the table salary for employees in the IT department? - (BCSE 2024)
=SUMIF(A2:A6, “IT”,C2:C6)
=SUMIF(A2:A6, “IT”,B2:B6)
=SUMIF(B2:B6, “IT”,B2:B6)
=SUMIF(B2:B6, “IT”,C2:C6)
(a) is the functions used in MS Excel that looks up the values vertically down a column and then horizontally across a row.
Using MS Excel, the (a) features allow karma to see only those records that he wants to display while it hides the rest of the data temporarily from the view.
What are some key steps in data cleaning, and why is it essential before performing data analysis and visualization?
Mr. Dorji, a sales manager, wants to visually analyse the monthly sales data for his team to identify trends and patterns. He has recorded the sales figures for each month in an Excel spreadsheet. Which Excel features should he use to create a graphical representation of the sales data and how will this help him in his analysis? (BCSE 2024)
The records of the students’ marks and the chart prepared on the basis of the information given in the worksheet is displayed as follows.
Answer the following questions based on the preceding chart.
Identify the types of the given chart.
Pie Chart
Column Chart
Bar Chart
Line Chart
Write down the formula used in cell G3.
