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 the following is used to move data from one cell to another?

Format Cells

Delete

Cut and Paste

Copy and Paste

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

Today's date

The current date and time

Total of values

The year only

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

=COUNT()

=IF()

=COUNTA()

=COUNTBLANK()

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

Text

Currency

General

Number

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

Tab

Shift

Ctrl

Enter

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

Click the Start button

Press Enter on the sheet

Double-click the sheet tab

Use the Insert tab

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

=COUNTIF()

=COUNTBLANK()

=COUNTA()

=COUNT()

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

Bar chart

Column chart

Line chart

Pie chart

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

Alignment

AutoFill

Sort

Cell Merge

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

######

#NUM!

#REF!

#DIV/0!

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

Multiplies values in A1 to A5

Shows the maximum value

Adds values from cells A1 to A5

Divides all numbers in A1 to A5

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

Protect Sheet

Page Layout

View Tab

Format Cells

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

A$1

$A$2

14. How can you insert multiple rows at once?

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

Press Ctrl + P

Use the Format Painter

Use the Insert tab and select “Insert Table”

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

=MIN()

=MAX()

=COUNT()

=SUM()

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

Data → Filter

View → Freeze Panes

Insert → Table

Home → Format

17. What is a function in Excel?

A tool to draw shapes

A worksheet name

A password

A built-in formula

18. What does cell reference A$1 mean?

Absolute reference

Relative reference

Mixed reference

Dynamic reference

19. What is a cell range?

A group of selected cells

The total number of rows

A column title

A single cell

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

.xlsm

.xlsx

.docx

.pptx

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

Box

Cell

Field

Table

22. What does the AutoSum button do?

Deletes rows

Merges cells

Inserts a chart

Adds selected values

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

=SUM()

=COUNT()

=ROUND()

=MAX()

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

25. What does the Merge & Center feature do?

Copies content

Combines cells and centers text

Deletes rows

Adds formulas

Page 2 of 2

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

Ctrl + S

Ctrl + W

Ctrl + N

Ctrl + O

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

Insert → Export

Data → Convert

View → Print

File → Save As → Choose PDF

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

=FLOOR()

=CEILING()

=ROUND()

=INT()

29. What does the Fill Handle do?

Clears formatting

Copies formulas or values to adjacent cells

Applies filters

Deletes data

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

=AVG()

=COUNT()

=SUM()

=AVERAGE()

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

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

Normal View

Zoom View

Draft View

Page Layout

33. Which feature is used to highlight duplicate values?

Conditional Formatting

Sort

AutoCorrect

Wrap Text

34. Which Excel function returns the current date?

=TIME()

=DATE()

=NOW()

=TODAY()

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

=AVERAGE()

=MAX()

=MIN()

=SUM()

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

View

Home

Page Layout

Insert

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

Left

Center

Justified

Right

38. What does the Wrap Text feature do?

Fills the cell with color

Deletes text

Adjusts font style

Displays text in multiple lines within a cell

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

Page Layout

Data tab

Insert tab

Home tab

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

A row only

A column only

A combination of row and column

Its font size

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

MS Excel

Adobe Photoshop

MS Word

MS Access

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

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

View → Zoom

Format → Hide

Data → Sort

Insert → Header

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

256,000

65,536

1,048,576

100,000

45. What is the formula bar used for?

Formatting cells

Hiding rows

Printing documents

Entering or editing formulas

46. Which function is used to apply a condition?

=MAX()

=IF()

=ROUND()

=SUM()

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

File → Save As

Data → Filter

View → Zoom

Insert → Symbol

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

Sort

Group

Filter

Format Painter

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

=SUM()

=IF()

=COUNT()

=AVERAGE()

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

NUST-Rawalpindi ECAT Physics Entry Test Preparation Online

ECAT Mathematics Differentiation Online Test

ECAT Mathematics Introduction to Analytic Geometry Online Test

ECAT Statistics Test Set 7

ECAT English Prepositions 1 Online Test

ECAT English Spotting Errors 5 Online Test

Leave a Reply Cancel reply