Home/Computer/Computer Spreadsheet Software Test Online

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 Excel function returns the current date?

=TIME()

=NOW()

=TODAY()

=DATE()

2. What is the formula bar used for?

Entering or editing formulas

Printing documents

Formatting cells

Hiding rows

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

=COUNT()

=IF()

=SUM()

=AVERAGE()

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

Tab

Ctrl

Enter

Shift

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

Insert

Page Layout

Home

View

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

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

=SUM()

=COUNT()

=MIN()

=MAX()

8. What does the Fill Handle do?

Clears formatting

Applies filters

Deletes data

Copies formulas or values to adjacent cells

9. What does the AutoSum button do?

Inserts a chart

Adds selected values

Deletes rows

Merges cells

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

Home tab

Page Layout

Data tab

Insert tab

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

MS Excel

Adobe Photoshop

MS Word

MS Access

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

=AVG()

=COUNT()

=AVERAGE()

=SUM()

13. What is a function in Excel?

A worksheet name

A built-in formula

A tool to draw shapes

A password

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

=COUNTBLANK()

=COUNTA()

=COUNTIF()

=COUNT()

15. Which function is used to apply a condition?

=SUM()

=ROUND()

=IF()

=MAX()

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

Field

Box

Table

Cell

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

Ctrl + N

Ctrl + O

Ctrl + W

Ctrl + S

18. What does cell reference A$1 mean?

Relative reference

Dynamic reference

Mixed reference

Absolute reference

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

1,048,576

65,536

256,000

100,000

20. How can you insert multiple rows at once?

Use the Insert tab and select “Insert Table”

Press Ctrl + P

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

Use the Format Painter

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

View → Zoom

Data → Filter

File → Save As

Insert → Symbol

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

Filter

Sort

Format Painter

Group

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

AutoFill

Sort

Cell Merge

Alignment

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

Use the Insert tab

Double-click the sheet tab

Click the Start button

Press Enter on the sheet

25. What does the Wrap Text feature do?

Deletes text

Fills the cell with color

Displays text in multiple lines within a cell

Adjusts font style

Page 2 of 2

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

A$1

$A$2

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

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

Format Cells

Cut and Paste

Copy and Paste

Delete

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

=COUNTBLANK()

=IF()

=COUNT()

=COUNTA()

30. What does the Merge & Center feature do?

Adds formulas

Combines cells and centers text

Copies content

Deletes rows

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

Zoom View

Page Layout

Draft View

Normal View

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

Pie chart

Line chart

Column chart

Bar chart

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

Protect Sheet

View Tab

Page Layout

Format Cells

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

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

=AVERAGE()

=SUM()

=MAX()

=MIN()

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

Insert → Export

Data → Convert

File → Save As → Choose PDF

View → Print

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

General

Text

Number

Currency

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

=ROUND()

=INT()

=CEILING()

=FLOOR()

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

Center

Left

Justified

Right

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

=SUM()

=ROUND()

=COUNT()

=MAX()

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

The year only

Total of values

The current date and time

Today's date

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

View → Zoom

Format → Hide

Data → Sort

Insert → Header

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

Adds values from cells A1 to A5

Divides all numbers in A1 to A5

Shows the maximum value

Multiplies values in A1 to A5

44. What is a cell range?

A column title

The total number of rows

A single cell

A group of selected cells

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

A column only

A combination of row and column

A row only

Its font size

46. Which feature is used to highlight duplicate values?

Wrap Text

AutoCorrect

Sort

Conditional Formatting

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

######

#DIV/0!

#REF!

#NUM!

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

.xlsm

.docx

.pptx

.xlsx

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

Home → Format

Data → Filter

View → Freeze Panes

Insert → Table

You Can Learn and Gain more Knowledge through our Online Quiz and Testing system Just Search your desired Preparation subject at Gotest.

Introduction to Computers Online Test
Computer File Handling in “C” Test Online
Computer Functions in “C” Test Online
Computer Loop Constructs Test Online
Computer Decision Constructs Test Online
Computer Input Output Test Online
Computer Elements of “C” Test Online
Computer Getting Started with “C” Test Online
Computer Microsoft Access-Forms and Reports Test Online
Computer Table and Query Test Online

Mustansar KhanLast Updated: October 15, 2025

Computer Spreadsheet Software Test Online

Important Computer Spreadsheet Software Question and Answer

Spreadsheet Software Practice Test Online With Explanation

Uncategorized

Related Posts

Mustansar Khan

Leave a Reply Cancel reply