Function | MCQs

Explanation

The F1 key is used to Help

****

F1: Opens the Help system for the active window.

F4: Creates a new document in programs that support this command

pressing F2 renames the file

F5 is also commonly used as a reload key

The F7 key is widely used to spell check 

Explanation

There is no function in Excel like AVG, at the time of writing,

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND7-5-2023

Explanation

Oracle is not a function of an operating system.

It is a database management system.

Whereas Linux, DOS, and Windows are examples of operating systems that manage hardware and software resources in a computer system.

Explanation

F5 – Allows you to refresh or reload the page or document window.

F6 – Moves the cursor to the address bar in most Internet browsers.

F7 – Used to spell check and grammar check a document in Microsoft Apps (e.g. Word).

F8 – Used to access the boot menu in Windows when turning on the computer.

Explanation

The function of Alt + Tab on the keyboard is to switch between open programs.

It allows users to quickly toggle between active applications or windows.

To switch between open tabs in the active window, use the keyboard shortcut Ctrl + Tab.

Explanation

F1

Opens the help menu when pressed with the Windows button.

F2

Allows you to edit the selected folder or file name in Windows Explorer & Cell

F3

Opens search feature in Windows Explorer

F4

Alt + F4 closes window

F5

Starts slideshow in PowerPoint

Refreshes Internet browser pages

F6

Goes to the next page in a split screen in Microsoft Word

F7

F7 does a spelling and grammar check in Microsoft Word

F8

In Excel, enables extend mode for arrow keys

F9

Refreshes document in Microsoft Word

F10

Opens menu bar

F11

Exits and enter full-screen mode in browsers

F12

Opens Save as in Word

AGM 08-2-2023

Explanation

A function the key is one of the "F" keys along the top of a computer keyboard.

On some keyboards, these range from F1 to F12, while others have function keys ranging from F1 to F9.

****

RY 16-01-2023

Explanation

All important questions about " MS EXCEL"

Microsoft Excel is a spreadsheet application launched in 1985 by the Microsoft Corporation.

MS-Excel uses the _____ function when creating a data table.

spreadsheet

****

Which of the following functions in Microsoft Excel is used to count items in a cell range?

Count

***

In MS Excel, which function automatically total a column or row of values?

SUM

***

MS Excel's function arguments are always written in----------?

Parenthesis

***

In MS Excel, which function automatically totals a column or row of values?

SUM

****

Columns in MS Excel are called?

Fields

***

Constant value in excel also called?

Number

***

Ctrl +D in MS Excel?

Fill down in the selection

***

Ctrl+R is used in Excel too?

Fill the selection with active cells to the right

***

MOD () function is used in MS Excel to get

Remainder

****

ND30-4-2023

Explanation

Bus: a high-speed internal connection.

A bus is an electronic path that sends signals from one part of a computer to another.

It allowing different components to communicate with each other.

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