NEW
Font size
WorksheetsMastering MS Excel Concepts
Total questions: 50
Worksheet time: 25mins
What function would you use to find the average of a range of cells?
MAX
SUM
AVERAGE
COUNT
How do you create a chart in Excel?
Right-click on the data and choose 'Delete'
Click on 'File' and select 'New'
Use the 'Format' tab to change colors only
Select data, go to 'Insert' tab, choose chart type, and customize.
What is the shortcut key for saving a workbook?
Alt + S
Shift + S
Ctrl + S
Ctrl + P
What does the VLOOKUP function do?
It calculates the sum of a range of cells.
It formats cells based on their values.
It looks up a value in a table and returns a corresponding value from another column.
It sorts data in ascending order.
How can you freeze panes in an Excel worksheet?
Select the cell, go to 'Home' > 'Freeze' > 'Freeze Top Row'.
Right-click the cell and choose 'Freeze Panes' from the context menu.
Select the cell, go to 'View' > 'Freeze Panes' > 'Freeze Panes'.
Select the entire worksheet and click 'View' > 'Freeze Panes' > 'Freeze First Column'.
What is the purpose of the CONCATENATE function?
To join multiple strings into one string.
To split a string into multiple parts.
To format a string with specific styles.
To convert a string to uppercase.
How do you apply conditional formatting to a cell?
Right-click the cell and select 'Format Cells'
Select the cell, then press 'Ctrl + Z' to undo any formatting
Go to 'Data' > 'Sort & Filter' > 'Filter'
Select the cell, go to 'Home' > 'Conditional Formatting' > choose a rule > set formatting > click 'OK'.
What is the difference between relative and absolute cell references?
Relative references adjust based on the position; absolute references do not change.
Both relative and absolute references are the same in functionality.
Relative references are used for formatting, while absolute references are for calculations.
Relative references are always fixed; absolute references change based on position.
How can you sort data in Excel?
Click on 'File' and select 'Export' to save the data.
Select the data range, go to 'Data' tab, and click 'Sort'.
Right-click on the data and choose 'Delete' to remove it.
Use the 'Insert' tab to add new data columns.
What is a pivot table and how is it used?
A pivot table is a tool for summarizing and analyzing data in spreadsheets.
A pivot table is a type of database management system.
A pivot table is a graphical representation of data trends.
A pivot table is used for creating complex algorithms.
The function COUNT is specific for _________________
Counting cells
Counting text
Counting number
Counting tables
What function was used to find the lowest data ?
AVERAGE
MIN
MAX
SUM
Microsoft Excel is categorize as ?
Word Processing Software
Database Software
Spreadsheet Software
Presentation Software
In Excel, the name of the bar where information appears as you input data in called ?
File Bar
Help Bar
Formula Bar
Window Bar
What function was used to find the highest data ?
AVERAGE
MIN
SUM
MAX
The function that lets you add up a range of cells or values
AVERAGE
SUM
MIN
MAX
To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula
&
#
=
*
In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on
Column
Label
Row
Cell Address
In a worksheet, the vertical spaces with the headings A, B, C and so on
Cell
Column
Row
Data
What does the horizontal axis (x-axis) of an Excel chart represent?
Data series
Category labels
Legend
Data points
What is the purpose of data labels in an Excel chart?
To display the category names on the chart
To provide a description of the chart's data
To identify each data point with its value
To create a legend for the chart
In Excel charts, what is data series?
The title of the chart
The horizontal axis labels
A collection of related data points
The vertical axis labels
What is the purpose of a legend in an Excel chart?
To display the data labels
To provide a title for the chart
To show the values of each data point
To identify the data series in the chart
Which Excel chart type is best suited for comparing individual data points in a category?
Line chart
Bar chart
Pie chart
Scatter plot
What is the purpose of a secondary axis in an Excel chart?
To add more data series to the chart
To make the chart title stand out
To display a second set of data with a different scale
To adjust the alignment of the data labels
Which of the following is not a valid type of Excel chart?
Area Chart
Radar Chart
Cylinder Chart
Bubble Chart
Which Excel chart type is suitable for showing trends over a period of time?
Bar Chart
Pie Chart
Line Chart
Scatter Plot
Charts are present in the _______ tab.
Home
Data
Insert
Formulas
The contextual tabs that appears with charts are
Design and Layout
Layout and Format
Format and Options
Design and Format
The bar where information appears as you input data is called ______________.
file bar
help bar
window bar
formula bar
Microsoft Excel is categorized as a ________________ software.
Database
Spreadsheet
Presentation
Word Processing
Which is NOT a term used in Excel?
Workbook
Worksheet
Cell
Document
In Excel, rows are identified by this
Letters
Numbers
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
The intersection of a row and a column is called this.
Active Cell
Chart
Column
Row
What is the purpose of a legend in an Excel chart?
To display the data labels
To provide a title for the chart
To show the values of each data point
To identify the data series in the chart
In Excel charts, what is data series?
The title of the chart
The horizontal axis labels
A collection of related data points
The vertical axis labels
What is the purpose of a secondary axis in an Excel chart?
To add more data series to the chart
To make the chart title stand out
To display a second set of data with a different scale
To adjust the alignment of the data labels
Which Excel chart type is suitable for showing trends over a period of time?
Bar Chart
Pie Chart
Line Chart
Scatter Plot
Charts are present in the _______ tab.
Home
Data
Insert
Formulas
The contextual tabs that appears with charts are
Design and Layout
Layout and Format
Format and Options
Design and Format
To alert Excel that you are entering a formula and not text, type a(n) _________________ proceeding the formula
&
#
=
*
In a worksheet, the horizontal spaces with the headings 1, 2, 3 and so on
Column
Label
Row
Cell Address
In a worksheet, the vertical spaces with the headings A, B, C and so on
Cell
Column
Row
Data
A program using a table comprising of rows, columns and cells.
MS Word
MS PowerPoint
MS Outlook
MS Excel
