Which of the following function is used to get the current date...? Mcqs

Latest MCQs

Which of the following function is used to get the current date...?

(A) Exact ()
(B) Today ()

(C) Month ()
(D) Year ()

Comments

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

Latest MCQs

Which is not the function of "Edit clear command"...?

(A) Delete cells
(B) Delete notes

(C) Delete contents
(D) None

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

What is the primary function of the register in a CPU:...?

(A) Quickly accept, store, and transfer data and instructions
(B) To manage the CPU's cache memory

(C) To control the flow of instructions
(D) To handle memory management

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

What is the function of the IF function in Excel...?

(A) To perform a logical test and return a value based on the result
(B) To add up a range of cells

(C) To find the average of a range of cells
(D) To count the number of cells in a range

Comments

Source: This question is taken from the Junior Computer Operator (Bs-12) Transport And Mass Transit Department, Irrigation Department PPSC 2024

Latest MCQs

In MS Excel formula and function start with ____...?

(A) +
(B) -

(C) =
(D) [

Comments

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

Latest MCQs

What is the function of the VLOOKUP function in Excel...?

(A) To perform a vertical lookup and return a value based on a specified criteria
(B) To perform a horizontal lookup and return a value based on a specified criteria

(C) To add up a range of cells
(D) To find the average of a range of cells

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

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

(A) Average
(B) Count

(C) Both A and B
(D) Table

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

What is the function of the F4 key in a Spreadsheet...?

(A) Change font
(B) Repeat the last action

(C) Choose open command
(D) Open bookmark

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

What is the function of the F4 key in most systems...?

(A) System Settings
(B) Close a Window

(C) Repeat Last Action
(D) Refresh Page

Comments

Source: This question is taken from the Assistant Punjab Police PPSC Past Paper 2024

Latest MCQs

Which is not the function of the operating system...?

(A) Linux
(B) DOS

(C) Oracle
(D) Window

Comments

Source: This question is taken from the Junior Computer Operator PPSC Past Paper 2024

Latest MCQs

Programs written to make computer function in a desired way are called:...?

(A) Codes
(B) Instructions

(C) Hardware
(D) Software

Comments

Source: This question is taken from the Junior Clerk Service and General Administration (S&GAD)

Latest MCQs

in MS Excel what is function inside another function is called...?

(A) nested
(B) round

(C) switch
(D) none of these

Comments

Source: This question is taken from the District Zakat Officer BS-17 PPSC past papers

Latest MCQs

What is the function of the SUM function in Excel...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find the maximum value in a range of cells

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which of the following function key activates the speller in Ms Word...?

(A) F5
(B) F7

(C) F9
(D) Shift + F7

Comments

Source: This question is taken from the Microsoft Word MCQs

Latest MCQs

Which of the following function rotate the contents of columns to rows and rows to columns in Microsoft Excel...?

(A) switching
(B) transpose

(C) matrix
(D) none

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

In Excel, what is the function of the F11 key...?

(A) Save the workbook
(B) Toggle full-screen mode on/off

(C) Insert a new worksheet
(D) Open the print preview

Comments
Explanation:

In Excel, pressing the "F11" key creates a new chart sheet based on the currently selected data range, essentially allowing you to quickly generate a chart from the highlighted cells in a separate chart sheet. 

Source: This question is taken from the Assistant (S&GAD) PPSC Past Paper 2024

Latest MCQs

In a computer spreadsheet, a function that is used to count a number of entries in a given range is called...?

(A) length
(B) counter

(C) counting
(D) count

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

A function inside another function in called _____...?

(A) Text function
(B) Sum function

(C) Round function
(D) Nested function

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which function is not available in the consolidate dialogue box ...?

(A) Average
(B) Max

(C) Pmt
(D) None

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

Which function is use to display the current date and time in a cell:...?

(A) Today
(B) Now

(C) Day
(D) Current

Comments

Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024

Latest MCQs

In MS Excel function to return one value if a condition is true and another value if it's false:...?

(A) If function
(B) Sum function

(C) Decimal function
(D) Info function

Comments

Source: This question is taken from the Clubbed Case Canal Patwari First Phase (Morning) 2023

Latest MCQs

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

(A) TOTAL
(B) ADD

(C) SUM
(D) AVG

Comments

Source: This question is taken from the Sub Inspector Punjab Police Open Marit

Latest MCQs

In Ms Excel, which of the following special function keys allow the content in cell...?

(A) Shift
(B) Esc

(C) Tab
(D) Space

Comments

Source: This question is taken from the Microsoft Excel MCQs

Latest MCQs

What is the function of the SUM function in Excel:...?

(A) To add up a range of cells
(B) To find the average of a range of cells

(C) To count the number of cells in a range
(D) To find maximum value in a range of cells

Comments

Source: This question is taken from the Assistant director (Bs-17) local government & community development department PPSC 2024

Latest MCQs

MS Excel's function arguments are always written in _______ ....?

(A) Cell
(B) Row

(C) Colomn
(D) Parenthesis

Comments

Source: This question is taken from the Punjab Police Sub Inspector (SI) Service Quota PPSC Past

Latest MCQs

Function key to go to a specific cell in MS Excel is:...?

(A) F4
(B) F5

(C) F6
(D) None of these

Comments

Source: This question is taken from the Microsoft Excel MCQs

Best of Luck

From ShineGk.com

Share our website's link