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. What is the maximum number of rows in a single Excel worksheet (Excel 2016 and later)?

1,048,576

256,000

100,000

65,536

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

Total of values

Today's date

The year only

The current date and time

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

.docx

.xlsm

.pptx

.xlsx

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

Number

Text

General

Currency

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

Page Layout

View

Insert

Home

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

Cut and Paste

Copy and Paste

Delete

Format Cells

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

=AVERAGE()

=SUM()

=COUNT()

=AVG()

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

Filter

Format Painter

Group

Sort

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

Format → Hide

Data → Sort

Insert → Header

View → Zoom

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

Insert → Table

Home → Format

View → Freeze Panes

Data → Filter

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

View → Print

File → Save As → Choose PDF

Data → Convert

Insert → Export

12. Which Excel function returns the current date?

=TIME()

=TODAY()

=NOW()

=DATE()

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

=COUNT()

=COUNTA()

=COUNTBLANK()

=IF()

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

Shows the maximum value

Adds values from cells A1 to A5

Divides all numbers in A1 to A5

Multiplies values in A1 to A5

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

=SUM()

=COUNT()

=MAX()

=MIN()

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

Ctrl + S

Ctrl + N

Ctrl + O

Ctrl + W

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

=MAX()

=AVERAGE()

=MIN()

=SUM()

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

=INT()

=CEILING()

=ROUND()

=FLOOR()

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

Insert tab

Page Layout

Data tab

Home tab

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

Insert → Symbol

View → Zoom

Data → Filter

File → Save As

21. What is a function in Excel?

A tool to draw shapes

A worksheet name

A password

A built-in formula

22. Which function is used to apply a condition?

=SUM()

=IF()

=MAX()

=ROUND()

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

Zoom View

Draft View

Normal View

Page Layout

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

Ctrl

Enter

Tab

Shift

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

=AVERAGE()

=IF()

=SUM()

=COUNT()

Page 2 of 2

26. What does the Wrap Text feature do?

Adjusts font style

Fills the cell with color

Displays text in multiple lines within a cell

Deletes text

27. What does the Merge & Center feature do?

Adds formulas

Deletes rows

Copies content

Combines cells and centers text

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

A$1

$A$2

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

=SUM()

=MAX()

=COUNT()

=ROUND()

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

Column chart

Bar chart

Pie chart

Line chart

31. What does cell reference A$1 mean?

Absolute reference

Relative reference

Dynamic reference

Mixed reference

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

Use the Insert tab

Click the Start button

Double-click the sheet tab

Press Enter on the sheet

33. What does the Fill Handle do?

Copies formulas or values to adjacent cells

Applies filters

Clears formatting

Deletes data

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

Field

Table

Box

Cell

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

Justified

Right

Center

Left

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

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

38. What does the AutoSum button do?

Inserts a chart

Adds selected values

Deletes rows

Merges cells

39. Which feature is used to highlight duplicate values?

Sort

Conditional Formatting

AutoCorrect

Wrap Text

40. How can you insert multiple rows at once?

Use the Format Painter

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

Use the Insert tab and select “Insert Table”

Press Ctrl + P

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

#REF!

#NUM!

######

#DIV/0!

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

Format Cells

Page Layout

Protect Sheet

View Tab

43. What is a cell range?

The total number of rows

A group of selected cells

A column title

A single cell

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

Adobe Photoshop

MS Access

MS Excel

MS Word

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

Its font size

A column only

A row only

A combination of row and column

46. What is the formula bar used for?

Formatting cells

Entering or editing formulas

Printing documents

Hiding rows

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

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

Alignment

Cell Merge

AutoFill

Sort

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

=COUNTA()

=COUNTIF()

=COUNT()

=COUNTBLANK()

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

ECAT Introduction to Computers Online Test
ECAT Physics Optical Instruments 1 Test Online
ECAT Computer File Handling in “C” Test Online
ECAT Computer Functions in “C” Test Online
ECAT Computer Loop Constructs Test Online
ECAT Computer Decision Constructs Test Online
ECAT Computer Input Output Test Online
ECAT Computer Elements of “C” Test Online
ECAT Computer Getting Started with “C” Test Online
ECAT Computer Science Microsoft Access-Forms and Reports Tes...

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 Chemistry Entry Test Preparation Online

ECAT English Spotting Errors Test 11 Online

ECAT English Antonyms 6 Online Test

ECAT Mathematics Functions and Limits Online Test

ECAT Computer Science Information Networks Test Online

ECAT Chemistry Chemical Equilibrium Test Online

Leave a Reply Cancel reply