Excel, CapCut, and AI Quiz

What is Microsoft Excel primarily used for?

• Creating presentations

• Managing databases and calculations

• Editing photos

• Writing documents

Answer explanation

Microsoft Excel is primarily used for managing databases and performing calculations, making it a powerful tool for data analysis and organization.

What do we call the intersection of a row and column in Excel?

• Cell

• Field

• Record

• Entry

Answer explanation

In Excel, the intersection of a row and a column is called a 'Cell'. Each cell can hold data, making it a fundamental component of spreadsheets.

What is the name of the first cell in Excel?

• A1

• 1A

• AA1

• A0

Answer explanation

The first cell in Excel is designated as A1, where 'A' represents the column and '1' represents the row. The other options do not follow the correct cell naming convention.

Which key combination moves to the next cell to the right?

• Ctrl+Right

• Tab

• Shift+Right

• Alt+Right

Answer explanation

The correct key combination to move to the next cell to the right is 'Tab'. While 'Ctrl+Right' and 'Alt+Right' can navigate in some applications, 'Tab' is the standard for moving right in spreadsheets and forms.

What happens when you press Enter in Excel?

• Saves the workbook

• Moves to cell below

• Moves to next column

• Closes the current cell

Answer explanation

Pressing Enter in Excel moves the active cell selection down to the cell directly below. This is the default behavior, allowing for quick data entry in a vertical manner.

What symbol MUST you use to start a formula in Excel?

• +

• *

• =

• $

Answer explanation

In Excel, all formulas must begin with the equal sign '='. This indicates to Excel that the following text is a formula, while other symbols like '+' or '*' are used for specific operations within the formula.

What does the SUM function do in Excel?

• Counts non-empty cells

• Adds numbers together

• Finds the average

• Finds the maximum value

Answer explanation

The SUM function in Excel is used to add numbers together. It calculates the total of a range of cells containing numeric values, making it essential for performing arithmetic operations in spreadsheets.

Which formula correctly adds cells A1 through A5?

• =A1+A2+A3+A4+A5

• =SUM(A1:A5)

• =ADD(A1:A5)

• Both A and B

Answer explanation

The correct formula to add cells A1 through A5 is =SUM(A1:A5). While =A1+A2+A3+A4+A5 also works, =SUM is more efficient and concise. =ADD is not a valid function in Excel.

What does Ctrl+S do in Excel?

• Selects all data

• Saves the workbook

• Starts a new worksheet

• Sorts the data

Answer explanation

In Excel, pressing Ctrl+S is a shortcut that saves the current workbook. This is essential for preventing data loss and ensuring your work is stored properly.

How do you make text bold in Excel?

• Ctrl+B

• Ctrl+I

• Ctrl+U

• Ctrl+T

Answer explanation

To make text bold in Excel, you can use the shortcut Ctrl+B. This command toggles the bold formatting on and off for the selected text, making it the correct choice among the options provided.