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

=DATE()

=TODAY()

=NOW()

=TIME()

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

=COUNTIF()

=COUNTBLANK()

=COUNT()

=COUNTA()

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

Group

Filter

Format Painter

Sort

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

A column only

A combination of row and column

Its font size

A row only

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

Table

Box

Cell

Field

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

File → Save As → Choose PDF

View → Print

Data → Convert

Insert → Export

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

Ctrl

Tab

Enter

Shift

8. Which function is used to apply a condition?

=MAX()

=SUM()

=IF()

=ROUND()

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

Insert

Home

View

Page Layout

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

Zoom View

Draft View

Page Layout

Normal View

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

Number

General

Text

Currency

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

.xlsx

.docx

.pptx

.xlsm

13. What is a cell range?

A group of selected cells

The total number of rows

A column title

A single cell

14. What does cell reference A$1 mean?

Mixed reference

Relative reference

Absolute reference

Dynamic reference

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

Copy and Paste

Format Cells

Delete

Cut and Paste

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

View → Zoom

File → Save As

Insert → Symbol

Data → Filter

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

=ROUND()

=INT()

=CEILING()

=FLOOR()

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

65,536

1,048,576

100,000

256,000

19. What is the formula bar used for?

Hiding rows

Formatting cells

Entering or editing formulas

Printing documents

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

Sort

AutoFill

Alignment

Cell Merge

21. What does the Wrap Text feature do?

Deletes text

Adjusts font style

Displays text in multiple lines within a cell

Fills the cell with color

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

Click the Start button

Double-click the sheet tab

Use the Insert tab

Press Enter on the sheet

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

=COUNT()

=IF()

=COUNTBLANK()

=COUNTA()

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

=AVERAGE()

=MAX()

=SUM()

=MIN()

25. How can you insert multiple rows at once?

Press Ctrl + P

Use the Insert tab and select “Insert Table”

Use the Format Painter

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

Page 2 of 2

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

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

Ctrl + O

Ctrl + N

Ctrl + W

Ctrl + S

28. Which feature is used to highlight duplicate values?

AutoCorrect

Conditional Formatting

Wrap Text

Sort

29. What does the Merge & Center feature do?

Copies content

Combines cells and centers text

Adds formulas

Deletes rows

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

######

#NUM!

#DIV/0!

#REF!

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

=AVERAGE()

=IF()

=SUM()

=COUNT()

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

Insert → Header

Data → Sort

Format → Hide

View → Zoom

33. What does the Fill Handle do?

Applies filters

Copies formulas or values to adjacent cells

Deletes data

Clears formatting

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

=MIN()

=SUM()

=MAX()

=COUNT()

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

Right

Justified

Center

Left

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

MS Word

MS Access

Adobe Photoshop

MS Excel

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

Today's date

The year only

Total of values

The current date and time

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

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

$A$2

A$1

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

41. What does the AutoSum button do?

Adds selected values

Inserts a chart

Deletes rows

Merges cells

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

Protect Sheet

Format Cells

View Tab

Page Layout

43. What is a function in Excel?

A built-in formula

A worksheet name

A password

A tool to draw shapes

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

Home → Format

View → Freeze Panes

Insert → Table

Data → Filter

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

Multiplies values in A1 to A5

Divides all numbers in A1 to A5

Shows the maximum value

Adds values from cells A1 to A5

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

=SUM()

=COUNT()

=ROUND()

=MAX()

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

Home tab

Insert tab

Page Layout

Data tab

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

Column chart

Pie chart

Bar chart

Line chart

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

=COUNT()

=SUM()

=AVG()

=AVERAGE()

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

UET Lahore Combined Entry Test 2025 ECAT Schedule…
UET Lahore, Taxila ECAT Chemistry Entry Test Online…
NED-Karachi ECAT Maths Entry Test Online Preparation
UET Lahore, Taxila ECAT Physics Entry Test Online…
NED-Karachi ECAT Physics Entry Test Online Preparation
NED-Karachi ECAT Chemistry Entry Test Online Preparation
Mehran University Sindh ECAT Physics Entry Test…
UET Lahore, Taxila ECAT Computer Science Entry Test…

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

Related:

You Might Also Like

Mustansar Khan

Leave a Reply Cancel reply