Free Excel Questions and Answers — Questions and Answers

Question 1: A ________ is the point where two rows and columns meet.

sum
chart
cell (Correct answer)
worksheet

Correct answer: cell

In spreadsheet programs like Excel, a cell is the fundamental unit where data is stored. It is precisely defined as the intersection point where a row and a column meet. Each cell has a unique address, such as A1 or B5, derived from its column letter and row number.

Question 2: The ________refers to a group of cells.

cell cluster
cell range (Correct answer)
chart
multicell

Correct answer: cell range

In Excel, a cell range refers to a collection of two or more cells. These cells can be adjacent or non-adjacent, and a contiguous range is typically denoted by the addresses of its top-left and bottom-right cells separated by a colon (e.g., A1:B5). This grouping allows for operations, formatting, or formulas to be applied to multiple cells simultaneously.

Question 3: What is the location of the filling handle?

At the beginning of any formula or function
In the bottom-right corner of the selected cell (Correct answer)
On the right side of the Home tab on the Ribbon
In Backstage view

Correct answer: In the bottom-right corner of the selected cell

The fill handle in Excel is a small square located in the bottom-right corner of a selected cell or range. It is a powerful tool used to quickly copy data, formulas, or extend a series of data (like numbers, dates, or custom lists) to adjacent cells. Dragging this handle allows for efficient data entry and formula replication.

Question 4: True or False: An Excel file is called a workbook?

True (Correct answer)
False

Correct answer: True

True. In Microsoft Excel, a file is indeed referred to as a workbook. A workbook acts as a container for one or more individual worksheets, which are the grids where data is entered and manipulated. This structure helps organize related data and calculations within a single file.

Question 5: What is the best way to remove of cell boarders?

Open the list on Border tool in Format Cell toolbar then choose first tool (none)
Choose None on Border tab of Format cells
Both of Both A and B (Correct answer)
None of these

Correct answer: Both of Both A and B

Both methods are effective for removing cell borders in Excel. You can access the Border tool directly from the Home tab's Font group on the Ribbon and select 'No Border' from the dropdown list. Alternatively, you can open the 'Format Cells' dialog box, navigate to the 'Border' tab, and then choose 'None' for the border style, which achieves the same result.

Question 6: In Excel, where can you change the shading color for a group of cells?

Choose required color on Fill tool in Drawing toolbar
Choose required color form Patterns tab of Format Cells dialog box
Choose required color on Fill Color tool in Formatting toolbar
All of the above (Correct answer)

Correct answer: All of the above

Excel provides multiple ways to change the shading or fill color for a group of cells. The 'Fill Color' tool is readily available on the Home tab (often referred to as the Formatting toolbar). Additionally, the 'Format Cells' dialog box, under the 'Fill' or 'Patterns' tab, offers extensive options for fill effects, including colors and patterns. All these options allow you to customize cell shading.

Question 7: When all of the numbers in a range between 0 and 100 should be displayed in red, what command would you use?

Select the cells that contain number between 0 and 100 then click Red color on Text Color Tool
Use =if() function to format the required numbers red
Apply Conditional Formatting command on Format menu (Correct answer)

Correct answer: Apply Conditional Formatting command on Format menu

Conditional Formatting is the most appropriate and efficient command for automatically applying formatting, such as changing text color to red, based on specific criteria. It allows you to set rules (e.g., 'cell value is between 0 and 100') and define the formatting to apply when those rules are met. This ensures dynamic formatting that updates automatically if cell values change, without manual intervention.

Question 8: In Excel, you may set the page border.

From Border tool in Formatting toolbar
From Border tab in Format Cells dialog box
You can not set page border in Excel (Correct answer)
From Line Style tool in Drawing toolbar

Correct answer: You can not set page border in Excel

Unlike word processing software, Excel does not have a direct feature to apply a 'page border' to the entire worksheet or printed page. Borders in Excel are applied to individual cells or ranges of cells. While you can create a visual effect resembling a page border by applying borders to a large range of cells, there isn't a dedicated 'page border' command.

Question 9: Which of the following statements about Conditional Formatting is not true?

You can set condition to look for Bold and apply Italics on them (Correct answer)
You can add more than one condition to check
You can delete any condition from Conditional Formatting dialog box if it is not required
You can apply Font, border and pattern formats that meets the specified conditions

Correct answer: You can set condition to look for Bold and apply Italics on them

Conditional Formatting in Excel allows you to apply formatting *based on* cell values, formulas, or other logical conditions, not based on existing manual formatting like 'Bold.' You can set conditions to *apply* bold or italics, but you cannot create a rule that *detects* if a cell is already bold and then applies italics. Conditional Formatting rules evaluate content or properties, not manual formatting styles.

Question 10: Which of the statements below is false?

Some pictures can be applied as a background of a sheet
Sheet tabs can be colored
The width of a row and be specified manually or fir automatically. (Correct answer)
You can set the column width automatically fit the amount of text

Correct answer: The width of a row and be specified manually or fir automatically.

The statement 'The width of a row and be specified manually or fir automatically' is false because rows have a height, not a width. Columns have width, which can be adjusted manually or automatically to fit content. Row height can be adjusted manually or automatically to fit content, but referring to the 'width of a row' is incorrect terminology in Excel.

Question 11: The formula palette can be used to

Enter assumptions data
Copy a range of cells
Create and edit formula containing functions (Correct answer)
Format cells containing numbers

Correct answer: Create and edit formula containing functions

The Formula Palette (or Function Arguments dialog box in modern Excel versions, accessed via the 'Insert Function' button next to the formula bar) is a helpful tool designed to assist users in creating and editing formulas, especially those involving functions. It provides a guided interface to input arguments for functions, making complex formulas easier to construct and debug by showing argument descriptions and results.

Question 12: How do you activate the previous cell when a range is selected?

Press Tab
Press Enter
Press the Alt Key
None of the above (Correct answer)

Correct answer: None of the above

When a range of cells is selected, pressing `Tab` moves to the next cell in the selection, and `Shift + Tab` moves to the previous cell in the selection. Pressing `Enter` typically moves to the next cell down in the selection, and `Shift + Enter` moves to the previous cell up. Therefore, none of the provided options (Tab, Enter, Alt Key) alone activate the 'previous cell' in a general sense within a selected range.

Question 13: Which tool will you use to combine certain cells and position the content in the middle?

From the Format Cells dialog box select the Centered alignment
From Format Cell dialog box click on Merge Cell check box (Correct answer)
Click on Merge and Center tool on formatting toolbar.
From Format Cells dialog box choose Merge and Center check box

Correct answer: From Format Cell dialog box click on Merge Cell check box

The 'Merge cells' checkbox, located within the 'Alignment' tab of the 'Format Cells' dialog box, is the specific control used to combine multiple selected cells into a single larger cell. This action is the core step for merging. To then position the content in the middle, you would separately apply the 'Center' alignment, which can also be done from the 'Format Cells' dialog or the Home tab.

Question 14: On the Excel screen, there are tab scroll buttons.

Towards the top left corner
Towards the top right corner
Towards the right button corner
Towards the button left corner (Correct answer)

Correct answer: Towards the button left corner

The tab scroll buttons in Excel are located in the bottom-left corner of the worksheet window, next to the sheet tabs themselves. These small arrow buttons allow users to navigate through multiple sheet tabs when there are too many to fit horizontally across the screen. They are essential for accessing hidden or distant worksheets within a workbook.

Question 15: On the left of the formula bar, there is a Name box.

Shows the name of worksheet currently working on
Shows the name of cell or range currently working on (Correct answer)
Show the name of Workbook currently working on
None of these

Correct answer: Shows the name of cell or range currently working on

The Name Box, situated to the left of the formula bar in Excel, displays the address of the currently selected cell (e.g., A1). When a range of cells is selected or a named range is active, it shows the address of the first cell in the range or the name of the defined range. It also allows users to quickly navigate to specific cells or ranges by typing their names.

Question 16: Each Excel file is a workbook with a variety of sheets. Which of the following can't be a workbook sheet?

Chart sheet
Work sheet
Data sheet (Correct answer)
Marco sheet

Correct answer: Data sheet

An Excel workbook can contain various types of sheets, including 'Worksheets' (for data entry and calculations), 'Chart Sheets' (dedicated sheets for displaying charts), and 'Macro Sheets' (for VBA code, though less common in modern Excel). 'Data sheet' is not a standard, distinct type of sheet within an Excel workbook; data is typically stored within a regular 'Worksheet'.

Free Excel Questions and Answers

A ________ is the point where two rows and columns meet.