NEW
Font size
WorksheetsFun with Excel Basics
Total questions: 20
Worksheet time: 10mins
What does Excel help you do?
Excel is used for graphic design.
Excel assists in writing code.
Excel helps you create presentations.
Excel helps you manage and analyze data.
What is a cell in Excel?
A cell in Excel is a collection of multiple spreadsheets.
A cell in Excel is a graphical representation of data.
A cell in Excel is a type of formula used for calculations.
A cell in Excel is a single data point in a spreadsheet.
How do you add numbers in Excel?
Use the AVERAGE function, e.g., =AVERAGE(A1:A10) to calculate mean values.
Enter numbers manually in each cell without using functions.
Apply the COUNT function, e.g., =COUNT(A1:A10) to sum the numbers.
Use the SUM function, e.g., =SUM(A1:A10) to add numbers in a range.
What is a spreadsheet?
A spreadsheet is a type of software for creating presentations.
A spreadsheet is a physical book for writing notes and calculations.
A spreadsheet is a tool for editing images and graphics.
A spreadsheet is a digital tool for organizing and analyzing data in tabular form.
What symbol do you use to start a formula?
-
+
*
=
What is the purpose of the SUM function?
To count the number of entries in a dataset.
To find the maximum value in a list.
To calculate the average of a set of numbers.
To add together a set of numbers.
How do you change the color of text in a cell?
Use the cell border option to change text color.
Right-click the cell and choose the background color.
Highlight the cell and adjust the font size in the menu.
Select the cell, then use the text color option in the formatting menu.
What is a row in Excel?
A row in Excel is a horizontal line of cells identified by a number.
A row in Excel is a vertical line of cells identified by a letter.
A row in Excel is a collection of formulas arranged in a column.
A row in Excel is a single cell that contains data.
What is a column in Excel?
A column in Excel is a vertical series of cells identified by letters.
A column in Excel is a collection of cells that can only contain text.
A column in Excel is a grid of cells arranged in a square format.
A column in Excel is a horizontal series of cells identified by numbers.
How do you save your work in Excel?
Press 'Ctrl' + 'P' to save your work.
Select 'Home' > 'Save' from the menu.
Click 'File' > 'Save' or 'Save As'.
Click 'Edit' > 'Save' or 'Save As'.
What does the 'Undo' button do?
Cancels the current operation.
Redoes the last action performed.
Reverses the last action taken.
Saves the current document.
How can you make a cell bold?
Select the cell and press Ctrl + B or click the Bold button.
Right-click the cell and choose Italics.
Select the cell and press Ctrl + I.
Click the cell and change the font color.
What is a chart in Excel?
A chart in Excel is a table of numerical values.
A chart in Excel is a graphical representation of data.
A chart in Excel is a text-based report.
A chart in Excel is a list of formulas used in calculations.
How do you insert a new row?
Apply the 'DELETE' command in SQL.
Use the 'INSERT' statement in SQL.
Use the 'UPDATE' statement in SQL.
Execute the 'SELECT' query in SQL.
What does the 'Copy' function do?
The 'Copy' function erases existing data.
The 'Copy' function compresses files for storage.
The 'Copy' function transfers data to a different location.
The 'Copy' function duplicates data for reuse.
What is a formula bar?
A formula bar is a section for viewing spreadsheet formulas.
A formula bar is a tool in spreadsheet software for editing cell contents.
A formula bar is a menu for accessing spreadsheet templates.
A formula bar is a feature for creating charts in spreadsheets.
How do you delete a cell?
Highlight the cell and choose 'Remove' option.
Click the cell and press 'Delete' key.
Select the cell, right-click, and choose 'Delete'.
Select the cell and hit 'Backspace'.
What is the purpose of the 'Filter' feature?
To delete unnecessary data entries.
To combine multiple datasets into one.
To narrow down data based on specified criteria.
To enhance data visualization with charts.
How can you find a specific word in Excel?
Highlight cells to find a specific word visually.
Use the 'Replace' feature to change a specific word.
Search for a word using the 'Sort' function in Excel.
Use the 'Find' feature (Ctrl + F) to search for a specific word.
What does 'Merge Cells' mean?
Highlighting cells with different colors in a spreadsheet.
Separating cells into individual units in a spreadsheet.
Duplicating the content of one cell into adjacent cells.
Combining adjacent cells into one cell in a spreadsheet.
