Functions | MCQs

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

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

Explanation

F7

F7 does a spelling and grammar check in Microsoft Word

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

F8

In Excel, enables extend mode for arrow keys

F9

Refreshes document in Microsoft Word

F10

Opens menu bar

F11

Exits and enters full-screen mode in browsers

F12

Opens Save as in Word

Explanation

In MS Excel, you can use the horizontal and vertical scroll bars to view different rows and columns in a worksheet.

The scroll bars are located on the right side and bottom of the Excel window, respectively.

• The vertical scroll bar allows you to scroll up and down to view different rows.
• The horizontal scroll bar allows you to scroll left and right to view different columns.

Explanation

These keys include the same letter, number, punctuation, and symbol keys found on a traditional typewriter.

Control keys. 

Function keys. 

Navigation keys. 

Numeric keypad.

Explanation

“Ctrl + Up Arrow” Shortcut key is used in Microsoft Word to move the cursor one paragraph up.

Explanation

Autosum is a feature in Excel that automatically adds numbers in selected cells.

It uses the SUM function.

It is commonly accessed via the Σ (sigma) icon on the toolbar.

Explanation

The SUM function in MS Excel is used to add numbers from selected cells or ranges (e.g., =SUM(A1:A5)).

It is one of the most commonly used functions for quick total calculations in spreadsheets.