Microsoft Excel | MCQs

Explanation

• In MS Excel, Conditional Formatting is in the Home tab
• ..
• Apply conditional formatting to text
• Select the range of cells, the table, or the whole sheet that you want to apply conditional formatting to.
• On the Home tab, click Conditional Formatting.
• Point to Highlight Cells Rules, and then click Text that Contains.
• Type the text that you want to highlight, and then click OK.

• ****

  RY 16-01-2023

Explanation

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

Explanation

Excel allowed you to create a chart by selecting the data and pressing the F11 key. 

Explanation

Automatically adjust your table or columns to fit the size of your content by using the AutoFit button.

Select your table.

On the Layout tab, in the Cell Size group, click AutoFit.

Do one of the following.

To adjust column width automatically, click AutoFit Contents.

Explanation

 Capitalizes the first letter in a text string and any other letters in text that follow any character other than a letter.

Explanation

Explanation

• The actual working area of the Computer's Microsoft Excel is a worksheet.
• The title bar in MS Excel displays the name of the workbook.
• The main window in a computer spreadsheet is called a workbook.
  

Explanation

• To edit a chart in most software applications, including MS Excel and MS PowerPoint.
• You can double-click the chart object to open its editing options.

Explanation

The .xls extension is used for excel files .

MS word = ..docx
MS Power Point: .pptx

Explanation

Shortcut key for spelling checking is F7