Q. 1
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Which program is used to manage expenses, budgets and financial analysis?
💡
Step-by-Step Explanation & Concept Rationale
Spreadsheets are the primary tool for numerical data management and financial modeling.
Q. 2
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Which of the following is spreadsheet software?
💡
Step-by-Step Explanation & Concept Rationale
Microsoft Excel is the industry-standard application for creating and managing spreadsheets.
Q. 3
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Which of the following is NOT an element of Excel interface?
💡
Step-by-Step Explanation & Concept Rationale
The Start button is a Windows OS element, not part of the internal Excel application window.
Q. 4
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Tabs, groups and commands make up the:
💡
Step-by-Step Explanation & Concept Rationale
The Ribbon is the primary navigation area at the top of the screen containing all commands.
Q. 5
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Which of the following is used to display similar groups of items on the Ribbon?
💡
Step-by-Step Explanation & Concept Rationale
Tabs categorize related groups of commands (e.g., Home, Insert, Formulas).
Q. 6
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
The title bar in Excel displays the name of:
💡
Step-by-Step Explanation & Concept Rationale
The title bar identifies the specific file (workbook) currently open in the application.
Q. 7
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Frequently used commands such as Save, Undo, and Redo appear on:
💡
Step-by-Step Explanation & Concept Rationale
This toolbar provides one-click access to the most common user actions.
Q. 8
Computer Aptitude Test
Difficulty: Hard
(1 Mark)
A workbook is a group of:
💡
Step-by-Step Explanation & Concept Rationale
An Excel file (workbook) contains one or more individual spreadsheets (worksheets).
Q. 9
Computer Aptitude Test
Difficulty: Hard
(1 Mark)
A workbook with 6 worksheets would be saved as _____ file(s):
💡
Step-by-Step Explanation & Concept Rationale
Regardless of the number of sheets inside, a workbook is saved as a single unified file.
Q. 10
Computer Aptitude Test
Difficulty: Hard
(1 Mark)
A worksheet in Excel is divided into:
💡
Step-by-Step Explanation & Concept Rationale
The grid structure of a worksheet is formed by vertical columns and horizontal rows.
Q. 11
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
The column headings in the spreadsheet are identified by:
💡
Step-by-Step Explanation & Concept Rationale
Columns are labeled with letters (A, B, C...) starting from the left.
Q. 12
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
The row headings in a spreadsheet are identified by:
💡
Step-by-Step Explanation & Concept Rationale
Rows are labeled with sequential integers starting from 1.
Q. 13
Computer Aptitude Test
Difficulty: Hard
(1 Mark)
The name of worksheet in Excel appears on:
💡
Step-by-Step Explanation & Concept Rationale
Individual worksheet names are displayed on tabs at the bottom of the workbook window.
Q. 14
Computer Aptitude Test
Difficulty: Hard
(1 Mark)
The default name of first worksheet in a workbook is:
💡
Step-by-Step Explanation & Concept Rationale
Excel automatically names new sheets sequentially as Sheet 1, Sheet 2, etc.
Q. 15
Computer Aptitude Test
Difficulty: Hard
(1 Mark)
What is the basic unit of a worksheet in which a user enters data?
💡
Step-by-Step Explanation & Concept Rationale
A cell is the intersection of a row and a column where data is stored.
Q. 16
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Which of the following is a correct cell address?
💡
Step-by-Step Explanation & Concept Rationale
A cell address combines the column letter with the row number (e.g., C5).
Q. 17
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
The data in a cell can be edited using:
💡
Step-by-Step Explanation & Concept Rationale
The formula bar allows users to view and modify the content of the active cell.
Q. 18
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
The default border color of selected cell is:
💡
Step-by-Step Explanation & Concept Rationale
By default, Excel highlights the active cell with a distinct black outline.
Q. 19
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Which of the following displays the cell address or name of the selected cell?
💡
Step-by-Step Explanation & Concept Rationale
The Name box shows the coordinates (like A1) of the currently selected cell.
Q. 20
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
To make a cell active, you _______ it:
💡
Step-by-Step Explanation & Concept Rationale
Simply clicking on a cell makes it the "active" cell ready for input.
Q. 21
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
_______ displays the contents of active cell and the formula as user type them:
💡
Step-by-Step Explanation & Concept Rationale
The formula bar serves as a mirror for active cell input and complex formulas.
Q. 22
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
_______ can be one cell or a group of cells:
💡
Step-by-Step Explanation & Concept Rationale
A range refers to a specific selection of one or more adjacent cells.
Q. 23
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
The _______ is found in the bottom right hand corner of an active cell:
💡
Step-by-Step Explanation & Concept Rationale
The small square used for AutoFill is called the fill handle.
Q. 24
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Which of the following key to select nonadjacent cells?
💡
Step-by-Step Explanation & Concept Rationale
Holding the Ctrl key allows the user to select multiple individual cells across the sheet.
Q. 25
Computer Aptitude Test
Difficulty: Medium
(1 Mark)
Which of the following key is used to select adjacent cells?
💡
Step-by-Step Explanation & Concept Rationale
Holding Shift while using arrow keys or clicking selects a continuous block of cells.
Study Stream Progress:
Showing 25 of 148 Questions (17%)
Jump to:
Ready to Test Your Retention & Speed?
Now that you have reviewed the study questions and rationales, test yourself in our interactive 1-by-1 practice engine or take the full official timed mock exam.