Tab | MCQs

Explanation

Ms. Excel is a Spreadsheet program

MS Excel is based on WINDOWS

shortcut key in  MS Excell:

which key is used for help in MS excel?

 F1

***

Shift+Backspace

**

Which key is used to enter the current date in Excel?

 Ctrl+;

Which key is used for the GO TO tab in Ms. Excel?

 F5 

Which key is used for excel column highlight?

CTRL + space

What is the keyboard shortcut to insert a SUM formula in MS Excel?

 ALT + =

***

The delete key of the keyboard is assigned to which command in excel?

 Edit > Clear > Contents

****

The shortcut key to insert a new worksheet in Excel is _____.

 Shift + F11

****

in excel which key is used to format numbers in comma format?

 shift+1

*****

In Excel which shortcut key is used to go to the formula tab?

 Alt+M

ND11-3-2023

Explanation

Explanation

Once you've applied heading styles, you can insert your table of contents in just a few clicks. 

Navigate to the References tab on the Ribbon, then click the Table of Contents command.

Select a built-in table from the menu that appears, and the table of contents will appear in your document.

Explanation

In MS Access, columns in a table are called fields.

It store specific types of data for each record.

Rows in an MS Access table are called Records.

It representing individual entries or data points within the table.

Explanation

the view used to define the structure of a table is called "Design View."

This view allows you to specify:

• the table's fields
• data types
• validation rules
• default values
• other properties that define its structure
  

Explanation

Ctrl+Tab: Switch to the next tab/ the tab on the right

Ctrl+Shift+Tab: Switch to the previous tab/the tab on the left

Explanation

On average, searching in a well-implemented hash table has a time complexity of O(1) (constant time) due to direct indexing using the hash function.

In the worst-case scenario, if many elements hash to the same index (collisions), the time complexity can degrade to O(n) (linear time).

Explanation

 MS Access, columns in a table are called fields.

It store specific types of data for each record.

Rows in an MS Access table are called Records.

It representing individual entries or data points within the table.

Explanation

Adam Osborne invented Laptop in 1981.

Explanation

The tables' columns are referred to as fields.

Within a record, a field holds a specific piece of data.

columns and rows make up the two-dimensional structure known as a table.

The columns are referred to as fields in more formal computer terminology, while the rows are referred to as records.