TECHNOLOGY

Question 1

What is a cell in Excel?

Answer 1

A cell is the intersection of a row and a column identified by a column letter and row number (e.g. A1).

Question 2

What types of data can a cell hold?

Answer 2

Text numbers or formulas.

Question 3

What is a workspace in Excel?

Answer 3

The workbook containing worksheets each a grid of cells where data is entered and manipulated.

Question 4

How do you enter data in a cell?

Answer 4

Click on the cell type the text or number then press Enter or Tab.

Question 5

How do you write a basic formula in Excel?

Answer 5

Start with an equal sign (=), e.g.=5+3 or =A1+B1.

Question 6

What order of operations does Excel follow?

Answer 6

BEDMAS: Brackets Exponents Division Multiplication Addition Subtraction.

Question 7

What are cell borders used for?

Answer 7

To create lines around cells for visual separation.

Question 8

What does cell shading do?

Answer 8

Fills a cell with color to highlight data.

Question 9

What is cell alignment?

Answer 9

Adjusting text horizontally (left center right) or vertically (top middle bottom).

Question 10

How do you format column width or row height?

Answer 10

Adjust them to fit the contents so data isn’t cut off.

Question 11

What is text wrapping in Excel?

Answer 11

Makes long text wrap to a new line inside the same cell.

Question 12

What does merging cells do?

Answer 12

Combines two or more adjacent cells into one larger cell.

Question 13

What is text orientation in Excel?

Answer 13

Rotating text inside cells to save space or improve layout.

Question 14

What data types can cells contain?

Answer 14

Text numbers dates or currency values.

Question 15

What is the purpose of page layout in Excel?

Answer 15

To set margins orientation and paper size before printing.

Question 16

How do you print a worksheet?

Answer 16

Use print preview scale if needed and print.

Question 17

What is a function in Excel?

Answer 17

A predefined formula that performs a specific calculation.

Question 18

What does =SUM(A1:A5) do?

Answer 18

Adds all numbers in the range A1 to A5.

Question 19

What does =AVERAGE(A1:A5) do?

Answer 19

Calculates the average of numbers in the range A1 to A5.

Question 20

What does an IF function do?

Answer 20

Checks a condition and returns one value if true another if false.

Question 21

What are the types of functions in Excel?

Answer 21

Mathematical logical text and date/time functions.

Question 22

What does #DIV/0! mean?

Answer 22

A formula tried to divide by zero.

Question 23

What does #NAME? mean?

Answer 23

Excel doesn’t recognize the formula or function name (possibly due to a typo).

Question 24

What does #REF! mean?

Answer 24

The formula refers to a cell that no longer exists or was deleted.

Question 25

How do you rename a worksheet?

Answer 25

Double-click the worksheet tab and type a new name.

Question 26

How do you change a worksheet tab color?

Answer 26

Right-click the tab and choose a color.

Question 27

What are headers and footers used for?

Answer 27

To add page numbers dates or titles on every printed page.

Question 28

How do you prepare a worksheet for printing?

Answer 28

Use print preview to adjust page settings and print area.

Question 29

What are bar charts used for?

Answer 29

To compare quantities using bars.

Question 30

What are column charts used for?

Answer 30

To show data using vertical bars over categories or time.

Question 31

What are line charts used for?

Answer 31

To show trends by connecting data points with lines.

Question 32

What are pie charts used for?

Answer 32

To show parts of a whole as slices.

Question 33

What elements are in a graph interface?

Answer 33

Titles, axis labels legends and data points.

Question 34

How do you insert a graph in Excel?

Answer 34

Select data → Insert tab → choose chart type → click to insert.

Question 35

How do you format a graph?

Answer 35

Customize colors titles labels and legends.

Question 36

What are tabs in MS Word?

Answer 36

Ruler positions that help align text useful for lists or tables.

Question 37

What are indents in Word?

Answer 37

Control how far text is from the margin used in formatting.

Question 38

What are columns in Word?

Answer 38

Split text into vertical sections like in newspapers.

Question 39

How can you protect a Word document?

Answer 39

By adding a password or restricting editing.

Question 40

What is a watermark?

Answer 40

Faint background text or images like "Confidential" or "Draft".

Question 41

What is a novice bot?

Answer 41

A beginner robot used to learn basic commands and movements.

Question 42

What is abstraction in robotics?

Answer 42

Simplifying problems by focusing on important parts only.

Question 43

What is problem solving in robotics?

Answer 43

Breaking down large problems into smaller solvable tasks.

Question 44

What is a non-Newtonian liquid?

Answer 44

A liquid that acts like a solid under force (e.g. cornstarch + water).

Question 45

What is rubber ducking?

Answer 45

Explaining your problem out loud to help find mistakes.

Question 46

What is an algorithm?

Answer 46

A step-by-step set of instructions to solve a problem efficiently.