Computer Most repeated MCQs, MS Excel Most repeated MCQs, MS Word Most repeated MCQs, MS PowerPoint Most repeated MCQs for CSS, PMS, Inspector, ASI, Sub-inspector, Constable, FPSC, PPSC, ETEA, FIA, Police, Army, Navy, Airforce, IB, MOFA, ASF, LHC, Educators all other competitive exams and govt, private Jobs. most of mcqspreparation.online these questions are also discussed on Pakmcqs official and . you can read the most repeated 100 MCQs, these questions get from past papers.
The VLOOKUP function in Excel is used to search for a value in the first column of a range
And return a value in the same row from a specified column.
It is commonly used for looking up data in a table or range.
The VLOOKUP function in Excel searches for a specified value in the first column of a table and returns a value from another column in the same row.
The VLOOKUP or Vertical Lookup function is used when data is listed in columns.
A worksheet consists of rows (horizontal) and columns (vertical) where data is entered into cells at their intersections.
After = symbol you can enter either a calculation or functions
Filtering in Excel enables you to display rows that meet certain criteria, hiding the others.
This Excel feature allows you to display only the rows that meet specific conditions while hiding the others.
A pie chart is best suited for showing the proportion of parts to a whole.
As it visually represents data as slices of a circle.
It highlighting the relative sizes of components.
DATE: returns the serial date value for a date
TODAY: returns today’s date
NOW: returns the current date and time
TIME: assemble a proper time.
Transposing is a process in data management where rows are converted into columns and vice versa.
This is a common operation in data analysis, reporting, and visualization.
In Microsoft Excel, for example, you can use the “Transpose” feature to switch rows and columns.
It allowing you to view and analyze data from a different perspective.
The process of combining two or more cells into a single cell in MS Word or Excel is called “merging.”
This is commonly used for formatting tables or organizing data.
