MS | MCQs

Explanation

A Workbook is a group of Worksheets.

A workbook is a file that contains one or more worksheets to help you organize data.

A workbook initially contains three worksheets, which are saved in a single file. 

1. Sheet1

2. Sheet2

3. Sheet3

Explanation

A Workbook is a group of Worksheets.

A workbook is a file that contains one or more worksheets to help you organize data.

A workbook initially contains three worksheets, which are saved in a single file. 

1. Sheet1

2. Sheet2

3. Sheet3

Explanation

In MS Word, indenting paragraphs allows users to set text within a paragraph at different margins.

Explanation

Formula palette is used to create and edit formula.

It is also possible to type a function directly into a cell.

Explanation

The term Worksheet used in Excel documents is a collection of cells organized in rows and columns.

Explanation

Delete a record

• Open the table in Datasheet View or form in Form View.
• Select the record or records that you want to delete. To select a record, click the record selector next to the record, if the record selector is available. 
• Press DELETE, select Home > Records > Delete, or press Ctrl+Minus Sign (-).

Explanation

The "Edit, Clear" command in spreadsheet software (like Microsoft Excel) allows you to remove different elements from selected cells, such as:

• Contents (values/data)

• Formats (cell formatting)

• Comments/Notes

However, it does not delete the cells themselves—it only clears their contents or attributes.

Explanation

The function key to quickly navigate to a specific cell in MS Excel is F5 or Ctrl+G.

These keys open the "Go To" dialog box, where you can enter the cell reference (e.g., B3) and press Enter to jump to that cell

Explanation

Spreadsheet:

This is the function of Excel, where data is organized in rows and columns within cells, allowing for calculations and analysis

Graphic program:

This is not associated with Excel, as it is designed for creating images and graphics. 

Word processor:

This refers to programs like Microsoft Word for creating and editing text documents. 

Presentation:

This refers to programs like PowerPoint, which are used to create slideshow presentations. 

Explanation

A column chart is ideal for comparing the performance of two employees in 2021 because it allows for a side-by-side comparison of their performance metrics, such as sales, productivity, or revenue.

Pie Chart: Shows how different components contribute to a whole.

Dot Chart: Displays a small number of data points.

Column Chart: Compares performance metrics side-by-side.

Line Chart: Shows trends over time.