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.
In the Data ribbon of Microsoft Excel, the feature “PivotTable” cannot be found.
The PivotTable feature is located in the Insert ribbon.
The Data ribbon includes features such as What-If Analysis, Data Validation, and Text to Columns.
Columns in MS Excel are numbered Alphabetically (A, B, C, etc.).
Rows in MS Excel are numbered Numerically (1, 2, 3, etc.).
A macro in MS Excel is a set of instructions that can be executed as a single command.
It automates repetitive tasks by recording and playing back sequences of actions, saving time and effort.
The vertical dimension of a spreadsheet is called a Column.
Columns run from top to bottom and are identified by letters.
The horizontal dimension of a spreadsheet is called a Row.
Rows run from left to right and are identified by numbers.
The utility of Excel to fill columns or rows with a series of data is Auto Fill.
It allows users to quickly populate cells with a sequence or pattern based on the initial values entered.
In Excel charts, the vertical axis is called the Y-axis.
The Y-axis typically represents values.
The horizontal axis is referred to as the X-axis.
The X-axis represents categories or time.
The default name of the first sheet in any workbook is Sheet1.
Excel assigns this name automatically.
It can be renamed by the user if desired.
The formula bar is the toolbar at the top of the spreadsheet that lets you enter or view information in a cell.
To sum up a range of cells in Excel, you use the SUM function.
This function adds together all the numbers in the specified range of cells.
MAX function finds the highest value in a range of cells.
AVERAGE function calculates the average of the numbers in a range.
COUNT function counts the number of cells that contain numbers.
