NEW
Font size
WorksheetsMastering Excel Essentials_Sairam
Total questions: 20
Worksheet time: 18mins
What function would you use to sum a range of cells in Excel?
TOTAL
SUM
ADD
COUNT
How do you create a chart in Excel to visualize data?
Choose a chart type without selecting data first.
Go to 'View' tab and click on 'Chart Wizard' to create a chart.
Select data, go to 'Insert' tab, choose chart type, and customize.
Select data, go to 'File' tab, and print.
What is the shortcut for copying selected cells in Excel?
Ctrl + V
Alt + C
Ctrl + X
Ctrl + C
Which feature allows you to highlight cells based on specific criteria?
Cell Highlighting
Conditional Formatting
Cell Styles
Data Validation
What is the purpose of data validation in Excel?
To enhance the visual appearance of spreadsheets.
To automatically generate charts from data.
The purpose of data validation in Excel is to ensure data integrity by restricting the type of data that can be entered into a cell.
To create complex formulas without user input.
How do you quickly format a cell to currency in Excel?
Use the 'Insert' menu to add a currency symbol.
Double-click the cell and type '$' before the number.
Right-click the cell, select 'Format Cells', choose 'Currency', and click 'OK' or use Ctrl + Shift + $.
Select the cell and press Ctrl + Alt + C.
What formula would you use to find the average of a set of numbers?
Average = (Count of numbers) - (Sum of numbers)
Average = (Sum of numbers) * (Count of numbers)
Average = (Sum of numbers) / (Count of numbers)
Average = (Sum of numbers) + (Count of numbers)
How can you create a pie chart in Excel?
Choose your data, navigate to 'View' > 'Chart Wizard', and select a format.
Select your data, go to 'File' > 'New Chart', and choose a type.
Highlight your data, click on 'Data' > 'Chart Options', and pick a design.
Select your data, go to 'Insert' > 'Pie Chart', and choose a style.
What is the keyboard shortcut to open the 'Format Cells' dialog?
Ctrl + 1
Alt + F1
Ctrl + Shift + C
Shift + F1
How do you restrict data entry to a specific list of values in Excel?
Use Data Validation with the List option.
Set cell protection to prevent editing.
Apply a formula to restrict input.
Use Conditional Formatting to highlight cells.
What function would you use to count the number of cells that meet a certain condition?
SUMIF
MAXIF
AVERAGEIF
COUNTIF
How can you apply conditional formatting to a range of cells?
Select the range, go to 'Home' > 'Conditional Formatting', choose a rule, set formatting, and click 'OK'.
Select the range, go to 'File' > 'Format Cells', and choose a color.
Highlight the range, then press 'Ctrl + Z' to undo any formatting.
Right-click the range, select 'Insert Comment', and type your formatting instructions.
What is the shortcut for saving a workbook in Excel?
Ctrl + S
Alt + S
Shift + S
Ctrl + P
How do you create a bar chart to compare different categories in Excel?
Select your data, go to 'File' > 'New Chart', and choose a type.
Select your data, go to 'Insert' > 'Bar Chart', and choose a style.
Highlight your data, click on 'Data' > 'Chart Options', and pick a design.
Choose your data, navigate to 'View' > 'Chart Wizard', and select a format.
What formula would you use to concatenate two text strings in Excel?
=CONCATENATE(A1, B1) or =A1 & B1
=MERGE(A1, B1)
=JOIN(A1, B1)
=APPEND(A1, B1)
How can you use sparklines to visualize data trends in a cell?
You need to use a specific formula to generate sparklines.
You can create sparklines in a cell by selecting the cell, inserting a sparkline type, and specifying the data range.
Sparklines can only display text data, not numerical data.
You can only create sparklines in a separate sheet.
What is the keyboard shortcut to undo the last action in Excel?
Ctrl + Y
Ctrl + Z
Alt + Z
Shift + Z
How do you set up a drop-down list for data entry in Excel?
Insert a table and select the drop-down option from the toolbar.
Copy and paste a list of items into a cell to create a drop-down.
Use Conditional Formatting to create a drop-down list in Excel.
Use Data Validation to create a drop-down list in Excel.
What function would you use to find the maximum value in a range of cells?
MIN
MAX
AVERAGE
SUM
How can you quickly apply bold formatting to selected text in Excel?
Use the keyboard shortcut Ctrl + I.
Use the keyboard shortcut Ctrl + B.
Click on the 'Format' menu and select 'Bold'.
Right-click and choose 'Make Text Bold' from the context menu.
