Font size
WorksheetsMicrosoft Excel
Total questions: 12
Worksheet time: 9mins
What is the meaning of 'IF' statement?
is a programming language that produces software for multiple platforms.
the process of assigning a code to something for classification or identification.
sample program that ask the user to enter two values
is a programming conditional statement that, if proved true, performs a function or displays information.
To sort names in a worksheet, we can use ____ button
If you want to find an average of cells A1 through A25, which formula would you use?
=average(A1:A25)
=avg(A1:A25)
=average(A1-A25)
=avg(A1-A25)
Which of the following is the correct syntax for the SUMIFS function?
=SUMIFS(Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …],Sum_Range)
=SUMIFS([Sum_Range], Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …])
=SUMIFS(Sum_Range, Criterion_Range1, Criterion1, [Criterion_Range2, Criterion2, …])
Don't know
What does COUNTA ( ) function do?
Counts cells having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells
What is a chart in Microsoft Excel?
A chart in Microsoft Excel is a type of formula.
A chart in Microsoft Excel is a way to organize files.
A chart in Microsoft Excel is a graphical representation of data.
A chart in Microsoft Excel is a feature for creating animations.
What is the typical sequence for creating a chart?
A. Click the cell to contain the chart, select the chart type, and then select the data source.
B. Select the data source, select the chart type, and then size and position the chart.
C. Select the data source, size the chart, select the chart type, and then position the chart.
D. Select the chart type, select the data source, and then size and position the chart.
What type of chart is good for single series of data ?
Column Chart
Bar Chart
Line Chart
Pie Chart
This is a horizontal or vertical line that extends across the plot area to make it easier to read and follow the values
Grid line
Data point
Value Axis
Tick mark
How can you create a chart in Excel?
Go to Format tab, click on Chart button, choose chart type
Click on the data, press Ctrl+C, go to Insert tab, click on Chart button, choose chart type
Select data, go to Insert tab, click on Chart button, choose chart type
Right-click on the data, select Create Chart
Which type of chart is the least appropriate for depicting yearly rainfall totals for five cities
for four years?
Bar Chart
Pie Chart
Line Chart
Column Chart
Tell me about your learning experience from the lectures conducted on Excel in 1-2 words?
