• A) Charles Babbage
• B) Alan Turing
• C) Konrad Zuse
• D) John von Neumann

• A) Ballistic calculations
• B) Code-breaking
• C) Weather forecasting
• D) Nuclear simulations

• A) 1945
• B) 1947
• C) 1948
• D) 1950

• A) UNIVAC I
• B) ENIAC
• C) IBM 701
• D) Ferranti Mark 1

• A) Jean Bartik
• B) Margaret Hamilton
• C) Grace Hopper
• D) Ada Lovelace

• A) IBM
• B) Intel
• C) Texas Instruments
• D) AMD

• A) Mosaic
• B) WorldWideWeb
• C) Netscape Navigator
• D) Internet Explorer

• A) Python
• B) HTML
• C) JavaScript
• D) C++

• A) IBM PC
• B) Osborne 1
• C) Apple Macintosh
• D) Compaq Portable

• A) MS-DOS
• B) Unix
• C) IBM System/360
• D) Windows NT

• A) Opens the print dialog box
• B) Captures a screenshot
• C) Prints the current document
• D) Opens the screen resolution settings

• A) Task Manager
• B) Control Panel
• C) MSConfig
• D) Services

• A) 8 characters
• B) 12 characters
• C) 16 characters
• D) 20 characters

• A) 1982
• B) 1983
• C) 1984
• D) 1985

• A) FAT32
• B) exFAT
• C) NTFS
• D) ReFS

• A) Win + Pause/Break
• B) Ctrl + Esc
• C) Alt + Enter
• D) Shift + F10

• A) Win + X
• B) Ctrl + Shift + Esc
• C) Appwiz.cpl
• D) Win + R

• A) Win + D
• B) Ctrl + D
• C) Win + X, M
• D) Devmgmt.msc

• A) Win + L
• B) Ncpa.cpl
• C) Ctrl + N
• D) Win + N

• A) Align
• B) Group
• C) Gridlines
• D) Arrange

• A) Limit file size
• B) Control formatting
• C) Restrict access to specific sections
• D) Prevent unauthorized changes

• A) Press Ctrl + Shift + 8
• B) Press Alt + F9
• C) Press Ctrl + * (asterisk)
• D) Press Alt + Shift + H

• A) Ctrl + N
• B) Ctrl + O
• C) Ctrl + Shift + N
• D) Ctrl + Alt + N

• A) Use the 'References' tab
• B) Use the 'Home' tab
• C) Use the 'Insert' tab
• D) Use the 'Review' tab

• A) SUM
• B) SUMIFS
• C) SUBTOTAL
• D) SUMPRODUCT

• A) Use the 'Sort' feature
• B) Use the 'Filter' feature
• C) Use the 'Remove Duplicates' feature
• D) Use the 'Conditional Formatting' feature

• A) AVERAGE
• B) AVERAGEIF
• C) SUMIF
• D) AVERAGEA

• A) Use the 'Text' function
• B) Use the 'Format Cells' dialog box
• C) Use the 'Number Format' dropdown
• D) Use the 'Conditional Formatting' feature

• A) Find the maximum value in a range
• B) Find the minimum value in a range
• C) Search for a value in a table and return a corresponding value in the same row
• D) Sum the values in a column

• A) Macros
• B) Filters
• C) Data Validation
• D) Pivot Tables

• A) Use the 'Data' tab
• B) Use the 'Formulas' tab
• C) Use the 'Insert' tab
• D) Use the 'Analyze' tab

• A) COUNT
• B) COUNTA
• C) COUNTIF
• D) COUNTIFS

• A) To format text based on specific conditions
• B) To apply custom styles to cells
• C) To automatically format cells based on their values
• D) To highlight cells that meet certain criteria

• A) Use the 'Lock' feature
• B) Use the 'Encrypt' feature
• C) Use the 'Protect Sheet' feature
• D) Use the 'Hide' feature

• A) MAX
• B) LARGE
• C) MAXA
• D) HLOOKUP

• A) Use the 'Merge & Center' feature
• B) Use the 'Merge Across' feature
• C) Use the 'Concatenate' function
• D) Use the 'Flash Fill' feature

• A) Themes
• B) Styles
• C) Conditional Formatting
• D) Cell Styles

• A) To format cells
• B) To apply formulas
• C) To create a drop-down list
• D) To restrict the type of data that can be entered into a cell

• A) Use the 'Sort' feature
• B) Use the 'Filter' feature
• C) Use the 'Group' feature
• D) Use the 'Conditional Formatting' feature

• A) JOIN
• B) CONCAT
• C) CONCATENATE
• D) TEXTJOIN

• A) To format cells
• B) To automatically fill in values based on a pattern
• C) To apply conditional formatting
• D) To create a pivot table

• A) Use the 'Insert' tab
• B) Use the 'Formulas' tab
• C) Use the 'Data Validation' feature
• D) Use the 'Review' tab

• A) CUMIPMT
• B) PV
• C) FV
• D) NPER

• A) Use the 'Show Formulas' button in the 'Formulas' tab
• B) Press Ctrl + ` (grave accent)
• C) Press Ctrl + Shift + ` (grave accent)
• D) Use the 'Formula Auditing' feature

• A) To integrate multiple tables and create relationships between them
• B) To format data
• C) To apply conditional formatting
• D) To create a pivot chart

• A) Use the 'Sort' feature in the 'Data' tab
• B) Use the 'Filter' feature in the 'Data' tab
• C) Use the 'Conditional Formatting' feature
• D) Use the 'Custom Sort' option in the 'Sort' dialog box

• A) To create pivot tables
• B) To apply conditional formatting
• C) To analyze different scenarios of a model
• D) To protect worksheet data

• A) Use the 'Design' tab
• B) Use the 'Chart Styles' option in the 'Design' tab
• C) Use the 'Format' tab
• D) Use the 'Insert' tab

• A) Consolidate
• B) Pivot Table
• C) Data Table
• D) Group

• A) To monitor changes in a cell
• B) To view the values of cells from different worksheets
• C) To audit formulas
• D) To create pivot charts

• A) Filter
• B) Conditional Formatting
• C) Remove Duplicates
• D) Data Validation

• A) Use the 'Format Painter'
• B) Use 'Conditional Formatting'
• C) Use a 'Custom Rule' in 'Conditional Formatting'
• D) Use 'Data Validation'

• A) To create pivot tables
• B) To find the input value needed to achieve a specific goal
• C) To sort data
• D) To apply conditional formatting

• A) DATE
• B) TIME
• C) NOW
• D) TODAY

• A) Use a Pivot Chart
• B) Use a Named Range
• C) Use a Table
• D) Use the 'Refresh' option

• A) PV
• B) PMT
• C) FV
• D) NPV

• A) Use 'Conditional Formatting'
• B) Use 'Go To Special' feature
• C) Use 'Data Validation'
• D) Use 'Filter' feature

• A) To calculate totals for selected cells
• B) To apply custom formatting
• C) To create a summary table
• D) To calculate subtotals and totals in a list or database

• A) Use 'Text to Columns' feature
• B) Use 'Flash Fill'
• C) Use 'Concatenate' function
• D) Use 'Text to Columns' feature in the 'Data' tab

• A) Pivot Table
• B) Interactive Chart
• C) Data Validation
• D) Dynamic Chart