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 error is displayed when a number is too large to fit in a cell?

######

#DIV/0!

#REF!

#NUM!

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

=SUM()

=ROUND()

=MAX()

=COUNT()

3. What does the Wrap Text feature do?

Adjusts font style

Deletes text

Fills the cell with color

Displays text in multiple lines within a cell

4. What is a cell range?

A column title

The total number of rows

A single cell

A group of selected cells

5. Which function is used to apply a condition?

=ROUND()

=SUM()

=IF()

=MAX()

6. What does the Merge & Center feature do?

Combines cells and centers text

Adds formulas

Deletes rows

Copies content

7. How can you insert multiple rows at once?

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

Use the Insert tab and select “Insert Table”

Use the Format Painter

Press Ctrl + P

8. Which Excel function returns the current date?

=TODAY()

=TIME()

=DATE()

=NOW()

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

Cut and Paste

Delete

Format Cells

Copy and Paste

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

Data → Convert

Insert → Export

File → Save As → Choose PDF

View → Print

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

=MIN()

=SUM()

=MAX()

=COUNT()

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

Home

View

Page Layout

Insert

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

Enter

Shift

Ctrl

Tab

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

The current date and time

Today's date

Total of values

The year only

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

View → Zoom

File → Save As

Data → Filter

Insert → Symbol

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

Use the Insert tab

Click the Start button

Press Enter on the sheet

Double-click the sheet tab

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

.docx

.xlsm

.pptx

.xlsx

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

=COUNT()

=COUNTA()

=COUNTIF()

=COUNTBLANK()

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

View Tab

Protect Sheet

Format Cells

Page Layout

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

A combination of row and column

Its font size

A column only

A row only

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

Ctrl + O

Ctrl + N

Ctrl + S

Ctrl + W

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

Adds values from cells A1 to A5

Shows the maximum value

Multiplies values in A1 to A5

Divides all numbers in A1 to A5

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

Data → Sort

View → Zoom

Format → Hide

Insert → Header

24. What is a function in Excel?

A built-in formula

A worksheet name

A password

A tool to draw shapes

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

Currency

Text

Number

General

Page 2 of 2

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

=COUNT()

=AVERAGE()

=AVG()

=SUM()

27. What does cell reference A$1 mean?

Relative reference

Absolute reference

Dynamic reference

Mixed reference

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

Alignment

AutoFill

Sort

Cell Merge

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

Column chart

Pie chart

Bar chart

Line chart

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

=AVERAGE()

=MAX()

=SUM()

=MIN()

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

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

Cell

Box

Field

Table

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

=INT()

=CEILING()

=FLOOR()

=ROUND()

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

1,048,576

100,000

256,000

65,536

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

=COUNTBLANK()

=COUNTA()

=IF()

=COUNT()

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

A$1

$A$2

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

Data → Filter

Home → Format

Insert → Table

View → Freeze Panes

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

Filter

Format Painter

Group

Sort

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

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

=SUM()

=IF()

=AVERAGE()

=COUNT()

41. What does the AutoSum button do?

Merges cells

Deletes rows

Inserts a chart

Adds selected values

42. What does the Fill Handle do?

Deletes data

Clears formatting

Applies filters

Copies formulas or values to adjacent cells

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

Page Layout

Insert tab

Home tab

Data tab

44. What is the formula bar used for?

Entering or editing formulas

Formatting cells

Hiding rows

Printing documents

45. Which feature is used to highlight duplicate values?

Conditional Formatting

Wrap Text

AutoCorrect

Sort

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

MS Word

Adobe Photoshop

MS Access

MS Excel

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

Right

Left

Center

Justified

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

Zoom View

Page Layout

Draft View

Normal View

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

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

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

Your Related

ECAT Chemistry Environmental Chemistry Test Online

ECAT Mathematics Functions and Limits Online Test

ECAT Mathematics Partial Fractions Online Test

NED-Karachi ECAT Maths Entry Test Online Preparation

ECAT Computer Science Computer Architecture Test Online

ECAT Statistics Test Set 7

Leave a Reply Cancel reply