Home/ECAT/ECAT Computer Science Spreadsheet Software Test Online

ECAT Computer Science Spreadsheet Software Test Online

Mustansar KhanLast Updated: May 1, 2025

ECAT Computer Science Spreadsheet Software Test

ECAT Computer Science Chapter 9 Spreadsheet Software Online Test

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

ECAT Spreadsheet Software Test Online MCQs

Please wait...

Page 1 of 2

Uncategorized

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

Press Enter on the sheet

Click the Start button

Double-click the sheet tab

Use the Insert tab

2. Which feature is used to highlight duplicate values?

Sort

Wrap Text

Conditional Formatting

AutoCorrect

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

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

Its font size

A column only

A row only

A combination of row and column

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

AutoFill

Sort

Cell Merge

Alignment

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

Format Cells

Protect Sheet

Page Layout

View Tab

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

Sort

Format Painter

Group

Filter

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

Bar chart

Column chart

Pie chart

Line chart

9. What does the AutoSum button do?

Deletes rows

Inserts a chart

Merges cells

Adds selected values

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

Currency

Text

Number

General

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

Insert → Table

Home → Format

Data → Filter

View → Freeze Panes

12. How can you insert multiple rows at once?

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

Use the Format Painter

Press Ctrl + P

Use the Insert tab and select “Insert Table”

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

Normal View

Zoom View

Draft View

Page Layout

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

=IF()

=COUNT()

=AVERAGE()

=SUM()

15. Which Excel function returns the current date?

=TODAY()

=TIME()

=DATE()

=NOW()

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

17. What does the Wrap Text feature do?

Displays text in multiple lines within a cell

Deletes text

Adjusts font style

Fills the cell with color

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

=AVERAGE()

=SUM()

=AVG()

=COUNT()

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

=COUNT()

=ROUND()

=MAX()

=SUM()

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

.docx

.pptx

.xlsx

.xlsm

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

=AVERAGE()

=MAX()

=MIN()

=SUM()

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

Today's date

The current date and time

The year only

Total of values

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

=FLOOR()

=INT()

=CEILING()

=ROUND()

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

Field

Cell

Table

Box

25. Which function is used to apply a condition?

=SUM()

=ROUND()

=MAX()

=IF()

Page 2 of 2

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

View → Print

File → Save As → Choose PDF

Insert → Export

Data → Convert

27. What is a cell range?

A single cell

The total number of rows

A column title

A group of selected cells

28. What is the formula bar used for?

Printing documents

Entering or editing formulas

Hiding rows

Formatting cells

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

=COUNT()

=MAX()

=SUM()

=MIN()

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

=COUNTBLANK()

=COUNT()

=IF()

=COUNTA()

31. What is a function in Excel?

A tool to draw shapes

A worksheet name

A built-in formula

A password

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

Adds values from cells A1 to A5

Multiplies values in A1 to A5

Divides all numbers in A1 to A5

Shows the maximum value

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

#NUM!

######

#DIV/0!

#REF!

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

Ctrl + N

Ctrl + O

Ctrl + S

Ctrl + W

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

Ctrl

Shift

Tab

Enter

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

65,536

100,000

256,000

1,048,576

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

Right

Center

Justified

Left

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

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

Data → Filter

Insert → Symbol

View → Zoom

File → Save As

40. What does the Merge & Center feature do?

Adds formulas

Deletes rows

Combines cells and centers text

Copies content

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

$A$2

A$1

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

View

Home

Page Layout

Insert

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

MS Word

Adobe Photoshop

MS Access

MS Excel

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

Format → Hide

Insert → Header

View → Zoom

Data → Sort

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

=COUNT()

=COUNTBLANK()

=COUNTIF()

=COUNTA()

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

Format Cells

Cut and Paste

Copy and Paste

Delete

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

Insert tab

Data tab

Page Layout

Home tab

48. What does the Fill Handle do?

Clears formatting

Deletes data

Copies formulas or values to adjacent cells

Applies filters

49. What does cell reference A$1 mean?

Absolute reference

Dynamic reference

Relative reference

Mixed reference

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

UET Peshawar Entry Test 2025 Registration Online ETEA Test D...
ECAT Statistics Test Set 17
ECAT Statistics Test Set 16
ECAT Statistics Test Set 15
ECAT Statistics Test Set 14
ECAT Statistics Test Set 13
ECAT Statistics Test Set 12
ECAT Statistics Test Set 11
ECAT Statistics Test Set 10
ECAT Statistics Test Set 9

Mustansar KhanLast Updated: May 1, 2025

Facebook Twitter Reddit WhatsApp Share via Email Print

ECAT Computer Science Spreadsheet Software Test Online

ECAT Computer Science Spreadsheet Software Test

ECAT Computer Science Chapter 9 Spreadsheet Software Online Test

ECAT Spreadsheet Software Test Online MCQs

Uncategorized

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply