TGPRB SCT ASI (Fingerprint Bureau) 2026 — Technical Paper
The official TGPRB notification lists these MS-Excel areas: Cell formatting, graphic objects and charts, database, pivot tables, data validation, maths functions and calculations, templates, file protection, and printing
Excel Basics & Cell Formatting
2001. MS Excel is primarily a:
A) Spreadsheet application B) Word processor C) Presentation application D) Web browser
Answer: A
2002. An Excel file is commonly called a:
A) Workbook B) Document only C) Presentation D) Database server
Answer: A
2003. A workbook contains:
A) Worksheets B) Slides C) Pages only D) Records only
Answer: A
2004. A worksheet consists of:
A) Rows and columns B) Slides and notes C) Pages only D) Records and forms
Answer: A
2005. The intersection of a row and column is called a:
A) Cell B) Table C) Range D) Field
Answer: A
2006. Columns in Excel are identified by:
A) Letters B) Numbers C) Symbols only D) Dates only
Answer: A
2007. Rows in Excel are identified by:
A) Numbers B) Letters C) Symbols D) Colors
Answer: A
2008. Cell A1 refers to:
A) Column A, Row 1 B) Row A, Column 1 C) Sheet A1 D) Workbook A1
Answer: A
2009. A group of cells is called a:
A) Range B) Record C) Slide D) Paragraph
Answer: A
2010. A1:C5 represents:
A) A cell range B) One cell C) One row only D) One column only
Answer: A
2011. The active cell is:
A) Currently selected cell B) First cell always C) Last cell D) Hidden cell
Answer: A
2012. The active cell is normally indicated by:
A) Selection border B) Page border C) Printer border D) Table border
Answer: A
2013. The Formula Bar displays:
A) Cell contents/formula B) Printer status C) Page margins D) File size only
Answer: A
2014. The Name Box displays:
A) Cell reference/name B) File password C) Printer name D) Font name only
Answer: A
2015. A formula in Excel normally begins with:
A) = B) # C) @ D) &
Answer: A
2016. A worksheet can contain:
A) Text B) Numbers C) Formulas D) All of these
Answer: D
2017. Excel formulas can perform:
A) Calculations B) Only text formatting C) Printing only D) Image editing
Answer: A
2018. A cell can contain:
A) Text B) Number C) Formula D) All of these
Answer: D
2019. Cell formatting changes:
A) Appearance of cell contents B) CPU speed C) File location D) Operating system
Answer: A
2020. Font formatting can change:
A) Font type B) Font size C) Font color D) All of these
Answer: D
2021. Bold formatting makes text:
A) Heavier/darker B) Smaller C) Underlined only D) Hidden
Answer: A
2022. Italic formatting makes text:
A) Slanted B) Bold C) Larger D) Hidden
Answer: A
2023. Underline places:
A) A line beneath text B) A line above text C) A border around sheet D) A page break
Answer: A
2024. Cell fill color changes:
A) Background color of cell B) Font size C) Formula D) Cell reference
Answer: A
2025. Font color changes:
A) Color of characters B) Cell background C) Row number D) Column width
Answer: A
2026. Alignment controls:
A) Position of cell content B) Formula result C) File size D) Worksheet name
Answer: A
2027. Horizontal alignment can be:
A) Left B) Center C) Right D) All of these
Answer: D
2028. Vertical alignment can be:
A) Top B) Center C) Bottom D) All of these
Answer: D
2029. Wrap Text is used to:
A) Display long content on multiple lines within a cell B) Delete text C) Hide formulas D) Protect workbook
Answer: A
2030. Merge & Center is used to:
A) Combine cells and center content B) Delete cells C) Create formulas D) Sort data
Answer: A
2031. Merging cells combines:
A) Two or more cells into one area B) Two worksheets C) Two workbooks D) Two formulas
Answer: A
2032. Borders are used to:
A) Visually separate cells B) Calculate values C) Sort data D) Protect files
Answer: A
2033. Cell borders can be:
A) Applied B) Removed C) Customized D) All of these
Answer: D
2034. Number formatting controls:
A) How numeric values are displayed B) Actual CPU value C) File name D) Worksheet count
Answer: A
2035. Currency format is used for:
A) Monetary values B) Text paragraphs C) Dates only D) Images
Answer: A
2036. Percentage format displays values as:
A) Percentages B) Currency C) Dates D) Text only
Answer: A
2037. Date format controls:
A) Display of dates B) File creation date only C) Row number D) Column width
Answer: A
2038. Decimal formatting controls:
A) Number of decimal places displayed B) Number of rows C) Number of sheets D) Font type
Answer: A
2039. Increasing decimal places:
A) Displays more decimal digits B) Deletes digits from value necessarily C) Deletes cell D) Changes formula
Answer: A
2040. Decreasing decimal places changes:
A) Display precision B) Underlying formula necessarily C) File name D) Worksheet count
Answer: A
2041. Format Painter is used to:
A) Copy formatting B) Copy formulas only C) Print cells D) Delete formatting
Answer: A
2042. Conditional Formatting is used to:
A) Format cells based on conditions B) Create operating systems C) Print documents D) Protect CPU
Answer: A
2043. Conditional Formatting can highlight:
A) Values meeting specified conditions B) Only text C) Only formulas D) Only empty cells
Answer: A
2044. Data bars are a type of:
A) Conditional formatting B) Database C) Formula D) Worksheet
Answer: A
2045. Color scales are used to:
A) Visually compare values B) Change file type C) Create formulas D) Protect workbook
Answer: A
2046. Icon sets provide:
A) Visual indicators based on values B) Database records C) Page numbers D) Worksheet names
Answer: A
2047. Row height controls:
A) Height of rows B) Width of columns C) Font type D) File size
Answer: A
2048. Column width controls:
A) Width of columns B) Height of rows C) Font color D) Worksheet count
Answer: A
2049. AutoFit can adjust:
A) Row height/column width to content B) File password C) Formula result D) Printer
Answer: A
2050. A column can be resized by:
A) Dragging its boundary B) Changing formula C) Using spell check D) Printing
Answer: A
2051. A row can be resized by:
A) Dragging its boundary B) Changing worksheet name C) Sorting data D) Creating chart
Answer: A
2052. Hiding a row makes it:
A) Temporarily invisible B) Permanently deleted C) Encrypted D) Printed
Answer: A
2053. Hiding a column makes it:
A) Temporarily invisible B) Permanently deleted C) Encrypted D) Protected automatically
Answer: A
2054. Unhide restores:
A) Hidden rows/columns B) Deleted files C) Deleted formulas always D) Printed pages
Answer: A
2055. Freeze Panes is useful for:
A) Keeping rows/columns visible while scrolling B) Protecting workbook C) Printing D) Sorting
Answer: A
2056. Freeze Top Row keeps:
A) Top row visible while scrolling B) Last row visible C) First column hidden D) Entire workbook locked
Answer: A
2057. Freeze First Column keeps:
A) First column visible while scrolling B) First row hidden C) Last column visible D) Sheet protected
Answer: A
2058. A cell reference identifies:
A) Cell location B) Font C) Printer D) Workbook password
Answer: A
2059. Relative reference changes when:
A) Formula is copied B) File is printed C) Sheet is renamed D) Font changes
Answer: A
2060. Absolute reference uses:
A) Dollar signs ($) B) Percent signs C) Hash signs D) Ampersands
Answer: A
2061. $A$1 is a:
A) Fully absolute reference B) Relative reference C) Mixed reference D) Range
Answer: A
2062. A$1 is a:
A) Mixed reference B) Absolute reference C) Relative reference only D) Named range
Answer: A
2063. $A1 is a:
A) Mixed reference B) Fully absolute reference C) Relative reference only D) Sheet reference
Answer: A
2064. Relative reference A1 changes when:
A) Formula is copied B) Workbook is printed C) Font changes D) Sheet is protected
Answer: A
2065. Absolute reference is useful when:
A) A fixed cell must remain referenced B) Every reference must change C) Formatting cells D) Printing
Answer: A
2066. The F4 key can be used to:
A) Cycle reference types while editing a formula B) Print C) Save D) Open
Answer: A
2067. Copying a formula can adjust:
A) Relative references B) File name C) Printer D) Worksheet color
Answer: A
2068. Paste Special provides:
A) Different ways to paste content B) Only normal paste C) Printing options D) Page setup
Answer: A
2069. Paste Values pastes:
A) Results/values rather than formulas B) Only formatting C) Only formulas D) Only comments
Answer: A
2070. Paste Formatting pastes:
A) Formatting B) Formula results only C) Values only D) Workbook
Answer: A
2071. Clear Contents removes:
A) Cell contents B) Entire worksheet C) Workbook D) Printer
Answer: A
2072. Clear Formats removes:
A) Formatting B) Values necessarily C) Formulas necessarily D) Worksheet
Answer: A
2073. Delete Cells can:
A) Remove cells and shift surrounding cells B) Only change font C) Print sheet D) Create chart
Answer: A
2074. Insert Cells can:
A) Add cells and shift surrounding cells B) Delete workbook C) Print D) Sort only
Answer: A
2075. Insert Rows adds:
A) New rows B) New worksheets only C) New workbooks D) New formulas only
Answer: A
2076. Insert Columns adds:
A) New columns B) New workbooks C) New printers D) New formulas only
Answer: A
2077. Worksheet tabs are used to:
A) Switch between worksheets B) Format fonts only C) Print D) Sort data
Answer: A
2078. A worksheet can be renamed:
A) Yes B) No C) Only after printing D) Only after protection
Answer: A
2079. A worksheet can be moved or copied:
A) Yes B) No C) Only in PDF D) Only in PowerPoint
Answer: A
2080. Cell formatting is explicitly included in the official MS-Excel syllabus.
A) True B) False
Answer: A
🔹 2081–2160: Graphic Objects & Charts
2081. A chart is used to:
A) Visually represent data B) Store passwords C) Create operating systems D) Protect files
Answer: A
2082. Charts can make data:
A) Easier to understand visually B) Encrypted C) Smaller always D) Hidden
Answer: A
2083. A chart is generally based on:
A) Data range B) Printer C) File password D) Page margins
Answer: A
2084. Column charts display data using:
A) Vertical columns B) Circular sectors C) Horizontal lines only D) Text boxes only
Answer: A
2085. Bar charts display data using:
A) Horizontal bars B) Circular sectors C) Vertical pages D) Pictures only
Answer: A
2086. Pie charts show:
A) Proportions of a whole B) Only trends over time C) Database relationships D) Text formatting
Answer: A
2087. Line charts are useful for:
A) Showing trends B) Showing passwords C) Formatting cells D) File protection
Answer: A
2088. Area charts can show:
A) Trends and magnitude B) Only text C) File names D) Page margins
Answer: A
2089. Scatter charts are useful for:
A) Relationships between numerical variables B) Page numbering C) Cell formatting D) Printing
Answer: A
2090. A chart title identifies:
A) What the chart represents B) File password C) Worksheet name necessarily D) Printer
Answer: A
2091. A legend identifies:
A) Data series B) Workbook password C) Rows only D) Columns only
Answer: A
2092. Chart axes provide:
A) Scales/reference for data B) Passwords C) File extensions D) Worksheet names
Answer: A
2093. Horizontal chart axis is commonly called:
A) X-axis B) Y-axis C) Z-axis only D) T-axis
Answer: A
2094. Vertical chart axis is commonly called:
A) Y-axis B) X-axis C) A-axis D) B-axis
Answer: A
2095. A data series represents:
A) Related set of values B) File password C) Worksheet name D) Font type
Answer: A
2096. Data labels can display:
A) Values on chart B) File passwords C) Page margins D) Cell formulas only
Answer: A
2097. Gridlines in a chart help:
A) Read values against an axis scale B) Protect workbook C) Sort data D) Save file
Answer: A
2098. Chart styles control:
A) Visual appearance B) Formula calculation C) File protection D) Data validation
Answer: A
2099. A chart can be resized:
A) Yes B) No C) Only after printing D) Only in PDF
Answer: A
2100. A chart can be moved:
A) Yes B) No C) Only to another workbook D) Only after protection
Answer: A
2101. A chart can be copied:
A) Yes B) No C) Only as text D) Only as formula
Answer: A
2102. A chart can be deleted without necessarily deleting:
A) Source data B) Workbook C) Worksheet D) Formula engine
Answer: A
2103. A chart may be placed:
A) On a worksheet B) On a chart sheet C) Depending on Excel options, both D) Neither
Answer: C
2104. A chart sheet contains:
A) A chart as the main sheet content B) Only formulas C) Only tables D) Only text
Answer: A
2105. Graphic objects can include:
A) Shapes B) Pictures C) Text boxes D) All of these
Answer: D
2106. A text box is used to:
A) Place text as a movable object B) Calculate formulas C) Protect files D) Sort data
Answer: A
2107. Shapes can include:
A) Arrows B) Rectangles C) Circles D) All of these
Answer: D
2108. Pictures can be inserted into:
A) Worksheets B) Charts/workbook areas C) Both depending on context D) Neither
Answer: C
2109. WordArt is:
A) Decorative text B) Database table C) Formula D) Pivot table
Answer: A
2110. Graphic objects can be:
A) Resized B) Moved C) Formatted D) All of these
Answer: D
2111. Object alignment is used to:
A) Position objects relative to each other/page B) Calculate values C) Sort records D) Validate data
Answer: A
2112. Grouping objects allows:
A) Multiple objects to behave as one unit B) Multiple formulas to merge C) Worksheets to merge automatically D) Files to compress
Answer: A
2113. Ungroup separates:
A) Grouped objects B) Cells C) Worksheets D) Workbooks
Answer: A
2114. Bring Forward changes:
A) Object stacking order B) Formula order C) Row order D) Column order
Answer: A
2115. Send Backward changes:
A) Object stacking order B) Data sorting C) Formula order D) Page numbering
Answer: A
2116. Crop is mainly used with:
A) Pictures B) Formulas C) Tables D) Worksheets
Answer: A
2117. Rotation changes:
A) Orientation of an object B) Cell value C) Formula result D) File extension
Answer: A
2118. A chart’s source data can be:
A) Changed B) Expanded C) Reduced D) All of these
Answer: D
2119. Changing source data can:
A) Update the chart B) Delete workbook C) Change printer D) Protect file
Answer: A
2120. A chart legend is especially useful when:
A) Multiple data series exist B) No data exists C) Only one cell exists D) Printing only
Answer: A
2121. Pie chart slices represent:
A) Categories/proportions B) Rows only C) Columns only D) Formulas only
Answer: A
2122. A pie chart is generally unsuitable for:
A) Showing many categories clearly B) Showing simple proportions C) Showing parts of a whole D) Small category sets
Answer: A
2123. Line chart is commonly suitable for:
A) Time-based trends B) Cell formatting C) Password protection D) Data validation
Answer: A
2124. Column chart is commonly suitable for:
A) Comparing categories B) File protection C) Data entry restrictions D) Templates
Answer: A
2125. Bar chart is useful for:
A) Comparing categories B) Cell protection C) Formula editing D) Printing only
Answer: A
2126. Scatter chart uses:
A) Numerical X and Y values B) Only text C) Only dates D) Only formulas
Answer: A
2127. Chart elements include:
A) Title B) Legend C) Axes D) All of these
Answer: D
2128. Data labels can show:
A) Values B) Category names depending on settings C) Percentages depending on chart/options D) All of these
Answer: D
2129. Chart formatting can change:
A) Fonts B) Borders C) Layout D) All of these
Answer: D
2130. Chart filters can control:
A) Which data is displayed B) Workbook password C) Printer D) Cell protection
Answer: A
2131. A sparkline is:
A) A small in-cell chart B) A database C) A formula D) A password
Answer: A
2132. Sparklines are useful for:
A) Quickly showing trends B) File protection C) Data validation D) Printing pages
Answer: A
2133. Graphic objects are separate from:
A) Cell values B) Cell formulas C) Worksheet data D) All of these
Answer: D
2134. An image can be layered:
A) Above or below other objects B) Only inside formulas C) Only in cells D) Only in headers
Answer: A
2135. Object formatting may include:
A) Fill B) Outline C) Effects D) All of these
Answer: D
2136. A shape’s fill changes:
A) Interior appearance B) Formula C) Cell value D) Workbook name
Answer: A
2137. A shape’s outline changes:
A) Border appearance B) Cell value C) Formula D) Worksheet name
Answer: A
2138. A chart can have a:
A) Title B) Legend C) Data labels D) All of these
Answer: D
2139. Changing chart type changes:
A) Visual representation of the same/selected data B) Source data necessarily C) File password D) Worksheet name
Answer: A
2140. Chart type can be changed after creation.
A) True B) False
Answer: A
2141. A chart can be printed:
A) Yes B) No C) Only as text D) Only after conversion to PDF
Answer: A
2142. Charts can be included in:
A) Printed worksheets B) Presentations C) Reports D) All of these
Answer: D
2143. A chart based on a selected range can:
A) Reflect the selected data B) Automatically repair formulas C) Protect workbook D) Validate cells
Answer: A
2144. Graphic objects are useful for:
A) Visual presentation B) Data entry only C) Password creation D) File compression
Answer: A
2145. Chart axis titles describe:
A) Meaning of axes B) File name C) Worksheet name D) Password
Answer: A
2146. A secondary axis may be used when:
A) Data series have very different scales B) No data exists C) Printing is disabled D) Workbook is protected
Answer: A
2147. A chart’s plot area contains:
A) Graphical representation of data B) File password C) Worksheet tabs D) Formulas only
Answer: A
2148. Chart area includes:
A) Overall chart object B) Only one data point C) Only title D) Only legend
Answer: A
2149. Data points represent:
A) Individual values in a series B) Files C) Worksheets D) Passwords
Answer: A
2150. A category axis generally represents:
A) Categories B) Workbook names C) File extensions D) Passwords
Answer: A
2151. A value axis generally represents:
A) Numeric scale B) Worksheet names C) File names D) Text formatting
Answer: A
2152. Chart legends use:
A) Series names B) Passwords C) Cell addresses only D) Page numbers
Answer: A
2153. Graphic objects can be deleted independently of:
A) Worksheet cells B) Workbook formulas C) Source data D) All of these
Answer: D
2154. A chart can be formatted without changing:
A) Underlying data B) Chart appearance C) Chart style D) Chart title
Answer: A
2155. Charts are particularly useful for:
A) Data visualization B) File security C) Data validation only D) Templates only
Answer: A
2156. Excel supports multiple chart types.
A) True B) False
Answer: A
2157. A column chart and bar chart differ mainly in:
A) Orientation of bars B) File format C) Formula language D) Worksheet structure
Answer: A
2158. A pie chart represents:
A) Parts of a whole B) Rows only C) Columns only D) File sizes
Answer: A
2159. A line chart emphasizes:
A) Trends B) File protection C) Cell formatting D) Data validation
Answer: A
2160. Graphic objects and charts are explicitly included in the official Excel syllabus.
A) True B) False
Answer: A
🔹 2161–2240: Database & Excel Data Management
2161. A database stores:
A) Organized data B) Only pictures C) Only formulas D) Only charts
Answer: A
2162. In a tabular database, a row is often called a:
A) Record B) Field C) Formula D) Chart
Answer: A
2163. In a tabular database, a column is often called a:
A) Field B) Record C) Worksheet D) Chart
Answer: A
2164. Excel tables organize data into:
A) Rows and columns B) Slides C) Pages only D) Pictures
Answer: A
2165. A field contains:
A) One type/category of information B) An entire database necessarily C) A workbook D) A chart
Answer: A
2166. A record contains:
A) Related fields describing one item/entity B) One cell only C) One column only D) One chart
Answer: A
2167. Excel can be used to manage:
A) Tabular data B) Records C) Lists D) All of these
Answer: D
2168. Sorting arranges data:
A) According to selected criteria B) Randomly C) Only alphabetically D) Only by date
Answer: A
2169. Ascending sort for text generally means:
A) A to Z B) Z to A C) Newest to oldest D) Largest to smallest
Answer: A
2170. Descending sort for text generally means:
A) Z to A B) A to Z C) Smallest to largest D) Oldest to newest
Answer: A
2171. Ascending numeric sort means:
A) Smallest to largest B) Largest to smallest C) Z to A D) Newest to oldest
Answer: A
2172. Descending numeric sort means:
A) Largest to smallest B) Smallest to largest C) A to Z D) Oldest to newest
Answer: A
2173. Filtering displays:
A) Records meeting criteria B) All hidden formulas C) Only charts D) Only blank cells
Answer: A
2174. Filtering does not normally:
A) Delete excluded records B) Hide records from view C) Reduce visible data D) Apply criteria
Answer: A
2175. An Excel table can provide:
A) Sorting B) Filtering C) Structured formatting D) All of these
Answer: D
2176. A header row contains:
A) Field/column names B) Only formulas C) Only totals D) Only charts
Answer: A
2177. Excel’s AutoFilter helps:
A) Filter data B) Format pictures C) Protect files D) Print pages
Answer: A
2178. A filter criterion determines:
A) Which records are displayed B) Font size C) Printer D) Worksheet name
Answer: A
2179. Multiple filters can be applied:
A) Yes B) No C) Only in Word D) Only in PowerPoint
Answer: A
2180. Filtering by date can display:
A) Records matching date conditions B) Only text C) Only charts D) Only formulas
Answer: A
2181. Filtering by number can use:
A) Greater than B) Less than C) Equal to D) All of these
Answer: D
2182. Filtering by text can use:
A) Contains B) Begins With C) Ends With D) All of these
Answer: D
2183. Sorting multiple columns is called:
A) Multi-level sorting B) Formatting C) Merging D) Validation
Answer: A
2184. Multi-level sorting can sort by:
A) Primary and secondary fields B) Printer C) Font only D) Chart only
Answer: A
2185. Data can be sorted by:
A) Values B) Cell color C) Font color depending on options D) All of these
Answer: D
2186. A unique identifier helps:
A) Distinguish records B) Change font C) Create charts only D) Print documents
Answer: A
2187. Duplicate data means:
A) Repeated records/values B) Missing data C) Formulas D) Charts
Answer: A
2188. Remove Duplicates is used to:
A) Remove duplicate records/values B) Delete formulas only C) Delete workbook D) Remove charts
Answer: A
2189. Data cleaning can include:
A) Removing duplicates B) Correcting inconsistent entries C) Handling blanks D) All of these
Answer: D
2190. A blank cell contains:
A) No value/content B) Zero necessarily C) Text necessarily D) Formula necessarily
Answer: A
2191. Zero and blank are:
A) Different concepts B) Always identical C) Always errors D) Both text
Answer: A
2192. Text data is commonly used for:
A) Names B) Addresses C) Categories D) All of these
Answer: D
2193. Numeric data is commonly used for:
A) Quantities B) Amounts C) Measurements D) All of these
Answer: D
2194. Dates in Excel are stored internally as:
A) Numeric serial values B) Pictures C) Text only D) Database tables
Answer: A
2195. Excel tables can automatically expand when:
A) Data is added adjacent to the table B) Printer is connected C) File is printed D) Font changes
Answer: A
2196. Structured references are associated with:
A) Excel tables B) Word documents C) PowerPoint slides D) Windows
Answer: A
2197. Table columns can have:
A) Header names B) Formulas C) Data D) All of these
Answer: D
2198. Total Row in an Excel table can provide:
A) Summary calculations B) Password C) Chart only D) Page margin
Answer: A
2199. A table’s Total Row can use:
A) Sum B) Average C) Count D) All of these
Answer: D
2200. Database-style Excel data should preferably have:
A) Clear column headings B) Consistent data C) One record per row D) All of these
Answer: D
2201. A database table should avoid:
A) Unnecessary blank rows within data B) Headers C) Records D) Fields
Answer: A
2202. One row in a data table usually represents:
A) One record B) One field C) One worksheet D) One formula
Answer: A
2203. One column usually represents:
A) One field B) One record C) One worksheet D) One chart
Answer: A
2204. Filtering is useful for:
A) Finding relevant records B) Changing formulas C) Printing only D) Formatting pictures
Answer: A
2205. Sorting changes:
A) Order of displayed data B) Underlying values necessarily C) File format D) Password
Answer: A
2206. A custom sort allows:
A) User-defined ordering B) Only A-Z sorting C) Only Z-A sorting D) No criteria
Answer: A
2207. Sort by Color can use:
A) Cell/font color B) Formula only C) File name D) Worksheet name
Answer: A
2208. Filter by Color can show:
A) Cells with selected color B) Only formulas C) Only text D) Only blank cells
Answer: A
2209. A database report summarizes or presents:
A) Data B) CPU speed C) File extension D) Printer settings
Answer: A
2210. Excel can create reports using:
A) Tables B) PivotTables C) Charts D) All of these
Answer: D
2211. Data should ideally have:
A) Consistent field types B) Random formats C) Mixed headings in every row D) No headers
Answer: A
2212. Data validation helps ensure:
A) Appropriate data entry B) Faster CPU C) Printing D) Chart animation
Answer: A
2213. Sorting and filtering are useful for:
A) Database-style data B) File protection only C) Templates only D) Printing only
Answer: A
2214. An Excel table can be:
A) Sorted B) Filtered C) Formatted D) All of these
Answer: D
2215. Structured data is easier to:
A) Sort and analyze B) Hide permanently C) Encrypt automatically D) Print only
Answer: A
2216. Database-style data commonly uses:
A) Headers in first row B) Random headers C) Pictures as every field D) Empty rows between records
Answer: A
2217. A field name should be:
A) Descriptive B) Ambiguous C) Random D) Repeated unnecessarily
Answer: A
2218. Data consistency means:
A) Similar data follows a consistent format B) Every cell is different C) Data is hidden D) Data is deleted
Answer: A
2219. Duplicate records can affect:
A) Accuracy of analysis B) Font size C) Page orientation D) Printer
Answer: A
2220. Filtering can be cleared to:
A) Show all records again B) Delete records C) Delete formulas D) Protect workbook
Answer: A
2221. A filtered worksheet can still:
A) Be edited depending on selection/operation B) Never be edited C) Only be printed D) Only be saved
Answer: A
2222. Excel database tools are useful for:
A) Managing lists B) Analyzing records C) Preparing reports D) All of these
Answer: D
2223. A table header should generally be:
A) Unique/descriptive B) Empty C) A chart D) A password
Answer: A
2224. Data sorting can be reversed:
A) Yes B) No C) Only after printing D) Only in PDF
Answer: A
2225. Filtering is different from sorting because filtering:
A) Shows records meeting conditions B) Changes order only C) Changes formulas D) Changes font
Answer: A
2226. Sorting is different from filtering because sorting:
A) Changes order of records B) Hides all records C) Deletes data D) Protects workbook
Answer: A
2227. Excel can handle large tabular datasets within its worksheet limits.
A) True B) False
Answer: A
2228. A table can be converted back to a normal range:
A) Yes B) No C) Only in Word D) Only in PDF
Answer: A
2229. Data analysis often begins with:
A) Organized data B) Random cells C) Empty workbook D) Printer setup
Answer: A
2230. A database field should normally contain:
A) Similar type of information B) Entire unrelated records C) Multiple headings D) Charts
Answer: A
2231. Customer ID can be an example of:
A) Identifier field B) Chart C) Formula D) Page number
Answer: A
2232. Employee Name is an example of:
A) Text field B) Chart C) Formula D) Worksheet
Answer: A
2233. Salary is generally:
A) Numeric data B) Picture C) Text necessarily D) Chart
Answer: A
2234. Date of Joining is generally:
A) Date data B) Picture C) Chart D) Password
Answer: A
2235. A database report may contain:
A) Summaries B) Tables C) Charts D) All of these
Answer: D
2236. Filtering can help identify:
A) Records matching a condition B) Printer drivers C) File passwords D) Font names
Answer: A
2237. Sorting can arrange dates:
A) Oldest to newest or reverse B) Only alphabetically C) Only randomly D) Never
Answer: A
2238. Database functionality is listed in the official Excel syllabus.
A) True B) False
Answer: A
2239. PivotTables are particularly useful for:
A) Summarizing data B) Writing paragraphs C) Editing pictures only D) Installing software
Answer: A
2240. Excel can be used as a basic data management tool.
A) True B) False
Answer: A
🔹 2241–2320: PivotTables
2241. A PivotTable is used to:
A) Summarize and analyze data B) Format Windows C) Create operating systems D) Edit videos
Answer: A
2242. PivotTables work best with:
A) Structured tabular data B) Random pictures C) Empty sheets D) Only text paragraphs
Answer: A
2243. PivotTable fields can be placed in:
A) Rows B) Columns C) Values D) All of these
Answer: D
2244. The Values area contains:
A) Data to summarize B) File passwords C) Page margins D) Pictures only
Answer: A
2245. The Rows area determines:
A) Row categories in PivotTable B) Font size C) Page size D) File name
Answer: A
2246. The Columns area determines:
A) Column categories in PivotTable B) Printer C) Worksheet name D) Password
Answer: A
2247. Filters in PivotTable are used to:
A) Restrict displayed data B) Change font C) Print only D) Protect file
Answer: A
2248. PivotTables can summarize using:
A) Sum B) Count C) Average D) All of these
Answer: D
2249. Sum calculates:
A) Total B) Average C) Number of records D) Minimum
Answer: A
2250. Average calculates:
A) Mean B) Total C) Maximum D) Count only
Answer: A
2251. Count calculates:
A) Number of items/cells meeting the relevant counting rules B) Total value C) Average D) Maximum
Answer: A
2252. Max returns:
A) Largest value B) Smallest value C) Average D) Count
Answer: A
2253. Min returns:
A) Smallest value B) Largest value C) Total D) Count
Answer: A
2254. A PivotChart is:
A) Chart associated with PivotTable data B) Database table C) Formula D) Template
Answer: A
2255. PivotTables can be refreshed when:
A) Source data changes B) Printer changes C) Font changes only D) Page orientation changes
Answer: A
2256. Refreshing a PivotTable:
A) Updates it from source data B) Deletes source data C) Deletes workbook D) Prints report
Answer: A
2257. PivotTable grouping can group:
A) Dates/numbers/categories depending on data B) Printers C) Files D) Fonts
Answer: A
2258. Grouping dates can create:
A) Months/quarters/years depending on options B) Printers C) Worksheets D) Passwords
Answer: A
2259. A PivotTable can display:
A) Subtotals B) Grand totals C) Both D) Neither
Answer: C
2260. Grand Total represents:
A) Overall total B) Only first row C) Only last row D) File size
Answer: A
2261. Subtotal represents:
A) Summary for a group/category B) Whole workbook C) Printer D) Page margin
Answer: A
2262. PivotTable layout can be changed:
A) Yes B) No C) Only after printing D) Only in PDF
Answer: A
2263. A PivotTable can be filtered by:
A) Field values B) Dates C) Categories D) All of these
Answer: D
2264. Slicers provide:
A) Visual filtering controls B) Passwords C) Formulas D) Page breaks
Answer: A
2265. Slicers can filter:
A) PivotTable data B) Operating system C) Printer D) Workbook password
Answer: A
2266. A timeline is useful for filtering:
A) Date-based PivotTable data B) Text only C) Printer settings D) Formulas only
Answer: A
2267. PivotTables can be used to analyze:
A) Sales data B) Employee data C) Survey data D) All of these
Answer: D
2268. PivotTable source data should preferably have:
A) Headers B) Consistent columns C) Records in rows D) All of these
Answer: D
2269. Blank headers can cause:
A) Problems when creating PivotTables B) Better analysis C) Automatic protection D) Printing improvement
Answer: A
2270. Each source column should ideally have:
A) A unique header B) No header C) Same header as every other column D) A picture
Answer: A
2271. PivotTables can calculate:
A) Totals B) Counts C) Averages D) All of these
Answer: D
2272. A PivotTable does not necessarily:
A) Change original source data B) Summarize it C) Group it D) Filter it
Answer: A
2273. PivotTable calculations can be changed:
A) Yes B) No C) Only in Word D) Only in PowerPoint
Answer: A
2274. “Show Values As” can display:
A) Percentages/differences depending on option B) Printer speed C) File size only D) Font
Answer: A
2275. Percentage of Grand Total shows:
A) Contribution to overall total B) Raw text C) Printer information D) Page number
Answer: A
2276. Percentage of Row Total shows:
A) Contribution within a row B) Workbook size C) Printer D) Font
Answer: A
2277. Percentage of Column Total shows:
A) Contribution within a column B) File size C) Page count D) Formula length
Answer: A
2278. PivotTable sorting can:
A) Arrange summarized values/categories B) Delete source data C) Protect workbook D) Change printer
Answer: A
2279. PivotTable filtering can:
A) Show selected categories B) Delete source records C) Change formulas D) Change file extension
Answer: A
2280. A PivotChart visually represents:
A) PivotTable analysis B) Operating system C) Passwords D) Templates
Answer: A
2281. PivotTables are useful for:
A) Large datasets B) Summary analysis C) Reports D) All of these
Answer: D
2282. PivotTables can be placed on:
A) New or existing worksheet B) Printer C) Operating system D) Word document only
Answer: A
2283. The Fields pane is used to:
A) Arrange PivotTable fields B) Print files C) Change CPU D) Protect Windows
Answer: A
2284. Dragging a field to Values means:
A) Summarize its values B) Hide it permanently C) Delete it D) Print it
Answer: A
2285. Dragging a field to Rows creates:
A) Row categories B) Formulas C) Page breaks D) Charts automatically always
Answer: A
2286. Dragging a field to Columns creates:
A) Column categories B) Printer settings C) Page margins D) File protection
Answer: A
2287. Dragging a field to Filters creates:
A) Report filter B) Formula C) Chart D) Template
Answer: A
2288. A PivotTable can contain:
A) Multiple row fields B) Multiple column fields C) Multiple value fields D) All of these
Answer: D
2289. Multiple value fields allow:
A) Several calculations B) Multiple printers C) Multiple files D) Multiple passwords
Answer: A
2290. PivotTable styles control:
A) Appearance B) Calculations necessarily C) Source data D) Password
Answer: A
2291. A PivotTable can be refreshed manually.
A) True B) False
Answer: A
2292. A PivotTable can often be refreshed from its source:
A) Data B) Printer C) Font D) Page border
Answer: A
2293. Changing source data may require:
A) Refreshing PivotTable B) Restarting Windows always C) Reinstalling Excel D) Reprinting only
Answer: A
2294. PivotTable source can be an Excel:
A) Table/range B) Printer C) WordArt D) Page
Answer: A
2295. A PivotTable can summarize:
A) Numeric data B) Counts of text records C) Dates D) All of these
Answer: D
2296. A PivotTable can be used to find:
A) Total sales by region B) Average salary by department C) Count by category D) All of these
Answer: D
2297. PivotTables are primarily an:
A) Analysis tool B) Operating system C) Antivirus D) Printer driver
Answer: A
2298. PivotCharts are primarily:
A) Visualization tools B) Database engines C) File protection tools D) Templates
Answer: A
2299. A PivotTable can show hierarchical:
A) Categories B) File names C) Passwords D) Printers
Answer: A
2300. PivotTable reports can be:
A) Formatted B) Filtered C) Sorted D) All of these
Answer: D
2301. PivotTables can show blank items depending on:
A) Source data/settings B) CPU C) Printer D) Windows version only
Answer: A
2302. PivotTable field names usually come from:
A) Source headers B) Printer C) Workbook password D) Chart title
Answer: A
2303. A PivotTable can be deleted without deleting:
A) Source data B) Excel C) Operating system D) Printer
Answer: A
2304. A PivotChart may be connected to:
A) PivotTable B) Word document C) PDF only D) Printer
Answer: A
2305. PivotTable analysis can reduce:
A) Manual calculation work B) RAM C) Storage D) Page size
Answer: A
2306. PivotTables are useful for:
A) Summaries B) Comparisons C) Aggregation D) All of these
Answer: D
2307. A PivotTable can group records by:
A) Category B) Date C) Number ranges D) All of these
Answer: D
2308. A PivotTable report can display:
A) Grand totals B) Subtotals C) Both D) Neither
Answer: C
2309. PivotTable filters help create:
A) Focused reports B) Operating systems C) Fonts D) Printers
Answer: A
2310. A PivotTable is not primarily used for:
A) Typing long paragraphs B) Data summarization C) Analysis D) Reporting
Answer: A
2311. Slicers are:
A) Interactive filtering controls B) Formulas C) Charts only D) Templates
Answer: A
2312. A timeline is:
A) A date filtering control B) A chart type only C) A formula D) A template
Answer: A
2313. PivotTable calculations can include:
A) Sum B) Count C) Average D) All of these
Answer: D
2314. A PivotTable can sort categories by:
A) Label/value B) Printer C) Font only D) Page number
Answer: A
2315. PivotTable data can be copied:
A) Yes B) No C) Only to Word D) Only to PowerPoint
Answer: A
2316. PivotTable formatting can include:
A) Styles B) Number formats C) Layout changes D) All of these
Answer: D
2317. PivotTables are specifically included in the official Excel syllabus.
A) True B) False
Answer: A
2318. A PivotTable is especially useful when:
A) Many records need summarization B) Only one value exists C) No data exists D) Printing is unavailable
Answer: A
2319. PivotTable reports can support:
A) Decision analysis B) Data summaries C) Reporting D) All of these
Answer: D
2320. Refreshing a PivotTable updates:
A) Its view from source data B) Printer hardware C) CPU D) File extension
Answer: A
🔹 2321–2400: Data Validation
2321. Data Validation controls:
A) What users can enter into cells B) Printer speed C) Font installation D) Workbook size
Answer: A
2322. Data Validation is useful for:
A) Restricting invalid entries B) Creating charts only C) Printing D) Changing CPU
Answer: A
2323. Data Validation can create:
A) Drop-down lists B) Charts C) PivotTables D) Templates only
Answer: A
2324. A list validation allows:
A) Selection from predefined items B) Any value C) Only formulas D) Only pictures
Answer: A
2325. Data Validation can restrict entries to:
A) Whole numbers B) Decimals C) Dates D) All of these
Answer: D
2326. Data Validation can restrict text length.
A) True B) False
Answer: A
2327. Whole Number validation accepts:
A) Integer values according to criteria B) Pictures C) Text only D) Charts
Answer: A
2328. Decimal validation accepts:
A) Decimal values according to criteria B) Images C) Worksheets D) Files
Answer: A
2329. Date validation can restrict:
A) Allowed dates B) Font size C) Chart type D) File format
Answer: A
2330. Time validation can restrict:
A) Allowed times B) Row height C) Column width D) Printer
Answer: A
2331. Text Length validation controls:
A) Number of characters B) Number of rows C) Font size D) File size
Answer: A
2332. Custom validation can use:
A) Formula/condition B) Printer C) Picture D) Page number
Answer: A
2333. Input Message can:
A) Guide users during data entry B) Print automatically C) Change formula D) Protect workbook
Answer: A
2334. Error Alert can:
A) Warn about invalid data B) Create charts C) Change page size D) Save file
Answer: A
2335. Stop error style generally:
A) Prevents invalid entry under the configured rule B) Allows anything C) Deletes workbook D) Prints error
Answer: A
2336. Warning error style:
A) Warns user about invalid data B) Always blocks entry C) Deletes cell D) Changes formula
Answer: A
2337. Information error style:
A) Displays information about validation B) Deletes entry C) Protects file D) Creates chart
Answer: A
2338. Data Validation improves:
A) Data accuracy B) CPU speed C) Printer speed D) File size
Answer: A
2339. A drop-down list is useful for:
A) Standardized choices B) Long documents C) Charts only D) Printing
Answer: A
2340. Example of a validation list:
A) Male/Female/Other or department names B) CPU temperatures only C) Page sizes D) Font names only
Answer: A
2341. Validation can reduce:
A) Inconsistent data entry B) RAM usage C) Page count D) Printer cost
Answer: A
2342. Data Validation applies to:
A) Selected cells B) CPU C) Printer D) Workbook hardware
Answer: A
2343. Validation rules can be copied to:
A) Other cells B) Printers C) Monitors D) Operating systems
Answer: A
2344. A validation rule can use a:
A) Cell range as list source B) Printer C) Picture D) Chart only
Answer: A
2345. Data Validation is useful for:
A) Data entry forms B) Database-style worksheets C) Controlled lists D) All of these
Answer: D
2346. Validation can require a value to be:
A) Between limits B) Equal to a value C) Greater than a value D) All of these
Answer: D
2347. “Between” means:
A) Value must fall within specified limits B) Any value allowed C) Text only D) Date only
Answer: A
2348. “Not between” means:
A) Value must fall outside specified limits B) Only zero allowed C) Only text allowed D) No value allowed
Answer: A
2349. “Equal to” requires:
A) Matching specified criterion B) Different value C) Blank D) Text only
Answer: A
2350. “Not equal to” requires:
A) Value different from criterion B) Same value C) Blank D) Zero
Answer: A
2351. “Greater than” requires:
A) Value above specified value B) Value below it C) Equal value D) Text
Answer: A
2352. “Less than” requires:
A) Value below specified value B) Value above it C) Equal value D) Text only
Answer: A
2353. Data Validation is found under:
A) Data tools B) Insert only C) Review only D) View only
Answer: A
2354. A drop-down arrow can appear in:
A) Validated cells with list validation B) Every cell automatically C) Charts only D) Worksheets only
Answer: A
2355. Data Validation can help standardize:
A) Department names B) Status values C) Categories D) All of these
Answer: D
2356. Validation does NOT automatically guarantee:
A) Data is meaningful in every context B) Entry follows configured rule C) Consistency with rule D) Controlled input
Answer: A
2357. Validation can be removed:
A) Yes B) No C) Only by reinstalling Excel D) Only by deleting workbook
Answer: A
2358. Clear Validation removes:
A) Validation rules B) Cell contents necessarily C) Worksheet D) Workbook
Answer: A
2359. Invalid data can be identified using:
A) Circle Invalid Data feature where supported B) Printer C) Chart D) PivotTable
Answer: A
2360. Data Validation is especially useful in:
A) Forms and data-entry sheets B) Presentations C) Word processing D) Image editing
Answer: A
2361. A validation list can be stored in:
A) A range of cells B) Printer C) Chart D) Header only
Answer: A
2362. Validation source can be:
A) Cell range B) List items C) Formula-based criteria D) All of these
Answer: D
2363. Input Message appears:
A) When validated cell is selected, if enabled B) Only after printing C) During Windows startup D) In PowerPoint
Answer: A
2364. Error Alert appears:
A) When invalid data is entered, if configured B) At computer startup C) During printing only D) Always
Answer: A
2365. Data Validation can be used to restrict age:
A) Yes B) No C) Only in Word D) Only in PowerPoint
Answer: A
2366. Data Validation can be used to restrict marks:
A) Yes B) No C) Only as text D) Only as pictures
Answer: A
2367. Data Validation can be used for attendance values:
A) Yes B) No C) Only in Access D) Only in PowerPoint
Answer: A
2368. A validation rule can restrict marks to:
A) 0–100 B) Any number C) Text only D) Negative only
Answer: A
2369. A validation list reduces:
A) Typing errors/inconsistent choices B) File size C) CPU speed D) Printer use
Answer: A
2370. Data Validation is a:
A) Data entry control B) Chart type C) Formula D) Template
Answer: A
2371. Data Validation can use formulas in:
A) Custom rules B) Printer settings C) Charts D) Page setup
Answer: A
2372. A custom validation formula should generally:
A) Evaluate to TRUE/FALSE B) Print a document C) Create a chart D) Open Windows
Answer: A
2373. Data Validation can be applied to:
A) One cell or a range B) Only entire workbook C) Only charts D) Only tables
Answer: A
2374. Validation settings can be copied using:
A) Copy/Paste or fill methods B) Printing C) WordArt D) Charts
Answer: A
2375. Validation helps:
A) Maintain data quality B) Increase monitor size C) Install Excel D) Create printers
Answer: A
2376. A list drop-down is an example of:
A) Data Validation B) PivotTable C) Macro D) Chart
Answer: A
2377. Data Validation is different from:
A) Conditional Formatting B) Data entry control C) List restrictions D) Error alerts
Answer: A
2378. Conditional Formatting primarily changes:
A) Appearance based on conditions B) Allowed input C) File password D) Printer
Answer: A
2379. Data Validation primarily controls:
A) Allowed input B) Cell appearance C) Chart type D) Printing
Answer: A
2380. Data Validation is explicitly included in the official Excel syllabus.
A) True B) False
Answer: A
🔹 2381–2460: Maths Functions & Calculations
2381. Excel formulas are used for:
A) Calculations B) Printing only C) Page design only D) File protection only
Answer: A
2382. Addition operator in Excel is:
A) + B) – C) * D) /
Answer: A
2383. Subtraction operator is:
A) – B) + C) * D) %
Answer: A
2384. Multiplication operator is:
A) * B) x C) # D) &
Answer: A
2385. Division operator is:
A) / B) \ C) : D) %
Answer: A
2386. Exponentiation operator is:
A) ^ B) ** C) ^^ D) #
Answer: A
2387. Percentage operator is:
A) % B) # C) & D) @
Answer: A
2388. SUM function calculates:
A) Total B) Average C) Minimum D) Count only
Answer: A
2389. =SUM(A1:A5) calculates:
A) Sum of A1 through A5 B) Average C) Maximum D) Minimum
Answer: A
2390. AVERAGE function calculates:
A) Arithmetic mean B) Total C) Minimum D) Maximum
Answer: A
2391. MAX function returns:
A) Largest value B) Smallest value C) Average D) Total
Answer: A
2392. MIN function returns:
A) Smallest value B) Largest value C) Average D) Count
Answer: A
2393. COUNT counts:
A) Numeric cells/values B) All text only C) Blank cells D) Images
Answer: A
2394. COUNTA counts:
A) Non-empty cells B) Only numbers C) Only blanks D) Only formulas
Answer: A
2395. COUNTBLANK counts:
A) Blank cells B) Numeric cells C) Text cells only D) Charts
Answer: A
2396. PRODUCT returns:
A) Product of values B) Sum C) Average D) Minimum
Answer: A
2397. ROUND is used to:
A) Round a number B) Sort data C) Format cells only D) Print
Answer: A
2398. ROUNDUP generally:
A) Rounds away from zero according to its rules B) Always rounds down C) Deletes decimals D) Converts text
Answer: A
2399. ROUNDDOWN generally:
A) Rounds toward zero according to its rules B) Always rounds up C) Adds values D) Sorts data
Answer: A
2400. ABS returns:
A) Absolute value B) Average C) Sum D) Maximum
Answer: A
2401. SQRT returns:
A) Square root B) Square C) Sum D) Percentage
Answer: A
2402. POWER is used to:
A) Raise a number to a power B) Sort values C) Count cells D) Print
Answer: A
2403. MOD returns:
A) Remainder after division B) Quotient only C) Sum D) Average
Answer: A
2404. INT returns:
A) Integer portion according to its rounding behavior B) Percentage C) Text D) Date only
Answer: A
2405. RAND generates:
A) Random number B) Sum C) Date only D) Text
Answer: A
2406. RANDBETWEEN generates:
A) Random integer within specified bounds B) Average C) Total D) Text
Answer: A
2407. SUMIF calculates:
A) Sum based on a criterion B) Average only C) Count only D) Maximum only
Answer: A
2408. COUNTIF counts:
A) Cells meeting a criterion B) All rows regardless of condition C) Only blanks D) Charts
Answer: A
2409. AVERAGEIF calculates:
A) Average of cells meeting a criterion B) Total C) Maximum D) Minimum
Answer: A
2410. SUMIFS can calculate:
A) Sum using multiple criteria B) Only one fixed value C) Text length D) Chart size
Answer: A
2411. COUNTIFS can count:
A) Cells meeting multiple criteria B) Only blank cells C) Only charts D) Only formulas
Answer: A
2412. IF function performs:
A) Logical test and returns results based on condition B) Sorting C) Printing D) Formatting only
Answer: A
2413. Example of IF:
A) =IF(A1>=40,”Pass”,”Fail”) B) =SUM() C) =PRINT() D) =TABLE()
Answer: A
2414. AND returns TRUE when:
A) All specified conditions are TRUE B) Any one condition is TRUE C) No conditions exist D) Values are text
Answer: A
2415. OR returns TRUE when:
A) At least one condition is TRUE B) All conditions must be FALSE C) No conditions exist D) Values are blank
Answer: A
2416. NOT reverses:
A) Logical value B) Numeric value C) Text format D) Cell color
Answer: A
2417. Mathematical functions are used for:
A) Numerical calculations B) Page design C) File protection D) Chart formatting only
Answer: A
2418. Parentheses in formulas control:
A) Order of calculation B) Font size C) Page size D) File name
Answer: A
2419. Multiplication is generally performed before:
A) Addition B) Exponentiation C) Parentheses D) Cell reference
Answer: A
2420. Parentheses are evaluated:
A) Before operations outside them B) Last always C) Never D) Only when printing
Answer: A
2421. =10+5*2 evaluates to:
A) 20 B) 30 C) 25 D) 15
Answer: A
2422. =(10+5)*2 evaluates to:
A) 30 B) 20 C) 15 D) 25
Answer: A
2423. A formula can reference:
A) Other cells B) Constants C) Functions D) All of these
Answer: D
2424. Cell references can be used in:
A) Formulas B) Charts only C) Page setup D) Printing only
Answer: A
2425. AutoSum is commonly used to:
A) Quickly insert SUM B) Insert chart C) Protect workbook D) Create PivotTable
Answer: A
2426. AutoSum often detects:
A) Adjacent range of numbers B) Printer C) Workbook password D) Chart
Answer: A
2427. Formula result is displayed in:
A) Cell B) Printer C) Title bar only D) Worksheet tab
Answer: A
2428. Formula itself can be viewed in:
A) Formula Bar B) Status Bar only C) Printer D) Header
Answer: A
2429. If a formula references a blank cell:
A) Result depends on operation/function B) Excel always crashes C) File is deleted D) Printer starts
Answer: A
2430. Division by zero commonly produces:
A) #DIV/0! B) #VALUE! C) #NAME? D) #REF!
Answer: A
2431. #VALUE! generally indicates:
A) Wrong type of value/argument for an operation B) Printer failure C) File deletion D) Workbook password
Answer: A
2432. #REF! generally indicates:
A) Invalid cell reference B) Correct calculation C) Printer error D) Valid date
Answer: A
2433. #NAME? generally indicates:
A) Unrecognized name/function/reference text B) Printer failure C) Blank cell D) Correct result
Answer: A
2434. #N/A often indicates:
A) Value not available/found B) Printer problem C) Blank workbook D) Correct result
Answer: A
2435. Excel recalculates formulas when:
A) Dependent values change B) Printer changes C) Font changes only D) Page size changes
Answer: A
2436. Manual calculation mode can affect:
A) When formulas recalculate B) Font C) Printing D) Chart style
Answer: A
2437. A formula can be copied using:
A) Fill handle B) Copy/Paste C) Both A and B D) Neither
Answer: C
2438. Fill handle is the:
A) Small square at selection corner B) Formula bar C) Name box D) Status bar
Answer: A
2439. AutoFill can extend:
A) Formulas/patterns B) Printer settings C) Workbook passwords D) Charts only
Answer: A
2440. Series can include:
A) 1,2,3,4… B) Jan, Feb, Mar… C) Dates D) All of these
Answer: D
2441. SUM is a:
A) Mathematical function B) Chart type C) Template D) Data validation rule
Answer: A
2442. AVERAGE is a:
A) Statistical/math function B) Chart C) Worksheet D) File type
Answer: A
2443. MAX and MIN are used to find:
A) Extreme values B) File names C) Page sizes D) Font sizes
Answer: A
2444. COUNT and COUNTA differ because:
A) COUNT counts numeric values while COUNTA counts non-empty cells B) Both always do exactly the same C) COUNTA counts only numbers D) COUNT counts pictures
Answer: A
2445. SUMIF uses:
A) Criteria B) Printer C) Chart D) Template
Answer: A
2446. COUNTIF uses:
A) Criteria B) Page numbers C) Printer D) Workbook password
Answer: A
2447. IF is a:
A) Logical function B) Chart C) Table style D) Printing option
Answer: A
2448. AND and OR are:
A) Logical functions B) Mathematical operators only C) Charts D) Templates
Answer: A
2449. Excel calculations can include:
A) Arithmetic B) Statistical calculations C) Logical calculations D) All of these
Answer: D
2450. A formula can contain multiple functions:
A) Yes B) No C) Only one function D) Only two functions
Answer: A
2451. Nested IF means:
A) IF function inside another IF/function B) Printing two files C) Two charts D) Two worksheets
Answer: A
2452. A nested function is:
A) One function used inside another B) A chart C) A worksheet D) A template
Answer: A
2453. Excel functions generally use:
A) Parentheses for arguments B) Square brackets only C) Quotes always D) No syntax
Answer: A
2454. Function arguments are separated by:
A) Commas/appropriate list separators depending on regional settings B) Spaces always C) Slashes only D) Colons only
Answer: A
2455. A range reference uses:
A) Colon : B) Slash / C) Semicolon only D) Hash #
Answer: A
2456. A1:A10 represents:
A) Range A1 through A10 B) A1 divided by A10 C) Two unrelated cells D) Sheet A1
Answer: A
2457. Mathematical calculations are explicitly included in the official Excel syllabus.
A) True B) False
Answer: A
2458. Excel can perform calculations automatically when formulas are used.
A) True B) False
Answer: A
2459. Functions reduce:
A) Need for manually entering repeated calculations B) Workbook security C) Printing quality D) Page size
Answer: A
2460. Excel formulas and functions are central to:
A) Numerical calculations B) Page design only C) File protection only D) Printing only
Answer: A
🔹 2461–2500: Templates, File Protection & Printing
2461. An Excel template provides:
A) Predefined workbook structure/design B) Antivirus C) Operating system D) Printer driver
Answer: A
2462. A template can contain:
A) Formatting B) Formulas C) Layout D) All of these
Answer: D
2463. Templates are useful for:
A) Repeatedly creating similar workbooks B) Replacing CPU C) Installing printers D) Network configuration
Answer: A
2464. A template file commonly uses:
A) .xltx B) .docx C) .pptx D) .txt
Answer: A
2465. A macro-enabled Excel template commonly uses:
A) .xltm B) .docm C) .pptm D) .xlsx
Answer: A
2466. A standard modern Excel workbook commonly uses:
A) .xlsx B) .docx C) .pptx D) .txt
Answer: A
2467. A macro-enabled Excel workbook commonly uses:
A) .xlsm B) .xlsx C) .docm D) .pptm
Answer: A
2468. A template can save:
A) Time and effort B) CPU permanently C) Printer ink automatically D) Internet bandwidth
Answer: A
2469. File protection can help:
A) Restrict unwanted changes/access B) Increase RAM C) Improve printer speed D) Change CPU
Answer: A
2470. Protect Sheet is used to:
A) Restrict changes to worksheet content/settings B) Delete worksheet C) Print sheet D) Create chart
Answer: A
2471. Protect Workbook can help protect:
A) Workbook structure B) Printer C) CPU D) Monitor
Answer: A
2472. Workbook protection can restrict:
A) Structural changes such as adding/deleting sheets depending on settings B) Font size only C) Printing only D) Chart creation only
Answer: A
2473. A password can be used with:
A) Protection features B) Font formatting C) Charts only D) Cell formulas only
Answer: A
2474. Protection is primarily intended to:
A) Prevent or restrict unauthorized changes B) Increase calculation speed C) Increase storage D) Improve display resolution
Answer: A
2475. Protect Sheet does not necessarily mean:
A) Entire file is encrypted B) Editing can be restricted C) Certain actions can be blocked D) Worksheet can be protected
Answer: A
2476. File-level password protection can help:
A) Restrict access to a workbook B) Change chart type C) Increase font size D) Create PivotTable
Answer: A
2477. Protection settings should be used:
A) According to security requirements B) Randomly C) Only for printing D) Only for charts
Answer: A
2478. A protected worksheet may still allow:
A) Selected permitted actions B) No actions under every configuration C) Only printing D) Only closing
Answer: A
2479. Excel printing allows selection of:
A) Printer B) Copies C) Pages D) All of these
Answer: D
2480. Print Preview is used to:
A) Check appearance before printing B) Create formulas C) Protect workbook D) Create templates
Answer: A
2481. Page Orientation can be:
A) Portrait or Landscape B) Square only C) Circular D) Diagonal
Answer: A
2482. Margins control:
A) Blank space around printed content B) Font color C) Formula result D) Cell value
Answer: A
2483. Print Area specifies:
A) Cells/range to print B) Printer password C) Workbook name D) Font
Answer: A
2484. Set Print Area is useful when:
A) Only part of a worksheet needs printing B) Entire computer must print C) Workbook is protected D) Chart is deleted
Answer: A
2485. Page Break Preview helps:
A) See page boundaries for printing B) Edit formulas C) Protect file D) Create PivotTables
Answer: A
2486. Scaling controls:
A) Size of worksheet content on printed pages B) Cell value C) Formula result D) File name
Answer: A
2487. Fit Sheet on One Page attempts to:
A) Scale worksheet to one page B) Delete rows C) Delete columns D) Protect workbook
Answer: A
2488. Header and Footer can appear on:
A) Printed pages B) Cells only C) Formulas only D) PivotTables only
Answer: A
2489. Page numbers can be inserted in:
A) Headers/footers B) Formulas only C) Cell comments only D) Charts only
Answer: A
2490. Repeat Rows at Top is useful when:
A) Printing multiple pages of data B) Creating formulas C) Protecting files D) Creating templates
Answer: A
2491. Repeat Columns at Left is useful when:
A) Printing wide data across multiple pages B) Formatting cells C) Creating charts D) Creating formulas
Answer: A
2492. Gridlines can be printed:
A) Depending on print settings B) Never C) Only in Word D) Only in PowerPoint
Answer: A
2493. Row and column headings can be printed:
A) Depending on print settings B) Never C) Only as charts D) Only in PDF
Answer: A
2494. Print Titles help repeat:
A) Selected rows/columns on printed pages B) Workbook passwords C) Formulas D) Charts
Answer: A
2495. Collate is useful when printing:
A) Multiple copies of multi-page documents B) One cell C) One formula D) One chart
Answer: A
2496. Excel worksheets can be printed:
A) Yes B) No C) Only as images D) Only after conversion to Word
Answer: A
2497. Excel charts can be printed:
A) Yes B) No C) Only in PowerPoint D) Only as text
Answer: A
2498. Templates, file protection and printing are:
A) Included in the official Excel syllabus B) Not related to Excel C) PowerPoint-only topics D) Windows-only topics
Answer: A
2499. Part 5 covers Excel topics specified in the official TGPRB technical syllabus.
A) True B) False
Answer: A
2500. The next part after Excel is:
A) Part 6 — PowerPoint + Access + Networking & Security B) Hardware C) MS Word D) DOS
Answer: A
🎯 Part 5 — Most Important Excel Topics for Revision
⭐ Very high-priority
Cell formatting
Rows & columns
Cell references
Relative/absolute/mixed references
Formulas
SUM
AVERAGE
MAX
MIN
COUNT
COUNTA
IF
SUMIF
COUNTIF
Charts
Column/Bar/Pie/Line charts
Data sorting
Data filtering
Excel database concepts
PivotTables
PivotTable fields
PivotTable calculations
Slicers
Data Validation
Drop-down lists
Conditional Formatting
Templates
Protect Sheet
Protect Workbook
Printing/Print Preview
Print Area
Page orientation
Margins
Scaling
Repeat rows/columns