Worksheet | MCQs

Explanation

ALT + Shift + F1 is also used to create a new worksheet

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+;

Explanation

The keyboard shortcut to minimize an Excel worksheet is Ctrl+F9.

This shortcut also restores all workbook windows that are maximized. 

Here are some other Excel keyboard shortcuts:

Ctrl+F10: Maximizes or restores the selected workbook window

Ctrl+F7: Moves workbook windows that are not maximized

Ctrl+F8: Performs the size command for workbook windows that are not maximized

Ctrl+P: Opens the print dialog box

Ctrl+Z: Undoes the last action

Alt+Space: Displays the Control menu for the Main Excel window

Alt+F4: Closes Excel

F6/Shift+F6: Moves to the next or previous pane in a workbook that has been split

Ctrl+Tab/Ctrl+Shift +Tab: Moves to the next or previous workbook window

Explanation

When we open an Excel workbook, there are three sheets by default, and the default names on the tabs are:

 Sheet1

Sheet2

Sheet3

ND26-9-2023

Explanation

A worksheet consists of rows (horizontal) and columns (vertical) where data is entered into cells at their intersections.

Explanation

In an Excel worksheet, the first cell is labeled as A1 due to the following reasons:

1. Grid System: Excel uses a grid to organize cells, with rows and columns.
2. Rows Labeled by Numbers: Rows are labeled using numbers (1, 2, 3, etc.).
3. Columns Labeled by Letters: Columns are labeled using letters (A, B, C, etc.).
4. First Cell Location: The first cell is located at the intersection of row 1 and column A, hence labeled A1.

Explanation

To show the gridlines, in Excel, PowerPoint, or Word, click the View tab,

and then check the Gridlines box.

To hide the gridlines, clear the Gridlines check box.

The keyboard shortcut to remove the gridlines is to press Alt and enter W, V, G.

Explanation

In Excel 2016, 2013, 2010, 2007, click on View > Show > Gridlines

For Excel 2003 and Earlier: Navigate to Tools > Options or Click Gridline tool on Forms toolbar.

Explanation

To move between worksheets in a workbook in MS Excel, you can use the following shortcuts:

• Ctrl+Page Up: Move to the previous worksheet
• Ctrl+Page Down: Move to the next worksheet

Explanation

To move between worksheets in a workbook in MS Excel, you can use the following shortcuts:

• Ctrl+Page Up: Move to the previous worksheet
• Ctrl+Page Down: Move to the next worksheet

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