Function | MCQs

Explanation

A function is a predefined formula that performs calculations using specific values in a particular order.

All spreadsheet programs include common functions that can be used for quickly finding the sum, average, count, maximum value, and minimum value for a range of cells.

Arguments can refer to both individual cells and cell ranges and must be enclosed within parentheses.

Explanation

The Backspace key or Backspace key is a keyboard key that deletes any character before the cursor's current position or the left.

****

The Delete key removes characters to the right of the cursor, whereas the Backspace key deletes to the left.

*****

The cursor is a Thin Blinking Line

******

RY 23-12-2022

SH4-0-2023

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

 Google Drive is a cloud-based service

They allow users to store, access, and share files like documents, photos, and videos online.

Explanation

A computer's microprocessor performs:

1. arithmetic and logic operations,
2. provides temporary memory storage,
3. times and regulates all elements of the computer system.
   

Explanation

The Recycle Bin temporarily stores deleted files and folders from your computer.

You can restore them if needed or permanently delete them from there.

Explanation

In Excel, the function used to perform addition is =SUM().

It calculates the total of the specified numbers or range of cells.

Explanation

The functional dependency is a relationship that exists between two attributes.

It typically exists between the primary key and non-key attribute within a table.

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

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