Excel-SQL

What is the extension used to save an Excel workbook?

• .com

• .xlxm

• .xlxs

• .excel

What does the TRIM() function do in Excel?

• Capitalizes the first letter of each word in the text

• Eliminates extra spaces in the text, including those at the start and end

• Trim the extra beard in pictures

• Removes all spaces in the text

Which formula would you use to calculate the number of products sold in a particular month?

• COUNTIF

• AVERAGE

• SHOWSALES

• COUNT

What is the formula to calculate the sum of cells A1 through A5 in Excel?

•  =SUM(A1;A5)  

• =SUM(A1 to A5)

• =SUM(A1:A5)

• =SUM(A:5)

Which of the following options in Excel allows you to display cell contents over multiple lines instead of one?

• Wrap text

• Merge & Center

• Format Painter

• Show in One Line

What is the purpose of the Format Painter tool in Excel?

• To paint your cat picture

• To copy and paste formats

• To insert charts

• To delete cells

Which of the following keys in Excel can be used to quickly lock a cell reference in a formula?

• Backspace

• Delete

• F3

• F4

Name the function helps merge two strings.

• Merge

• Plus

• Concat

• Join

What does DML stand for?

• Data Manipulation language

• Data Mode Lane

• Data Model Language

• Different Mode Level

Which of the following are some common RDBMS in use?

• Oracle

• Excel

• a & b

• All of the above