Font size
Worksheets3rd Qurter Exam Exploring Microsoft Excel
Total questions: 20
Worksheet time: 26mins
What is the main purpose of Microsoft Excel?
The main purpose of Microsoft Excel is to organize and analyze data.
To manage email communications.
To create and edit text documents.
To design graphics and illustrations.
Name three main components of the Excel interface.
Toolbar, Cell, Formula Bar
Ribbon, Worksheet, Status Bar
Header, Footer, Navigation Pane
Menu Bar, Grid, Sidebar
What is a cell in Excel?
A cell in Excel is a basic unit of a spreadsheet where data is entered.
A cell in Excel is a programming function.
A cell in Excel is a type of formula.
A cell in Excel is a graphic element.
How do you select a range of cells in Excel?
Use the arrow keys to highlight a range of cells.
Double-click on a cell to select it.
Click and drag or use Shift + click to select a range of cells.
Press Ctrl + A to select all cells.
What is the difference between a formula and a function?
A formula is used for formatting; a function is used for styling.
A formula calculates values; a function performs operations and returns results.
A formula is always a number; a function is always a text.
A formula is a type of function; a function cannot be a formula.
How do you start a formula in Excel?
Enter 'formula' before the equation.
Start with '!' followed by the formula.
Type '=' followed by the formula.
Use '#' to begin the formula.
What function would you use to find the total of a set of numbers?
average()
sum()
total()
mean()
How can you create a chart in Excel?
Right-click on the data and choose 'Delete'
Select data, go to 'Insert' tab, choose chart type, and customize.
Go to 'View' tab and select 'Zoom'
Click on 'File' and select 'New'
What types of charts can you create in Excel?
Bar charts, line charts, pie charts, scatter plots, area charts, column charts, doughnut charts, radar charts, and surface charts.
histogram charts
Gantt charts
waterfall charts
What is the purpose of sorting data in Excel?
To change the font style of the text.
To organize and analyze data more effectively.
To create charts and graphs automatically.
To delete unnecessary data from the spreadsheet.
How can you filter data in an Excel spreadsheet?
Use the 'Filter' option in the 'Data' tab to filter data in Excel.
Apply conditional formatting to highlight specific data in Excel.
Use the 'Sort' option in the 'Home' tab to filter data in Excel.
Create a pivot table to summarize data instead of filtering it.
What is the shortcut key to copy a cell in Excel?
Ctrl + C
Alt + C
Ctrl + X
Ctrl + V
How do you change the format of a cell in Excel?
Right-click the cell, select 'Format Cells', choose the format, and click 'OK'.
Select the cell, go to the 'Home' tab, and click 'Insert'.
Double-click the cell and type the new format directly.
Use the 'Data' tab to change the cell format.
Which kind of chart uses bars to compare different things?
Bar Graphs
Line Graphs
Scatter
Pie Chart
How can you insert a new row in an Excel worksheet?
Press Ctrl + N to create a new row.
Drag and drop a cell to create a new row.
Click on the 'Home' tab and select 'New Row'.
Right-click on a row number and select 'Insert'.
How will you compute the average from A1 to A10?
=SUM(A1:A10)
=SUM(A1:A10)/10
=SUM(A1:A10)+10
=SUM(A1:A10)-10
How will you compute the sum of B1 to B20?
=SUM(B1-B20)/20
=SUM(B1:B20)
=SUM(B1:B20)-20
=SUM(B1:B20)+20
DETERMINE THE "MIN" OF THE FOLLOWING DATA: 78, 80, 69, 70, 71, 81, 89, 90, 99, 79, 100
(a)
DETERMINE THE "MAX" OF THE FOLLOWING DATA. 67, 69, 70, 66, 81, 63, 64, 74, 61, 75, 80
(a)
WHAT IS THE AVERAGE OF THE FOLLOWING DATA? 90, 89, 100, 88, 86, 95, 93, 82, 91, 94
(a)
