Computer Spreadsheet Software Test Online

Mustansar KhanLast Updated: October 15, 2025

Important Computer Spreadsheet Software Question and Answer

Total Questions:	49
Time Allowed:	25 Minutes
Total Marks:	49
How to Attempt Test:	Please choose the right Option in MCQ-type question.
Test Helpful For:	ECAT Entry Test Computer Online Test Interview Questions about Computer All Universities Entrance Test Recruitments Tests

Spreadsheet Software Practice Test Online With Explanation

Please wait...

Page 1 of 2

Uncategorized

1. Which of the following is not a valid cell reference?

A$1

$A$2

2. In a spreadsheet, a cell is identified by:

A row only

A combination of row and column

A column only

Its font size

3. What is a function in Excel?

A built-in formula

A password

A worksheet name

A tool to draw shapes

4. Which function is used to calculate the average of values?

=SUM()

=COUNT()

=AVG()

=AVERAGE()

5. What does the Wrap Text feature do?

Displays text in multiple lines within a cell

Adjusts font style

Deletes text

Fills the cell with color

6. Which of the following is used to move data from one cell to another?

Delete

Cut and Paste

Copy and Paste

Format Cells

7. Which key is used to move to the next cell on the right?

Enter

Shift

Tab

Ctrl

8. Which of the following is an example of spreadsheet software?

Adobe Photoshop

MS Excel

MS Access

MS Word

9. Which of the following is used to insert charts in Excel?

Page Layout

Data tab

Home tab

Insert tab

10. Which function is used to count non-empty cells?

=COUNTBLANK()

=COUNT()

=COUNTA()

=COUNTIF()

11. Which function counts the number of numeric values in a range?

=AVERAGE()

=IF()

=SUM()

=COUNT()

12. What does the AutoSum button do?

Deletes rows

Adds selected values

Merges cells

Inserts a chart

13. Which tool is used to arrange data in ascending or descending order?

Format Painter

Filter

Group

Sort

14. What is the default file extension of an Excel workbook?

.docx

.xlsx

.xlsm

.pptx

15. Which function is used to apply a condition?

=MAX()

=ROUND()

=IF()

=SUM()

16. Which of the following can you use to protect a worksheet?

Page Layout

View Tab

Protect Sheet

Format Cells

17. Which tab in Excel contains the basic formatting tools?

Insert

Page Layout

View

Home

18. Which function is used to round a number up?

=ROUND()

=CEILING()

=INT()

=FLOOR()

19. Which symbol is used to lock a cell reference in a formula?

20. Which Excel function returns the current date?

=TIME()

=NOW()

=TODAY()

=DATE()

21. Which function returns the smallest number in a range?

=MAX()

=MIN()

=SUM()

=AVERAGE()

22. Which chart is best used to show parts of a whole?

Pie chart

Column chart

Bar chart

Line chart

23. How many worksheets are there in a new Excel workbook by default?

24. What is a cell range?

A group of selected cells

A column title

A single cell

The total number of rows

25. Which feature lets you fill a series (like 1, 2, 3...) automatically?

Alignment

AutoFill

Sort

Cell Merge

Page 2 of 2

26. Which Excel function returns the number of blank cells in a range?

=COUNT()

=COUNTA()

=COUNTBLANK()

=IF()

27. What is the maximum number of rows in a single Excel worksheet (Excel 2016 and later)?

256,000

1,048,576

65,536

100,000

28. What does the Merge & Center feature do?

Combines cells and centers text

Adds formulas

Deletes rows

Copies content

29. What does the function =NOW() return?

The year only

Today's date

The current date and time

Total of values

30. Which function returns the highest value in a range?

=SUM()

=COUNT()

=MAX()

=MIN()

31. How can you insert multiple rows at once?

Use the Format Painter

Use the Insert tab and select “Insert Table”

Press Ctrl + P

Right-click and select "Insert" after selecting multiple rows

32. Which error is displayed when a number is too large to fit in a cell?

#NUM!

#REF!

#DIV/0!

######

33. What is the intersection of a row and a column called?

Cell

Field

Box

Table

34. What does the function =SUM(A1:A5) do?

Shows the maximum value

Adds values from cells A1 to A5

Multiplies values in A1 to A5

Divides all numbers in A1 to A5

35. Which of the following allows filtering data based on conditions?

View → Zoom

File → Save As

Data → Filter

Insert → Symbol

36. What does the Fill Handle do?

Clears formatting

Applies filters

Copies formulas or values to adjacent cells

Deletes data

37. Which of these options lets you export an Excel file to PDF?

View → Print

File → Save As → Choose PDF

Insert → Export

Data → Convert

38. Which of the following is used to freeze rows or columns?

Home → Format

Data → Filter

Insert → Table

View → Freeze Panes

39. What is the formula bar used for?

Formatting cells

Printing documents

Hiding rows

Entering or editing formulas

40. What is the default number format in Excel cells?

Number

General

Text

Currency

41. What does cell reference A$1 mean?

Absolute reference

Dynamic reference

Relative reference

Mixed reference

42. Which of the following symbols is used to begin a formula in Excel?

43. Which of the following Excel views shows how the sheet will look when printed?

Draft View

Zoom View

Page Layout

Normal View

44. Which feature is used to highlight duplicate values?

Wrap Text

AutoCorrect

Conditional Formatting

Sort

45. What is the shortcut key to create a new workbook in Excel?

Ctrl + W

Ctrl + O

Ctrl + S

Ctrl + N

46. What is the default alignment of text in a cell?

Right

Left

Justified

Center

47. Which of the following lets you hide rows or columns?

View → Zoom

Format → Hide

Insert → Header

Data → Sort

48. Which function is used to round off decimal numbers?

=SUM()

=ROUND()

=MAX()

=COUNT()

49. Which of these is used to rename a worksheet?

Double-click the sheet tab

Press Enter on the sheet

Click the Start button

Use the Insert tab

More Related Resources

Best Computer Courses List in Pakis... NTS NAT & GAT Computer Science... FBISE 9th Class Computer Chapter 3 ... KPK 9th Class Computer Chapter 3 Of... 9th Class Computer: chapter 2 Compu... FBR Test Preparation 2026 Online (I... Scope of ICS in Pakistan Job Opport...

Can't find what you're looking for? Search below:

Latest Updates

Best Computer Courses List in Pakistan
NTS NAT & GAT Computer Science MCQs (Solved Past Papers)
FBR Test Preparation 2026 Online (Inspector, Sub-Inspector, Sepoy...
Scope of ICS in Pakistan Job Opportunities Salary and Best Fields

Mustansar KhanLast Updated: October 15, 2025

Important Computer Spreadsheet Software Question and Answer

Spreadsheet Software Practice Test Online With Explanation

Uncategorized

More Related Resources

Latest Updates

Mustansar Khan

Leave a Reply Cancel reply