WorksheetsBasic Ms Excel
Total questions: 10
Worksheet time: 5mins
What is a function in Excel?
A function in Excel is a random value generated by the software.
A function in Excel is a feature used for inserting images into spreadsheets.
A function in Excel is a predefined formula that performs calculations using specific values in a particular order.
A function in Excel is a type of formatting applied to cells.
How can you format cells in Excel?
Open 'Insert' tab -> Click on 'Format Cells' -> Apply formatting options
Right-click on cells -> Select 'Format Cells' -> Choose formatting options
Select cells -> Go to 'Home' tab -> Choose formatting options
Press Ctrl + F -> Type in formatting commands -> Press Enter
Define Workbook in Spreadsheet.
A Workbook contains multiple Cells in Excel.
A Worksheet contains multiple Workbooks in Excel.
A Workbook contains multiple Worksheets in Excel.
A Workbook contains multiple Rows in Excel.
What is the difference between a cell and a range in Excel?
A cell is a group of cells, while a range is a single unit.
A cell is used for text, while a range is used for numbers.
A cell is horizontal, while a range is vertical.
A cell is a single unit, while a range is a group of cells.
Explain the concept of Autofill in Excel.
Autofill in Excel only works with numerical data, not text.
Autofill in Excel is a manual process that requires entering data cell by cell.
Autofill in Excel is a feature that automatically fills in a series of data or formulas into adjacent cells by recognizing patterns in the existing data.
Autofill in Excel can only be used in one direction, either horizontally or vertically.
How do you use functions in Excel to perform calculations?
Use a function name without parentheses
Type the calculation directly into a cell without using functions
Use a random number generator function
Start with =, followed by function name and input range of cells or values within parentheses.
What are some common formatting options available in Excel?
Font styles, cell alignment, borders, fill colors, merge cells, conditional formatting
Page layout options
Data validation
Chart styles
How can you create a new worksheet in an Excel workbook?
Press Ctrl + N
Double-click on existing worksheet tab
Go to File -> New Worksheet
Right-click on existing worksheet tab -> Insert -> Worksheet
What is the purpose of a cell reference in Excel?
To refer to a specific cell or range of cells within a worksheet.
To add cell
To add new worksheet
To delete all cell content
How can you quickly fill a series of cells with data in Excel?
Fill the first cell, select it, hover over the bottom right corner until the cursor changes, click and drag to fill the series of cells.
Right-click on the first cell and select 'Fill Series'
Use the 'Delete' key to clear the cells and start over
Manually type the data into each cell
