Microsoft Excel MCQs for Competitive Exams

31

Which Excel function should be utilized to convert all text entries in a specific column to uppercase letters?

A Trim B Upper C Proper D Lower

Answer & Solution Discuss Save Report

32

What information does the Excel function =today() return when executed?

A All of above B Today’s date as Text format C The date value for the day according to system clock D The time value according to system clock

Answer & Solution Discuss Save Report

33

If a user needs to split full names located in a single column into two separate columns, which tool should be utilized?

A Convert text to Column Wizard B View Side-by-Side C Comma Delimited D Split View

Answer & Solution Discuss Save Report

34

Which category of functions in Microsoft Excel is specifically designed for calculating depreciation, rates of return, future values, and loan payments?

A Statistical B Math & Trigonometry C Financial D Logical

Answer & Solution Discuss Save Report

35

Within the context of the Chart Wizard, what does the term 'data categories' refer to?

A A horizontal axis B The organization of individual values with a chart’s data series C A chart plot area D The data range that supply chart data

Answer & Solution Discuss Save Report

36

How can a user navigate between different worksheets within an Excel workbook?

A scroll bar B active cell C sheet tab D tab button

Answer & Solution Discuss Save Report

37

Which method is used to insert a PivotChart into an Excel workbook?

A Click the PivotChart button on the Insert tab. B None of these C Click the PivotChart button in the PivotTable Fields pane. D Click the Insert Chart button on the PivotTable Tools Analyze tab.

Answer & Solution Discuss Save Report

38

Which method allows you to automatically adjust the text size within an Excel cell if the content exceeds the column width?

A From Format choose Columns and then Autofit Selection B From Format Cells dialog box mark Shrink to fit check box C All of above D Double clicking on the right border of column header

Answer & Solution Discuss Save Report

39

What is the primary purpose for adjusting the width of a column in a spreadsheet?

A To make sure the column headings are always visible when scrolling. B To make sure all of the information in the column is visible. C None of above D To draw attention to the data in those cells.

Answer & Solution Discuss Save Report

40

What is the term for a unique identifier in a spreadsheet that combines a column letter and a row number?

A Cell Reference B AutoSum C Pivot Table D IF Function

Answer & Solution Discuss Save Report