Ms Excel(Computer Fundamentals ) Questions and answers for exam Preparation

Question 1. Which of the following format you can decide to apply or not in AutoFormat dialog box?

Number format
Border format
Font format
All of above

Explanation:-

Answer: Option D. -> All of above
AutoFormat option in excel is a unique way of formatting data quickly, the first step is we need to select the entire data we need to format and then the second step we need to click on auto-format from the QAT and third step we need to choose the format from the different options.

Question 2. How can you remove borders applied in cells?

Choose None on Border tab of Format cells
Open the list on Border tool in Format Cell toolbar then choose first tool (none)
Both of above
None of above

Explanation:-

Answer: Option C. -> Both of above
On the Home tab, in the Font group, click the arrow next to Borders Button, and then click No Border Button.
--OR--
Click Home > the Borders arrow > Erase Border, and then select the cells with the border you want to erase.

Question 3. When all the numbers between 0 and 100 in a range should be displayed in Red Color, apply

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

Explanation:-

Answer: Option B. -> Apply Conditional Formatting command on Format menu
A conditional format changes the appearance of cells on the basis of conditions that you specify. If the conditions are true, the cell range is formatted; if the conditions are false, the cell range is not formatted.

Question 4. You can set Page Border in Excel from

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

Explanation:-

Answer: Option D. -> You can not set page border in Excel
There is no option to set page border in Excel.

Question 5. Where can you set the shading color for a range of cells in Excel?

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

Explanation:-

Answer: Option D. -> All of above
The formatting and Drawing toolbar is a toolbar in Microsoft Office 2003 and earlier applications, that gives the user the ability to change the formatting of selected text or cell.

Question 6. How do you display current date only in MS Excel?

Date ()
Today ()
Now ()
Time ()

Explanation:-

Answer: Option B. -> Today ()
DATE - returns the serial date value for a date
TODAY - returns today's date
NOW - returns the current date and time
TIME - assemble a proper time.

Question 7. In the formula, which symbol specifies the fixed columns or rows?

$
*
%
&

Explanation:-

Answer: Option A. -> $
The absolute cell reference in excel is a cell address that contains a dollar sign ($). It can precede the column reference, the row reference or both.

Question 8. How do you wrap the text in a cell?

Format, cells, font
Format, cells, protection
Format, cells, number
Format, cells, alignment

Explanation:-

Answer: Option D. -> Format, cells, alignment
Microsoft Excel can wrap text so it appears on multiple lines in a cell. We can format the cell so the text wraps automatically, or enter a manual line break.
On the Home tab, in the Alignment group, click Wrap Text.

Question 9. What does COUNTA () function do?

Counts cells having alphabets
Counts empty cells
Counts cells having number
Counts non-empty cells

Explanation:-

Answer: Option D. -> Counts non-empty cells
COUNTA function counts cells containing any type of information, including error values. COUNTA function does not count empty cells.

Question 10. What is the short cut key to highlight the entire column?

Ctrl + C
Ctrl + Enter
Ctrl + Page Up
Ctrl + Space Bar

Explanation:-

Answer: Option D. -> Ctrl + Space Bar
Ctrl + Space Bar is the short cut key to highlight the entire column.