Test 10
When you create a chart on a separate sheet in the same workbook it is called a a. chart sheet b. embedded sheet c. view sheet d. view chart
  • Embedded sheet
  • View sheet
  • View chart
Explanation: When you create a chart on a separate sheet within the same workbook in Microsoft Excel, it is referred to as a chart sheet. This is distinct from embedding a chart within an existing worksheet, where the chart resides within the worksheet itself. A chart sheet allows for a larger view of the chart and easier navigation within the workbook.
Which of the following is not a text function
  • CHAR ()
  • LEN ()
  • VAR ()
  • ABS ()
Explanation: ABS (): This function is not a text function. It stands for "absolute value" and is used to return the absolute (positive) value of a number. It is a mathematical function rather than a text function. Text functions, on the other hand, are used to manipulate or extract information from text strings. Examples of text functions include CHAR (), LEN (), CONCATENATE (), LEFT (), RIGHT (), etc., which are used to perform operations specifically on text data.
To display the chart option dialog box, choose
  • Chart menu
  • File menu
  • Insert menu
  • View menu
Explanation: In older versions of Excel (specifically Excel 2003 and earlier), there was indeed a "Chart" menu from where you could access various chart-related options, including options to format the chart, change chart type, and other chart-specific settings. However, in newer versions of Excel (from Excel 2007 onwards), the chart-related options are typically found under the "Chart Tools" contextual tabs that appear when you select a chart. These tabs are named "Design," "Layout," and "Format," and they provide comprehensive options for modifying and formatting your chart. Therefore, the correct answer to display the chart options dialog box in Excel would be: a. Chart menu (for older versions of Excel) If you are using a newer version of Excel, you would use the "Chart Tools" contextual tabs that appear when you select a chart.
Page break command on the insert menu will result in insertion of page break
  • Above the selected row
  • Below the select row
  • Middle of the selected row
  • None of the above
Explanation: In Microsoft Excel, when you use the Page Break command from the Insert menu and select a specific row, it will insert a page break above that selected row. This means that the content above the selected row will start on a new page when the document is printed or viewed in Page Break Preview mode.
Which of the following can be used to create presentation from scratch?
  • Auto content Wizard
  • Design templates
  • Sample presentation
  • Blank presentation
Explanation: The AutoContent Wizard was a feature in older versions of Microsoft PowerPoint (like PowerPoint 2003 and earlier). It provided users with predefined templates and suggestions for creating presentations quickly. However, it's important to note that the AutoContent Wizard is now deprecated in newer versions of PowerPoint (2010 onwards), and the recommended approach to create a presentation from scratch in modern versions is to start with a Blank presentation. This allows for more customization and flexibility in creating slides and content.
Which of the following view does PowerPoint provide?
  • Outline
  • Slide Sorter
  • Notes page
  • All of the above
Explanation: PowerPoint provides multiple views to help users work with their presentations: Outline View: Shows the structure of the presentation in outline form, with titles and main text of each slide. Slide Sorter View: Displays thumbnails of all slides in the presentation, allowing for easy reordering and organizing. Notes Page View: Provides a space to add notes for each slide, which can be printed as reference material. So, all of the options listed (Outline, Slide Sorter, Notes page) are views provided by PowerPoint.
Pie charts can be plotted on
  • Multiple data series
  • Only two data series
  • Explanation: Pie charts in Microsoft Excel (and similar charting software) are typically designed to display one data series at a time. Each slice of the pie represents a single data point or category from that series. Therefore, pie charts can only be plotted on one data series at a time, making option c. Only one data series, the correct answer.