NEW
Font size
WorksheetsMastering Excel Basics
Total questions: 10
Worksheet time: 5mins
What are the main components of an Excel workbook?
The main components of an Excel workbook consist of dashboards, pivots, scripts, and styles.
The main components of an Excel workbook are worksheets, cells, ranges, charts, and tables.
The main components of an Excel workbook are formulas, macros, graphs, and filters.
The main components of an Excel workbook include headers, footers, comments, and hyperlinks.
How do you create a new workbook in Excel?
Go to 'View' > 'New' > 'Open Workbook' or hit 'Shift + N'.
Choose 'Insert' > 'New' > 'Workbook' or press 'Ctrl + W'.
Click 'File' > 'New' > 'Blank Workbook' or press 'Ctrl + N'.
Select 'Home' > 'New' > 'Create Workbook' or use 'Alt + N'.
What is the purpose of columns and rows in Excel?
Columns and rows in Excel are used for creating charts and graphs.
The purpose of columns and rows in Excel is to organize data in a structured format for easy analysis and manipulation.
Columns and rows in Excel serve to format text and images only.
Columns and rows in Excel help in designing web pages and applications.
How can you enter a formula in a cell?
Select the cell, type '!', enter the formula, and hit Return.
Double-click the cell, type '=', add the formula, and click Save.
Right-click the cell, choose 'Insert', type the formula, and confirm.
Click on the cell, type '=', enter the formula, and press Enter.
What is the function of the SUM formula in Excel?
The function of the SUM formula in Excel is to multiply numbers.
The function of the SUM formula in Excel is to find the average of numbers.
The function of the SUM formula in Excel is to count the number of entries.
The function of the SUM formula in Excel is to add numbers.
How do you copy a formula from one cell to another?
Right-click the cell and select 'duplicate'.
Drag the formula to the new cell directly.
Select the cell with the formula, copy it, then paste it into the desired cell.
Use the fill handle to extend the formula.
What is a range in Excel, and how is it used?
A range in Excel is a function that sorts data automatically.
A range in Excel is a single cell used for formatting text.
A range in Excel is a selection of two or more cells used for calculations and data analysis.
A range in Excel refers to a chart type for visual data.
What is the default file extension for an Excel workbook?
.excel
.xls
.txt
.xlsx
What keyboard shortcut can be used to copy and paste in Excel?
Ctrl+X to copy and Ctrl+Z to paste
Shift+C to copy and Shift+P to paste
Ctrl+C to copy and Ctrl+V to paste
Alt+C to copy and Alt+V to paste
How do you adjust the width of a column in Excel?
Drag the column border or use 'Column Width' option.
Double-click the column header.
Select 'Row Height' from the menu.
Right-click and choose 'Insert Column' option.
