MS | MCQs

Explanation

In MS Excel, the term "data categories" refers to the horizontal axis (also known as the X-axis) in a chart.

It organizes individual values within the chart's data series and represents different categories or labels along this axis.

Explanation

Columns in MS Excel are numbered Alphabetically (A, B, C, etc.).

Rows in MS Excel are numbered Numerically (1, 2, 3, etc.).

Explanation

Shortcut key F1 to enable the Help window.

The Help button in Word is too small and will be easily ignored.

The Help button stays in the top right corner of the window.

Additional Information:

Explanation

1. Sentence Case
2. Lowercase
3. Uppercase
4. Title Case
5. Toggle Case

Explanation

Most repeated questions about shortcut key

Goes to beginning of current line = Home

Goes to beginning of document = Ctrl + Home

Goes to end of current line = End

      Goes to end of document = Ctrl + End

Highlights from current position to beginning of line = Shift + Home

Highlights from current position to end of line = Shift + End

Cut selected item = Shift + Del & Ctrl + X

Copy selected item = Ctrl + C

Paste selected item = Ctrl + V

       Paste = Shift + Ins.

*********

VU FIA UDC CONSTABLE PAST PAPER 31-12-2021

Explanation

The menu bar is the part of a browser or application window, typically at the top left side, that houses drop-down menus that allow the user to interact with the content or application in various ways.

Explanation

On the Page Layout tab, in the Page Setup group, choose Margins and the Margins gallery appears

Explanation

The =NOW() function in MS Excel returns the current date and time.
It is updated automatically whenever the worksheet is opened or calculations are performed.

Some other important functions in MS Excel include:

1. =TODAY() - returns the current date (without time)

2. =YEAR() - returns the year from a given date

3. =MONTH() - returns the month from a given date

4. =DAY() - returns the day from a given date

5. =HOUR() - returns the hour from a given time

6. =MINUTE() - returns the minute from a given time

7. =SECOND() - returns the second from a given time

Explanation

DOCX is the newer version of DOC, the original official Microsoft Word file format.

Microsoft Word 97 - 2003 Document extension (.doc).

Microsoft Word 2007 to till date Document extension (.docx).

Explanation

Switching between portrait and landscape modes done by Page setup dialog box

 Portrait and landscape are: Page Orientation 

****

Portrait and Landscape are examples of page orientation in MS Word.

Page orientation is the direction in which a document is displayed or printed.

The two basic types of page orientation are portrait (vertical) and landscape (horizontal)

****
Page orientation is the way in which a rectangular page is oriented for normal viewing. 

SH4-9-2023